There is now an enhanced import available for CSV schools via a new web based version of Schoolcomms with the following added features.
-
Ability to review data before running an import
-
Ability for one contact to be added per school member
-
Contact can be a self-contact (the MIS ID must be the same)
-
-
Ability for FSM data to be imported
The enhanced import will enable you to review the data on a comparison table that will show after you have selected a CSV file to import. This will inform you of any amendments that have been made to the CSV file to ensure you are happy with it before running an import.
For example:
- Amendments/new school members are highlighted in blue.
- School members marked as leavers have dashes instead of data and are highlighted in dark grey.
- If there has been no change, the data is identical in each row.
If you would like further information on the new web based version please click here to complete a support request form or alternatively email your enquiry to support@schoolcomms.com
Import members into 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 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 |
|
| Field# 13 |
FSM Start Date |
| Field# 14 |
FSM End Date |
* Parental Responsibility format: Yes or No
** Mobile format: first 5 digits followed by a space then the remaining 6 digits; e.g. 07321 987654
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
Save the Excel sheet with the following file type: ‘CSV (Comma delimited) (*.csv)’
Part 2
- 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