...
Special characters can sometimes cause a problem. The issue is with Microsoft Excel. The workaround is the following:
1)
- 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
...