Foxel

Importing contacts from AllAssured to Merlin

  • Foxle Team

How To Use This Function

Click on the Run Function button. Select CSV file downloaded from nGage per Step 1. Upload only 1 file. The function will clean and prepared the data per Step 2. Download the output CSV file. Import to Merlin per Step 3.

Step 1. Download the data

Login to n2 and go to nGage Click on the Download AllAssured button to export all of your existing contacts on AllAssured into a CSV file.

Note: you will be able to use this same CSV file to import your contacts to Merlin

Step 2. Clean the data

You can review this contact list and remove those you don’t wish to import to Merlin At this point of time, you may also update your contact classifications. By default, all contacts downloaded from AllAssured will be auto-assigned as Clients (Type = C). If your client’s details on AllAssured are incomplete, you may see some of the columns as blank.

Step 3. Import to Merlin

Upload the same CSV file (from “Download AllAssured” button on nGage) to Merlin Go to Merlin’s People menu, click on Import People button, then upload the CSV file to Merlin

Note: Only contacts with a complete set of First Name, Email, Mobile No, DOB, AND Gender will appear under “Contacts” tab. Otherwise, it will appear under “Leads” tab.

Tips: When importing data into Merlin, it's recommended to do so in batches of 100 or fewer records at a time. This approach not only helps prevent errors but also makes it easier to track the number of records that have been successfully imported or rejected.

Troubleshooting

Some of my contacts or policies are not added

If your import file contains an error, you will see an error message similar to the following screenshot.

Find out the issue by clicking on the Download people or Download policies button and a CSV file will be downloaded.

Open the downloaded CSV file, and you can refer to the last column in the CSV file to learn what’s wrong with each particular contact or policy.

Sometimes, an error can be caused by deviation in naming from the template file (for example, having “FPI” as the Insurer Name instead of “Friends Provident”) or the presence of special characters (ã, ë, î, ņ, and so on).

Amend the contact or policy accordingly, and try importing the people or policy again.

How does Merlin handle duplications?

On Merlin, each contact/client is identified by the email address.

In other words, email address is the unique identifier for your contacts/clients on Merlin. As a result, you won’t be able to have more than 1 client using the same email address.

When you upload a new contact with the same email address as your existing contact on Merlin, the new contact won’t be added to Merlin, unless you opt to overwrite your existing contact with the data from this new contact.

Why do some of my imported clients appear under “Leads” instead of “Contacts”

It may be caused by any of the following reasons.

Possible cause 1. Column A (Type) is left blank. Refer to page 5 for more details.

Possible cause 2. Compulsory columns are not filled up. Contacts without a complete set of First Name, Email, Mobile No, DOB, AND Gender (Column B, F, G, H, AND I) will appear under “Leads” tab.

To resolve this, you can update the import file you used previously (i.e. fill up the necessary columns), save the file, and try importing using the update file again. Don’t forget to put a tick on Overwrite Duplicates checkbox.

I have 2 clients sharing the same email address, but only 1 client can be added to Merlin

As mentioned previously, 1 email address can only be used for 1 client. In this case, you may advise the client to provide you with (or to create) another email address for this purpose.