Integrating with the Jupiter student information system
Overview
This article contains guidance on setting up a SIS integration using the Jupiter Automated Import/Export functionality.
Integrating with Jupiter
Setting Up The Integration
- Login to Jupiter as an admin with access to all schools that need to be exported.
- Go to Setup > Import/Export
- Use the following instructions to set up a customized export using these options:
Export Students
- Click Export Students
- In the top box:
- Make sure you are exporting All Students at All Schools
| Save These Settings | Check this box and name the export something you will remember. Example: "DESSA Students Export" |
| File Type | .csv is preferred, but .txt is also acceptable |
| Line Breaks | LF or CRLF both work fine |
| Header Row |
Check this box |
| Compress as ZIP | Leave unchecked |
| Transfer to FTP Server | Check this box |
| SFTP Jupiter vs Other FTP Server | Select Other FTP Server |
| Server |
DESSA Server name or IP address This will be sent to you by the DESSA Data Operations Team via a 1Password Secure Link |
| SFTP vs FTP | Select SFTP |
| Port | 22 |
| Username |
Username to connect to the DESSA server This will be sent to you by the DESSA Data Operations Team via a 1Password Secure Link |
| Password |
Password to connect to the DESSA server This will be sent to you by the DESSA Data Operations Team via a 1Password Secure Link |
| Filename |
This is the name of the export file Please use a name that is easily recognizable and includes the file type at the end such as students.csv |
| Export Automatically | Check this box |
| Days to Export | Check the box for each day of the week |
| Time to Export |
DESSA System imports each morning at 2 AM EST. We recommend scheduling your files to be sent daily no later than 1:30 AM EST. |
| Export End Date | Set this date for the end of the school year or contract to ensure the integration continues to work through the school year |
| Email Error Reports | Check this box and input your email if export reports are desired |
- In the bottom box:
|
Data (Italicized names are custom fields and may or may not match the fields used in your Jupiter SIS) |
Dropdown |
Header (These are editable and the following are Aperture Recommendations) |
DESSA Required? | DESSA Format |
|
Student ID |
N/A | StudentID | Y | At least one non-whitespace character, unique within the Program |
| State ID | N/A | StateID | N | Blank or unique within the Program; Required for CSDE programs |
| First Name | Select Legal | FirstName | Y | At least one non-whitespace character |
| Last Name | N/A | LastName | Y | At least one non-whitespace character |
| School# | N/A | SchoolID | Y | Unique to each individual school |
| Grade Level | N/A | GradeLevel | Y | K, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, or 12 |
| Gender | Select M/F | Gender | Y | M, F, T, U, N, or X |
| Birthdate | Select MM/DD/YYYY | Birthdate | Y | Date Format: mm/dd/yyyy |
| *American Indian or Alaskan Native | Select Y/N | AmericanIndianorAlaskanNative | Y | Y, N, or U |
| *Asian | Select Y/N | Asian | Y | Y, N, or U |
| *Black or African American | Select Y/N | BlackorAfricanAmerican | Y | Y, N, or U |
| *Hispanic or Latinx | Select Y/N | HispanicorLatinx | Y | Y, N, or U |
| *Pacific Islander | Select Y/N | PacificIslander | Y | Y, N, or U |
| *White | Select Y/N | White | Y | Y, N, or U |
| *Other | Select Y/N | Other | Y | Y, N, or U |
| *Free or Reduced Lunch | Select Y/N | FreeorReducedLunch | N | Blank, Y, or N |
| *Economically Disadvantaged | Select Y/N | EconomicallyDisadvantaged | N | Blank, Y, or N |
| *McKinney-Vento | Select Y/N | McKinneyVento | N | Blank, Y, or N |
| *Migrant | Select Y/N | Migrant | N | Blank, Y, or N |
| *Gifted | Select Y/N | Gifted | N | Blank, Y, or N |
| *Special Ed | Select Y/N | SpecialEd | N | Blank, Y, or N |
| *504 Plan | Select Y/N | 504Plan | N | Blank, Y, or N |
| *English Language Learner | Select Y/N | EnglishLanguageLearner | N | Blank, Y, or N |
| Zip | Select Residence | ResidenceZip | N | Blank or ##### |
*Note: Anything stared and italicized is considered a "Custom Field" in Jupiter and would have to be configured in Jupiter as such by going to Setup > Custom Fields. Once configured, students would then need to be marked appropriately in Jupiter for these fields to work.
- After all of the settings above are configured, click "Export" to send data immediately and begin the integration process.
Export Staff
- Click Export Staff
- In the top box:
- Make sure you are exporting All Staff at All Schools
| Save These Settings | Check this box and name the export something you will remember. Example: "DESSA Staff Export" |
| File Type | .csv is preferred, but .txt is also acceptable |
| Line Breaks | LF or CRLF both work fine |
| Header Row |
Check this box |
| Compress as ZIP | Leave unchecked |
| Transfer to FTP Server | Check this box |
| SFTP Jupiter vs Other FTP Server | Select Other FTP Server |
| Server |
DESSA Server name or IP address This will be sent to you by the Aperture Data Operations Team via a 1Password Secure Link |
| SFTP vs FTP | Select SFTP |
| Port | 22 |
| Username |
Username to connect to the DESS server This will be sent to you by the DESSA Data Operations Team via a 1Password Secure Link |
| Password |
Password to connect to the DESSA server This will be sent to you by the DESSA Data Operations Team via a 1Password Secure Link |
| Filename |
This is the name of the export file Please use a name that is easily recognizable and includes the file type at the end such as staff.csv |
| Export Automatically | Check this box |
| Days to Export | Check the box for each day of the week |
| Time to Export |
DESSA system imports each morning at 2 AM EST. We recommend scheduling your files to be sent daily no later than 1:30 AM EST. |
| Export End Date | Set this date for the end of the school year or contract to ensure the integration continues to work through the school year |
| Email Error Reports |
Check this box and input your email if export reports are desired |
- In the bottom box:
|
Data |
Header (These are editable and the following are Aperture Recommendations) |
DESSA Required? | DESSA Format |
| First Name | FirstName | Y | At least one non-whitespace character |
| Last Name | LastName | Y | At least one non-whitespace character |
| Y | Email format, unique within the Org | ||
| Staff ID | StaffID | Y | Unique to each individual Staff Member |
- After all of the settings above are configured, click "Export" to send data immediately and begin the integration process.
Export Schools
- Click Export Schools
- In the top box:
- Make sure you are exporting All Schools
| Save These Settings | Check this box and name the export something you will remember. Example: "DESSA Schools Export" |
| File Type | .csv is preferred, but .txt is also acceptable |
| Line Breaks | LF or CRLF both work fine |
| Header Row |
Check this box |
| Compress as ZIP | Leave unchecked |
| Transfer to FTP Server | Check this box |
| SFTP Jupiter vs Other FTP Server | Select Other FTP Server |
| Server |
DESSA Server name or IP address This will be sent to you by the DESSA Data Operations Team via a 1Password Secure Link |
| SFTP vs FTP | Select SFTP |
| Port | 22 |
| Username |
Username to connect to the DESSA server This will be sent to you by the DESSA Data Operations Team via a 1Password Secure Link |
| Password |
Password to connect to the DESSA server This will be sent to you by the DESSA Data Operations Team via a 1Password Secure Link |
| Filename |
This is the name of the export file Please use a name that is easily recognizable and includes the file type at the end such as schools.csv |
| Export Automatically | Check this box |
| Days to Export | Check the box for each day of the week |
| Time to Export |
DESSA System imports each morning at 2 AM EST. We recommend scheduling your files to be sent daily no later than 1:30 AM EST. |
| Export End Date | Set this date for the end of the school year or contract to ensure the integration continues to work through the school year |
| Email Error Reports | Check this box and input your email if export reports are desired |
- In the bottom box:
|
Data |
Header (These are editable and the following are DESSA Recommendations) |
DESSA Required? | DESSA Format |
| School# | SchoolID | Y | Unique to each individual school |
| School Name | SchoolName | Y | At least one non-whitespace character |
- After all of the settings above are configured, click "Export" to send data immediately and begin the integration process.
Export Grades/Rosters
- Click Export Schools
- In the top box:
- Make sure you are exporting All Classes at All Schools
| Save These Settings | Check this box and name the export something you will remember. Example: "Aperture Class Export" |
| File Type | .csv is preferred, but .txt is also acceptable |
| Line Breaks | LF or CRLF both work fine |
| Header Row |
Check this box |
| Compress as ZIP | Leave unchecked |
| Transfer to FTP Server | Check this box |
| SFTP Jupiter vs Other FTP Server | Select Other FTP Server |
| Server |
DESSA Server name or IP address This will be sent to you by the DESSA Data Operations Team via a 1Password Secure Link |
| SFTP vs FTP | Select SFTP |
| Port | 22 |
| Username |
Username to connect to the DESSA server This will be sent to you by the DESSA Data Operations Team via a 1Password Secure Link |
| Password |
Password to connect to the DESSA server This will be sent to you by the DESSA Data Operations Team via a 1Password Secure Link |
| Filename |
This is the name of the export file Please use a name that is easily recognizable and includes the file type at the end such as schools.csv |
| Export Automatically | Check this box |
| Days to Export | Check the box for each day of the week |
| Time to Export |
DESSA Imports each morning at 2 AM EST. We recommend scheduling your files to be sent daily no later than 1:30 AM EST. |
| Export End Date | Set this date for the end of the school year or contract to ensure the integration continues to work through the school year |
| Email Error Reports | Check this box and input your email if export reports are desired |
- In the bottom box:
|
Data |
Dropdowns |
Header (These are editable and the following are DESSA Recommendations) |
DESSA Required? | DESSA Format |
|
Student ID |
N/A |
StudentID |
Y | At least one non-whitespace character, unique within the Program |
|
School# |
N/A |
SchoolID |
Y | Unique to each individual school |
|
Course# |
N/A |
CourseNum |
Y | At least one non-whitespace character |
|
Section# |
N/A |
SectionNum |
Y | At least one non-whitespace character |
|
Course Title/Subject |
N/A |
CourseTitle |
Y | At least one non-whitespace character |
|
Teacher |
Select Master Teacher and Staff ID |
StaffID |
Y | Unique to each individual Staff Member |
|
Period |
N/A |
Period |
Y | At least one non-whitespace character |
- After all of the settings above are configured, click "Export" to send data immediately and begin the integration process.
Helpful Resources
For in-depth information on how to configure the Jupiter Automated Import/Export functionality, please refer to the following articles from the Jupiter support site:
For any additional information on using the Jupiter Automated Import/Export functionality, please contact Jupiter Support directly.
For questions about what data Aperture Education uses to upload your rosters, please refer to the following article: Required fields for Aperture roster files.
For additional information regarding the steps to set up a SIS Integration, please refer to the following article: Steps for setting up a SIS Integration with Aperture Education.
Comments
0 comments
Article is closed for comments.