Why do I get an error whilst trying to import a CSV file?

What causes it?

If the Windows Batch Sender generates an error whilst importing a CSV (comma separated value) file then that means the CSV file is probably corrupt.

How do I fix it?

The Windows Batch Sender will still process and display the contents up to the point where it encountered the problem, so this can be used to identify where the error can be found in the CSV file.

Common errors include:

• Missing a comma between two values (for example Value1 Value2 instead of Value1, Value2).
• A text value containing a comma not being wrapped up in double quote marks (for example House 25, King Street instead of "House 25, King Street") which will cause the Windows Batch Sender to interpret the item as two values rather than one.

Once these errors in the CSV file have been corrected the Windows Batch Sender will be able to read the file correctly.