Import Assets
AssetIT supports users to import their assets from a CSV file. You can download the sample CSV file format from the import dialog.
There are 3 steps to import assets including Data Preview, Importing and Results
Data Preview
In this step, you can preview all of your assets to be imported. It also validates your data, and displays invalid fields before you can submit the csv file to import.
Data validation
No | Field | Value | Require | Length |
|---|---|---|---|---|
1 | Name | Any text | Yes | Max: 50 characters |
2 | Asset Tag | Unique string | Yes | Max: 100 characters |
3 | Model | Asset Model name defined in Settings → Asset Models | Yes | NA |
4 | Status | Status Label name defined in Settings → Status Labels | Yes | NA |
5 | Serial | Any text | No | Max: 100 characters |
6 | Assigned To | Jira user id. This field requires Status (No #4) with Status Type deployable | No | Max: 150 characters |
7 | Order Number | Any text | No | Max: 100 characters |
8 | Purchase Date | Date format MMM D, YYYY. Example Mar 6, 2020 | No | NA |
9 | Purchase Cost | Format: Number with 2 decimal digits. Example 265.89 USD Currency: a valid currency. Default currency is USD if not provided | No | Min: 0 Max: 999999.99 |
10 | Warranty Months | Any number | No | Max: 999 |
11 | Department | Department name defined in Settings → Departments | No | NA |
12 | Location | Location name defined in Settings → Locations | No | NA |
13 | Supplier | Supplier name defined in Settings → Supplier | No | NA |
14 | Notes | Any text | No | NA |
Importing
After you ensured that all the input values are valid, click on Submit button to import your assets.
In here, you can see the import progress
Results
Results step shows you the final import results
In case the import process failed, you can download a csv file which contains all the failed rows
