|
Josh Monk
|
November 28, 2016 at 2:53 am
Original thread: https://eventespresso.com/topic/ee4-csv-export-of-attendees-all-in-a-single-column/
Im having exactly the same issue?????
What should we do?????? I need the CSV to export into separate colums.
-
This topic was modified 8 years, 1 month ago by
 Tony.
-
This topic was modified 8 years, 1 month ago by Tony. Reason: Split thread
|
|
Tony
|
November 28, 2016 at 9:41 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.
|
|
Josh Monk
|
November 28, 2016 at 11:03 pm
I have emailed the CSV file
|
|
Josh Monk
|
November 28, 2016 at 11:04 pm
i have place this in the functions.php file
function ee_specify_comma_seperator( $initial_csv_output ) {
$initial_csv_output .= “sep=,\n”;
return $initial_csv_output;
}
add_filter( ‘FHEE__EE_CSV__begin_sending_csv__start_writing’, ‘ee_specify_comma_seperator’ );
|
|
Tony
|
November 29, 2016 at 10:06 am
Did the above fix the problem?
If so can I ask where are you located?
It may be that your system is setup to use tab as a delimiter for the CSV but EE by default uses commas. You can change this using the above (which basically just tells Excel to use commas as the delmitier) or you can change EE to use tabs rather than commas using something like this:
https://gist.github.com/Pebblo/3f56efe054c2d5dde50ea0104d605758
|
|
Tony
|
November 29, 2016 at 10:44 am
I should add, I didn’t have any issues with the CSV file you sent over via email which is why I mentioned the above.
|
