South Carolina

South Carolina FitnessGram® Project

South Carolina Import Guidance

The Import process imports school, student, class, and teacher information, along with their relationships. It does not remove or delete users from your school/district — it inserts new users or updates existing information.

South Carolina District Admins watch a video tutorial and review instructions below to get started.

 

SIS Extract Data Import

Import data into FitnessGram® from your PowerSchool FitnessGram® extract, which is a comma-delimited (.csv) file. It is preformatted with all the data fields necessary for the import. Follow the steps below for instructions.

Step 1: Check District and School Information in PowerSchool
Note: Your PowerSchool extract file includes the field of “Student Is Active” which is managed by the data updated in PowerSchool.  The information for active or inactive students comes directly from PowerSchool.  Please make sure data is updated in PowerSchool before downloading the FitnessGram® extract. This includes the state student unique ID number, the PE teacher’s unique SC certification number, and teacher email addresses.

Step 2: Create an Import File
South Carolina District Administrators must run the latest SQL query provided by the state project coordinator at SC DHEC or SCDE to create a file to import into FitnessGram®. The SQL query extracts the needed information and is preformatted with all the data fields and headers necessary to create the import file for FitnessGram®.

Updated South Carolina FitnessGram Extract

Please note that the FitnessGram CSV Import Template has been updated. Various fields have been removed to cut down on the information in the file, and other fields have been renamed. No action is required on SC District Admins as the SC SQL query has been updated to match these changes.

Note of updated fields:

Removed

  • Student Address 1
  • Student Address 2
  • Student City
  • Student State
  • Student Zip
  • Teacher Address 1
  • Teacher Address 2
  • Teacher City
  • Teacher State
  • Teacher Zip

Name Change

  • Student Address 3 – updated to Student SSO ID (useful only if a district wants to set up single sign on)
  • Teacher Address 3 – updated to Teacher SSO ID (useful only if a district wants to set up single sign on)

Note: The SSO ID (formerly Student/Teacher Address 3) is useful for districts wanting to set up Single Sign On. This field allows them to import an ID that is used during the Single Sign On set up process.

For more information on the query contact Lynn Hammond at hammonld@dhec.sc.gov or Meredith Prince at mprince@ed.sc.gov.

PowerSchool Instructions:

Choose your district’s PowerSchool version and follow the corresponding instructions:

For Districts running Power Schools on their own servers (not hosted by Pearson-PowerSchool)
  • Create a FG folder onto the appropriate drive on your PowerSchool server and publish FGExport Passwords – FG and FG.sql to the folder.
  • Rename FGExport.txt to FGExport.bat.
  • Rename Passwords – FG.txt to Passwords – FG.bat.
  • Rename sql script to FG.sql.
  • Update/edit the Passwords – FG.bat file with the districts’ current PowerSchool username and password credentials.
  • Run FGExport batch file.
  • Save and maintain the file as a .csv file.
  • Utilize the Task Scheduler to automate executing the FGExport.bat script on your server.
For Districts Hosted by Pearson Power Schools
  • Districts that are hosted by Pearson (PowerSchool) please copy the SQL statement only (between the Spool commands) to execute using SQLDeveloper or utility of your preference.
  • Please ensure the Header checkbox is checked or unchecked to exclude header rows depending on your version of SQL Developer Export Wizard.
  • Download the FitnessGram® import file for the current school year.
  • Save and maintain the file as a .csv file.

Export Wizard

 

Step 3: Import your File
Now you are ready to import your file.  Click here to find Step 4: Import File for step-by-step instructions.  (South Carolina districts skip Step 3: Create Mapping.) Make sure to select No for the Update usernames and passwords setting.

Note: When importing data using FTP, FitnessGram leverages the SFTP protocol with 256 bit AES encryption. Data is encrypted in transit and at rest throughout the import process.

PowerSchool FTP Tips

Who to Contact
Please review the import instructions first to see if your question is answered before contacting the SC DHEC or the FitnessGram® Help Desk.

FitnessGram® South Carolina DHEC
For questions about the PowerSchool SQL query or South Carolina FitnessGram project, contact Lynn Hammond (hammonld@dhec.sc.gov)or Meredith Prince (MPrince@ed.sc.gov).

FitnessGram® Help Desk
Questions on the import process or technical support should be directed to the FitnessGram® Help Desk.

Back to Top