CSV Export umlauts

Hello together

I made a List, with an CSV Export to Excel. Works perfect.

But, the special letters are not okay in Excel -> "beim Güterschuppen gegenüber FW Bahn"

Is there a option to convert this?

Thank youuuu
Corinne

Hi Corinne,

I think that when you import the CSV file into Excel there is an option to change the Character set - try using UTF-8 there and see if that makes the difference.

Bob

Hi Bob

Yes, but then i have first to save it. Nice would be i can open direct correct :-)

An other "bigger" problem i have... my list read 4 Tables, work ok. But the csv export show ALL files from the maintable, not only the selected in the view. So i try to fill out "Fields to retrieve", but this does not work with more than one table.

In the download Button i have:
{view:table1}
{fn:read_partner}
{var:read_partner.[n].Partner}
{fn:csv}

Any Tipps? 😀

Greetings from Switzerland
Corinne

Hi Corinne,

For the first question - there is an Excel setting that you can change please see here for some suggestions.

You need Max for the second question, I have no idea :-(

Bob

Hi Corinne,

For #1, please send me a message using the "Contact us" page to test a patch file.

For #2, I think your setup here is not correct, what is the "data provider" in the csv function ? and you do not need the {view:table1} in a download event call.

You can comment the {fn:csv} and test the data passed to the csv using this:
{var.pr:read_partner}

Best regards,
Max