Obtaining files from TSDS.
- Option 1 -TSDS edm functionality allows users to pull xml files.
- Option 2- PEIMS Data Mart (PDM) Data Retrieve functionality allows user to pull CSV files.
- CAUTION: The following data is not currently included in TSDS retrieve data (CSV files).
- Student Section Association complex
- *Campus Expanded Learning Opportunity Information (Summer-10020)
- *Special Education Program Effective Dates-All E1632 (Summer-41163)
- *Summer Student Special Ed Program Information for PEIMS/RF Tracker report
- *Residential Facility Indicator E1629 (Summer-40100)
- (* due to being unbound or multiples)
- CAUTION: The following data is not currently included in TSDS retrieve data (CSV files).
TSDS Retrieval Instructions: Log into TSDS
Option 1: TSDS EDM BATCH FILE (XML Format) – preferred
- TSDS edm/batch file – pulls the interchange files out of TSDS
Example- ECDS data elements that are included in the Summer PEIMS file, but are NOT loaded into the PDM.
edm instructions:
- Log into TSDS and go to the Batch Manager- EDM
- Locate your “Batch”
![](https://i2.wp.com/Manuals.OnDataSuite.com/wp-content/uploads/2017/07/batch-manager-1024x243.png?resize=1024%2C243)
- Select the “Spyglass” ( on the right)
- Under “actions”, you should be able to see all your interchange files for the batch
![](https://i2.wp.com/Manuals.OnDataSuite.com/wp-content/uploads/2017/07/edm-data-loads-1024x370.png?resize=1024%2C370)
- This should send you to the ETL
- Scroll to the top and locate the “Validation Info” tab
- Click on Validation Information tab
![](https://i0.wp.com/Manuals.OnDataSuite.com/wp-content/uploads/2017/07/edm-DL-2-1024x433.png?resize=1024%2C433)
- Toward the bottom see the “Source File” and “Download File”.
- Use the “Download file” to pull up your interchange files for the collection and download to your local drive!
![](https://i1.wp.com/Manuals.OnDataSuite.com/wp-content/uploads/2017/07/ETL-1024x409.png?resize=1024%2C409)
- Option 2- Retrieve data from PDM (CSV Format)
- Log in and go to PEIMS/View Reports
![](https://i0.wp.com/manuals.ondatasuite.com/wp-content/uploads/2017/07/View-reports-2-300x250.png?resize=300%2C250)
- Locate the “Retrieve Submission Data” functionality under Access Data.
![](https://i1.wp.com/manuals.ondatasuite.com/wp-content/uploads/2017/07/Retrieve-3-300x139.png?resize=300%2C139)
- Select All Categories and click “ADD”. Create a name for the file in the “Submission Retrieval Name” field, and click “Next”.
![](https://i0.wp.com/manuals.ondatasuite.com/wp-content/uploads/2017/07/Step-5-name-data-tsds-284x300.png?resize=284%2C300)
- Confirm Year, collect and categories, then click “Submit”.
![](https://i0.wp.com/manuals.ondatasuite.com/wp-content/uploads/2017/07/confirm-TSDS-data-retrival-300x233.png?resize=300%2C233)
NOTE: If changes are needed, “Cancel” and find the correct Year/Submission using the drop downs located at the top of the TSDS screen.
- When Data is ready to download, the status will show COMPLETED and Retrieve will be hyperlinked to the file. (Use refresh, as needed.)
![](https://i0.wp.com/manuals.ondatasuite.com/wp-content/uploads/2017/07/Retrieve-and-save-8.png?resize=1065%2C561)
- Click “Save” and a zipped file will appear on the bottom right of the screen.
- Save zipped file in desired location/folder. It is ready to upload into OnDataSuite.