Legacy Import on the Assignar dashboard imports records that Assisted Import doesn't handle: contacts, suppliers, tasks (roles), skills, competencies, inductions and asset attachments. It reads one sheet of an Excel file and lets you choose which spreadsheet column goes into each Assignar field. Admins with the Data Import permission can use it.
Your company can rename some words in Assignar, so you might see different names for the record types and fields, for example Role instead of Task.
Before you start
You need the Data Import permission, and not Read Only. Without it, the page shows "No Access to This Page".
Your file must be an Excel workbook in .xlsx format. The page says "Only Excel files are supported." Other formats, including .csv and older .xls files, can't be selected.
Put one record per row, with column headings in the first row. The first row is never imported.
Keep each sheet to 1,000 rows or fewer. The page says "Maximum 1000 rows per spreadsheet".
For workers, clients, assets, activities and projects, use Assisted Import instead: it checks your data before anything is saved. See Getting started with Assisted Import on the dashboard.
What you can import with Legacy Import
The table below shows each record type in Legacy Import on the Assignar dashboard and its fields. Required fields are marked on the page with an icon; they are listed first here.
Record type | Required field | Other fields |
Contacts | First name, Last name | Company, Job Title, Email, Office Phone, Mobile, Address 1, Address 2, Suburb, State, External ID, Comments |
Assets | Asset name | Description, Rego Number, Year, Make, Model, Serial number, Avg hourly charge rate, External ID, Number Reading |
Asset Attachments | Asset attachment name | Description, Rego Number, Year, Make, Model, Serial number, Charge rate, Number reading, External ID, Comments |
Clients | Client name | ABN, Email, Office phone, Mobile, Address 1, Address 2, Suburb, Postcode, State, External ID, Comments |
Suppliers | Supplier name | ABN, Email, Office phone, Mobile, Address 1, Address 2, Suburb, Postcode, State, External ID, Comments |
Tasks | Task name | Assets required, Pay Level, External ID |
Skills | Skill name | None |
Competencies | Competency name | Expiry required, Issue date required |
Inductions | Induction name | Expiry required, Issue date required |
For each record type, click Download example XLSX on the page to get a sample file with the right layout, or What fields can I import? to read about each field.
Import data with Legacy Import on the dashboard
To import records with Legacy Import on the Assignar dashboard:
Go to Settings > Legacy Import.
In the Import other items panel, under Choose the type of records you are importing:, pick a record type from ---- Select a module ----.
Drag your .xlsx file onto the box, or click select a file and choose it. The file name appears; click the red cross to remove it and choose another.
If the workbook has more than one sheet, choose the sheet under Choose Excel Worksheet:. A preview of the sheet appears at the bottom of the page.
Under Assignar Fields, for each field you want to fill, choose the matching column from ---- Select column in your spreadsheet ----. Every required field must have a column.
Click Import. The button stays greyed out until a sheet is chosen and every required field has a column.
When the import works, a message such as "12 contacts saved." appears, where 12 is the number of rows in the sheet.
When some rows don't import with Legacy Import
When Legacy Import on the Assignar dashboard can't save some rows, it shows a warning message and a Wrong rows table with the rows it rejected. For contacts the message reads, for example, "10 records were imported successfully. 2 failed to import." The other rows are saved, so fix only the rejected rows in a new file and import that file. Don't import the whole sheet again, or you'll create duplicates.
If nothing could be imported, or the connection failed, the page shows "An error occured". Check the file and try again.
Import orders on the Legacy Import page
If you have the Order Import permission, the Legacy Import page on the Assignar dashboard also shows an Import Orders panel above Import other items. That panel imports orders from a CSV file. See How do I import orders from a CSV file on the dashboard?.
Related articles
How do I add a task on the dashboard? How do I add a role (task) on the dashboard?

