Page 1 of 1

FormBrowser CSV export issue (charset)

Posted: Wed Oct 03, 2018 4:49 pm
by slick
Hi there

I have some lengthy FormBuilder forms set up to shoot emails and save the data in the FormBrowser module (most recent version of the module and CMS). To export the data, I rely on FormBrowser to export CSV files.

Because my data contains German and French language, I need the CSV files to be in utf-8. But now I have the issue explained years ago in the Bug Tracker: http://dev.cmsmadesimple.org/bug/view/3308

The proposed solution does not generate proper files anymore for me.

If anyone can help I would really appreciate it. Unfortunately I can't share real data because of privacy issues.

— — —

Secondary issue: the default suffix for the exported files is .xls, yet the format is .csv – that is easily fixed by renaming the file. But I would appreciate a more direct solution as well.

Re: FormBrowser CSV export issue (charset)

Posted: Thu Oct 04, 2018 2:31 pm
by slick
I found a problem with two translations in the German (de_DE.php) language file (how can I commit those to the module translation?):

$lang['exporttoexcel'] = 'Nach Excel exportieren (CVS-Format)';
should be
$lang['exporttoexcel'] = 'Nach Excel exportieren (CSV-Format)';

and

$lang['export_spec'] = 'FormBuilderExportdatei-%s-%s.xls';
should be
$lang['export_spec'] = 'FormBuilderExportdatei-%s-%s.csv';

The latter actually fixes my second problem with the suffix. I will test more and report back if I can solve the character issue as well.

Re: FormBrowser CSV export issue (charset)

Posted: Thu Oct 04, 2018 8:39 pm
by DIGI3
You can request to join a translation team at https://www.cmsmadesimple.org/community ... nslations/

You might also be able to post in the German forum (viewforum.php?f=11) and see if one of the current translators can do it.