Hi
I got to Problems with the default CSV Export.
First Problem is, that when I export the CSV and I have got an Textarea field and the fieldvalues contain a CarrigeReturn it will generate multiple rows in CSV. Where can I change this setting (like replace with space).
Second Problem I got is just occuring under mac. When importing in Excel the special characters like äöü are not shown right, when selected utf-8 for import (this work without problems under windows7 excel 2010).
I was reading, that for GH there is a workaround about the BOM attribute. Does this exist also for the default export?
Thanks Pawel
I got to Problems with the default CSV Export.
First Problem is, that when I export the CSV and I have got an Textarea field and the fieldvalues contain a CarrigeReturn it will generate multiple rows in CSV. Where can I change this setting (like replace with space).
Second Problem I got is just occuring under mac. When importing in Excel the special characters like äöü are not shown right, when selected utf-8 for import (this work without problems under windows7 excel 2010).
I was reading, that for GH there is a workaround about the BOM attribute. Does this exist also for the default export?
Thanks Pawel
I tied the solution...
Since I didn't have the "csv_export_v2_gh" directory I tried it with the "/administrator/components/com_chronoforms/form_actions/csv_export_gh" directory.
When I replaced the code in "csv_export_gh.php" I got an error on line 303.
So after a quick look I changed the code of csv_export_gh.php to the following in the attachment.
Now the problem with the line breaks is solved.
But I still have the problem with the utf-8 import with f**cking mac excel 14.3.9...
My only solutions is terrible for my users:
open terminal go to the download directory (ls Downloads) and
and then import it with the windows charset... 😟
Since I didn't have the "csv_export_v2_gh" directory I tried it with the "/administrator/components/com_chronoforms/form_actions/csv_export_gh" directory.
When I replaced the code in "csv_export_gh.php" I got an error on line 303.
So after a quick look I changed the code of csv_export_gh.php to the following in the attachment.
Now the problem with the line breaks is solved.
But I still have the problem with the utf-8 import with f**cking mac excel 14.3.9...
My only solutions is terrible for my users:
open terminal go to the download directory (ls Downloads) and
iconv -f UTF-8 -t WINDOWS-1252 query_result.csv > query_result-win.csvand then import it with the windows charset... 😟
Since I have multiple forms for this customer and you cant drag events to a child event, it would have been a big work for me to edit all of them.
But I did look on it.
But I did look on it.
This topic is locked and no more replies can be posted.
