Versions Compared

Old Version 46

changes.mady.by.user Jonathan Burke

Saved on

compared with

New Version Current

changes.mady.by.user Jonathan Burke

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Welcome to TestHound Data Integration!

Follow this guide to send data from your SIS to TestHound

Table of Contents
minLevel1
maxLevel2
outlinefalse
typelist
printablefalse

Introduction

TestHound is a premiere education administration software. Your district and school-level testing coordinators will use TestHound to assign, manage, and report standardize tests/scores for your students.

Data Sets:

TestHound will require at least four of the below data from your SIS. See Part 4on details on your state’s data requirements.

...

  1. Demographics Data: Contains additional data for TX state reporting; required for TX districts.

  2. Accommodations Data: Contains data for student testing accommodations. In most cases, this data will be sent directly to TestHound from your Accommodations Vendor.

Adding Users:

Please email the completed User List to your DI Engineer, who will add the bulk of your users to TestHound. Additional users will be added/removed by your district’s TestHound admin.

SFTP & Send Schedules

Data sets (except the user list) will be sent to TestHound using SFTP. Please schedule all files to send nightly (including weekends) before 1am CST.

...

Please send the User List directly to your DI Engineer via email. For security reasons, please do not send any other data sets via email.

Data Transfer & Responsibilities

TestHound 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 TestHound.

...

6 - EAI Product -EAI will display your district data in TestHound.

Timeline & Checklist

Ideally, your TestHound data Integration will take two weeks to complete. The actual timeframe will depend on your regional center and other 3rd parties who may need to send data to TestHound.

Day 1: Tech KO:

A meeting with your TestHound 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 TestHound.

Please configure all files to be sent nightly (including weekends) before 1am CST.

Week 2: Data Validation:

Your TestHound 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 TestHound is validated, you will continue to maintain data within your SI; you may be contacted by your staff if data abnormalities are discovered in TestHound.

Please reach out to your DI Engineer if you need assistance troubleshooting any of these data abnormalities.

Anchor
part4
part4
Data Requirements

See below for TestHound’s data requirements. Note that Florida and Texas districts will need to send additional data sets.

All States

The following data sets are required by all districts using TestHound:

...

Expand
titleUsers

Instructions: Download and fill out the Users Template in the Downloads section below. Then email the completed Users List to your TestHound DI Engineer.

Contents: Account information for district and school testing coordinators who will be using TestHound

File Naming Convention: NA

Best Practices:

  • Leave CampusIDs blank (NULL) for district staff.

  • Email is the primary key for TestHound users; each staff person on the file must have a unique email.

  • Only include staff person’s primary school. Contact your DTC about staff that coordinate tests for multiple schools.

Roll Types:

Data Requirements:

Example Data:

...

Florida - Additional Data

Students’ accommodation data is also required for Florida districts. This data set will be sent with the other files via SFTP.

...

Expand
titleClick to Open

Contents: data for student testing accommodations.

Ideally, all accommodations data should be sent on a single file. Please email your TestHound DI Engineer if you need to send multiple accommodation files.

File Naming Convention: d_th_ia_ST_ST-District-ID_auto1.csv
Example Filename = d_th_ia_in_123456_auto1.csv

Best Practices:

  • Use the exact filenames provided by your TestHound DI Engineer.

  • Do not send Social Security Numbersfor any of the requested data.

  • Export your state-assigned district id as the "District ID" on this file.

  • Export your local school ids as the "CanpusID" on this file.

  • Headers are required and all elements must be in the order above.

  • Whitelist all recommended TestHound IPs.

Data Requirements:

Example Output:

...

Texas - Additional Data

Students' demographics data is also required by Texas districts. This data set will be sent with the other files via SFTP.

...

Expand
titleClick to Open

Contents: additional student demographics data for TX state reporting.

File Naming Convention: d_th_demographics_ST_ST-District-ID.csv
Example Filename = d_th_demographics_tx_123456.csv

Best Practices:

  • Use the exact filenames provided by your TestHound DI Engineer.

  • Do not send Social Security Numbersfor any of the requested data.

  • Export your state-assigned district id as the "District ID" on this file.

  • Export your local school ids as the "CanpusID" on this file.

  • Headers are required and all elements must be in the order above.

  • Whitelist all recommended TestHound IPs.

Data Requirements:

Example Output:

image-20240112-150952.png

Instructions for Exporting SIS Data:

Ascender

Instructions:

Contact your Regional Center and provide them with the following information so they can open a ticket and begin sending the Students, Schedules, Teachers, and Demographics data sets to TestHound.

...

Please complete the User List and email it to your DI Engineer; users are the one data set not provided by your Regional Center.

...

eSchool & eSchoolPLUS

Locate your state, download the SQL scripts, and follow the instructions below.

...

  1. Download and import the above templates to Cognos.

  2. Run and review the CSV exports; edit the templates, as needed.

  3. Schedule and send each CSV using the SFTP details provided by your DI Engineer.

...

PowerSchool

Locate your state, download the plugin file, and follow the instructions below.

...

Expand
titleEnabling the Plugin

