Data Validation Rules for License 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 | Seats | Required | Positive number\n\nMax quantity is 10000 | — |
| 5 | Serial | Optional | Max 255 characters | — |
| 6 | Manufacturer | Optional | Max 255 characters | Auto-created if not existing |
| 7 | Order Number | Optional | Max 255 characters | — |
| 8 | Purchase Order Number | Optional | Max 255 characters | — |
| 9 | Purchase Date | Optional | Must match selected date format | — |
| 10 | Purchase Cost | Optional | Numeric, max 2 decimal places | Currency is parsed automatically. Defaults to system currency if missing |
| 11 | Expiration Date | Optional | Must match selected date format | — |
| 12 | Termination Date | Optional | Must match selected date format | — |
| 13 | Depreciation | Optional | Max 255 characters | Auto-created if not existing. Defaults to system currency if missing |
| 14 | License to Name | Optional | Max 255 characters | — |
| 15 | License to Email | Optional | Must be a valid email | — |
| 16 | Department | Optional | Max 255 characters | Auto-created if not existing |
| 17 | Supplier | Optional | Max 255 characters | Auto-created if not existing |
| 18 | Reassignable | Optional | Boolean values only | Accepts: 1, true, yes, y, on = True. All others = False |
| 19 | 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 ->