|
Angus Russell
|
April 26, 2016 at 8:40 am
When we export the attendees list to an excel/csv file how can we change the order of the columns in that file?
We also use an external booking engine, and would like to simplify the data consolidation process.
Thanks
|
|
Tony
|
April 26, 2016 at 1:37 pm
Hi Angus,
To do this you will need some custom coding.
You can use the FHEE__EE_Export__report_registrations__reg_csv_array to alter the CSV before it is written to the file, here is an example of how to exclude some fields from the CSV:
https://github.com/eventespresso/ee-code-snippet-library/blob/master/admin/tw_registration_report_exclude_fields.php
Although changing the order will need to be done a little differently, can yo provide an example of the order you want to use? The first 4/5 columns for example.
|
|
Angus Russell
|
April 27, 2016 at 4:42 am
I don’t deal with that side of things, but the snippet you provided looks easy enough to work around to omit certain columns.
If you could let me have a similar snippet to change the order I should be able to work it out from there.
Thanks
|
|
Josh
|
April 29, 2016 at 11:48 am
Hi Angus,
It turns out that the snippet that Tony shared with you is for Event Espresso 4. I seem to remember that your site is still on Event Espresso 3. For EE3, you look in the event-espresso/includes/functions/export.php file. You should be able to override the “espresso_export_stuff” function because it’s a pluggable function.
|
