Common Errors During Import and How to Fix Them
This page outlines common errors you may encounter during the import process and provides solutions for resolving them
If an error occurs, you can correct it directly in the Review & Correct step.
How to Fix Errors in the Review & Correct Step
- Hover over the error icon to view more details about the issue.
- Double-click on any cell with an error in the table to edit the value directly. For fields like Asset Model, Status, Assigned To, Checkout Type, and Inventory, you can select the appropriate value from a dropdown list.
- Once the error is corrected, re-validation will happen automatically, and the error icon will disappear if the issue is resolved.
| Error | Description | Solution | How to Fix |
|---|---|---|---|
| Missing Required Fields | Required fields like Name, Asset Tag, Status, Model, and Category are missing in the CSV. | Make sure all required fields are populated in your CSV file before import. | Hover over the error icon and double-click on the cell in the Review & Correct table to modify the field directly. |
| Invalid Date Format | The date format in your CSV file doesn’t match the selected format (e.g., YYYY-MM-DD). | Select the correct date format in the Date Format field to match your data. | Double-click on the date field in the Review & Correct table to correct it. |
| Duplicate Asset Tags | An asset with the same Asset Tag already exists in the system. | Ensure each asset has a unique Asset Tag in the CSV. | Skip or update the asset directly in the Review & Correct step. |
| Invalid Asset Model | The Asset Model doesn’t exist in the system or is incorrectly listed. | Verify the Asset Model and ensure it matches the existing models in your system. | Double-click on the Asset Model cell in the Review & Correct table and select the correct model from the list. |
| Invalid Assigned To / Checkout Type Mapping | Assigned To or Checkout Type fields are either missing or incorrectly mapped. | Map the Assigned To and Checkout Type fields correctly from your CSV. | Double-click on the Assigned To or Checkout Type cell in the table and select the appropriate value from the dropdown. |
| Missing or Invalid Inventory Data | The Inventory field is either blank or doesn’t match the available inventory in the system. | Ensure all Inventory fields contain valid data matching system values. | Double-click the Inventory field in the table and select the correct inventory from the list. |
| Invalid Currency in Purchase Cost | The Purchase Cost contains invalid formatting (e.g., missing currency symbol or incorrect decimal places). | Ensure Purchase Cost follows the correct format (e.g., 1299.99 USD). | Double-click on the Purchase Cost field to correct the value. |
| Asset Not Assigned to Any Location | Asset is marked for checkout, but there is no Assigned To or Location. | Assign a User, Asset, or Location to the asset in your CSV. | Select a value for Assigned To or Location directly in the table. |
| Field Value Exceeds Maximum Length | A field exceeds the allowed character limit (e.g., Asset Tag, Name, Notes). | Ensure field values are within the allowed length (check field character limits). | Double-click on the field and modify the value to fit within the length limit. |
| Invalid Status Transition | The asset’s Status is invalid or doesn’t allow the intended transition. | Ensure the Status is valid and compatible with transitions in your system. | Double-click on the Status field and select the valid status from the dropdown. |