Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Special characters can sometimes cause a problem. The issue is with Microsoft Excel. The workaround is the following:
1)

  1. Open your .csv import file in Excel 

...

  1. Go to File -> Save As -> Unicode Text

...

  1. Open the exported Unicode Text (*.txt) file with an advanced text editor like Notepad++ (http://notepad-plus-plus.org/download/v6.1.5.html)

...

  1. Go to Search -> Replace and replace all tabulations with ";" or ","

...

  1. Go to Encoding -> Convert to UTF-8 without BOM

...

  1. Go to File -> Save As and type a filename ending with the ".csv" extension

...

  1. Import the file into Lead Liaison

Alternatively, try a slightly different approach:

  1. Open your Excel document containing your list
  2. Highlight and copy the range of cells to import
  3. Create a blank document With an advanced text editor like Notepad++
  4. Paste your list into it
  5. Go to Encoding -> Convert to UTF-8 without BOM
  6. Go to File -> Save As and type a filename (keep the ".txt" file-type)
  7. Import the file into Lead Liaison using "TAB" as the field separator

Forcing Import of Special Characters

...