Monthly Archives: November 2010

Chinese fonts

We need to import Chinese texts into vTiger.

At present data is stored in excel files with the correct characters, but we have not found a way to export these characters to CSV files.

It appears that OpenOffice is much better than MS Excel when exporting to CSV files. OpenOffice asks for the parameters to use when creating the CSV.

You can then select the character set (encoding), the Field delimiter and the Text delimiter. So nothing to wory, just open the MS Excel file in OpenOffice Clac,

select the worksheet to export,

Click File -> Save as

Select the Text CSV format

Select Charater set UTF-8, delimiters and save.