SwiftK12 Sync Tool-Setting up the sync tool

What does the SwiftK12 Sync Tool do?

The SwiftK12 sync tool is a desktop application that takes an export from a  SIS (Student Information System) and automatically imports it into SwiftK12. 

When using SwiftK12 Standalone with the sync tool the customer will also only use their SIS's web portal, enabling their parents to have a one stop data entry experience.

When using the sync tool data should only be updated in your SIS and not directly into SwiftK12, as all inputted data directly into SwiftK12 would be overwritten on the next  sync.

How to setup the sync tool?

There are 3 steps in the setup of this tool:

1. Setup 2 separate .csv exports (Students and Staff) from your SIS and point those exports to a designated folder created by the sync tool on the customers computer or server.  In order for full automation to occur, you must setup this export to be automatically exported to the respective sync folder (created during installation) on an interval which best suits you schools needs.
   1. There are minimum required fields for Students and Staff exports; however more fields can be used such as bus routes, homeroom numbers, etc. depending on the needs of the customer.  The minimum required fields for each export are as follows:
   2. Important: .CSV exports from your SIS must always be exported with the same name every time.  This will allow the sync tool to process the file.
      1. Students
         1. First Name (a combined first and last name field is also allowed)
         2. Last Name
         3. Student ID (If no student ID field is available choose a field that has a unique number identifier)
         4. School Name
         5. Grade
         6. Phone number fields
         7. Email address fields
      2. Staff
         1. First Name (a combined first and last name field is also allowed)
         2. Last Name
         3. Staff ID (If no student ID field is available choose a field that has a unique number identifier)
         4. School Name
         5. Phone number fields
         6. Email address fields
   3. The column headers/field used must be identical to the column headers/fields used in your initial .csv import of your data.
      1. If you would like to add or remove column headers/fields at any point, please contact support to have them remap your account as a whole.  This would require you sending a csv with the new fields removed or added to support and using those column headers/fields in all future csv exports from your SIS.
2. Install the SwiftK12 sync app on a computer or server that is very rarely turned off.  In order for the customers SIS to export a csv to the computer, it must be turned on.  Also, in order for the sync tool to process the .csv the computer that the sync tool is installed on must be on.  The computer or server chosen must also have access to the internet. 
3. The steps to install the sync tool are as follows:
   1. Login to https://k12.swiftreach.com
   2. Got to “Settings”
   3. On the bottom right of the screen click on “Download Desktop Sync App”
   4. Click the “For Windows” or “For Macintosh” button depending on the type of the computer you are installing the tool on.
   5. On the bottom of the screen you will see the file download.
   6. Once download is complete, click on the file and click the “Run” button that appears on the middle of the screen.
   7. The tool will run and installation progress bar, once the sync tool has completed the installation process, the installation window will disappear, and the sync tool “Register App” screen will appear.
   8. Login to the sync tool using the same credential you use to login to K12. (Note: the user must have access to all the school they wish to sync.)  Click the “Register App” button to continue.
   9. A pop up window will appear letting you know the registration was successful.  Click the “continue button” to continue to the setup phase.
   10. You are now on the “Set Root File Folder & Error Email” page.
   11. You can opt to keep the Folder Path (root folder) the desktop or choose a different root folder to add the sync tool folders to.  (We recommend leaving the Folder path (root folder) in its default location (C:\Users\%Username%\Desktop.
   12. Enter the email address to which you would like to receive an email if any errors occur in the future with the sync process. And click the “Save & Continue” button.
   13. At this point you will notice a folder called [swiftk12-sync-files] has appeared at the root location chosen in the last step.  (The users desktop by default).
   14. When you open the folder you will see 6 sub-folders.  Each folder corresponds to a different sync function with the sync tool.
       1. Students: This would be the folder that you would set your SIS up to automatically export the student .csv export to.  (Please remember that the .csv’s field columns must be identical to the file you sent us for your initial data upload in order for the sync to work properly.
          1.  Please do not add or remove any fields from the export csv’s.  Our system maps these fields specifically and they must be identical at all times.
          2. If you would like to add or remove column headers/fields at any point, please contact support to have them remap your account as a whole.  This would require you sending a csv with the new fields removed or added to support and using those column headers/fields in all future csv exports from your SIS.
   15. Go back to the SwiftK12 Sync Tool interface, you are now in the [Alerts List & Configuration] screen of the sync tool.
   16. On this page you will see on the top left what school you are in, most schools will start in the “District Office” by default.
       1. While in the District Office you will see 2 tabs; “Students” and “Staff”.
          1. These are the 2 areas that will show the file location of the folder you are sending the csv exports from your SIS to, as well as, the file name the sync tool is looking for to process the sync.
          2. It is important to not change the location of file, as the sync tool uses this location specifically to process the csv file.
          3. If you have renamed your csv export from your SIS to something other than the default “students.csv” or “staff.csv”, please put that file into the students or staff folder and then click on the “Update” button and choose that file.
       2. At this point your sync tool is setup for Students and Staff.  From now on, whenever a .csv file of the correct name is added to the respective folders (Students, Staff, Etc.), the sync tool will automatically process the update.
4. If you would like to add automated syncs for any of our automated alerts, those would show up for each of the schools that have the automated alerts setup in the SwiftK12 application.
   1. Once you create an automated alert for a specific school, you can go back into the sync tool by going to the bottom right of the screen on your operating system, clicking on the “Show hidden icons” up arrow and clicking on the Graduation cap icon.
      1. The SwiftK12 sync tool is always running in the background to allow the syncs to run.
   2. Once in the sync tool you can change the “School” drop down on the top left of the sync tool window to the school name that you setup the automated alert for.
   3. Switching to a school from the District Office will add 4 more tabs to display.  Each tab corresponds with that schools automated alerts.
   4. For example: If you created an attendance alert in SwiftK12 for the school, when you click on the “Daily Attendance” tab for the school in the sync tool, it will now show that “Alert Name” you created.
   5. To configure the sync tool for an automated alert, click the “Configure” button next to the automated alert you wish to sync.
   6. Click the “Choose File” and choose the file you have going to the corresponding automated alert folder on your computer then click the “Save Configuration” button.
   7. A “Map Alert Headers” window will appear, this will allow you to map unknown column header names from your SIS to the correct field types in SwiftK12.
      1. Click the “Create Mapping” button.
      2. Click the “Choose Template File” button.
      3. Select the file in the respective automated alert folder on your computer that you have exported from your SIS.
      4. Choose the mapping that most closely correlates with the field.  If using the ID csv for the alert rather than the field csv, put a check in the “Contain ID Column” box at the top of the form.  If you are using the field csv for the automated alert, do not put a check in the box.
      5. After mapping the field types, click the “Save Mapping” button.
      6. At this point, whenever a .csv file of the correct name is added to the respective folders (Attendance, Fees, Grades, Lunch), the sync tool will automatically process the update.
      7. Please note that when scheduling your SIS to run exports, it is best practice to schedule the exports for 30 minutes prior to when the alert is scheduled to go out from SwiftK12.  This allows ample time to ensure an alert doesn’t go out before the update is done processing.

NOTE: Please keep in mind that when setting up an automated alert file you must include all field types required for the automated alert you are using.  During the mapping process you will need to have all required fields mapped.  For a list of required fields please go into the automated alert section in SwiftK12 and click the “Upload” button to view the required field types in Blue for each type of alert.

Conclusion:

Now that you have setup the sync tool in its entirety it will run automatically.