Data Validation Rules for Component Bulk Import
During the import process, AssetLoom validates your data to ensure it meets system requirements. Review the following rules before preparing your CSV file.
During the import process, AssetLoom validates your data to ensure it meets system requirements. Review the following rules before preparing your CSV file.
1. Default Fields
These are standard fields supported by AssetLoom. Each field has specific validation rules and, in some cases, automatic data handling.
| No. | Field | Requirement | Validation Rules | Data Handling / Notes |
|---|---|---|---|---|
| 1 | Name | Required | Max 255 characters | — |
| 2 | Inventory | Required | Max 255 characters | Auto-created if not existing. Cannot be saved if the component is assigned |
| 3 | Category | Required | Max length 255 characters. | Auto-created if not existing. The category must belong to the imported resource |
| 4 | Quantity | Required | Positive number\n\nMax quantity is 10000 | — |
| 5 | Min Quantity | Optional | Positive number\n\nMin quantity < Quantity | — |
| 6 | Order Number | Optional | Max 255 characters | — |
| 7 | Purchase Date | Optional | Must match selected date format | — |
| 8 | Purchase Cost | Optional | Numeric, max 2 decimal places | Currency is parsed automatically. Defaults to system currency if missing |
| 9 | Serial | Optional | Max 255 characters | — |
| 10 | Location | Optional | Max 255 characters | Auto-created if not existing |
| 11 | Department | Optional | Max 255 characters | Auto-created if not existing |
| 12 | Notes | Optional | Max 2048 characters | — |
2. Custom Fields
Custom fields are validated based on their configured type in AssetLoom.
| Field Type | Validation Rules | Data Handling / Notes |
|---|---|---|
| Textbox | Based on field configuration | — |
| Text Area | Max 2048 characters | — |
| List Box / Checkbox | Value must match predefined options | Multiple values must be separated by line breaks (\n) |
| Date Picker | Must be a valid date format | Must match configured format |
info
Only custom fields included in the import file will be processed; custom fields not present in the file will not be added automatically, even if they’re default custom fields.
Learn more about Custom Fields ->