Hi Simon,
Can you tell me what the problem is? That’s the only way I can try to help you.
Thread Starter
Simon
(@spa180)
Thanks for replying.
Sorry, as I was typing my message the fire alarm sounded at work!!!
All the different versions I load (csv, txt, etc) fail either because they’re aren’t enough columns or because there’s an issue with row 2.
Simon
Sorry, as I was typing my message the fire alarm sounded at work!!!
Always makes me think of this image 🙂
If you share the file, I can have a look. Should be easy to fix.
Thread Starter
Simon
(@spa180)
I may actually have done that today (though it was FB Messenger)!
What’s the best way to share the file with you?
Post a link to dropbox or similar service here. Or email me (address is on the help page in the admin).
Your lines contain too many double quotes. A single value can be surrounded by double quotes (not always needed, though), but if you look at the following example from your file, you’ll see that the first column (play_date) starts with a double quote, but is not closed with a double quote. And then the following columns all have two double quotes.
play_date;home_team;away_team;stadium;match_type
"2020-01-11 20:00:00;""Sheff Utd"";""West Ham"";""Brammall Lane"";""Round 01"""
The line should either be this:
play_date;home_team;away_team;stadium;match_type
"2020-01-11 20:00:00";"Sheff Utd";"West Ham";"Brammall Lane";"Round 01"
or this:
play_date;home_team;away_team;stadium;match_type
2020-01-11 20:00:00;Sheff Utd;West Ham;Brammall Lane;Round 01
I’ve emailed you a working file.
Thread Starter
Simon
(@spa180)
Thanks for your help Antoine. Your support of the plugin is second to none and your efforts are totally appreciated.
