Skip to main content

How do I import workers on the dashboard?

You can add many workers to Assignar at once by importing a spreadsheet with Assisted Import on the Assignar dashboard.

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.

Email

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:

  1. Go to Settings > Assisted Import.

  2. On the Workers row, click Upload.

  3. 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.

  4. In the importer window, upload your file or type the workers in.

  5. Match the columns in your file to the fields in the table above, and continue.

  6. 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.

  7. When every row is valid, click Submit Fieldworkers.

  8. 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.

The Workers Data Formats window with the date and phone number formats.

Worker rows in the importer, with a red email cell and its message.

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

Did this answer your question?