Support

Home Forums Event Espresso Premium Bulk Events Uploader Skewing Data

Bulk Events Uploader Skewing Data

Posted: October 8, 2013 at 5:18 pm


Bera Aksoy

October 8, 2013 at 5:18 pm

I tried uploading some events using the events.csv as a template. The data in the database is skewed. Then, I tried uploading the sample events.csv file. The same thing happened.

Thanks in advance for your help.


Sidney Harrell

October 8, 2013 at 8:36 pm

You might want to try grabbing the 3.1.36-BETA from the pre-release channel and swapping out the file includes/event-management/csv_import.php from the beta into your current version. You’ll have to use the events.csv from the Beta as your template because it adds the address2 field and a categories field at the end. But more importantly, it uses an improved method of getting each line of the csv file.


Bera Aksoy

October 9, 2013 at 2:50 pm

Great thanks!

The new bulk import works great, but I had to add a line of code after line 100

line 100 $csvfile = “../wp-content/uploads/events.csv”;

// Added on 10/9/13
ini_set(‘auto_detect_line_endings’, true);

The loader was not autodetecting line endings and loaded in the complete CSV in one go, so nothing was uploading. I’m on a Mac.


Sidney Harrell

October 9, 2013 at 5:58 pm

Awesome. I’ve had some troubles with the line endings myself depending on what I use to edit the csv file (on linux, gedit works, libreoffice and netbeans are troublesome). I’ll give that line a test. Thanks.

The support post ‘Bulk Events Uploader Skewing Data’ 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