Connective

When you join Connective, we want you to hit the ground running that’s why we make it easy for you to import your client contact details into Mercury Nexus.

Can I import my client data into Mercury Nexus?

You can import your contact details from an Excel spreadsheet, including phone numbers and address directly into the People section of your CRM.

We suggest you create a Data Category so that you can easily find all your imported contacts in case you need to roll back your import. There is a limit of 5,000 contact records per file uploaded.

People records without a Date of Birth need to be uploaded separately from records with a Date of Birth.

To import your client data to Mercury Nexus:

Open the Admin app select Data from the left-hand menu.

Click on Import Contacts in the top menu.

Click on the Browse button to find the Excel spreadsheet to be uploaded.

Click Import to CRM. The first ten records in the excel spreadsheet will show as a preview.

Select the company from the Import to Company drop-down list.

Select the specific category from the Category drop-down list, if required.

Check the Create an opportunity for each contact checkbox if required.

Use the drop-downs at the top of each column to match your data with the appropriate Mercury Nexus field.

Company Records need to be imported separately. Check the Import data as company records checkbox to do so.

To finalise the import click the Approve Import.

To cancel the import, highlight and click Rollback Selected Imports.

1. Open the Admin app select Data from the left-hand menu.
2. Click on Import Contacts in the top menu.
3. Click on the Browse button to find the Excel spreadsheet to be uploaded.
4. Click Import to CRM. The first ten records in the excel spreadsheet will show as a preview.
5. Select the company from the Import to Company drop-down list.
6. Select the specific category from the Category drop-down list, if required.
7. Check the Create an opportunity for each contact checkbox if required.
8. Use the drop-downs at the top of each column to match your data with the appropriate Mercury Nexus field.
9. Company Records need to be imported separately. Check the Import data as company records checkbox to do so.
10. Click Import.
11. To finalise the import click the Approve Import.
12. To cancel the import, highlight and click Rollback Selected Imports.

Note. The Excel document needs to be saved as .xls file, you will be unable to use a .csv file.

Once your data has been imported, Mercury Nexus will validate the email addresses and mark them as bounced if they cannot be validated. These email addresses will need to be verified and validated.  

What data can I import into Mercury Nexus?

 You can import the following data fields:

- Title
- First Name
- Middle Name
- Last Name
- Salutation
- Date of Birth
- Gender
- Marital Status
- Mobile
- Home Phone
- Business Phone
- Email
- Relationship Manager
- Home Address Line 1
- Home Address City
- Home Address State
- Home Address Postcode
- Home Address Country
- Business Address Line 1
- Business Address City
- Business Address State
- Business Address Postcode