Import school members in to Schoolcomms

All School Members (pupils and staff) will need to be entered into a CSV file and imported in to Schoolcomms.


Part 1

Complete the following information on the spreadsheet we have sent you, the field types are as follows:

Field# 1 Student admission number / unique identifier
Field# 2 Forename
Field# 3 Surname
Field# 4 Registration group
Field# 5 School year
Field# 6 Role ID (See the role types table)


The role types are as follows:

School member type Role ID
Student 1
Teacher 2
Support Staff 3
Governor 4
School board member 5
Other 6


Remove the column headers, the top line, from the spreadsheet

Image-3.jpg

Save the Excel sheet with the following file type: ‘CSV (Comma delimited) (*.csv)’


Part 2

Log in to Schoolcomms and go to the Management tab and click on Browse and select the CSV file you saved earlier.

Image-4.jpg

When the file name is showing click on Run Import to bring the data into Schoolcomms.

 

Please note: Wonde imports data from Arbor/ScholarPack on an hourly basis so users will need to wait an hour after amending any details in Arbor before running an import to ensure the latest data is imported.

 

Import data into Schoolcomms

ScholarPack Data Requirements

Arbor Data Requirements