Show Data - CSV Export

Question

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

le5 · Accepted Answer

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

iconv -f UTF-8 -t WINDOWS-1252 query_result.csv > query_result-win.csv

and then import it with the windows charset... 😟

Forums

Show Data -> CSV Export