TSDS – PEIMS

  • Use Chrome as your browser when loading files.
  • Format = XML (preferred) or CSV.
  • Files can be loaded either zipped or unzipped.
  •  If zipped, ensure interchanges are directly in the zipped file and not in a parent folder within the zipped file.
  • If unzipped, multi select all the xml files to be loaded. The order does not matter.
  • NOTE: Use 7-zip files (.zip), not .7z
  • NOTE: When using a different SIS than Business:
    • Opt 1- put all unzipped files in a folder and upload them all at once. OnDataSuite will merge the data together.
    • Opt 2 – merge together using SIS or Bus Software then extract into TSDS interchange files (zipped or unzipped).
  • For ESC’s ONLY:
    • Put all of 1 district’s files (xml or cvs) in a zipped file.
  • Then, zip all of the district in your regions zipped files up together in one Regional folder to load.

NOTE: (For instructions for retrieving PEIMS files from TSDS-scroll to the bottom)

Uploading TSDS PEIMS files into OnDataSuite

Once files have been either extracted from the SIS ( BIS) or retrieved from TSDS, use the following steps to upload into OnDataSuite.

  1. Log into OnDataSuite, go to “File Center”/ “Data Sources”
  2. Select the blue “TSDS PEIMS” tab.
  3. Use the green “Click to upload TSDS- PEIMS file” button to browse to zipped or unzipped xml or csv files. (order does not matter) 

Note: Multiple files of the same interchange, for example, Interchange Staff Association Extension-one from business side and one from student side, can be loaded at the same time.  The load will merge the records.

Once files have been sent to OnDataSuite:

Review the following columns.

Note: Year and Submission will automatically populate if using the TSDS naming structure

  • “Year”
  • “Submission” – Fall, Mid Year, Summer, Extended
  • “Preliminary” – Flags the file to remind users that changes are to be expected.
    • If unchecked, file will be labeled as “Final”.
    • Files can be relabeled after loaded.
    • Prelim and/or Final files can be overwritten with subsequent data loads. ( wipe/replace)
  • “Rep Period: – Available only for Summer files to indicate how many six weeks of data are included in the file.
  • “Process”- drop down
    • Load data and run edits – data will be updated in the database and applied to all reports and the edits.
    • Run edits only – data will only be applied to edits portion of the system (no updates to the database).
    • Load data only – data will be updated in the database and applied to all reports except for the edits (depending on size of file, could save significant time).
      • These processes can be run without files replacing each other.
      • They all will be stored in the history area below. 
      • ‘Run edits only’ files will have a Status of “Edits only file” and an indicator on the far-right hand side labeled “Edits”.
      • ‘Load data only’ will have a Status of “Load data only file” and an indicator labeled “Data”.
  • Delete – a specific file before processing.        

4. Start Upload – Green Tab

5. When data load is complete scroll down to view all the files loaded.

6. Click on the file or on the InfoEdits, or Data link, far right side.

  • View individual interchanges and ensure files loaded.
  • Missing interchanges (not marked with a green “ok”) will affect reports needing data elements from these areas.
  • Options to  change the “status” of the file. (bottom right) The file status may be changed from final to preliminary or from preliminary to final.
  • Note speedy processing time… 🙂

Note: While a file is loading, you may start another file upload and/or continue to work throughout the rest of the system.

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)

TSDS Retrieval Instructions: Log into TSDS

Option 1: TSDS EDM BATCH FILE  (XML Format)

  • 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”
  • 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!
  • Option 2- Retrieve data from PDM   (CSV Format)
    • Log in and go to PEIMS/View Reports
  • 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.
Updated on 10/11/2021

Was this article helpful?

Related Articles