Importing CSV files with special characters
Importing CSV Files into Lead Liaison
Special characters can sometimes cause a problem. The issue is with Microsoft Excel. The workaround is the following:
Open your .csv import file in Excel
Go to File -> Save As -> Unicode Text
Open the exported Unicode Text (*.txt) file with an advanced text editor like Notepad++ (http://notepad-plus-plus.org/download/v6.1.5.html)
Go to Search -> Replace and replace all tabulations with ";" or ","
Go to Encoding -> Convert to UTF-8 without BOM
Go to File -> Save As and type a filename ending with the ".csv" extension
Import the file into Lead Liaison
Alternatively, try a slightly different approach:
Open your Excel document containing your list
Highlight and copy the range of cells to import
Create a blank document With an advanced text editor like Notepad++
Paste your list into it
Go to Encoding -> Convert to UTF-8 without BOM
Go to File -> Save As and type a filename (keep the ".txt" file-type)
Import the file into Lead Liaison using "TAB" as the field separator
Forcing Import of Special Characters
It looks like you have to enclose the CSV fields with quotes in order for the system (which uses php fgetcsv function) to parse those characters correctly. Otherwise they are stripped out. They tried various ways of encoding the file before it's parsed by fgetcsv but it seems to strip the characters out. The problem is the quotes remain in the values.