You can add many clients to Assignar at once by importing a spreadsheet with Assisted Import on the Assignar dashboard. Clients are the customers you do work for; projects, orders, timesheets and dockets are linked to them. Admins with the Data Import and Add Projects/Clients permissions can import clients.
Your company can rename some words in Assignar, so you might see a different word for Clients.
Before you start
You need the Data Import and Add Projects/Clients permissions, and not Read Only.
Check the Clients page for clients you already have. The import does not stop you adding a client whose name already exists, and two clients with the same name cause problems later when you import projects.
Have your file ready as .csv, .tsv, .xls or .xlsx, with one row per client.
Columns for a client import on the dashboard
The table below shows the fields a client import on the Assignar dashboard accepts. Only Client Name is required.
Field | Required | What to enter |
Client Name | Yes | The name of the client, for example Harbour City Council. Up to 100 characters. |
External ID | No | An ID from another system, such as your accounting software. Must not appear twice in the file or belong to a client already in Assignar. Up to 50 characters. |
ABN/TIN | No | The client's ABN or tax number. Up to 20 characters. |
No | The client's main email address. | |
Office 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. |
Mobile Phone | No | Checked the same way as Office Phone. |
Address | No | The client's address on one line. Up to 100 characters. |
Comments | No | Any notes about the client. |
Import clients on the dashboard
To import clients with Assisted Import on the Assignar dashboard:
Go to Settings > Assisted Import.
On the Clients row, click Upload.
The Clients Data Formats window opens. Choose a Phone Number Format: Australia (AU) or United States (US), to match phone numbers that don't start with a country code. Click Continue.
In the importer window, upload your file or type the clients 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.
When every row is valid, click Submit Clients.
Wait for "This is now complete.", then close the importer.
The new clients appear on the Clients page as active clients.
Common problems when importing clients on the dashboard
These are the messages the importer shows on a client 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 it or leave it blank.
"Duplicate external identifier detected. Choose a unique ID.": a client in Assignar already has this external ID. The client may already exist: search the Clients page. Otherwise use a different ID.
"Phone number is not a valid phone number.": the office or mobile phone isn't valid for the country chosen in Phone Number Format. Add the country code or correct the number.
Client Name missing, or the same External 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 Clients, see Why did my import fail on the dashboard?.

