Definition of "Index was outside the bounds of the array" import error

Description

What does the "Index was outside the bounds of the array" import error mean?

Resolution

This error is returned by email when a file import fails because of invalid formatting. This typically indicates that one or more fields are missing in the file. When creating a CSV file for import, all fields are required, even if they are empty. As an example, take a look at this sample CSV import.

The commas separate the information, you can think of them as the columns of a spreadsheet. The values on the first line are the column headers; lines two and three contain sample customers/transactions.

Notice the series of adjacent commas towards the ends of lines two and three. These commas denote optional information that the user is choosing not to submit. In other words, the commas mark where that optional information would be if the user were submitting it. If the commas were omitted entirely, then the columns would be out of alignment, and the system would lose track of where it is.

If you have questions or require additional assistance, please submit a ticket and we will be in touch with you shortly.