Hello,
we experienced troubles while exporting tickets CSV due to a lack of cleaning up / preparing ticket details.
You set delimiter to comma. As a consequence all appearence of commata in data should be cleaned up or escaped.
Otherwise if a customer uses comma in for example the name field, the corresponding line of the CSV file is corrupted due to this additional comma.
In the file class-admin-ajax.php we changed some lines:
line 323
#echo “xEFxBBxBF”; // UTF-8 BOM
line 355 ff
‘name’=> ‘”‘.str_replace(‘”‘, ”, $td[‘n’]).'”‘,
’email’=> $td[‘e’],
‘company’=> ‘”‘. isset($td[‘company’])? str_replace(‘”‘, ”, $td[‘company’]):”.'”‘,
‘address’=> ‘”‘.str_replace(‘”‘, ”, $td[‘aD’]).'”‘,
It’s certainly not the best solution, but it works. Would be great if you would consider to correct the CSV file output.
Best regards and keep up the good work
Heiko
Hello,
Thank you for your messages, I am going to assign this ticket to Ashan and he will be able to take it from here and find you a solution. Please allow some time for him to get back to you, we greatly appreciate your patience and thank you for being a eventon customer! Also please disable any IP blocking on your site if there are any.
Hello,
I’ve been waiting for two weeks now. No response so far.
Best regards
Hello my friend sorry for the delay in responding. We can certainly implement those str_replace values to make sure ‘ is correctly implemented in the exported CSV file.
Kindly use your solution for the moment on your end.