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.

Done

Advertisements
Post a comment or leave a trackback: Trackback URL.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: