search

bpcurse / nextcloud-userexport

PHP script to export and filter lists (users, groups and groupfolders) using different Nextcloud APIs
The Unlicense
11 stars 3 forks source link

Special chars on CSV export #62

Open solracsf opened 3 years ago

solracsf commented 3 years ago

CSV outputs :

Etc.

bpcurse commented 3 years ago

I've just tested this by creating a testuser (Database, not LDAP backend) on Nextcloud 20.0.10 / userexport 1.2.1 and did a csv file export using Firefox 89.0/Linux. After opening the file in LibreOffice (with default UTF-8 setting) "Mélanie Tëst" (Displayname) is displayed correctly :thinking:

I have to test this on Nextcloud v21, as soon as I'm able to.

bpcurse commented 3 years ago

Now I was able to test on Nextcloud v21.0.3 but I still cannot recreate the issue.

An experimental user with the displayname "Mélanie Tëst" is displayed correctly in the table, the csv browser display and after opening the csv file with LibreOffice and MousePad.

The only way for me to recreate this issue is by forcing LibreOffice to use another charset on import (like ISO-8859-15/EURO instead of UTF-8). I cannot test this on Windows/Microsoft Office as I got rid of it years ago.

Could this be some individual client/software configuration problem? What software has been used to open the file? Did it ask you for a charset on import? Is the System using UTF-8? Could you try to export and open the csv file on another client system?

solracsf commented 3 years ago

I'll test again soon to be sure.