Obtaining files from TSDS
- Option 1- PEIMS Data Mart (PDM) Data Retrieve functionality allows user to pull CSV files.
- Option 2 -TSDS edm functionality allows users to pull xml files.
TSDS Retrieval Instructions: Log into TSDS
Option 1: Retrieve data from PDM – CSV Format
- Locate the “Retrieve Submission Data” functionality under Access Data.
- Select All Categories and click “ADD”. Create a name for the file in the “Submission Retrieval Name” field, and click “Next”.
- Confirm Year, collect and categories, then click “Submit”.
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.)
- 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.
Option 2: TSDS EDM BATCH FILE – XML Format
- TSDS edm/batch file – pulls the interchange files out of TSDS
edm instructions:
- Log into TSDS and go to the Batch Manager- EDM
- Locate your “Batch”
- Select the “Spyglass” ( on the right)
- Under “actions”, you should be able to see all your interchange files for the batch
- This should send you to the ETL
- Scroll to the top and locate the “Validation Info” tab
- Click on Validation Information tab
- 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!
