When a Excel Sync revision fails to load the status will be Updated to Invalid and the error causing it to first fail will be indicated in the Errors column.
Given the process stops processing once the first error is found, you may find that once the error is fixed and the file is re-processed another error will be presented.
Common Errors
- Invalid Transaction ID on Row XX - The row number indicated has no Row ID to import. Transaction IDs should not be changed or removed. You can remove the complete row. Note that will not delete it from the system. Only rows imported in get updated, none get deleted.
- Invalid Transaction ID on Row XX - The row number indicated is the Row ID in excel of the first error in the file. Transaction IDs should not be changed. So this error might occur if the user has modified the ID on the output file. Or the transaction was removed from the system after the output file was originally created, so the system can not find the transaction to update.
- Invalid transaction kind “” entry in row XXX - The row number indicated is after all the rows in your file. This error is fixed by deleting all rows after the last row you are uploading in this sync file. Excel is recognizing data after your last record and is trying to load that row. By deleting all rows after, this error will be rectified.
- Invalid column "column_name" in CSV file - The sync process looks for the columns in the exact order that the current output file produces. If columns are reordered, added or deleted this error will be shown. The column name listed is the first column it has found an error. It was expecting the column from the output file and instead found this column.
- Export a new file from the system - and you can see the order of columns required. If the file you are trying to import was created before a change was deployed to the excel template, it is likely to be missing columns. If those columns are grey in the new file export (meaning they don't sync back into the system) you can just insert those into the system (with the appropriate column headers) and reimport the file successfully.
- Exceeding 100 labels - 100 unique labels is the allowed limit. This includes the labels already created (and showing in the application) as well as the new labels you are currently importing via Excel. Remove labels from the Transaction section (via the Action link) to allow new labels to be imported from Excel.
- The total number of labels for each Data Viz Column is shown when you click the Data Viz Columns button on the TRANSACTIONS screen.
-
- Note, it is 100 unique customer labels. The 'Unknown' (default) label does not count against the 100 unique labels.
Check this article for more information on Excel Sync.