Chicago Public Schools Aspen Data Export Instructions

To upload student, teacher, and schedule information from Aspen into JumpRope, three CSV files are required from Aspen with custom field settings.

Follow these steps to export the three files:

1. Log into Aspen
2. Student Info: 
   1. Click on the Students tab
   2. Click on the Field Set Menu icon (a table to the right of the Filter Menu icon) and then click on Manage Field Settings
   3. Create a new field set called "JumpRope Students" and add the following fields in this order (parenthesis show what the export will name the column):
      1. Student ID
      2. State ID (SASIS)
      3. Last name (LastName)
      4. Middle name (MiddleName)
      5. First name (FirstName)
      6. Gender 
      7. Date of Birth (DOB)
      8. Grade level (Grade)
      9. Ethnic Category (Ethnic)
      10. Physical Address > Postal Code (Zip)
      11. Primary email-Correo electrónico primario (Email1)
      12. Emergency contact 1 > Name (Name)
      13. Emergency contact 1 > Relationship (Relationship)
      14. Phone 1 (Phone1)
      15. Emergency contact 1 > Primary email-Correo electronico primario (Email1)
   4. From the print icon, select CSV to download the export.  A consistent filename is important for our scripts, so please name this file Students.csv
3. Staff Info: 
   1. Click on the Staff tab
   2. Click on the Field Set Menu icon and then click on Manage Field Settings
   3. Create a new field set called "JumpRope Staff" and add the following fields in this order:
      1. Last name (LastName)
      2. First name (FirstName)
      3. Primary email-Correo electronico primario (Email1)
      4. User > Login ID (Login)
   4. Form the print icon, select CSV to download the export.  A consistent filename is important for our scripts, so please name this file Staff.csv
4. Student Schedules:
   1. Click on the Schedule tab
   2. Click on the Schedules side tab (on the vertical menu on the left side of the screen)
   3. Click on the Field Set Menu icon and then click on Manage Field Settings
   4. Create a new field set called "JumpRope Student Schedules" and add the following fields in this order
   1. Student > Student ID
   2. Student > Name
   3. Student > Grade Level
   4. School Course > Number
   5. Section Number
   6. Schedule
   7. Description
   8. Primary Staff > Name
   9. Teacher   **Note: this may appear to be duplicate information, but it's important in order to model co-teacher relationships
   10. Primary Staff > Primary email-Correo electrónico
   11. Schedule Term
   5. From the print icon, select CSV to download the export.  A consistent filename is important for our scripts, so please name this file "Schedules.csv"
5. Previously, these three files were uploaded to JumpRope's SFTP.  Now you can upload the files directly into JumpRope from your account.  Follow these steps:
   1. Go to Admin -> Schedule Imports and select New Schedule Import
   2. Browse for each of the three files and then click Upload:
   3. Wait approximately 5 minutes while the sync completes, more info will be displayed throughout the process
   4. You're done!

Advantages:

1. You can do this upload as many times as you need to throughout the day (though I don't recommend doing it constantly..).  You won't have to wait on us.
2. It will let you know right away if we notice a problem in the file format or data by giving you an error (sometimes with enough info that you can fix it yourself).
3. You get to skip the whole SFTP bit.