In the app 'Data Manager' you can use the 'Data Importer' tool to import new records (or update existing records). Max 10,000 records at a time into:

Contact Manager

Courses & Subjects

Mobile Event Capture

Rapid Response

Student Database

Why do I need to prepare my data?

Student CRM looks carefully at each record in your data file to see if it can be imported successfully into your chosen destination. Let's say you want to import 5,000 students into Student database: if you take a little time to follow the Guides below before you click the 'Upload your Data' button, the chances are you will get a fast and complete import the first time.

Remember, we provide different templates for you to complete using the correct Guide for that app. In this example, the template requires you to add your Contacts & Organisations records in before you upload it into Contact Manager (CTM).

Just pick your destination app below and download the guide to start preparing your data.

Please note: If your data contains any Emoji characters, these will be stripped out of the data on import.

Contact Manager (CTM)

Purpose: Use this to import new and/or update existing CTM records. Click these links to download what you need to import data:

Course & Subjects (CRS)

Purpose: Use this to import new CRS records. Click these links to download what you need to import data:

Please note: All courses will be imported as Draft status.

Mobile Event Capture (MEC)

Purpose: Use this to import new MEC records. Click these links to download what you need to import data:

Rapid Response (RAP)

Purpose: Use this to import new RAP records (and to import new Student Database (SDB) records, see next section). Click these links to download what you need to import data:

Student Database (SDB)

Purpose: Use this to update existing SDB records. Click these links to download what you need to import data:

SDB tip: if you want to import completely new students into the Student Database (SDB) please use the Rapid Response (RAP) template and Guide above. RAP allows you to create students in Student Database (SDB) whilst adding extra academic fields such as Year or Entry, Level of Study, Subject, Course, Intake etc.

When it matches an existing record

  1. Data Importer processes each row in turn, starting at the top of your data file.

  2. If it matches an existing record, then it updates the existing student. (To see the matching and updating rules please see the XLS Guides above.)

  3. If the row it is processing doesn't match any existing record, it creates a new one.

  4. If it doesn't like the row it is processing, it writes a helpful error message at the end of that row, ie: "no email address" and skips to the next one. (You can download these errored records to fix them and upload again).

  5. When it reaches the last row, it changes the status from 'processing' to 'finished' and shows you the results.

Summary:

Follow the Guide to prepare your data, and ensure a fast and complete import every time.

Next: Starting your import project

Did this answer your question?