If you have opened a csv file and found weird characters in it, chances are you are using Excel. All of WebCollects exports are in the "UTF8" character set, which covers all international characters correctly. Some versions of Excel have trouble opening csv files that use UTF8 format. We can't promise that this will work (nor do we provide support for using Excel if you have an issue), however you can try this (or something similar depending on the version you are using):
- Save the exported file as a csv
- Open Excel
- Import the data using Data-->Import External Data --> Import Data
- Select the file type of "csv" and browse to your file
- In the import wizard change the File_Origin to "65001 UTF" (or choose correct language character identifier)
- Change the Delimiter to comma
- Select where to import to and Finish
If you can't make that work, you can force WebCollect to export
all CSV files in a more limited character set, which Excel should
have less trouble with. Go to:
Admin Home -> Organisation -> Edit -> Configuration
tab
Change the "CSV output character set" to one of the more limited
character set options and retry your export. Bear in mind that
these more limited character sets, cannot cover all international
characters like UTF8 can.