UTF8 problem with submissions export

Welcome, Guest

UTF8 problem with submissions export

(1 viewing) (1) Guest

Reply Topic

New Topic

Page:
1

TOPIC: UTF8 problem with submissions export

UTF8 problem with submissions export 2 years, 4 months ago #8468

kamidan
OFFLINE
Fresh Boarder
Posts: 1

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

Reply Quote

Re:UTF8 problem with submissions export 2 years, 4 months ago #8607

alexp OFFLINE Moderator Posts: 1047	Hello, Thank you for sharing this with us.
	Please note: my help is not official customer support. To receive your support, submit a ticket by clicking here Regards, RSJoomla! Development Team Reply Quote

Re:UTF8 problem with submissions export 1 year, 12 months ago #9796

mkalleso OFFLINE Fresh Boarder Posts: 1	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
	Reply Quote

Re:UTF8 problem with submissions export 1 year, 8 months ago #10505

Abdel08 OFFLINE Fresh Boarder Posts: 1	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
	Last Edit: 1 year, 8 months ago by alexp. Reply Quote

Re:UTF8 problem with submissions export 1 year, 8 months ago #10510

alexp OFFLINE Moderator Posts: 1047	@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
	Please note: my help is not official customer support. To receive your support, submit a ticket by clicking here Regards, RSJoomla! Development Team Reply Quote

Re:UTF8 problem with submissions export 1 year, 8 months ago #10674

lord313
OFFLINE
Fresh Boarder
Posts: 1

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

Reply Quote

Re:UTF8 problem with submissions export 11 months, 3 weeks ago #12797

zaldiar OFFLINE Fresh Boarder Posts: 2	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.
	Reply Quote

Re:UTF8 problem with submissions export 6 hours, 1 minute ago #0

rsjoomlasupport
OFFLINE
Moderator

Hello,
This is an automatically generated message.
We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you wish to receive our support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here: http://www.rsjoomla.com/support-policy.html.

Thank You!
PLEASE NOTE: This topic is NOT locked and you can add replies to it. Other users are free to reply as well. This message has been generated by a bot and has no effect on the topic whatsoever.

Need help ? Submit a ticket!

Reply Quote