Assisted Import lets you add many records to Assignar at once from a spreadsheet, instead of typing them in one by one. On the Assignar dashboard you can use it to import workers, clients, assets, activities (cost codes) and projects. Admins with the Data Import permission can use it.
Your company can rename some words in Assignar, so you might see different names for Workers, Clients, Assets, Activities or Projects on the page.
Before you start
You need the Data Import permission in your user access settings, and you must not have Read Only. Without it, Assisted Import does not appear under Settings.
You also need permission to add the records you are importing. See "Permissions for each data type" below.
Have your data in a .csv, .tsv, .xls or .xlsx file. The page says "Supported file types: .CSV, .TSV, .XLS & .XLSX."
Import in this order, because later records refer to earlier ones: workers, clients, assets, activities, then projects. A project import can create missing clients and activities for you, but it can't match a worker or contact that is spelled differently.
What you can import with Assisted Import
The table below shows each data type on the Assisted Import page of the Assignar dashboard, the description the page shows for it, and the article with the columns and rules.
Data type | Description on the page | Article |
Workers | "Your work force at job sites" | |
Clients | "Your customers" | |
Assets | "Vehicles or machinery" | |
Activities | "Activities or cost codes" | |
Projects | "Create new Projects and update existing Projects that have matching names." |
To import contacts, suppliers, tasks (roles), skills, competencies, inductions or asset attachments, use Legacy Import instead. See How do I import other data with Legacy Import on the dashboard?.
Open Assisted Import on the dashboard
To open Assisted Import on the Assignar dashboard, go to Settings > Assisted Import.
The page shows Getting Activated, the supported file types, the 3 simple steps (Upload, Map & Adjust, Begin) and a Recommended Data table with one row per data type. The table has these columns:
Type: the data type. Point to the question-mark icon to see its description.
An Upload button that starts an import.
Status: a link icon. Point to it to see "Edit Data", and click it to open that list in a new tab, for example the Clients page.
Record Count: how many records of that type your company has in Assignar now, not only the imported ones. It shows "..." when there are none.
Last Imported By and Date Uploaded: who ran the last Assisted Import for that type, and when. They show "..." if nobody has.
How an Assisted Import works on the dashboard
Every Assisted Import on the Assignar dashboard follows the same steps:
On the Recommended Data table, click Upload on the row for the data type.
For Workers and Clients only, a Data Formats window opens first. Choose how dates and phone numbers are written in your file, then click Continue. Click BACK to cancel.
The importer window opens. Upload your file, or type the data in.
Match the columns in your file to the Assignar fields. Assignar suggests a match for each column from its heading, so your headings don't have to match exactly.
Fix any problems. Cells with a problem are shown in red; click a cell to read the message and type a new value. Assignar checks required fields, duplicates within the file, duplicates against records already in Assignar, and the format of emails, phone numbers, dates and numbers.
When every row is valid, click the submit button, for example Submit Clients. The button can't be used while any row has a problem.
When the import has finished, the importer shows "This is now complete." Close the importer to go back to the Assisted Import page. Record Count, Last Imported By and Date Uploaded are updated.
If anything goes wrong when you submit, the importer shows a message that starts with "Failed to import data due to error:". When that happens, none of the rows in the file are saved, so you can fix the problem and submit the same file again. See Why did my import fail on the dashboard?.
Permissions for each data type
Assisted Import on the Assignar dashboard checks two permissions: Data Import to open the page, and the permission to add that kind of record. The table below shows the second permission for each data type.
Data type | Permission needed as well as Data Import |
Workers | Add Users |
Clients | Add Projects/Clients |
Projects | Add Projects/Clients |
Assets | Add Tasks/Machines |
Activities | Orders |
If you have Data Import but not the second permission, the import fails when you submit, with a message such as "Failed to import data due to error: You do not have access to write Users." Ask an admin with User Access Management to update your access.
Can I undo an Assisted Import?
No, Assisted Import on the Assignar dashboard has no undo. Imported records are added to Assignar like records you create by hand, so to remove them you archive or delete them from their own page, for example Clients or Assets. Every import is recorded in Settings > Audit Trail, with who ran it and how many records it added: worker, client, asset and project imports under the Import module, and activity imports under the Activity module.

