Data Integration for Pathways
Former user (Deleted)
Former user (Deleted)
Alan Degener
Laura Allen
Welcome to Pathways Data Integration!
Follow this guide to send your SIS data to Pathways
Table of Contents:
Introduction
Pathways is a premier school administration software for managing the graduation requirements, grades, and statuses for your high school students.
Data Sets
Each Student Information System (SIS) provides unique data sets for Pathways. Generally speaking, Pathways will collect the following student data:
Students - Contains general student information including: names, ids, etc.
Grades - historical and current-semester grades for your students. Some SISs will send data in two files.
GPA - the weighted and/or unweighted grade point averages for your students. Some SISs include this data within the students file.
IBC (TX Only) - additional details on student graduation paths and programs for Texas districts.
Course Crosswalk - an additional data set, required by some SISs, to align local course codes with sate-assigned course codes.
Method
Data exported from most SISs will be sent to Pathways via SFTP. If your district uses Aeries SIS, data will be transferred using API.
Data Send Schedules
All data sets should be sent nightly (including weekends) before 1am CST.
Data Transfer & Responsibilities
Pathways views your SIS as the Single Source of Truth for all data. Please review the steps below for how data is sent from your SIS to Pathways.
1 - Manage Data in SIS – Sending data to Pathways begins with adding, updating, and maintaining the accuracy of course request, student, and teacher data within your SIS.
2 - Export Data from SIS – Your district IT, with help from your Pathways Data Integrations Engineer, will configure SIS data exports that create the Pathways data files.
3 - Send Files to EAI – Your SIS/District IT will send data files to Pathways on a regular basis (via SFTP or API, depending on your SIS).
4 - Maintain Servers – Pathways will create and maintain servers for the purpose of securely retrieving data from your SIS.
5 - ETL & Data Security – EAI will retrieve the data files from SFTP, encrypt, and store data using AWS. See EAI’s Data Privacy page for more information on how EAI secures your data.
6 - EAI Product - EAI will display your district data in Pathways.
Timeline & Checklist
A meeting with your Pathways DI Engineer to review the data requirements and/or configure exports in your SIS. This meeting can be up to 45 minutes.
Weeks 1: Send First Files:
By the end of the first week, SFTP will be configured and the first files (data sets) sent to Pathways.
Please configure all files to be sent nightly (including weekends) before 1am CST.
Week 2: Data Validation:
Your Pathways DI Engineer will review and validate the sent data, then follow up with you for any needed adjustments to the exports.
After: Data Management:
Once the data in Pathways is validated, you will continue to maintain data within your SIS you may be contacted by your staff if data abnormalities are discovered in Pathways.
Please reach out to your DI Engineer if you need assistance troubleshooting any of these data abnormalities.
Instructions for Exporting SIS Data:
Locate the templates and instructions for your SIS below.
Ascender SIS
Contact your Education Regional Center (ERC) support team to submit a request to send data to Pathways. Please include the information below and cc your DI Engineer as part of this request.
Data Requirements:
| File | Modified | |
|---|---|---|
|
Microsoft Excel Spreadsheet PW-Ascender Data Requirements.xlsx Ascender SIS data requirements for Pathways |
Sept 26, 2023 by Former user | |
|
Text File students.txt Example Students data for Ascender SIS |
Sept 26, 2023 by Former user | |
|
Text File historic_grades.txt Example Historic Grades data for Ascender SIS |
Sept 26, 2023 by Former user | |
|
Text File current_grades.txt Example Current Grades for Ascender SIS |
Sept 26, 2023 by Former user |
Instructions:
Step 1: Your ERC will build the following export files:
All data files must be in CSV format and pipe-separated.
students.txt - First Name|Last Name|State Student Id|Ascender Student Id|Gender|Graduation Year|Birthdate|School Id|GPA|IBC PEIMS|Sum|Total Credits District|Sumt|Total Credits Transferred|Stem Endeavors|Public Service Endeavors|BUS Industry Endeavors|Multi Discipline Endeavors|Arts Humanities Endeavors|Distinguished Coursework|Foundation Coursework|College Career Instruction|DT CPR|DT Police Interact|DT Speech|FAFSA Status
current_grades.txt - Student ID|Course Name|Course ID|State Course ID|Potential Credits|Credits Earned|Grade/Score|Year Taken|Grading Period|Counts Toward GPA|Is AP Class|Earned Dual Credit|ONRAMPS|Final Grade
historic_grades.txt - Student ID|Course Name|Course ID|State Course ID|Potential Credits|Credits Earned|Grade/Score|Year Taken|Grading Period|Counts Toward GPA|Is AP Class|Earned Dual Credit|ONRAMPS
Step 2: Send test data exports to Pathways:
Notify your DI Engineer that your ERC has completed the data exports.
Send these files via SFTP using the SFTP creds provided by your DI Engineer.
Your DI Engineer will then validate the data and load it to Pathways.
Step 3: Request Nightly Sends from ERC:
Once the data has been validated by your DI Engineer, forward the SFTP details to your ERC so they can schedule the export.
eSchoolPLUS
Download the Cognos templates (below) and configure them using the instructions below. Please note, these templates may need to be modified to account for district-specific data.
Cognos Report Templates:
| File | Modified | |
|---|---|---|
|
Text File Clipboard_students.txt Student import file for eSchoolPLUS/Cognos |
May 20, 2024 by Former user | |
|
Text File Clipboard_courses.txt Courses import file for eSchoolPLUS/Cognos |
May 20, 2024 by Former user | |
|
Text File Clipboard_current_grades.txt Current grades import file for eSchoolPLUS/Cognos |
May 20, 2024 by Former user | |
|
Text File Clipboard_GPA.txt GPA import file for eSchoolPLUS/Cognos |
May 20, 2024 by Former user | |
|
Text File Clipboard_historical_grades.txt Historical grades import file for eSchoolPLUS/Cognos |
May 20, 2024 by Former user |
Instructions:
Step 1: Download Cognos files:
Download the Cognos Report Template files, above.
Step 2: Load the files to Cognos:
Load each report template file to Cognos.
Then run each report to confirm that the expected data was exported.
Note: The template files may need to be customized for your specific table structure. Your Pathways DI Engineer can assist you with this process.
Step 3: Schedule and send CSV files via SFTP:
Schedule all reports to run and send data to Pathways nightly, before 1am CST using the SFTP credentials provided by your Pathways DI Engineer.
Harmony
Follow the instructions below to manually update data from Harmony SIS to Pathways. We recommend completing this update at the end of each grading period (quarter, semester, trimester, etc.).
Instructions:
Log into Pathways and click on Import Data under Utilities:
Click on the link to select the Harmony SIS file you wish to import:
Select Choose File and then Upload File to complete the update.
PowerSchool
Download the PowerSchool API directly within Pathways and configure it by following the instructions below.
Instruction:
Step 1: Download API file from Pathways
Log into your Pathways account.
Go to Utilities in the green ribbon and select District Settings.
Scroll down and click Student Information System (SIS) Settings and Import Policies under Student Information System (SIS) Settings.
Download the API ZPI file by clicking the link:
Step 2: Install the API file in PowerSchool
Open a new tab and log into PowerSchool. Go to Plugin Management Configuration.
Install and Enable the API ZIP file. Do not unzip this file before installation.
Find and open Standards for Success Plugin on the plugin list.
Click Data Provider Configuration to view the your API Key and Secret.
Step 3: Configure API in Pathways
Go back to your Pathways account to Student Information System (SIS) Settings and Import Policies
Enter the following information under the PowerSchool API Access section:
Click Test Connection to confirm the API is retrieving data.
Then click Save at the bottom of the page.
Step 4: Notify your DI Engineer
Email your DI Engineer that the plugin has been configured. They will then validate data within Pathways and follow up with you on next steps, if needed.
Skyward Q
Download the Import files for your state (below) and then load/configure them in Skyward Q using the instructions below.
Indiana Import Files:
| File | Modified | |
|---|---|---|
|
File IN_Pathways_EAI_Students.sxr IN Students import file for Skyward Q |
Oct 02, 2023 by Former user | |
|
File IN_Pathways_EAI_Grades.sxr IN Grades import file for Skyward Q |
Oct 02, 2023 by Former user | |
|
File IN_Pathways_EAI_GPA.sxr IN GPA Import file for Skyward Q |
Oct 02, 2023 by Former user | |
|
File IN_Pathways_EAI_Course_Crosswalk.sxr IN Course Crosswalk import file for Skyward Q |
Oct 02, 2023 by Former user |
Texas Import Files:
| File | Modified | |
|---|---|---|
|
File TX_Pathways_EAI_Students.sxr TX Students import file for Skyward Q |
Sept 29, 2023 by Former user | |
|
File TX_Pathways_EAI_Grades.sxr TX Grades import file for Skyward Q |
Sept 29, 2023 by Former user | |
|
File TX_Pathways_EAI_GPA.sxr TX GPA import file for Skyward Q |
Sept 29, 2023 by Former user | |
|
File TX_Pathways_EAI_Course_Service_IDs.sxr TX Service ID import file for Skyward Q |
Sept 29, 2023 by Former user | |
|
File TX_Pathways_EAI_Course_Crosswalk.sxr TX Course Crosswalk import file for Skyward Q |
Sept 29, 2023 by Former user |
Instructions:
Step 1: Download Import Files
Download your State-specific Pathways import files, below. The data files are:
Step 2: Load Import Files to Skyward Q:
Log into Skyward Q. Then select the green menu. Go to Reporting, then Report Manager.
Select Upload Reports and chose all downloaded Pathways import files.
Finally, click Run Process to create the reports.
Step 3: Schedule and Configure SFTP:
Complete the following for each Pathways Import file.
In Skyward Q, go back to Report Manager.
Search for “Education Advanced” and click the Details button.
Click Scheduled Reports then Add Scheduled Report.
Enter a Report Name of your choice. Then enter of Start Time before 1am CST.
Click on Save & Add Export Location.
Enter the Skyward @ Report Name from the chart in Step 1, above.
Click Add FTP/SFTP Connection or search for your existing Pathways SFTP connection.
Use the hostname and credentials provided by your Pathways DI Engineer to add a new SFTP connection in Skyward Q. Please click Test Connection before saving.
Save and manually send the file. Then email your Pathways DI Engineer to notify them that the files have been sent.
See Skyward Q’s Technical Knowledge Base for more information on configuring data exports.
Skyward SMS
Download the Import files for your state (below) and then load/configure them in Skyward SMS using the instructions below.
Indiana Import Files:
| File | Modified | |
|---|---|---|
|
Text File Pathways IN SSMS - course_crosswalk.txt IN course_crosswalk export template for Skyward SMS |
Nov 06, 2023 by Former user | |
|
Text File Pathways IN SSMS - gpa.txt IN gpa export template for Skyward SMS |
Nov 06, 2023 by Former user | |
|
Text File Pathways IN SSMS - grades.txt IN grades export template for Skyward SMS |
Nov 07, 2023 by Former user | |
|
Text File Pathways IN SSMS - students.txt IN students export template for Skyward SMS |
Nov 06, 2023 by Former user |
Texas Import Files:
| File | Modified | |
|---|---|---|
|
Text File TX EAI-IBC.txt TX ibc export template for Skyward SMS |
Nov 06, 2023 by Former user | |
|
Text File TX Pathways - Course_Crosswalk.txt TX course_crosswalk export template for Skyward SMS |
Nov 06, 2023 by Former user | |
|
Text File TX Pathways - Students.txt TX students export template for Skyward SMS |
Nov 06, 2023 by Former user | |
|
Text File TX Pathways-GPA.txt TX gpa export template for Skyward SMS |
Nov 06, 2023 by Former user | |
|
Text File TX Pathways-Grades.txt TX grades export template for Skyward SMS |
Nov 06, 2023 by Former user |
Instructions: