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.