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

Please complete the following information on the spreadsheet we will have provided you with, 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)

Field# 7

Contact MIS ID

Field# 8

Contact Forename

Field# 9

Contact Surname

Field# 10

Parental Responsibility

Field# 11

Mobile

Field# 12

Email

Field# 13

FSM Start Date

Field# 14

FSM End Date

* Parental Responsibility format: Yes or No

 

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 (If using the desktop version of Schoolcomms)

Log in to Schoolcomms and go to the Management tab

mceclip3.png

Click on Browse and select the CSV file you saved earlier

mceclip4.png

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

 

Part 2 (If using the web version of Schoolcomms)

  • Log in to Schoolcomms and go to the Import Management tab
  • Click or drag to select CSV file

 

Once the file has been selected and there are no errors, you will be able to review the data to make sure you are happy with it before running an import.

  • Amendments/new school members are highlighted in blue as seen in the screenshot below
    • Tamwar Abdullah - the registration group has been amended
    • Max Allen and Sandra Anderson - new school members (staff)
  • School members marked as leavers have dashes instead of data and are highlighted in dark grey
    • Wills Astwick – leaver
  • If there has been no change, the data is identical in each row
    • Tilly Candy - no change

Please note: There may be a short wait for the comparison table to show after you have selected a file.

 

Validation

  • If the file type is not supported, you will see a validation error.

Accepted file types:

  • CSV
  • CSV UTF-8
  • CSV (MS-DOS)
  • CSV (Macintosh) (Mac only)

  • If there are one or more data issues, you will see the error message below

 

 

 

 

 

 

 

 

 

 

 

 

Was this article helpful?
0 out of 0 found this helpful