Special characters such as Quotation Marks, Commas or Apostrophes will cause issues when trying to import data through the Data Import Routine. This is because the file becomes delimited by these special characters.
We recommend, if possible you do not use these characters in names or descriptions as they will cause issues when exporting your product file in the future.
However if these characters are essential to your data they can be imported using a placeholder string.
For example, the data below will import the description up to the quotation mark, and then attempt to put the rest in the next import field.
If these characters are an essential part of your data you will need Infusion Support or your certified Partner to assist once the data is imported using this procedure:
Replace the special character in your .csv file with a ‘placeholder’ string – eg. “ZZZZZ” (this must be a string that is not normally found in your data).
Run the import
Infusion Support or your Certified Partner can now log in and in partner mode complete the following after a backup is taken:
REPLACE desc WITH STRTRAN(desc,"ZZZZZ",'"')
This command transforms the string ZZZZZ to "