You can add many workers to Assignar at once by importing a spreadsheet with Assisted Import on the Assignar dashboard. Workers are the people who use the Assignar mobile app in the field. Admins with the Data Import and Add Users permissions can import workers.
Your company can rename some words in Assignar, so you might see a different word for Workers or Tasks. The importer window itself calls workers Fieldworkers, for example on the Submit Fieldworkers button.
Before you start
You need the Data Import and Add Users permissions, and not Read Only.
If you want to give workers an employment type, set the employment types up first. The import can only choose from employment types that already exist.
Every worker needs a first name, last name and an email address that no other active worker in Assignar uses.
Have your file ready as .csv, .tsv, .xls or .xlsx, with one row per worker.
Columns for a worker import on the dashboard
The table below shows the fields a worker import on the Assignar dashboard accepts. Only First Name, Last Name and Email are required.
Field | Required | What to enter |
Employee ID | No | Your own ID for the worker, for example from payroll. Up to 50 characters. Must be unique: not used twice in the file, and not used by any worker already in Assignar, including archived workers. |
First Name | Yes | Up to 100 characters. |
Last Name | Yes | Up to 100 characters. |
Employment Type | No | Choose from your company's existing employment types. New types are not created. |
Yes | A valid email address, unique in the file and not used by an active worker in Assignar. It becomes the worker's login for the mobile app. Up to 100 characters. | |
Date Of Birth | No | A date in the format you choose in the Data Formats window, for example 15/4/1990. |
Mobile Phone | No | A valid phone number for the country you choose in the Data Formats window, or a number that starts with its country code, for example +61 412 345 678. |
Address | No | Up to 100 characters. |
Suburb | No | Up to 100 characters. |
Postcode | No | Up to 10 characters. |
State | No | Up to 50 characters. |
Emergency Contact | No | The emergency contact's name. Up to 50 characters. |
Emergency Contact Phone | No | Checked the same way as Mobile Phone. |
Comments | No | Any notes. |
USI | No | The worker's Unique Student Identifier. |
Tags | No | One or more worker tags, separated by commas. Tags that don't exist yet are created. |
Tasks | No | One or more tasks (roles) the worker can do, separated by commas, for example "General Workforce, Supervisor". Tasks that don't exist yet are created. |
Import workers on the dashboard
To import workers with Assisted Import on the Assignar dashboard:
Go to Settings > Assisted Import.
On the Workers row, click Upload.
The Workers Data Formats window opens. Choose:
Date Format: Day / Month / Year or Month / Day / Year, to match the dates of birth in your file.
Phone Number Format: Australia (AU) or United States (US), to match phone numbers that don't start with a country code. Assignar pre-selects these from your location. Click Continue.
In the importer window, upload your file or type the workers 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. See "Common problems when importing workers" below.
When every row is valid, click Submit Fieldworkers.
Wait for "This is now complete.", then close the importer.
The new workers appear on the Users page. Back on Assisted Import, the Workers row shows the new Record Count and your name under Last Imported By.
If one row has a problem when you submit, no workers from the file are saved. Fix the problem and submit again.
Common problems when importing workers on the dashboard
These are the messages the importer shows on a worker import on the Assignar dashboard, and how to fix them.
"Email is not a valid email address": the email has no @, no dot after the @, or contains a space. Correct the address.
"Duplicate email detected. Choose a unique email.": an active worker in Assignar already uses this email. The worker may already exist: search the Users page. If it is someone else, use a different email.
"Duplicate employee ID detected. Choose a unique ID.": a worker in Assignar, active or archived, already has this employee ID. Use a different ID, or leave it blank.
"Phone number is not a valid phone number.": the number isn't valid for the country chosen in Phone Number Format. Add the country code (for example +64 for New Zealand) or correct the number.
"Date must be a valid date format": the date of birth doesn't match the Date Format you chose. Correct the date, or start the import again and choose the other format.
A required or duplicate cell (First Name, Last Name, Email missing, or the same email or employee ID twice in the file) is also shown in red. Fill it in or remove the duplicate row.
For errors that appear after you click Submit Fieldworkers, see Why did my import fail on the dashboard?.
What happens to imported workers
Each imported worker is created on the Assignar dashboard as an active worker with mobile app access, and their email is their login. Tags and tasks in the file are linked to the worker, and any that didn't exist are created. To check or change a worker afterwards, open them from the Users page.
Related articles
How do I add a task on the dashboard? How do I add a role (task) on the dashboard?


