Importing from CSV File

When importing contacts from a CSV file, special characters (e.g. è, é, ê...) may not be visible at times.

It is important to ensure that your CSV file is encoded with the same character set that Lead Liaison is in (UTF-8 by default).

Unfortunately Microsoft Excel has trouble saving CSV files with a UTF-8 encoding. Another tool to use is OpenOffice.org Calc (which is similar to Excel and free).

To change a CSV file to use UTF-8 encoding with OpenOffice.org Calc, follow these steps:

Open your CSV file in OpenOffice.org Calc with its original encoding, e.g. Western Europe (Windows-1252/WinLatin1).
Verify that your special characters are appearing properly - if they are not, try another encoding when you open the file.
Go to File -> Save As and save the CSV file as an ODF Spreadsheet (in the 'Save as Type' drop-down).
Go to File -> Save As again and save the ODF file as a CSV again (Text CSV).
If you are prompted to Keep Current Format or Save in ODF Format, elect to Keep Current Format.
You will now be prompted to choose the character set, so choose UTF-8 from the drop-down.

The newly saved CSV file will now have a UTF-8 encoding, with all the special characters converted properly. You can then upload the file to Lead Liaison and it will preserve the special characters.

Special characters in Forms

If you find that special characters (e.g. öüó?ú?áéí) submitted into a subscription form,unsubscribe form, etc. do not show up in the application, the problem is most likely due to a difference in character encoding between the web page your form is on and Lead Liaison.

The application uses a UTF-8 character encoding by default, and you need to make sure that the page your form is on is also UTF-8 encoded. You might need to add the following tag to the <head> section of your HTML page:

Managing Special Characters

Special characters in Forms