| Error Message | Reason | Resolution |
|---|---|---|
Input string was not in a correct format. | A required column's data is not the required format - usually a number. Import data may be blank or contain alpha characters or symbols such as commas, currency symbols etc. | Remove the data that is not in the required format. Replace blank data with a zero. |
| 'System.Dynamic.ExpandoObject' does not contain a definition for 'xxxxxxx' | You are missing a required column/header in the import spreadsheet. Even if you do not need to populate it with data, it still needs to be included in the import. | The message will contain the missing header name that needs to be added to the import spreadsheet. eg: does not contain a definition for 'AccountCode' where AccountCode is the missing header |
| String was not recognized as a valid Boolean. | IsActive column missing TRUE or FALSE value | Add TRUE or FALSE to IsActive column. |
| Method arguments are not valid! See ValidationErrors for details | Missing required/mandatory data. | Check the fields required for import and populate with valid data. |
| No code specified. | No product code/sku data in required/mandatory column | Populate the code/sku column for each row. |
| Error at line x: Object reference not set to an instance of an object. | Duplicate SKU in the product import. WorkGuru cannot identify the correct product to match and update. | Identify and resolve the duplicate so all SKU in the import are unique. |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article