Error: Field cannot contain | and "

Error message when importing a contact source

Symptoms

When importing a contact source into your Acoustic Campaign Org, either through an Import Update, Import New, or a Recurring Import Job, the Data Job fails with the following error: Field cannot contain | and '.

This issue usually occurs when importing a PSV file with an opening ' that does not have a corresponding closing '. Example records that may fail to import may look similar to |TULIP 26' SKIRT| while records that are imported successfully may look like |Cashmere 'V' Neck Sweater|.

Resolving the problem

Try importing the file as a TSV instead of a PSV. This will remove your | characters, allowing Acoustic Campaign to properly parse and import records that may contain a single opening ' but no closing ' in the same field.