emm3

Thanks!

Ok I’m being stupid I think. I have tried every which way to no avail.

I have set out all the Column headings as you have (same capitalisation, same order , some empty fields because we don’t have results).

In the next row I have filled in the req fields with ‘Team 1’ in the ‘Teams’ column.
Underneath that I have filled in exactly the same fields as the row above with ‘Team 2’ in the ‘Teams’ column.

It imports 2 events both scheduled for the same time and place etc but one with Team 1 and no opponent and the other with Team 2 and no opponent.

I have also tried with “,” where the field information is a duplicate of that above in case that was what you meant but I get one event imported and one not.

Please can you walk me through this like I’m a five year old because the prospect of doing this manually is out of the question. I’ve got hundreds of events to input, 4 leagues, 6 teams and 2 seasons.

I did try that and I got twice as many events imported, in other words one event with one team and no opponent 🙁

I’m pretty sure I was importing data that directly matched the teams that are already input but it’s not picking that up, it’s not taking the 1st two events and creating a single event with the 1st two rows as opponents and then moving on to the next? I think that is what you are saying should happen?

Looking through the forum a lot of people have struggled with this and the sample doesn’t really help in the sense that there is no mention of opponents. Would it not be easier to have a heading ‘HOME TEAM’, and another ‘AWAY TEAM’.

At the moment I can put TEAM1 vs TEAM 2 and get a ton of events that I have to go into individually to assign teams and then delete all the non-existent teams that the import created. It’s either that or do hundreds of events manually?