CSV Content
Having selected 'Bulk add users' from above the table of existing users, you will see a link to a template CSV file that you can download and complete ready to be uploaded. It is also provided below for your convenience.
The columns in the CSV file are as shown below, example data has been provided along with notes on usage.
Column Heading | User First Name | User Last Name | Job Title | Phone | School Reference Number (URN) | Pupil Reference Number (UPN) | Pupil Reference Number (UPN) | Pupil Reference Number (UPN) | Pupil Reference Number (UPN) | |
---|---|---|---|---|---|---|---|---|---|---|
Mandatory | Yes | Yes | No | Yes | No | No | No | No | No | No |
Notes | Must be unique within your Looked After Call account | Controls which pupils a Designated Teacher has access to. This must be the URN allocated to the organisation by the Government. See https://get-information-schools.service.gov.uk/ for a current list. | There is no limit to the number of pupils you can link to a user. | |||||||
Examples; | Joe | Bloggs | French Teacher | jbloggs@school.sch.uk | 01234567890 | 983561 | 9875 | |||
Jane | Doe | Office Administrator | doe.jane@school.sch.uk | 02036789512 | 546983 | 4932 | 4683 | |||
John | Appleseed | Pastoral Head | john@school.sch.uk | 01896563986 | 761259 | 477966 | 345962 | 4692313 | 8797316 |