The most common reasons for data import errors relate to the data import file not being formatted as expected by Virtual Ticket's Data Import tool:

• You have a blank space instead of a tab character between fields in the data import text file.
• Data in a field in the text file cannot be converted to the expected field type in the database.

If you encounter errors on Import Data, check to make sure that:

• The number of fields in each line of your data import text file corresponds to the number of fields selected in the Fields for Import list of the Import Data window.
• The fields in your data import text file are tab-delimited.
• If your import data includes Customer Codes, all Customer Codes that are to be imported must either use a NULL value or correspond to existing Customer Codes in the database.

If there is an error on importing the import data text file, the import will stop and an error message will be displayed. Error messages typically contain information indicating the line and field in which it encountered the error.

Because the Import Data tool processes data import files in batches of 100 lines, errors will result in no data being imported for the batch in which the error was encountered, but data imported for any preceding batches will be added to the database.