Bulk Add Users

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.

exampleBulkUsers_NewV4.csv

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	Email	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' If you do not see this option, you are not signed in as a user with appropriate rights to manage users. 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'.
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. The options are; Designated Teacher LA User LA Super User Social Worker 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.