This article lists the error messages you can see when importing data on the Assignar dashboard with Assisted Import or Legacy Import, what causes each one and how to fix it. Admins with the Data Import permission import data.
Your company can rename some words in Assignar, so the record names in these messages may differ from the ones here.
Can't find Assisted Import or Legacy Import on the dashboard
Assisted Import and Legacy Import appear under Settings on the Assignar dashboard only for users with the Data Import permission who don't have Read Only. If you open Legacy Import without that access, the page says "No Access to This Page". Ask an admin with User Access Management to give you Data Import.
If the importer window shows only "not found", the record type in the page address isn't available. Go back to Settings > Assisted Import and click Upload on a row of the Recommended Data table.
Red cells in the Assisted Import review on the dashboard
During an Assisted Import on the Assignar dashboard, every cell with a problem is shown in red, and the submit button can't be used until all of them are fixed. Click a red cell to read its message. The table below shows each message, which imports show it, and how to fix it.
Message | Import | Cause and fix |
"Email is not a valid email address" | Workers, Clients | The email has no @, no dot after the @, or a space in it. Correct it. |
"Duplicate email detected. Choose a unique email." | Workers | An active worker in Assignar already uses this email. Search the Users page: the worker may already exist. |
"Duplicate employee ID detected. Choose a unique ID." | Workers | A worker in Assignar, active or archived, already has this employee ID. Use another ID or leave it blank. |
"Duplicate external identifier detected. Choose a unique ID." | Clients, Assets, Activities | A record of that type in Assignar already has this external ID. |
"Duplicate name detected. Choose a unique name." | Assets | An asset in Assignar, active or archived, already has this name. |
"Phone number is not a valid phone number." | Workers, Clients | The number isn't valid for the Phone Number Format you chose. Add the country code, for example +61, or correct the number. |
"Date must be a valid date format" | Workers | The date of birth doesn't match the Date Format you chose (Day / Month / Year or Month / Day / Year). |
"Year must be a valid year format" | Assets | Enter a four-digit year, for example 2019. |
"Charge Rate must be a valid chargeRate format" | Assets | Enter a whole number only, with no $, commas or cents. |
"Number Reading must be a valid number reading format" | Assets | Enter a whole number only, with no units or decimals. |
"Unit cannot be greater than 20 characters." | Activities | Shorten the unit. |
"Unit cannot be blank." | Activities | The unit contains only spaces. Clear it or enter a unit. |
A required field left empty, or a value that must be unique appearing twice in your file, is also shown in red with the importer's own message.
If a duplicate message appears on a row where the value looks fine, search the whole file for that value: when some rows leave that column empty, the message can show on a different row from the one that has the duplicate.
"Failed to import data due to error:" after submitting on the dashboard
When an Assisted Import on the Assignar dashboard fails after you click the submit button, the importer shows a message that starts with "Failed to import data due to error:" followed by the reason. Nothing from the file is saved when this happens, so you can fix the problem and submit the same rows again. The common reasons:
"You do not have access to write Users." (or Clients, Projects, Assets, Activities): you have Data Import but not the permission to add that type of record. Workers need Add Users; clients and projects need Add Projects/Clients; assets need Add Tasks/Machines; activities need Orders. Ask an admin to update your access.
"Unable to import users" on a worker or activity import: Assignar refused one or more rows, usually because a worker with the same email or employee ID, or an activity with the same external ID, was added after you uploaded the file. Close the importer, start the import again with the same file and fix the cells that are now red.
"Unable to import Asset:" followed by a reason: an asset value is too long, or a name or external ID is already used. A message such as "Record already exists with
name:Excavator 20t - EX01." names the field and value. Change it and submit again. Registration numbers can be up to 20 characters."Unable to import Project:" followed by one or more reasons, separated by commas: see "Error messages on a project import" in How do I import projects on the dashboard?. The most common are "Parent project '…' not found." and "Multiple clients found with name '…'. Client name must be unique for import."
Dates missing after a project import on the dashboard
If imported projects on the Assignar dashboard have no start or end date, the dates in your file were probably not written as yyyy-mm-dd. Write them as, for example, 2026-10-26, then import the file again: rows that match an existing project name update that project and fill in the dates.
Duplicate records after an import on the dashboard
Assisted Import on the Assignar dashboard does not stop you importing a client or activity whose name already exists. If you import the same file twice, you get two of each. Archive the extra records from the Clients page or your activities list. Workers and assets are protected: a second import of the same workers or assets is stopped by the email, employee ID and name checks.
Legacy Import errors on the dashboard
These are the messages Legacy Import on the Assignar dashboard can show.
The Import button is greyed out: choose a sheet under Choose Excel Worksheet: and pick a spreadsheet column for every required field under Assignar Fields.
You can't select your file: Legacy Import only accepts .xlsx files. Open the file in Excel and save it as an Excel Workbook (.xlsx).
A warning and a "Wrong rows" table: some rows were rejected and the rest were saved. For contacts the message reads, for example, "10 records were imported successfully. 2 failed to import." Fix only the rejected rows and import them in a new file.
"An error occured": nothing could be imported, or the connection failed. Check that the required columns are filled on every row, then try again.
