Hi All,

I've found a problem while using the submissions exportation tool. The accents are messed up in the CSV file. Since I did not want my client to have to open the CSV file in notepad and save it back in UTF8 format each time, I modified the code...

The change was done in the 'components/com_rsform/submissions.class.php' file, around line #370.

I created a '$output' variable

and replaced every 'echo ...' to '$output .= ...'

Then I do this...
'echo utf8_decode($output);'

Could this fix be included in the next versions. I suppose this will have to be done also for the the backup/restore procedure.

Thanks,

- Dan

Hello,

Thank you for sharing this with us.

Hi Dan

I've experienced the same bug and I'm not a programmer. Any chance that I can have a copy of your 'components/com_rsform/submissions.class.php'?

Best regards

Mogens

Hello,

just bought me the latest version and it is still not fixed!

You could not we put the file "submissions.class.php" corrected for download?

Thank you

Abdel

@Adel08,

You can only add replies in English. Your post will be erased next time.

If you are using the latest version of RSForm!Pro (revision 28) you shouldn't encounter this issue. If for some reason this occurs, please submit a ticket here (in english):

http://www.rsjoomla.com/customer-support/tickets.html

The CSV file generated by the export uses the "UTF-8" character encoding, which is not correctly detected by some older versions of MS Excel. You must first save the file locally, then open Excel and use the data import wizard (Data menu->Import External Data). There you should be able to choose the correct encoding for your data: UTF-8 if available (Excel 2003) or the encoding corresponding to your language.

If this doesn't work, you need to open your file in a text editor that supports the UTF-8 character encoding (for instance notepad on windows) and save the file with an encoding supported by Excel (the 'ANSI' option in notepad should work).


thanks from https://app.formassembly.com/pages/support/troubleshooting

Hello,

Same pb with accents when exporting to CSV file, but the last version of RSform doesn't contain the "components/com_rsform/submissions.class.php" file.

I just have the path "component/com_forme/..." and no "submissions.class.php" file. Any translation of this solution to this new file structure ?

The RS team give also a solution for RSForm pro which is not appicable to RSform.