Comma Separated Values (CSV) Files Localization

Localtransformer supports also localization for Comma Separated Values (.csv) files. It does extract the values of the strings to be localized and the structure of the file is remained intact.
In order to localize a Comma Separated Values file , create a new project and add it to the target files or simply add it to an existing project. Then a new screen will appear where the user specifies if this csv file is for .NET 3.5 localization or if it is a normal csv file. Choose "Normal CSV File". Then you will have to specify the csv file format. Select the delimiter (the character that separates values) the text qualifier , how to escape the qualifier character and whether to convert escape symbols. Also if the first line of the csv file consists of column headers specify "Ignore Column Headers". You can also specify to ignore a number of lines in the beginning of the file. Afterwards, specify which columns consist the key of each item to be localized. Then specify the localized columns i.e. the columns that contain the data to be localized. They can be more than one . This means that Localtransformer can localize more than one column of the csv file. Lastly, specify the Comments columns i.e. the columns that contain the comments for each localized item.
As was mentioned earlier , Localtransformer extracts the values of the strings to be localized and leaves the structure of the file intact.
If , for example , the .csv file that is to be localized contains the following text :

"Category","Key","Message"

# basic info

"Misc","ApplicationTitle","Catalog of Mobile Phones"

"Category","Category Description","Latest Mobile Phones"

# product list

# product 1

"Product1","ID","1000"

"Product1","Name","DS 150 Mobile Phone"

"Product1","Description","Popular mobile phone with 5 mega pixels camera , GPRS and Java"

The German version of the .csv file, if we localize only the third (called "Message") column, will have the structure of the file intact and only the values will be changed :

"Category","Key","Message"

# basic info

"Misc","ApplicationTitle","Katalog von Handys"

"Category","Category Description","Aktuelle Handys"

# product list

# product 1

"Product1","ID","1000"

"Product1","Name","DS 150 Handy"

"Product1","Description","Beliebte Handy mit 5-Megapixel-Kamera , GPRS und Java"