CSV file with chinese characters

Ask general questions here.
anja
Posts: 67
Joined: Fri Nov 26, 2010 3:39 pm

CSV file with chinese characters

Post by anja » Thu Apr 11, 2013 2:23 pm

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
RANOREXDatasource.JPG
DatasourceEditor Ranorex
RANOREXDatasource.JPG (31.62 KiB) Viewed 10506 times
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)
IM Translation_Small.csv
CSVFile
(216 Bytes) Downloaded 467 times

User avatar
odklizec
Ranorex Guru
Ranorex Guru
Posts: 3945
Joined: Mon Aug 13, 2012 9:54 am
Location: Zilina, Slovakia

Re: CSV file with chinese characters

Post by odklizec » Thu Apr 11, 2013 4:57 pm

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...
utf_8.png
utf_8.png (10.14 KiB) Viewed 10498 times
Try this file saved eith UTF-8:
IM Translation_Small.csv
(124 Bytes) Downloaded 940 times
Pavel Kudrys
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

anja
Posts: 67
Joined: Fri Nov 26, 2010 3:39 pm

Re: CSV file with chinese characters

Post by anja » Fri Apr 12, 2013 6:41 am

Thank you very much for this quick answer! This solved my problem.

User avatar
odklizec
Ranorex Guru
Ranorex Guru
Posts: 3945
Joined: Mon Aug 13, 2012 9:54 am
Location: Zilina, Slovakia

Re: CSV file with chinese characters

Post by odklizec » Fri Apr 12, 2013 8:00 am

You are welcome! ;)
Pavel Kudrys
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

pinnaka
Posts: 1
Joined: Thu Sep 05, 2013 10:34 am

Re: CSV file with chinese characters

Post by pinnaka » Thu Sep 05, 2013 10:38 am

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.
Attachments
IM Translation_Small.csv
(107 Bytes) Downloaded 307 times