📖 In This Article
›Some Assembly Required
›Columns – the pillars of your data…
›Let’s Do It (Yourself)!
›Mapping Your Data
›Ready to Launch!
›Don’t forget…
›Thank You
Our Do-It-Yourself migration option can be used to import a list of Clients and Contacts quickly and easily into your Nookal account.
This page is part of our Moving to Nookal guide – if you have just discovered this page, please consider starting from the beginning.
📦 Some Assembly Required
This is an easy process, but let’s quickly make sure we’re both starting on the same page:
- You will need a CSV (Comma-Separated Values) file containing the Client (or Contact) details you wish to migrate into your Nookal account.
- A CSV file can typically be created and edited with most popular spreadsheeting software – such as Microsoft Excel, Apple Numbers, etc.
- You must not have your Clients and Contacts details in the same CSV file. They must each be within their own file – e.g: “clients.csv” and “contacts.csv”.
🏦 Columns – the pillars of your data…
Let’s take a look at the columns your CSV file may contain:
Select your Data Type: | ||
Header | Format | Example |
Title | Text | Mrs |
First Name | Text | Mary |
Middle Name | Text | Elizabeth |
Last Name | Text | Johnson |
Gender | M/F/O | F |
Date of Birth | YYYY-MM-DD | 1970-01-31 |
Notes | Text | Prefers to be contacted via phone. |
Date Registered | YYYY-MM-DD | 2015-06-30 |
Address Line 1 | Text | Level 1/2a |
Address Line 2 | Text | 345 Main Street |
City / Suburb | Text | Brisbane |
State | Abbreviated | QLD |
Country | Text | Australia |
Postcode | Text | 4321 |
Home Phone | Text | 01 2345 6789 |
Mobile Phone | Text | 0412 345 678 |
Work Phone | Text | 01 2345 6789 |
Email Address | Text | example@nookal.com |
Company | Text | Medical Insurance Pty Ltd |
Type | Text | Insurer |
Title | Text | Mrs |
First Name | Text | Mary |
Last Name | Text | Johnson |
Notes | Text | Prefers to be contacted via phone. |
Position | Text | Case Manager |
Provider Number | Text | 12345XYZ |
Website | Text | https://www.nookal.com |
Third Party | Yes/No | No |
Address Line 1 | Text | Level 1/2a |
Address Line 2 | Text | 345 Main Street |
Address Line 3 | Text | West End |
City / Suburb | Text | Brisbane |
State | Abbreviated | QLD |
Country | Text | Australia |
Postcode | Text | 4321 |
Home Phone | Text | 01 2345 6789 |
Mobile Phone | Text | 0412 345 678 |
Work Phone | Text | 01 2345 6789 |
Fax Number | Text | 01 2345 6789 |
Email Address | Text | example@nookal.com |
Your column headers don’t have to match our examples. Although you may find it helpful.
And when saving your CSV file, we recommend the following options:
- Character Set: Unicode (UTF-8)
- Field Delimiter: Comma (,)
- Text/String Delimiter: Double-quote (“)
- Save Cell Content as Shown: Yes
🛠️ Let’s Do It (Yourself)!
Time for that beautiful CSV to shine…
- Login to your Nookal account.
- Navigate to the Manage > Data > Import page.
- Select the Type of data you’re migrating.
- Choose the CSV File from your computer.
- Click the Upload button.
- Select the Location to connect the data to.
- Tell us if the CSV contains a Header row or not – it usually does…
- ⚠️ Stop! It’s important to triple-check this next step:
- Tell us if you want to Delete Data (i.e. all existing Clients or Contacts) – this is unrecoverable, and should only be used if you want to remove all previously added Client or Contact records.
🗺️ Mapping Your Data
When you’re happy with all of the options above, let’s map that CSV…
For each Nookal field:
- Make sure the according column from your CSV file is selected.
- Make sure the Sample Data fields are showing your data correctly – check your Date formats specifically…
🚀 Ready to Launch!
Once you’ve mapped your CSV – click the Add Data button.
- Your request will be added to our queue to be processed.
- Our queue can take up to an hour (usually sooner) to be completed, the time required will depend on the size of your CSV file.
- The Status of the request will be updated once processing has been completed.
🚨 Don’t forget…
It is absolutely critical that you make time to check your data after we have processed it and before you use your account operationally.
Once you start using your account, the ability to correct any issues with your data becomes significantly difficult – if not impossible.
Check out our guide on how to Check Your Data – it’s quick, easy, and you won’t regret it.
🙏 Thank You
Thanks for reading this guide – I hope you enjoyed reading it as much as I did writing it.
If you have any questions, comments, feedback for us about it, we’d love to hear it.
It’s fantastic to have you on-board with us at Nookal.
I look forward to hearing of your success.