Hi,
I'm using csv files as datasource for my tests. As I'm testsing the strings displayed on the GUI in different languages I added a csv file as datasource containing all strings in the different languages.
The CSV file is created from an excel sheet following the steps (I cannot use excel directly because there is no excel installed on the testpc):
1. Save the excel sheet as Unicode textfile with ending .txt
2. replace the tabs in the textfile (using texteditor) with ","
3. Save the file as CSV file.
My Problem is now, that within Ranorex the CSV file is not correctly displayed within the Datasource editor
It seems that every character gets its own row.
I attached the CSV file I wanted to use as Datasource as well in a little bit reduced version (because of internal data)
CSV file with chinese characters
CSV file with chinese characters
You do not have the required permissions to view the files attached to this post.
Re: CSV file with chinese characters
Hi,
It seems the data connector does not support Unicode? Is it absolutely necessary for you to use the Unicode encoding? If you save it with UTF-8, it will work as expected... Try this file saved eith UTF-8:
It seems the data connector does not support Unicode? Is it absolutely necessary for you to use the Unicode encoding? If you save it with UTF-8, it will work as expected... Try this file saved eith UTF-8:
You do not have the required permissions to view the files attached to this post.
Pavel Kudrys
Ranorex explorer at Descartes Systems
Please add these details to your questions:
Ranorex explorer at Descartes Systems
Please add these details to your questions:
- Ranorex Snapshot. Learn how to create one >here<
- Ranorex xPath of problematic element(s)
- Ranorex version
- OS version
- HW configuration
Re: CSV file with chinese characters
Thank you very much for this quick answer! This solved my problem.
Re: CSV file with chinese characters
You are welcome! 
Pavel Kudrys
Ranorex explorer at Descartes Systems
Please add these details to your questions:
Ranorex explorer at Descartes Systems
Please add these details to your questions:
- Ranorex Snapshot. Learn how to create one >here<
- Ranorex xPath of problematic element(s)
- Ranorex version
- OS version
- HW configuration
Re: CSV file with chinese characters
but when i open it with Microsoft Excel & save. And open it back i can see chinese characters got replaced with junk characters. i think its due to the BOM in the CSV.
You do not have the required permissions to view the files attached to this post.
