Schools who use MIS/SIS databases that do not integrate with Parents Booking can create a custom .CSV file that can be uploaded. This blog post features instructions on how to create your own .CSV upload.
This two-spreadsheet approach involves linking two spreadsheets using pupil, parent and teacher IDs.
Spreadsheet 1 lists all of the pupils and parents, while spreadsheet 2 links the students to their classes and creates the teachers’ accounts (using the student ID number to link both spreadsheets).
Student Name (this field is [forename] + [surname] typically. Do not use commas.)
Student Date of Birth
Student Registration Group or Year Group
Parent ID
Parent/carer Title
Parent/carer Forename
Parent/carer Surname
Parent/carer Mobile/Telephone
Parent/carer Email
Emergency Priority Number (schools usually denote a ‘Main Contact’ as priority 1, and lower priority parents as 2, 3, 4, etc. If you are uploading multiple parents for a student, you will see in our spreadsheet example that you do this by adding each parent to a new line, with the same student details on each row. Giving one of the parents priority 1 in this column will help us understand who the ‘main contact’ is).
Receives Email? (Set everyone to “TRUE” in this column unless you have some parents who do not wish to be contacted by email, in which case set them to “FALSE”).
You can list a pupil on two different rows to link them to 2nd parent/carer.
Rules: Do not extract parent/carers who do not have “parental responsibility” / legal rights.
Save this spreadsheet as a .CSV file (in UTF-8 Format if possible) by going to File > Save As.. and underneath the file name choose “.CSV UTF-8 (Comma Delimited)”.
The data fields required for spreadsheet 2 are:
Student ID
Teacher ID
Teacher Title
Teacher Forename
Teacher Surname
Teacher’s Email Address
Subject Name
Class Code
Again, save this spreadsheet as a .CSV file (in UTF-8 Format if possible) by going to File > Save As.. and underneath the file name choose “.CSV UTF-8 (Comma Delimited)”.
These spreadsheets are then uploaded in the following order:
If you would like to use Parents Booking to help facilitate telephone meetings, in the place of ‘in-person’ meetings, or video meetings, we can help.
In the Admin Area, go to: Set Up School > Parent Login Method. On this page tick “Mobile Phone”.
This will activate a new field on the parent login page which asks for the parent’s mobile number. The mobile number input by the parent will then show on the teachers’ appointment schedule. Et voila!
Parents Booking uses a video meeting technology called Twilio.com to facilitate its integrated video meetings.
Sometimes schools or parents might have a problem connecting to these video meetings, because unlike Teams, Zoom and Skype, meetings are conducted by an internet browser, and these meetings sometimes need to be “unblocked” by certain work or home networks and firewalls. Furthermore, your computer/device needs to be compatible with the video technology.
Below are three ‘parts’ to this blog, which explain how you can test your device and network/firewall to ensure compliance ahead of a parents’ evening – and we highly recommend Parts 1 and 3 for schools and Part 2 for all users.
Part One: Run a Network test using the Twilio Network Tester:
This is a great starting point for a school that is going to be using Parents Booking’s video meeting technology (supplied by Twilio.com) for the first time, of if it has recently changed its network/firewall and wants to check the video meeting technology is still compatible.
One school has reported that where there were issues with the camera and mic not working on HP laptops and computers, this was resolved by removing the Cyberlink YouCam application.
If you have any errors or questions about this test, please review the information in Part Three of this post, and relay it to your school’s IT team.
This network test does not need to show a Pass for all results. So long as one of the top three results, and one of the bottom two are Passes, the video technology should be able to connect teachers to parents on your network. If you are at all unsure, copy the ‘Output Log’ (right hand side of the test) into an email and send, along with your school’s name, to support@parents-booking.com to ask for advice. Also, we recommend using the test below in Part Two before worrying!
Part Two: A more user-friendly test for yourself and teachers to use:
The below web link will test your device (its webcam and microphone), internet browser and internet connection are all compatible with the Twilio video meeting technology, and will connect to meetings. You can share this with teachers to help them check that they are ready to join our online video meetings.
Part Three: Information for your IT/server team on what changes might be required to the network/firewall
Media / UDP Network Settings :
– Schools need to allow Port 443 / HTTPS traffic and IT/network teams should be aware these video calls will happen over an encrypted peer-to-peer (P2P) connection, making any network adjustments required.
– Ensure *.Twilio.com URLs are whitelisted.
– Crucially, we advise whitelisting the most local “media servers” from this list of Twilio IP address ranges. You can also go to your school’s Parents Booking ‘admin area’ > Set Up School page > Preferences page button (bottom left corner, orange button) and choose a region to match the IPs you have whitelisted, rather than using the default “Global Low Latency”, if you want to be certain about which IPs should be whitelisted and will be used.
– Smoothwall/firewall users should add Twilio.com to ‘authentication exceptions’ in Smoothwall’s policies. Some Smoothwall users have also had to modify the’ default outgoing policy’ to allow ‘any internal interfaces’ to access ‘any external interfaces’.
– Our video meetings through Twilio.com generate lots of UDP connections, which school firewalls (or ISP DDOS blocking software) may well be setup to block/drop if they consider them to be a UDP flood attack, and we have seen this on rare occasions. Consider disabling UDP flood protection, or adding Twilio.com as an exception to this part of your firewall, if you find (while using the Twilio Network Test) that the number of UDP connections allowed is much lower than it should be, or if video/audio quality is poor during real video meetings (because these should be crystal clear). Video meetings with anything less than a perfect video, or where the audio and video are not in sync, should be taken as a clue to some sort of disruption caused possibly by a factor such as this.
– We’re also aware that adding chunderw-vpc-gll.twilio.com into to the SSL Inspection exceptions for a firewall has been of significant help to some schools, including those who use Sophos SG UTM as their firewall.
– We are also aware that some schools/local authorities need to ‘allow’ “amazonws.com” to be able to connect to the Twilio servers. We are learning more about why, but assume this is because Twilio use Amazon AWS servers.
– In one case a Scottish local authority has to allow “Dublin.turn.twillio.com” direct out of the firewall, and so this is being noted here in case it is of use for others too.
Information for Edinburgh Council schools:
At the time of writing schools/teachers should not use the LTAD network for their view meetings as this seems to be blocking the video meetings (although it does seem to work at some schools). Please advise teachers to use either the LTAP_P or LT_Open networks.
Information for South Ayrshire Council schools:
We have been asked to make sure schools are aware that software called Zscaler, on teachers’ devices/computers, needs be have a blue icon showing in the bottom right corner of teachers’ Windows task bar, meaning it is enabled. If the icon is grey it has not been enabled and would not allow the video call to take place.
Information for HP Laptops/Computers
One school has reported that where there were issues with the camera and mic not working on HP laptops and computers, this was resolved by removing the Cyberlink YouCam application.
Recent Comments