LIVE SYNC CONFIGURATION
You will need the following three (3) pieces of information to create the security token in order for LIVE SYNC to connect your Power School application:
The BusBoss button
You will see the BusBoss screen (below) by default. The following fields need to be filled in to connect to your BusBoss database: Server, Database, UserName, and Password
The BusBoss Test Button
Click on the Test button to test the connection. You should get a message "Database Connection Succeeded"
The Powerschool button
Click on the Power School button on the left hand side of the Live Sync dialog screen and you will see the screen below. The following fields need to be filled in to connect to your Power School: URL, Client ID, and Client Secret.
The Power School Test Button
Click on the Test Powerschool button to test the connection. You should get a message "Powerschool Connection Succeeded"
The Columns button
Click on the Columns button to view the Import Column Mapping. Keep the default column mappings unless instructed otherwise
NOTE: IF THE COLUMN MAPPING OR THE SCHOOL MAPPING ARE NOT POPULATING: CLOSE OUT OF TOOL AND RE-OPEN.
The School button
Click on the Schools button to view the School Mapping. The left side will show all the schools in Power School and on the right will be the schools in BusBoss. By default the BusBoss side will be blank and you have to choose the correct school in BusBoss that matches the school in Power School. Make sure your school mappings are one-to-one. Make sure to click the SAVE button when finished on this screen
The Log button
Click on the Log button on the left hand side of the Live Sync dialog screen to check what activity has taken place
The Check for Updates button
Click on the Check for Updates button on the left hand side of the Live Sync dialog screen to see if there are any updates available from BusBoss
The Synchronize Student button
Click on the Synchronize Students button on the left hand side of the Live Sync dialog screen to to view the Synchronize Students dialog screen shown below.
Click on the Synchronize Students Now button to synchronize students now.
The check box Automatically Synchronize student information, when checked, will allow Synchronize Students to be run via a scheduled task.
Synchronizing students will copy the students from Powerschool into BusBoss.
When synchronizing students, information that does not affect transportation will automatically be imported to BusBoss. Information that does affect transportation will be stored in a holding area within BusBoss. You will need to click on Tools -> Import -> SIF in order to complete the import.
When Synchronize Students is run, the PowerSchool.Students table and the dbo.SIFIncomingStudent table are both cleared. The PowerSchool.Students table is populated with the student information from Power School
The program validates that the StudentIdNumbers match in BusBoss before transferring the data from the PowerSchool.Students table to the dbo.SIFIncomingStudent table
Once the synchronization is completed you can check the log to confirm completion
Once the synchronization is completed the dbo.SIFIncomingStudent table should be populated and you should see an icon in the lower right hand screen in BusBoss alerting the user that there is new data from Power School that needs to be imported
If the icon in BusBoss has not appeared you can check the tables by running SQL queries via the back-end in SQL Server Manager or in BusBoss via File -> Modify Data
To apply the changes that are in the SIF table to BusBoss, from within BusBoss, run Tools -> Import -> SIF to import the student data into BusBoss
You will see the screen below: Click yes to continue. The SIF table will be cleared for the next Syncroniztion.
Next, if there are any data mismatches, you will get a Compare Data - Data Mismatch screen which will require user responses
One completed with the Data Mismatch screen the Import Student screen will appear. Click the Import Student Data button to start the import
The Synchronize Transportation button
Click on the Synchronize Transportation button on the left hand side of the Live Sync dialog screen to to view the Synchronize Transportation dialog screen shown below.
Click on the Synchronize Transportation Now button to synchronize transportation now.
The check box Automatically Synchronize Transportation Infomation, when checked, will allow Synchronize Transporation to be run via a scheduled task.
Synchronizing transportation will copy transportation information from BusBoss to Powerschool.
When synchronizing transporation, bus number, stop assignments, times, etc. will be copied to Powerschool, i.e., LIVE SYNC will add, delete, or update the transportation information in Power School so that it is the same as in BusBoss.