This is the article if you want to import just Organisations.

If you want to import just Contacts, click this link.

If you want to import Organisations and Contacts at the same time, click this link.

Introduction

Organisations can be imported in bulk to CTM via Data Manager using a CSV file.

The Importer matches any existing Organisations on the CRM and updates them with your new information, but if it can't find a match it creates a new Organisation.

Your data needs to be carefully prepared but if you follow these steps, the import should go smoothly.

Firstly, Go to Data Manager App, Data Importer tab and click on the + Add a New Import Project.

Step 1 - About

  1. Add some meaningful information in this bus stop. This will help if you return to this import at a later date.

Step 2 - Configuration

  1. Complete the details for bus stop 2.

Step 3 - Data File

  1. Click the Download Template button.

  2. Add your data to the CSV template exactly as specified in the Guide.

  3. Save your file as a CSV (Comma Separated Variable) file. Do not open it again in Excel as the phone numbers may become corrupted.

  4. Click the link and upload your data.

Step 4 - Import

  1. Check the details and import.

Step 5 - Results

  1. The number of rows Attempted, Imported and Rejected will be shown in the Results bus stop.

FAQs

Q. How many records can I import at one time?

A. up to 10,000.

Q. Are any fields mandatory?

A. Yes, and the Guide highlights those fields in red for you.

Q. Can I import Organisations and Contacts at the same time?

A. Yes, read this article for more details: Importing Data to Contact Manager (Organisations & Contacts at the same time)

Q. My phone numbers went all funny! What happened?

A. Don't re-open the CSV once you have created it. Re-opening a CSV in Excel often corrupts phone numbers so import the CSV as soon as you have created it.

Q. Why didn't my import match an existing record?

A. Check again the Matching Rules below. And make sure the ids, names, postcodes etc are exactly the same as on the CRM.

Q. Can I manually link a Contact to an Organisation after import?

A. Yes, go to Contact Manager and update the Contact record.

Q. Can I manually merge a Contact or an Organisation after they have been imported?

A. Yes, on the record card, click the three button More options menu and select Merge.


Q. What's the difference between Creating and Updating?

A. The Data Importer can be used to create new organisations and contacts, or update existing organisation and contact records on the CRM. If there is data already in Contact Manager, the importer will use Matching Rules to try to match and update an existing record.

Q. What are the Matching Rules?

A. Here is an explanation of the Matching Rules.

Matching Rules to match existing records on the CRM

The importer will try to match your import data to existing data on the CRM using Strong Identifiers. Only one field needs to match for success.

for Organisations

for Contacts

CRM ID

CRM ID

School URB

UUID long

Legacy ID

UUID short

Legacy ID

If none of the Strong Identifiers match, the importer will try to match on a combination of fields - Weak Identifiers. Every field in a weak identify has to match for success.

for Organisations

for Contacts

name, address_1, postcode, country

first_name, last_name, email

name, postcode, country

first_name, last_name, phone

name, address_1, country

first_name, last_name, address_1, postcode

known_as, last_name, email

known_as, last_name, phone

known_as, last_name, address_1, postcode

Error Messages

Q. What are the error messages?

A. In the Data Importer bus stop 5, you can download a file of records that have not been imported because they have errors. The errors are shown for each record in the final column. Here is a list of error messages and what you can do to rectify them.

Type

Error Message

How to fix it.

Organisation

Unable to match the provided organisation to an existing organisation for a contact record. Check the provided Org fields attached to this contact and try again

Double check the CRM's Organisation ID, or your internal Legacy Organisation ID is correct.

Organisation

Unable to import Orphan organisations in this file.

(Note: you can only get this error in the orgs only file, not the combined file)
Ensure you have not entered anything aside from a CRM-generated ID in the Organisation_ID field.

Organisation

Unable to match the provided Contact_country (via countries_iso_code_2/ via countries_name). Please ensure you're using a valid country!

Ensure you've provided a two letter Country ISO code or the CRM Numeric ID, rather than the full name or other ID. Eg "GB" or "222". For a full list of codes and IDs click here
Country MUST be provided for both Contact and Organisation in the Combi file

Organisation

Invalid phone number provided ([phone number])

Check that the phone number: is prefixed by a type (eg "work"); has a "+" in front of the country code (eg "+44"); is using a correct country code (eg "44"); has no more than 15 digits.

Organisation

You must provide an Organisation name

Ensure the Organisation has a name, eg "Student CRM"

Organisation

Please provide a valid School URN. Six digits, starting with 1 for English, 2 for Children Centres and 4 for Welsh establishments, or 7 digits for a Scottish SEED, or 3 digits and 4 digits with a dash for a Northern Ireland DE number

Check the School URN for typos. You can double check the URN is correct by searching the government's database of education providers for the school you want to use.

END.

Did this answer your question?