Data Validation Rules for Asset 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 | Asset Tag | Required | Must be unique (within system and file) | Can be auto-generated if enabled |
| 3 | Status | Required | Must follow valid status transitions\n\nMax length 255 characters. | Created automatically if it does not exist |
| 5 | Category | Required | - Max length 255 characters.\n- The existing category must belong to the imported resource; otherwise, the category is invalid. | If the value does not exist, it is created automatically. The default category type is the imported resource. |
| 6 | Asset Model | Optional | If multiple rows define the same new Asset Model name, they must all belong to the same Category. Different categories for the same new model name will trigger an error. | If the model does not exist, it is created automatically, and linked to the category |
| 7 | Serial | Optional | Max 255 characters | — |
| 8 | Order Number | Optional | Max 255 characters | — |
| 9 | Notes | Optional | Max 2048 characters | — |
| 10 | Location | Optional | Max 255 characters | Auto-created if not existing |
| 11 | Department | Optional | Max 255 characters | Auto-created if not existing |
| 12 | Supplier | Optional | Max 255 characters | Auto-created if not existing |
| 13 | Inventory | Optional | Max 255 characters | Auto-created if not existing. Cannot be saved if asset is assigned |
| 14 | Assigned To | Optional | Max 150 characters | Only applied if status allows Checkout transition |
| 15 | Checkout Type | Optional | Must be User, Asset, or Location | Required to enable assignment during import |
| 16 | Purchase Date | Optional | Must match selected date format | — |
| 17 | Purchase Cost | Optional | Numeric, max 2 decimal places | Currency is parsed automatically. Defaults to system currency if missing |
| 18 | Enable Booking | Optional | Boolean values only | Accepts: 1, true, yes, y, on = True. All others = False |
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 ->