Contents
What does it mean when CSV file fails to parse?
An error message that begins “Failed to parse file” indicates that the uploaded CSV file is invalid in some way. Watershed supports UTF-8 comma separated files, which can use quotes to enclose text. Any quotes used in fields must be escaped with an additional double quote.
Why does my CSV template keep throwing errors?
Most commonly toDateTime function errors can occur with a previously working template if the format of the date in the uploaded CSV file changes. This can happen if either the original file that the template was based on, or the latest file that’s throwing errors, has been edited in Excel.
What are the lines in the CSV error message?
The line numbers referenced in the error message can be helpful in tracking down specific issues. The first number in the error message (“516731” in the example above) is the affected row of the CSV data. The other line number given (“516747” in the example above) is the affected line of the file.
Can a CSV import be used to assign multiple Personas?
CSV imports can be used to assign multiple personas to a person. This error means that a single import has attempted to assign the same persona to multiple people, but Watershed only allows a persona to be assigned to one person.
How can I correct errors in CSV files?
It enables you to remotely browse files on a data server, automatically identify and correct errors, and export the file to a database free from parsing errors. Watch the demos to learn more.
What does it mean when CSV file is not UTF-8?
This might indicate an unescaped quote where the next character after the quote is ‘x’. To fix this error, the uploaded CSV file must be fixed so as to be a valid UTF-8 CSV file. You should check that: The file is UTF-8 encoded. Fields are separated by commas. Any quotes appearing in the data are properly escaped with an additional quote character.