Column Mapping Error

[jasonmcartor]

I seem to be having a problem with importing a CSV Events file. I do not have Venues or Organizers but rather just events. First line of every column is named as it’s supposed to be. When I import, the column mapping doesn’t read each column as individuals but rather ONE LONG title, thus not allowing me to map any at all. What am I doing wrong?

[Barry]

Hi – sorry to hear you are hitting difficulties here.

Would it be possible to share your CSV data so I can take a look and see how it’s structured?

Though pasting it straight into the forum probably isn’t a great idea if you could make it available for download (you could even upload it as a media file to your WordPress site and grab the URL, or else use a service like Dropbox or similar) and share that as a private reply that would be awesome.

Thanks!

[jasonmcartor]

This reply is private.

[Barry]

Hi!

I suspect the meridiem and timezone appended to those fields is throwing things off slightly.

Though a pretty wide range of date formats are accepted it’s best to keep it simple and I’d strongly recommend a MySQL-like format such as yyyy-mm-dd for dates and hh:mm (24hr format) for times – though you should also be good with North American style dates mm/dd/yyyy and 12hr times followed by am or pm.

Separating out the date and time (right now for example your start time field contains both the date and the time) is also a good practice here.

Does that help?

[Barry]

Hi! It’s been a while so I’m going to go ahead and close this thread. If we can help with anything else, though, please don’t hesitate to create new threads as needed. Thanks!

[Author]

Posts