CSV Export with german Characters
We use the CSV export file for an ACCESS database. Now some German characters are exported differently in this CSV-File. In the column “EventDescription” and “EventName” there is a HTML code for the german “Ü” (Ü!).
In the Event-Location column, the “Ü” is exported without HTML as “Ü”.
How can i unify that?
- Mar 15,2017 AT 8:18AM - 4 years ago-
-
Mar 17,2017 AT 10:00AM -
Posted 5 years ago
- #31502
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!
-
Mar 17,2017 AT 1:28PM -
Posted 5 years ago
- #31532
In the eventon/includes/admin/class-admin-ajax.php file line around 160 there are htmlentities() function that converts to html so you can remove those there are multiple of those in there and u can remove those if that is what you want. We will add an option in the future version for this to be optinal.
-
Mar 20,2017 AT 9:54AM -
Posted 5 years ago
- #31704
ok. Remove is no problem. But how can i add some new fields?
I have tried it so for the Event Location, but it does not work:
// event location
$eventLocation = get_the_title();
$eventLocation = htmlentities($eventLocation);
//$output = iconv(“utf-8”, “ascii//TRANSLIT//IGNORE”, $eventLocation);
//$output = preg_replace(“/^’|[^A-Za-z0-9s-]|’$/”, ”, $output);
$csvRow.= ‘”‘.$eventLocation.'”,’; -
Mar 21,2017 AT 8:28AM -
Posted 5 years ago
- #31795
What? add new fields??? earlier you just wanted to fix character issue. And thats what I gave my solution for. At the moment it doesnt suppose adding new fields to export CSV file.
-
Mar 22,2017 AT 6:44AM -
Posted 5 years ago
- #31912
Hi, i don want to add ne fields. i need the HTML-Code for the german signs in the entire CSV file.
At the moment there is the HTML-Code only in the Event Name and in the Event Description, but not in the Event Location. Event Location is a standard-field in the Export-CSV-File.
-
Mar 22,2017 AT 8:50AM -
Posted 5 years ago
- #31944
Oh i see what you need my apologies.
I have pointed to the places where I have added the htmlconversion function. please copy this to your file as well. Let me know if this work
cheers.
-
Mar 27,2017 AT 2:07AM -
Posted 4 years ago
- #32230
Hi, thank you. It works now.
Only the columns cmd_1 to cmd_4 still have german signs. Can you change that? -
Mar 27,2017 AT 9:21AM -
Posted 4 years ago
- #32275
please try the same thing in the code. I will make those updates in the next eventon version.
Cheers!
-
Apr 10,2017 AT 8:45AM -
Posted 4 years ago
- #33810
I’m sorry. The script for Custom Meta is different and it does not work. I am not a programmer and am not sure which line I should use “$ value = htmlentities”:
}// for event custom meta data
for($z=1; $z<=$cmd_count; $z++){
$cmd_name = ‘_evcal_ec_f’.$z.’a1_cus’;
$csvRow.= (!empty($pmv[$cmd_name])?
‘”‘.str_replace(‘”‘, “‘”,$pmv[$cmd_name][0]).'”‘
:”);
$csvRow.= “,”;}
-
Apr 13,2017 AT 7:37AM -
Posted 4 years ago
- #34154
No worries, if you would like to send us FTP access to your site myself or one of our admins will be able to login and make that change for you. Thanks
-
Apr 13,2017 AT 9:52AM -
Posted 4 years ago
- #34176
I can make the change. Send me only the adapted script
-
Apr 14,2017 AT 8:09AM -
Posted 4 years ago
- #34257
Fine. So you basically have to add htmlentities($pmv[$cmd_name][0]) where is says just $pmv[$cmd_name][0], make sense?
-
Mar 17,2017 AT 10:00AM -
Posted 5 years ago
- #31502
