Forums

Hello again Mr. GreyHead and moderators

It seems that Chronoforms's actions do not work well when I save a CSV or XLS file. It doesn't save the character set correct.

The database is working in utf_8_general_ci and it is using the spanish charset (with symbols as á, é, í, ó, ú or ñ)

So if it want to store "Educación y Psicología" (Education & Psicology) it is saved in the file as "Educación y Psicología"

Data are shown correct but when they are saved into a file, these symbols are changed. I had downloaded and tested your new free CSV action but the problem does not solve

What am I doing wrong?

I have found server (ubuntu with joomla and chronoforms latests version installed) generates the file correct for UNIX systems but it does not work in Windows Systems or Mac

In Windows machines, I fix the CSV generated file opening with notepad and saving its data under UTF8 format, I know it is dataformat issue but I am stuck, can someone help me?

Thanks for your time

Hi Siphon,

I don't think that there is usually any problem with the CSV file - they are all downloaded with charset UTF-8 where there is an option. There can be a problem importing into Excel - you may need to set the charset there.

Bob

Thank you for your answer Mr. GreyHead

I am convinced the problem is inside charset, what is the right charset for latin/spanish symbols for a right work?

I am stuck in this point, can anyone give me any advice?

Server is server ubuntu 12.04 and host use to conect from iMacs and Windows machines

Hi Siphon,

UTF-8 works well.

Bob

Hello Mr GreyHead

I have been checking the data output on each form and I have obtained the following results:

CSV output sets a correct layout on Linux but the charset is wrong on Windows and Mac as I told you on previous posts

XLS output sets a correct layout on Windows, a bad charset in Linux (the same problem as I have with CSVs on Windows or Mac)

I have no problem on coding CSV or XLS output depending the operating system

I am convinced it is a type conversion problem, any ideas or suggestions will be welcomed

Sugesstion/question: Could it be possible an "add BOM" option on CSV actions? (This option inside XLS action add the UTF-8 BOM characters to the output and it works great for Windows and MacOS)

Thanks in advanced