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
Email	Email	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

Unique to each individual school

School Name

SchoolName

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.