|
Gen Gelinas
|
November 26, 2016 at 2:49 pm
When I export the attendees, the data is all stuck in the first column. If I save the csv and try to import the data in a new Excel file, delimiting with the comma, it doesn’t fix the problem.
Help, plaase!
|
|
Tony
|
November 28, 2016 at 9:40 am
Hi there,
Do you normally use tabs or commas as the delimiter on your system?
Can you send me a copy of the CSV before opening and saving? If so you can send it to support[at]eventespresso.com
Or provide temporary login details using this form:
https://eventespresso.com/send-login-details/
and I will run an export myself to see if I can see the problem.
|
|
Tony
|
November 28, 2016 at 5:39 pm
Thank you for sending over the CSV.
However is that CSV file directly from the site without first opening within Excel? I’m asking as there are missing double quotes, additional double quotes around each section and the formatting for the file is incorrect. This would normally happen after the file had been opened within CSV and then saved with the wrong settings.
If it is directly from the site it could also be that something is altering the request to export the data, this could be another plugin or possibly your theme.
You can rule those out by following these steps:
1) A theme conflict. You can rule this out by temporarily switching to the default WordPress theme, then test. The theme test drive plugin allows for testing another theme without actually changing your site’s theme.
2) A plugin conflict. You can rule this out by temporarily deactivating any other installed WordPress plugins. Test again to confirm if the export works, then you reactivate them one by one, while testing the error condition between each reactivation to see which plugin causes the problem.
|
|
Gen Gelinas
|
November 29, 2016 at 8:28 am
The file I sent had been opened in Excel first. If I download the .csv and import the data in blank Excel Sheet, the columns align properly. Thanks!
|
|
Tony
|
November 29, 2016 at 10:04 am
It sounds like your system is setup to use Tabs as the delimiter but the CSV from EE uses commas by default.
Importing the file into Excel allows you to specific how the data should be importanted so works around that problem, but you can also set EE to use a tab as the delimiter if prefered.
You would need to add something like this to your site:
https://gist.github.com/Pebblo/3f56efe054c2d5dde50ea0104d605758
That’s a function wrapped in a Custom Functions Plugin that sets the CSV to use tabs.
|
