Importing Pupils

If you are importing staff & pupils we recommend you import staff before pupils. This allows the import process to pair pupils with their instructors.

Data Requirements

You can download a template CSV file for use with a spreadsheet application from here: Download Template CSV File.

Full details of required and optional fields are listed below. Your import CSV file does not have to contain a header record and the fields do not have to appear in any particular order. The import process allows you map fields in your file to the fields listed below.

Required Fields

  • First Names - text field.
  • Surname - text field.
  • Instructor - instructor field. The pupil's instructor's name - this will be used to match pupils with instructors you have already added/imported. You should ensure you spell their name correctly for this to work, although the import process does allow you to make manual corrections.

Optional Fields

  • Login Email - email field - if provided this will be used to create the pupil's account and optionally send them a welcome email. This must be unique, two users cannot share the the same login email address.
  • Address Line 1 - text field.
  • Address Line 2 - text field.
  • Address Line 3 - text field.
  • Address Town - text field.
  • Address County - text field.
  • Address Post Code - text field.
  • Mobile Telephone - text field.
  • Landline Telephone - text field.
  • Driving Licence Number - text field - we encourage you to fill this in. This information will make your life easier when completing administrative tasks.
  • Date of Birth - date field.

Step 1 - Uploading Your Data

The first step is simply concerned with uploading your raw data file:

Pupil Import - Step 1 - Uploading

Pupil Import - Step 1 - Uploading

  1. Import Type - choose the type of data you wish to import. Choose 'Pupils'.
  2. File Upload - Click this to be shown a file chooser. Once you have chosen your file it will be automatically uploaded and checked.
  3. Download a Template File - using this link you can download a template CSV file for use with a spreadsheet application.
  4. Upload & Check Status - indicates whether your uploaded file has been successfully uploaded, checked and read.
  5. Next  - once you have uploaded your file you can click this to proceed to the next step.

Step 2 - Column Mapping

The step allows you to map fields in your uploaded data file with the required and optional columns.This is known as Column Mapping.

You will be presented with a list containing a sample of up to the first 5 records from your data file, this allows you to identify fields based on their content. If your data contains a header record this will appear as the first record in this list, making identification of columns even easier. You will be able to exclude the header record from import in the next step.

Initially columns will be mapped based on the order in which they appear within their respective records.You should check all column mappings to make sure they are correct for your data.

Pupil Import - Step 2 - Column Mapping

Pupil Import - Step 2 - Column Mapping

  1. Required Columns - shows required column mappings. All required columns must be mapped to continue to the next step. A tick indicates that the column has been mapped; a question mark that it is not mapped.
  2. Optional Columns - shows optional column mappings. The more of these columns you provide the less data you will need to enter at a later date. A tick indicates that the column has been mapped; a question mark that it is not mapped.
  3. Mapping - the name of the import column which is currently mapped to this data field position. Use the drop down to change the mappings.
  4. Data Record - contains the individual data fields as read from your uploaded data file.
  5. Next - once you have mapped all required columns you can click this to proceed to the next step.

Step 3 - Data Check

This step will allow you to check, and if necessary adjust, all of your uploaded data records. The import process performs validation on all of your data fields, based on the column mappings defined in the last step.

Pupil Import - Step 3 - Data Check

Pupil Import - Step 3 - Data Check

If you realise you have made a mistake with your column mappings at this stage you can use the 'Prev' button to return to the previous step.

  1. Data Summary.
  2. Valid Indicator - indicates if a record is valid. If the record has one or more invalid fields a red warning triangle will be shown. See Correcting Invalid Records for more details.
  3. Import Toggle - un-toggle this if you wish to prevent record from being imported. See Excluding Records from Import for more details.
  4. Data Record, Invalid Field - a red background indicates an invalid field. Click the record to adjust the data. See Correcting Invalid Records for more details.
  5. Validation Error - If some of your records include invalid fields you will see this message. You will also be unable to proceed to the next and final step.
  6. Next - once all of your records have either successfully validated or have been ignored for import you will be able to click this to proceed to the next and final step.

Excluding Records from Import

There are circumstances where you may wish to prevent a specific data record from being imported, for example:

  • a header record from your original data file that you need to exclude.
  • a record that will not validate that you will deal with later. You can exclude it to allow you proceed with importing the bulk of data.

If you wish to exclude a record simply un-toggle the record's 'Import?' toggle. The row will be 'crossed out' to show that it has been excluded:

Step 3 - Data Check - Ignored Row

Step 3 - Data Check - Ignored Record

The row will also be excluded from validation, allowing you to skip problem rows. See Correcting Invalid Records for details on how you can correct and avoid skipping problematic rows.

Correcting Invalid Records

If you have rows that will not pass validation, you can correct problematic fields. Simpy click on the row to show the 'Adjust Import Data Record' popup:

Pupil Import - Step 3 - Adjust Data Popup

Pupil Import - Step 3 - Adjust Data Popup

Fields that have failed validation will be shown with a red border and have a validation failure message below.

Text fields can simply be edited as any other text. 

Email fields must be valid email address. The 'Login Email' address must also be unique within the app.

True/False fields will give you a drop down to select a valid value from.

Date fields will give you a date picker to choose a valid date from.

Instructor fields must be a valid active instructor already within your school. A finder input will allow you to choose a valid instructor.

Step 4 - Perform Import

The final step simply allows you to the start import process.

If you realise you have made a mistake with your in one of the previous steps at this stage you can use the 'Prev' button to return to the previous step.

Pupil Import - Step 4 - Perform Import

Pupil Import - Step 4 - Perform Import

  1. Toggle this to send/not-send welcome messages to new users. These messages will include details on how to log in to the app and a system generated password.
  2. Import Status - shows you how the import is progressing once you have clicked the 'Import My Data' button.If an error occurs that will shown here too.
  3. Import My Data - once you are happy and ready to import your data you should click this button. The import may take several minutes.