Import Learners
The Evidence for Learning App allows you to import your learners in bulk. It’s very easy to do once you have collected the data in the right format.
The Learner Data
The following data fields can be saved in the learner record. Please Note: FirstName is the only mandatory field.
FirstName
LastName
Email
UniqueReference
Parent1FirstName
Parent1LastName
Parent1Email
Parent2FirstName
Parent2LastName
Parent2Email
DateOfBirth
How to Import Data
Easiest way to do this is to build the data in the required format and then copy and paste it into the space provided.
The format required is a comma separated list of values in the order presented above with 1 learner per line, no text delimiters such as ” or ‘. No column headers. Each row has the same data fields.
You can include all data fields or you can choose to include all data fields up to and including the field you need.
If you plan on updating learner data later then it’s important to include a UniqueReference with your data. When a unique reference is included in the data the system checks if it exists, if not then it creates a NEW record, if it does exist then the supplied fields are updated.
We recommend trying to import a sample of your data first with 2 or 3 learners so you can check the columns map to the right fields. When you are happy repeat for all learners.
Examples of Data
To import FirstName only you should structure your data like so…
Jack
Annie
George
Alan
Sarah
Tyson
To import FirstName & LastName you should structure your data like so…
Jack, Bannister
Annie, Smith
George, Dexter
Alan, Bradley
Sarah, Sugden
Tyson, Allen
To import FirstName, LastName, Email, UniqueReference you should structure your data like so…
Jack, Bannister, jack.bannister@example_school_domain.com, 3144
Annie, Smith, annie.smith@example_school_domain.com, 3143
Dexter, Geroge, dexter.george@example_school_domain.com, 3223
Alan, Bradley, alan.bradley@example_school_domain.com,3345
Sarah, Sugden, sarah.sugden@example_school_domain.com,3972
Tyson, Allen, tyson.allen@example_school_domain.com,3764
OR (without emails)
Jack, Bannister, , 3144
Annie, Smith, , 3143
Dexter, Geroge, , 3223
Alan, Bradley, , 3345
Sarah, Sugden, , 3972
Tyson, Allen, , 3764
To import FirstName, LastName, Email, UniqueReference and some parent contact info you should structure your data like so…
Jack, Bannister, jack.bannister@example_school_domain.com, 3144, Jean, Bannister, j.b@the_family_email.com
Annie, Smith, annie.smith@example_school_domain.com, 3143, Ron, Smith, r.s@the_family_email.com
Dexter, Geroge, dexter.george@example_school_domain.com, 3223, Anne, George, a.g@the_family_email.com
Alan, Bradley, alan.bradley@example_school_domain.com, 3345, Harry, Bradley, h.b@the_family_email.com
Sarah, Sugden, sarah.sugden@example_school_domain.com, 3972, Jenny, Sugden, j.s@the_family_email.com
Tyson, Allen, tyson.allen@example_school_domain.com, 3764, Lisa, Allen, l.a@the_family_email.com
To import all fields you should structure your data like so…
Jack, Bannister, jack.bannister@example_school_domain.com, 3144, Jean, Bannister, j.b@the_family_email.com, Barney, Bannister, b.b@the_family_email.com, 21082010
Annie, Smith, annie.smith@example_school_domain.com, 3143, Ron, Smith, r.s@the_family_email.com, Helen, Smith, h.s@the_family_email.com, 02122009
Dexter, Geroge, dexter.george@example_school_domain.com, 3223, Anne, George, a.g@the_family_email.com, Jake, George, j.g@the_family_email.com, 03032010
Alan, Bradley, alan.bradley@example_school_domain.com, 3345, Harry, Bradley, h.b@the_family_email.com, Susan, Bradley, s.b@the_family_email.com, 01082010
Sarah, Sugden, sarah.sugden@example_school_domain.com, 3972, Jenny, Sugden, j.s@the_family_email.com, Tom, Sugden, t.s@the_family_email.com, 09102009
Tyson, Allen, tyson.allen@example_school_domain.com, 3764, Lisa, Allen, l.a@the_family_email.com, Darren, Allen, d.a@the_family_email.com, 12112009
