Versions Compared

Key

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

Importing CSV Files into Lead Liaison

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

...

7) Import the file into Lead Liaison

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.