Install the unzipped plugin file at your District Office. Then enable the TestHound plugin file.

  1. Log into PowerSchool and select the District Office (location ‘000’ for most districts)

  2. Go to Setup → System. Then scroll down and select System Settings.

  3. Select Plugin Management Configuration.

  4. Click the Install button and search for the unzipped TestHound plugin file.

  5. Find the Education Advanced - TestHound* plugin on your list and click the Enable/Disable box.

  6. Finally, click Enable to confirm. The Enable/Disable box will turn blue when the plugin is enabled.

*Note - your plugin name may differ from the one shown in the screenshot.

...

Expand
titleConfiguring Schedules CSV Export

Configuring Schedules Export

  1. Go to System → System Administrator → Page and Data Management.

  2. Scroll down to Data Export and select Export Data.

  3. Select the Show All category and select the following NQ Queryquery:

Image Removed

    1. NQ - com.educationAdvanced.testHound.schedules

  1. Select the PowerSchool attributes in the order shown below. Then remove the Table Names in the Labels Used on Export:

  1. Test the export by clicking Show Data. Then click Next.

  2. Enter the following details and click Save Template:

    1. Export File Name = use the Teachers filename provided by your DI Engineer

    2. Line Delimitator = CR

    3. Field Delimitator = Comma

    4. Character Set = Windows ANSI

    5. Under Export Options, select Include Column Headers

Assigning/Scheduling SFTP

  1. Go to the My Templates Tab and find the TestHound Schedules template. Click on the calendar icon to begin scheduling the feed.

  2. Select the following settings and Save the export schedule.

  1. Finally, go back to the My Templates Tab and click the Play Button to send the first Schedules file TestHound.

Expand
titleConfiguring Students CSV Export

Configuring Students Export

  1. Go to System → System Administrator → Page and Data Management.

  2. Scroll down to Data Export and select Export Data.

  3. Select the Show All category and select the following NQ Queryquery:

Image Removed

    1. NQ - com.educationAdvanced.testHound.students

  1. Select the PowerSchool attributes in the order, as shown below. Then remove the Table Names in the Labels Used on Export:

  1. Test the export by clicking Show Data. Then click Next.

  2. Enter the following details and click Save Template:

    1. Export File Name = use the Teachers filename provided by your DI Engineer

    2. Line Delimitator = CR

    3. Field Delimitator = Comma

    4. Character Set = Windows ANSI

    5. Under Export Options, select Include Column Headers

Assigning/Scheduling SFTP

  1. Go to the My Templates Tab and find the TestHound Schedules template. Click on the calendar icon to begin scheduling the feed.

  2. Select the following settings and Save the export schedule.

  1. Finally, go back to the My Templates Tab and click the Play Button to send the first Schedules file TestHound.

Expand
titleConfiguring Teachers CSV Export

Configuring Teachers Export

  1. Go to System → System Administrator → Page and Data Management.

  2. Scroll down to Data Export and select Export Data.

  3. Select the Show All category and select the following NQ Queryquery:

Image Removed

    1. NQ - com.educationAdvanced.testHound.teachers

  1. Select the PowerSchool attributes in the order, as show below. Then remove the Table Names in the Labels Used on Export:

  1. Test the export by clicking Show Data. Then click Next.

  2. Enter the following details and click Save Template:

    1. Export File Name = use the Teachers filename provided by your DI Engineer

    2. Line Delimitator = CR

    3. Field Delimitator = Comma

    4. Character Set = Windows ANSI

    5. Under Export Options, select Include Column Headers

Assigning/Scheduling SFTP

  1. Go to the My Templates Tab and find the TestHound Teachers template. Click on the calendar icon to begin scheduling the feed.

  2. Select the following settings and Save the export schedule.

  1. Finally, go back to the My Templates Tab and click the Play Button to send the first Teachers file TestHound.

...

Expand
titleConfiguring Demographics CSV Export

Configuring Demographics Export

  1. Go to System → System Administrator → Page and Data Management.

  2. Scroll down to Data Export and select Export Data.

  3. Select the Show All category and select the following NQ Query:

  1. Select the PowerSchool attributes in the order, as show below. Then remove the Table Names in the Labels Used on Export:

  1. Test the export by clicking Show Data. Then click Next.

  2. Enter the following details and click Save Template:

    1. Export File Name = use the Teachers filename provided by your DI Engineer

    2. Line Delimitator = CR

    3. Field Delimitator = Comma

    4. Character Set = Windows ANSI

    5. Under Export Options, select Include Column Headers

Assigning/Scheduling SFTP

  1. Go to the My Templates Tab and find the TestHound Teachers template. Click on the calendar icon to begin scheduling the feed.

  2. Select the following settings and Save the export schedule.

  1. Finally, go back to the My Templates Tab and click the Play Button to send the first Teachers file TestHound.

...

Skyward Q

Follow the instructions below to add the built-in TestHound exports within Skyward Q:

...

Follow the above instructions to also add the Test Hound Demographics report to Skyward Q.

...

Skyward SMS

Download the Skyward SMS exports for your state and follow the instructions below.

...