You can add many assets to Assignar at once by importing a spreadsheet with Assisted Import on the Assignar dashboard. Assets are the vehicles, plant and machinery you schedule on jobs. Admins with the Data Import and Add Tasks/Machines permissions can import assets.
Your company can rename some words in Assignar, so you might see a different word for Assets or Tasks.
Before you start
You need the Data Import and Add Tasks/Machines permissions, and not Read Only.
Every asset name must be unique in Assignar, including archived assets. Check the Assets page if you're not sure.
Have your file ready as .csv, .tsv, .xls or .xlsx, with one row per asset.
Columns for an asset import on the dashboard
The table below shows the fields an asset import on the Assignar dashboard accepts. Only Name is required.
Field | Required | What to enter |
Name | Yes | The asset's name, for example Excavator 20t - EX01. Must not appear twice in the file or belong to any asset already in Assignar, including archived ones. Up to 255 characters. |
Description | No | Up to 255 characters. |
External ID | No | An ID from another system, such as your asset register. Must be unique, like Name. Up to 50 characters. |
Registration Number | No | The rego, for example EX01. Up to 20 characters. |
Year | No | A four-digit year starting with 1 or 2, for example 2019. |
Make | No | For example Komatsu. Up to 100 characters. |
Model | No | For example PC210. Up to 100 characters. |
Serial Number | No | Up to 150 characters. |
Charge Rate | No | A whole number with no dollar sign or decimals, for example 180. |
Number Reading | No | The current odometer or hour-meter reading, as a whole number, for example 4520. |
Comments | No | Up to 255 characters. |
Tags | No | Asset tags, separated by commas. New tags are created. |
Tasks | No | The tasks (roles) this asset can be used for, separated by commas, for example "Operator". New tasks are created. |
Import assets on the dashboard
To import assets with Assisted Import on the Assignar dashboard:
Go to Settings > Assisted Import.
On the Assets row, click Upload. The importer window opens straight away; there is no Data Formats window for assets.
Upload your file or type the assets in.
Match the columns in your file to the fields in the table above, and continue.
Fix any cells shown in red. Click a cell to read the problem, then type a new value or delete the row.
When every row is valid, click Submit Assets.
Wait for "This is now complete.", then close the importer.
The new assets appear on the Assets page as active assets. If any row has a problem when you submit, no assets from the file are saved.
Common problems when importing assets on the dashboard
These are the messages the importer shows on an asset import on the Assignar dashboard, and how to fix them.
"Duplicate name detected. Choose a unique name.": an asset in Assignar, active or archived, already has this name. Rename the asset in your file, for example by adding its fleet number.
"Duplicate external identifier detected. Choose a unique ID.": an asset in Assignar already has this external ID.
"Year must be a valid year format": enter four digits, for example 2019.
"Charge Rate must be a valid chargeRate format": enter a whole number only, with no $, commas or cents.
"Number Reading must be a valid number reading format": enter a whole number only, with no units or decimals.
A missing Name, or the same name or external ID twice in the file, is also shown in red.
After you click Submit Assets, a problem the importer didn't catch (for example a registration number longer than 20 characters) shows "Failed to import data due to error: Unable to import Asset:" followed by the reason. See Why did my import fail on the dashboard?.

