In order to manage users in Looked After Call, you must be logged in to the Looked After Call Admin site (http://admin.lookedaftercall.com) as a user with the type 'LA Super User'.
Prepare User List - CSV File
- In order to upload users in bulk, you will need to prepare a CSV file listing the users' details in order to upload that file to Looked After Call.
- Anyone can prepare this file, it is just a list of users' details in Excel. You do not need an 'LA Super User' account to prepare the file.
- You can only upload users one 'role' at a time so you may need multiple CSVs
e.g. one file for all 'Designated Teachers' and another for all 'Social Workers'.- See here for a guide on the different types of user role.
- See the section below for an example CSV file that you can complete.
CSV File 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. If the URN is not known at this time, enter "0" and add it later on using the 'Edit' button for each user. Until a Designated Teacher is linked to an organisation, they will not be able to see any pupils. See https://get-information-schools.service.gov.uk/ for a current list. | UPNs are used only for users with a role of "Social Worker", "LA User" and "LA Super User". There is no limit to the number of pupils you can link to a user. If a user is linked to an organisation, as they must be in the case of Designated Teachers, then you do not need to specify a UPN for each user, and any you do will be ignored as the organisation link overrides individual links. | |||||||
| Examples; | Joe | Bloggs | French Teacher | jbloggs@school.sch.uk | 01234567890 | 983561 | ||||
| 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 | |
Upload CSV - Bulk Upload Users
Navigate to http://admin.lookedaftercall.com and sign in;
Select 'Settings' > 'Users'
|  |
Select 'Bulk add users' from above the table of existing users. |  |
In the 'Bulk add users' dialog box, select the user role from the 'Choose a user role for this import' dropdown box.
See here for a guide on the different types of user role. | |
Select the 'Choose file' button and navigate to the location where the CSV you prepared is saved on your computer. Click 'Save' to upload the file and submit it for processing. |
|
You will now see your new users listed in the 'User management' table. Each user will be sent an email inviting them to set their password and log in. |
|
