Support

Home Forums Event Espresso Premium CSV Import is not working

CSV Import is not working

Posted: July 1, 2013 at 9:47 pm

Viewing 17 reply threads


Rob Reese

July 1, 2013 at 9:47 pm

I get:
File uploaded successfully. – events.csv
Upload file has been deleted.
Added a total of 41 events to the database

But no new events are added to the database. I cannot figure out what.
I tried removing all ‘ from the excel spreadsheet and have verified my dates are in yyyy-mm-dd format. Need help!


Rob Reese

July 1, 2013 at 9:52 pm

<code>0,event_name,event_desc,address,city,state,country,zip,phone,display_desc,event_identifier,start_date,end_date,start_time,end_time,reg_limit,event_cost,allow_multiple,additional_limit,send_mail,is_active,conf_mail,registration_start,registration_end
42,Japanese Noodle,&quot;Japanese Noodles (Ramen) are becoming the next craze from Japan. With noodles, fresh broth, and other locally sourced ingredients, Ramen is easy to prepare at home for a fun and surprisingly nutritious meal.
 
Other dishes you will learn: Hayashi Chuka- Chilled cooked noodles with shreds of carrot, Japanese seedless cucumber, ham sesame and a light dipping sauce. Perfect for hot summer days. Tamago Maki – Rolled Japanese sweet omlet, and Inari sushi
No prior cooking experience necessary.&quot;,176A South Van Brunt St.,Englewood,NJ,USA,7631,855-408-COOK,Y,1005,7/11/2013,7/11/2013,6:00:00 PM,8:30:00 PM,14,110,Y,5,Y,Y,&quot;***This is an automated response - Do Not Reply***
Thank you [fname] [lname] for registering for [event]. 
We hope that you will find this event both informative and enjoyable. 
Should have any questions, please contact [contact].

If you have not done so already, please submit your payment in the amount of [cost].

Click here to reveiw your payment information [payment_url].

Thank You.

&quot;,7/1/2013,7/11/2013</code>


Dean

July 2, 2013 at 1:06 am

Hi,

The first thing I would check is the number in the first column. It looks that yours says 42, when it should say 1. All the rows should say 1 except the first row (its a true/false thing for the code) – example


Rob Reese

July 2, 2013 at 6:13 am

Still no good, unfortunately…. I changed the first column to all 1’s and it didn’t make a difference – still says 42 imported but none of the new events are in the events overview.

<code>,event_name,event_desc,address,city,state,country,zip,phone,display_desc,event_identifier,start_date,end_date,start_time,end_time,reg_limit,event_cost,allow_multiple,additional_limit,send_mail,is_active,conf_mail,registration_start,registration_end
1,Japanese Noodle,&quot;Japanese Noodles (Ramen) are becoming the next craze from Japan. With noodles fresh broth and other locally sourced ingredients Ramen is easy to prepare at home for a fun and surprisingly nutritious meal.
 
Other dishes you will learn: Hayashi Chuka- Chilled cooked noodles with shreds of carrot Japanese seedless cucumber ham sesame and a light dipping sauce. Perfect for hot summer days. Tamago Maki – Rolled Japanese sweet omlet and Inari sushi
No prior cooking experience necessary.&quot;,176A South Van Brunt St.,Englewood,NJ,USA,7631,855-408-COOK,Y,1005,2013-07-11,2013-07-11,6:00:00 PM,8:30:00 PM,14,110,Y,5,Y,Y,&quot;***This is an automated response - Do Not Reply***
Thank you [fname] [lname] for registering for [event]. 
We hope that you will find this event both informative and enjoyable. 
Should have any questions please contact [contact].

If you have not done so already please submit your payment in the amount of [cost].

Click here to reveiw your payment information [payment_url].

Thank You.

&quot;,2013-07-01,2013-07-11</code>


Dean

July 2, 2013 at 7:11 am

It it possible to get a copy of the CSV file please? You can email it to support @ eventespresso.com


Rob Reese

July 2, 2013 at 7:41 am

Sent.


Dean

July 2, 2013 at 7:54 am

Hi rob,

Thanks for that, I had no problem with importing the events.

Is it possible to get your login details in order to look into this?

If so, please send them via https://eventespresso.com/send-login-details/

NOTE: login details need to be Admin level.


Rob Reese

July 2, 2013 at 8:07 am

sent


Dean

July 2, 2013 at 9:28 am

Hi,

OK, I understand now why it isnt working for you, and in fact only partially working for me. The punctuation is causing the issue, specifically the single quote marks and the triple periods (…) seem to be causing the issue.

I would advise to update to the latest version, and to remove those punctuation marks from the spreadsheet, this should get you the events imported, but you will need to manually add back the culprit punctuation.

I will raise a ticket to look into this matter.


Rob Reese

July 2, 2013 at 9:44 am

I did a find + replace for all . and .. and … and ‘ and replaced with a space.
Still doesn’t show up in the event overview.


Josh

  • Support Staff

July 2, 2013 at 10:26 am

Hi Rob,

I checked on this too and there’s a bit more than the punctuation that’s involved. In the events.csv that you sent there are non-alphanumeric characters in the event_desc fields that may be breaking the import.

One example I saw:

broths and the five classic ìmotherî sauces: tomato Espagnole VeloutÈ Hollandaise and BÈchamel as well

If you can go through and clean those up that should help.


Rob Reese

July 2, 2013 at 11:36 am

I removed all the descriptions making it simple 3 word text and it still won’t upload. I even went so far as getting rid of all events except the first row and it won’t upload.


Sidney Harrell

July 2, 2013 at 1:20 pm

I emailed you a copy of an improvement to the csv import tool we’ve been working on. You have to add 2 fields to the events.csv file, address2 comes right after address, and categories comes at the end.


Rob Reese

July 2, 2013 at 2:11 pm

Using the new upload script, I received “Sorry, there was a security error and your event was not saved.”


Rob Reese

July 2, 2013 at 2:20 pm

I tried it again and I’m back to getting “Added a total of 42 events to the database.” … but none of the new events are in the event overview.


Rob Reese

July 2, 2013 at 2:26 pm

I tried changing the description column to a three word description and it still won’t upload. I’m lost. No clue why this won’t work.


Rob Reese

July 2, 2013 at 5:50 pm

Basically the importer is broken – because my client was waiting I had to give up and use a direct-to-database approach – rather than use the import functionality.


Josh

  • Support Staff

July 3, 2013 at 8:18 am

Hi Rob,

I’m sorry to hear about the trouble you’re having with the import tool. It can be finicky if the data isn’t just right. We ran into a few issues last week doing an import of ~ 120 events at first. It ended up being some unescaped single quotes that were breaking it. After escaping the slashes the data imported as expected. Sidney has been working on adding a few columns and adding a few general improvements to the importer to make it more robust. Did you try the copy that he sent?

Viewing 17 reply threads

The support post ‘CSV Import is not working’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso