You can add many activities to Assignar at once by importing a spreadsheet with Assisted Import on the Assignar dashboard. Activities, also called cost codes, are what workers code their time to on timesheets, for example Excavation or Demolition. Admins with the Data Import and Orders permissions can import activities.
Your company can rename some words in Assignar, so you might see a different word for Activities.
Before you start
You need the Data Import and Orders permissions, and not Read Only.
Have your file ready as .csv, .tsv, .xls or .xlsx, with one row per activity.
Columns for an activity import on the dashboard
The table below shows the fields an activity import on the Assignar dashboard accepts. Only Name is required.
Field | Required | What to enter |
Name | Yes | The activity's name, for example Excavation. Up to 100 characters. Names don't have to be unique, but two activities with the same name stop project imports from using that name. |
External ID | No | The cost code from your payroll or accounting system. Must not appear twice in the file or belong to an activity already in Assignar. Up to 100 characters. |
Unit | No | The unit of measure for quantities, for example m3 or hrs. Up to 20 characters. |
Import activities on the dashboard
To import activities with Assisted Import on the Assignar dashboard:
Go to Settings > Assisted Import.
On the Activities row, click Upload. The importer window opens straight away.
Upload your file or type the activities in.
Match the columns in your file to Name, External ID and Unit, and continue.
Fix any cells shown in red.
When every row is valid, click the submit button at the top of the importer. For activities it is labelled Activities.
Wait for "This is now complete.", then close the importer.
Each imported activity is created as an active, payable labour activity. You can change it afterwards on the activities list (the Status link on the Activities row opens it). If any row has a problem when you submit, no activities from the file are saved.
Common problems when importing activities on the dashboard
These are the messages the importer shows on an activity import on the Assignar dashboard, and how to fix them.
"Duplicate external identifier detected. Choose a unique ID.": an activity in Assignar already has this external ID. The activity may already exist: check your activities list.
"Unit cannot be greater than 20 characters.": shorten the unit, for example "m3" instead of "cubic metres".
"Unit cannot be blank.": the unit contains only spaces. Delete the spaces or enter a unit.
A missing Name, or the same external ID twice in the file, is also shown in red.
If the import fails after you submit, the message starts with "Failed to import data due to error:". See Why did my import fail on the dashboard?.

