Search Tips
Account Management Apps Attendance Call Alerts Classroom Data Imports Data Security Directory Services Google Classroom Integration Grade Export Gradebook Groups Implementation
Lockers LoopMail Mobile School Loop Partner Gradebooks Portals Publishing Registration Sections School Settings Student Record Student Tracker Unification Webmaster Websites
Frequently Asked Questions Document Library Design Services Gallery of Sample Sites Help & Support
Course Outlines On-Site Training Website Training
Account Management Grade Submission Gradebook LoopMail Trackers Miscellaneous

Gripper for PowerSchool

For PowerSchool, School Loop has a custom Java program that will reads the grade import file from School Loop and modifies it to be compatible with PowerSchool's import utility. Contact School Loop to get the latest version of Gripper for PowerSchool.

Using Gripper for PowerSchool

1. Install Gripper

Download Gripper using the link provided by School Loop. Unzip and save the Gripper program to a local directory on a computer that has access rights to the directory containing the database for your SIS.


2. Launch Gripper

Locate and double click the batch file: gripper.bat.


3. Choose the Grade Import File


Click the Import File tab, then the Choose button to select the import file previously created. (See the Grade Export Setup page)





4. Enter Database Information


Click the Database tab, then enter values for Host, as well as the User and Password credentials for a database user with read access rights. Then Click Connect.







5. Enter PowerSchool Information


Click the Powerschool tab, then click Choose to set the name and location for the PowerSchool Import File that will be generated. Enter the Store Code for your grading period, then click Create PowerSchool Import File.


Terms and Percentages multiplies the EarnedCrHours by the percentage specified  for the term of the section (default is 100%).


6. Import Grades into PowerSchool

Locate the PowerSchool compatible data file generated by Gripper and use this file to imports grades using PowerSchool grade import utility.

Connecting to Hosted Version of PowerSchool

To connect Gripper to your hosted PowerSchool database:

1. Setup A VPN Connection

Pearson provides this connection


2. Obtain the following information about your database

IP address, Port number, and SID for your PowerSchool database.


3. Edit Gripper.bat in the Gripper folder

Replace the default port number (1521) if necessary and replace PSPRODDB with the database SID in the java line:  java -DjdbcCon=jdbc:oracle:thin:%%s/%%s@%%s:1521:PSPRODDB