Skip to main content
All CollectionsIntegrationsAdvanced CSV Connector
Error handling in the Advanced CSV connector
Error handling in the Advanced CSV connector
S
Written by Sara Jaffer
Updated over a week ago

The Advanced CSV connector is in Early Access. If you're interested, you can click here to apply to our Early Adopter Program.

Note: The Advanced CSV connector is only available to Premium subscribers. Contact Inventory Planner Support to learn more about upgrading to Premium.

The Advanced CSV connector will alert you of any errors within the rows of your loaded files.

Row-level errors will not stop your file from processing – only the individual affected row.

Reported errors

The errors that will be reported are:

  • Required data missing

  • Invalid data (wrong type, invalid value for the field, or too long for the field)

  • Unique ID is not unique

  • A referenced ID does not exist (e.g. a stock order references a warehouse ID that doesn’t exist)

Note that the connector will not provide any error messaging if there is a file-level error (e.g. incorrect format, invalid columns). The file will simply fail to process.

Error notifications

If a sync fails, you’ll receive an error notification in Inventory Planner beside the “Sync” icon in the menu.

Clicking on the Sync icon will display the Sync menu, where you can access the connector settings and view a summary of the last sync for each file.

The summary will list:

  • The file type

  • The last time the file was synced

  • The sync status

    • Successful

    • Errors

    • No file supplied

  • List of all files synced in the batch processing

  • Count of row errors in all files of this type

You can click the “View sync errors” button at the bottom of the page to view a detailed report of all the errors.

Sync records page

The Sync records page displays all the errors which have been flagged to date. Access the Sync records page in your connector settings by clicking “View sync errors” at the bottom of the page.

On the page, you’ll see a table with the following information:

Column

Data

ID

Connection

Name of the Advanced CSV connection the file is linked to

File type

The type of data file

Error type

General type of error

Error

Details of the error

File name

The file resource where the error was flagged

File uploaded at

The date and time the file was uploaded

File line

The row in the file which displayed the error

You can filter to view specific errors based on date ranges, error types, file types, and the specific Advanced CSV connection. You can also search for specific file names.

Did this answer your question?