Automated Data Import from PowerSchool

Many schools use PowerSchool in addition to JumpRope either because PowerSchool is provided/required by their state or district or because they use functions of PowerSchool that JumpRope does not provide (such as lunch management and purchasing).  Instead of maintaining student records manually in JumpRope, we recommend that any schools that store student records and schedules in PowerSchool follow these instructions to set up automatic & secure synchronization of student schedules to JumpRope.  It will take a few minutes to set up initially, but when complete you schedule and students will automatically synchronize once each night and on demand whenever required!

Setting Up PowerSchool->JumpRope Synchronization

1. Make sure that you have indicated to JumpRope (via the Admin Console or via our support system) that you would like to synchronize data with PowerSchool.  When complete, we will provide you with a login and a password to our SFTP synchronization server.
2. Log into the PowerSchool Admin interface as you normally would.  Often, you can do this by visiting http://{your_school}.powerschool.com/admin or the web address that you typically log in with.  JumpRope cannot help you with your username or password to PowerSchool - you'll have to contact Pearson if you run into trouble logging in.
3. First, we need to tell PowerSchool how to connect securely to JumpRope via a Managed Connection.
1. Click System in the menu at left: http://screencast.com/t/tXLwYG3aK0q
2. Scroll down and click on System Settings: http://screencast.com/t/tXLwYG3aK0q
3. Select Plugin Management Configuration: http://screencast.com/t/OMXtpSdl
4. Enable and select the Remote Connection Manager: http://screencast.com/t/k2lSiIhtt
5. Click on Remote Connection Manager once again: http://screencast.com/t/L5EM0ebKR5bJ
6. Click on Create Connection: http://screencast.com/t/HVWv698D2DbC
7. Carefully fill out the fields as shown in this screenshot: https://goo.gl/Fu4Aay. If you are setting this up for multiple schools and have been provided separate FTP credentials for each school, please be sure to adjust the "Name" field to also include the name of the school. You'll need one managed connection per school. 
1. Name: JumpRope SFTP
2. Protocol: SFTP
3. Host: sync2015.jumpro.pe
4. Port: 22
5. Username: as provided by JumpRope
6. Password: as provided by JumpRope
7. Click on Test Connection, and "Yes, Accept Host Key" if prompted with a failure warning (see screenshot: http://screencast.com/t/WWkS4Cq9U)
8. Remote Path: jumprope_imports/
9. Allow download: check the box
10. Allow upload: check the box
11. Click on submit.  You should see a screen that looks similar to this: http://screencast.com/t/YNUaU93z1R
4. Now that we have a secure connection set up, we need to tell PowerSchool which files to send and when to send them.
1. Click System in the menu at left: http://screencast.com/t/tXLwYG3aK0q
2. Select AutoSend Setup: http://screencast.com/t/MDKaSlqE
3. Click on New (ignore any existing AutoSend configurations): http://screencast.com/t/DcOYF73q7I
4. We now need to create five separate AutoSend configurations (one for each of Courses, Sections, Student Schedules, Students, and Teachers).  Each configuration is similar, but we'll walk through each separately.
5. ***Important*** Note that all autosends that you will set up below will indicate 3:00 AM for "When to Execute". The time that you choose to execute these is up to you, but be aware of anything else that may be running on your server overnight and keep that in mind when setting up the times. We recommend that you stagger the times of the 5 autosends below so that they run 15-30 minutes apart, beginning no earlier than 10 PM and completing no later than 6 AM. If too many items are scheduled at once, your autosends may fail.
6. Create an AutoSend configuration for Courses: 
1. Fill out all fields exactly as shown in this screenshot: http://screencast.com/t/wUx6WV1ud

2. Id
   Course_Name
   Course_Number
   Credit_Hours
   Maxclasssize
   Schoolid
   Credittype
   Crhrweight
   Gpa_Addedvalue
   GradeScaleID

3. Submit, and click on Run Now and ensure that no error message appears (it will not give a confirmation message - we'll check that it is successful on our end): http://screencast.com/t/MzmrSXpUVeel
7. Create an AutoSend configuration for Sections:
1. Fill out all fields exactly as shown in this screenshot: http://screencast.com/t/vM9HhopTIO

2. Id
   Course_Number
   Expression
   No_Of_Students
   Room
   Rostermodser
   Schedulesectionid
   SchoolID
   Section_Number
   Teacher
   TermID
   Exclude_Ada
   Excludefromclassrank
   Excludefromhonorroll
   GradeScaleID

3. Submit, and click on Run Now and ensure that no error message appears (it will not give a confirmation message - we'll check that it is successful on our end).  If you run into an error, edit the configuration and verify that all fields are filled out exactly as shown.
8. Create an AutoSend configuration for Student Schedules:
1. Fill out all fields exactly as shown in this screenshot: http://screencast.com/t/h3fGZAkV2k1N

2. Id
   Course_Number
   DateEnrolled
   DateLeft
   Expression
   Schoolid
   Sectionid
   Section_Number
   Studentid
   Teacher
   TermID
   [Terms]Abbreviation
   [Terms]Firstday
   [Terms]Importmap
   [Terms]IsYearRec
   [Terms]LastDay
   [Terms]Name
   [Terms]NoOfDays
   [Terms]Portion
   [Terms]YearID
   [CC]TeacherID
   [Sections]Teacher

3. Submit, and click on Run Now and ensure that no error message appears (it will not give a confirmation message - we'll check that it is successful on our end).  If you run into an error, edit the configuration and verify that all fields are filled out exactly as shown.
9. Create an AutoSend configuration for Students:
1. Fill out all fields exactly as shown in this screenshot: http://screencast.com/t/ybA95RuEwaO, but please use the list of fields below rather than the one in the screenshot.

2. Id
   Cell_Phone
   City
   Classof
   Dob
   Emerg_1_Rel
   Emerg_Contact_1
   Emerg_Phone_1
   Ethnicity
   Father
   Fatherdayphone
   First_Name
   Last_Name
   Gender
   Grade_Level
   Home_Phone
   Mailing_Street
   Mailing_City
   Mailing_State
   Mailing_Zip
   Mother
   Motherdayphone
   Person_Id
   SchoolID
   Student_Number
   student_email

3. Submit, and click on Run Now and ensure that no error message appears (it will not give a confirmation message - we'll check that it is successful on our end).  If you run into an error, edit the configuration and verify that all fields are filled out exactly as shown.
10. Finally, create an AutoSend configuration for Teachers:
1. Fill out all fields exactly as shown in this screenshot: http://screencast.com/t/q5SNVFeU4m

2. Id
   Email_Addr
   First_Name
   Last_Name
   SchoolID
   TeacherNumber
   Title

3. Submit, and click on Run Now and ensure that no error message appears (it will not give a confirmation message - we'll check that it is successful on our end).  If you run into an error, edit the configuration and verify that all fields are filled out exactly as shown.
11. Almost done!  Verify that your AutoSend screen now looks similar to this (it's okay if there are additional AutoSend configurations that are unrelated to JumpRope, but we need all five of these): http://screencast.com/t/iYQeMZ0twl1.  Verify that you have clicked Run Now at least once for each configuration and that it has completed without warning.  If everything looks good, please contact support@jumpro.pe and we will double-check the configuration on our end and let you know if you need to take any additional steps.