CSV Importer Events

[dcantato]

Hi,

The issue I’m having is with the CSV importer. It seems to work perfectly except after the import says success, all the events don’t show up. The sheet I’m working with has 47 events. It says 47 were added but only 15 get added.

And when I try and use the sheet again it says 32 updated, but there are still only 15 events.

The venue importer worked perfect.

Any idea what is going on?

This is a live site and I can’t deactivate the plugins or change the theme.

[dcantato]

This reply is private.

[dcantato]

If you are having this issue you need to make sure you are saving the file correctly as utf-8. It took me upgrading from 2003 excel to a more new version to see I was saving as western. The best way to make sure your data is correct is:

1. Save to CSV in excel
2. Open the CSV file in TextEdit(mac), you may have to right click the file and go to Open With…
3. Once in TextEdit, on the menu bar click File and go to Duplicate or press Command + Shift + S
4. Save the new duplicated file as “yourFileNameHere”.csv and change the dropdown at the bottom that says Plain Text Encoding to UTF-8.
5. If it alerts you about the extension being a csv accept the change and your file is ready to upload.

I hope this helps you, the csv converter link in the plugin import screen did nothing for me.

[Geoff]

Right on! Nice work @dcantato! Thanks a ton for reaching out and sharing the solution–I’m certain this will help others as well. 🙂

Cheers,
Geoff

[Author]

Posts