Not enough columns when importing from CSV

[Ashley Thornton]

I am trying to import events from a CSV. When I preview and try to map, there are not enough columns. I see in the primer in knowledge base that there should be a way to see the “previous and next” columns, but that is not showing up when I try to import. I am using firefox if that makes a difference. (Tried with edge and that did not work at all.)

[Andras]

Hi Ashley,

Thanks for going Pro and welcome to the forums!  Let me help you with your issue here.

I checked your csv file and it looks like it doesn’t have a first row describing what each column is. If you paste this as the first row, that should already help you out:

Description,ZIP,Event title,price,noclue,venue,address

I might not have gotten all columns right 🙂 but it doesn’t matter, you will be able to match the columns.

Also note that you need to have the venues set up or imported in the system first. When importing an event you can only import a venue name, but not the rest. Then the venue name will be matched with the existing ones in your database.

What you can do – after adding that first line – is import the file first for Venues and then only select the columns relevant for the venues. Then import the events.

One more more important note. Your events in the csv file don’t have a start or end date (as a separate column). Without this your events will not import.

I hope this gets you started. Let me know if you need any more help.

Cheers,
Andras

 

[Support Droid]

Hey there! This thread has been pretty quiet for the last three weeks, so we’re going to go ahead and close it to avoid confusion with other topics. If you’re still looking for help with this, please do open a new thread, reference this one and we’d be more than happy to continue the conversation over there.

Thanks so much!
The Events Calendar Support Team

[Author]

Posts