Dear Paessler Team

While using "/api/table.csv" function of the API, we notice that resulting data was not correctly extracted when it contains special symbols such as "é, è, ç..." (which are quite frequent in my country).

My question is : is there any option coming with "/api/table.csv" function such that we could explicitly mention the output encoding format (such as UTF-8 for instance) ?

Best regards

Mathieu Boscher

Article Comments

Hi,
The API output is encoded in UTF-8 already. May you send us an email to support@paessler.com referring to this thread? Please include the API call you are using, the output of the same as well as the language of your PRTG installation.
Best regards


Jun, 2014 - Permalink

Guten tag

Brilliant, You are definitely right! We change the code accordingly, & now everything runs fine.

One more time, thanks for your precious help.

Mathieu BOSCHER -------------------------------------------------------------------------------------------------------- Good morning Mathieu,

Thank you for sending over the files.

I just checked the same and it seems this is only a display issue when using Excel as by standard the encoding Excel uses is Windows 1252 and the files are UTF-8 encoded. Please try opening the file using Notepad++ (http://notepad-plus-plus.org/) you should not have any issues here.

If you want to open the files in Excel correctly you have to import the file but not just open it. To do so, create an new empty file in Excel. Then do to tab "Data" and use the import from text function there. As encoding choose UTF-8 instead of the Windows encoding. Excel should now show the data correctly (see attachment).

With kind regards / Mit freundlichen Gruessen


Jul, 2014 - Permalink