CatapultEMS PowerSchool Plugin Setup Instructions

Content

Download & Install Plugin

  1. Download Catapult Plugin v2.2 (leave in zip format).
  2. Log into PowerSchool - Admin (District Office).

  3. In the left pane, under “Setup,” select System (New UI: System Management).

  4. Under the “Server” heading, select System Settings (New UI: Server).

  5. Select Plugin Management Configuration (New UI: Plugin Configuration).

  6. Select Install (upper right).

  7. Select Choose File and browse to the downloaded plugin location.

  8. Select Install.

  9. Once the plugin installs, it shows up in the list of plugins. Select the enable checkbox.

  10. In the pop up window, select Enable.

  1. Confirm you are in the District Office.

  2. From the left pane, select Importing & Exporting (New UI: Data and Reporting).

  3. Select Data Export Manager (New UI: Exports > Data Export Manager).


Staff to Student Export

  1. Select Importing & Exporting > Data Export Manager (New UI: Data and Reporting > Exports > Data Export Manager). See Navigate to the Data Export Manager above for screenshots.
  2. Change Category to Additional Data Sets.
  3. Select Catapult Staff To Student Upload.
  4. Select CC checkbox (which selects all the items below cc)
  5. For each label, delete the underscore and everything before it. (The a, b, c letters are only used to force sorting)
    • Change  CC.a_school  to  school
    • Change  CC.b_teacher  to  teacher
    • Change  CC.c_student  to  student
    • Change  CC.d_period  to  period
    • Change  CC.e_name  to  name
    • Change  CC.f_course_number  to  coursenumber
    • Change  CC.g_sectionnumber  to  sectionnumber

  1. Select Next.

  2. Apply filters (if desired).

  3. Select Next.

  4. Export File Name: StaffToStudentExport.csv  *** Match file name exactly. No underscores. File extension must match. ***
  5. Line Delimiter: CR/LF
  6. Field Delimiter: Comma
  7. Character Set: UTF-8
  8. Select Include Column Headers.

  9. Select Save Template:

  10. Enter Name and Description (if desired).

  11. Select Save as New (or Save if the template has already been saved before).

Staff Export

  1. Select Importing & Exporting > Data Export Manager (New UI: Data and Reporting > Exports > Data Export Manager). See Navigate to the Data Export Manager above for screenshots.
  2. Change Category to Additional Data Sets.
  3. Select Catapult Staff Upload.
  4. Select Users checkbox (which selects all the items below users).
  5. For each label, delete the underscore and everything before it. (The a, b, c letters are only used to force sorting)
    • Change  USERS.a_id  to  id
    • Change  USERS.b_school  to  school
    • Change  USERS.c_namefirst  to  namefirst
    • Change  USERS.d_namelast  to  namelast
    • Change  USERS.e_email  to  email
    • Change  USERS.f_mobilenumber  to  mobilenumber
    • Change  USERS.g_title  to  title

  1. Select Next.

  2. Apply filters if desired.

  3. Select Next.

  4. Export File Name: StaffExport.csv  *** Match file name exactly. ***
  5. Line Delimiter: CR/LF
  6. Field Delimiter: Comma
  7. Character Set: UTF-8
  8. Select Include Column Headers

  9. Select Save Template.

  10. Fill in Name and Description (if desired).
  11. Select Save as New (or Save if the template has already been saved before).


Student Export

  1. Select Importing & Exporting > Data Export Manager (New UI: Data and Reporting > Exports > Data Export Manager). See Navigate to the Data Export Manager above for screenshots.
  2. Change Category to Additional Data Sets.
  3. Select Catapult Student Upload.
  4. Select Students checkbox (which selects all the items below users). 
    • Note: CatapultCONNECT customers need all the columns. CatapultEMS customers only need the first 12 columns (through “contactemailsecondary”)
  5. For each label, delete the underscore and everything before it. (The a, b, c letters are only used to force sorting)
    • Change  Students.a_id  to  id
    • Change  Students.b_school  to  school
    • Change  Students.c_namefirst  to  namefirst
    • Change  Students.d_namelast  to  namelast
    • Change  Students.e_mobilenumber  to  mobilenumber
    • Change  Students.f_email to email 

(We use a custom email field which you may need to alter in the plugin)

  1. Scroll down to show additional data
    • Change Students.g_contactnameprimary  to  contactnameprimary
    • Change Students.h_contactphoneprimary  to  contactphoneprimary
    • Change Students.i_contactemailprimary  to  contactemailprimary
    • Change Students.j_contactnamesecondary  to  contactnamesecondary
    • Change Students.k_contactphonesecondary  to  contactphonesecondary
    • Change Students.l_contactemailsecondary  to  contactemailsecondary
    • Change Students.m_zipcode  to  zipcode
    • Change Students.n_busroute to  busroute

  1. Scroll down to show additional data
    • Change Students.o_grade to  grade
    • Change Students.p_lunchbalance to  lunchbalance
    • Change Students.q_primarylanguage  to  primarylanguage
    • Change Students.r_primaryZip  to  primaryZip
    • Change Students.s_primaryprefferedcontactmethod  to  primaryprefferedcontactmethod
    • Change Students.t_secondarylanguage  to  contactemailsecondary
    • Change Students.v_secondarypreferredcontactmethod  to  secondarypreferredcontactmethod
    • Change Students.u_secondaryZip to  secondaryZip

  1. Select Next.
  2. Apply filters if desired.

  3. Select Next.

  4. Export File Name: StudentExport.csv    *** Match file name exactly. ***
  5. Line Delimiter: CR/LF
  6. Field Delimiter: Comma
  7. Character Set: UTF-8
  8. Select Include Column Headers

  9. Select Save Template.

  10. Enter Name and Description (if desired).

  11. Select Save as New (or Save if the template has already been saved before).


School Export

  1. Select Importing & Exporting > Data Export Manager (New UI: Data and Reporting > Exports > Data Export Manager). See Navigate to the Data Export Manager above for screenshots.
  2. Change Category to Additional Data Sets.
  3. Select Catapult School Upload
  4. Select the Schools checkbox (which selects all the items below users)
  5. For each label, delete the underscore and everything before it. (The a, b, c letters are only used to force sorting)
    • Change  Schools.a_schoolCode  to  schoolCode
    • Change  Schools.b_schoolSiteNamel  to  schoolSiteName
    • Change  Schools.c_address  to  address
    • Change  Schools.d_phoneNumber  to  phoneNumber
    • Change  Schools.e_mergeWithSchoolCode  to  mergeWithSchoolCode

(Each district/school is different, so you will need to manually change mergeWithSchoolCode)

    • Change  Schools.f_pluginVersion  to  pluginVersion

  1. Select Next

  2. Apply filters if desired.

  3. Select Next.

  4. Export File Name: SchoolExport.csv
  5. Line Delimiter: CR/LF
  6. Field Delimiter: Comma
  7. Select Include Column Headers.

  8. Select Save Template.

  9. Enter Name and Description (if desired).
  10. Select Save as New (or Save if the template has already been saved before).


Attendance Export

(Only needed for CatapultCONNECT customers.)

  1. Select Importing & Exporting > Data Export Manager (New UI: Data and Reporting > Exports > Data Export Manager). See Navigate to the Data Export Manager above for screenshots.
  2. Change Category to Additional Data Sets.
  3. Select Catapult Attendance Upload
  4. Select the Students checkbox (which selects all the items below users)
  5. Change Labels for Export:   students.a_ (etc) only used to force sorting
    • Change  Students.a_school  to  school
    • Change  Students.b_student  to  student
    • Change  Students.c_period  to  period
    • Change  Students.d_absenceCode  to  absenceCode
    • Change  Students.e_teacherName  to  teacherName
    • Change  Students.f_date  to  date

  1. Select Next.

  2. Apply filters if desired.

  3. Select Next.

  4. Export File Name: AttendanceExport.csv    *** Match file name exactly. ***
  5. Line Delimiter: CR/LF
  6. Field Delimiter: Comma
  7. Select Include Column Headers.

  8. Select Save Template.

  9. Enter Name and Description (if desired).

  10. Select Save as New (or Save if the template has already been saved before).


SFTP Setup

  1. In the left pane, under “Setup,” select System (New UI: System Management).

  2. Under the “Server” heading, select System Settings (New UI: Server).

  3. Select Plugin Management Configuration (New UI: Plugin Configuration).

  4. Select the Remote Connection Manager plugin.

  5. Select Remote Connection Manager link below general info

  6. Select Create Connection.

Edit Remote Connection Screen

  1. Enter Name and Description (if desired)
  2. Protocol:  SFTP
  3. Host: sftp.catapultems.com
  4. Port: 22
  5. Authentication Type: Password
  6. Enter username (provided by Catapult)
  7. Enter password in both fields (provided by Catapult)
  8. Choose Test Connection
  9. FingerPrint: The first time you connect, it says "Connection failed" because "The server host key does not match with any known hosts in the system." Select Yes, Accept Host Key.
  10. Remote Path:   /
  11. Check Allow upload
  12. Select Submit

Scheduled System Templates

  1. Select Importing & Exporting > Data Export Manager (New UI: Data and Reporting > Exports > Data Export Manager). See Navigate to the Data Export Manager above for screenshots.
  2. On DEM, select the My Templates tab
  3. Select the calendar icon to the right of each of your newly saved templates

If you don’t see the calendar then you need to upgrade your permissions: System ► Roles Administration ► User Access Roles ► (desired role) ► Export/Edit (tab) ► User can set up and run scheduled system templates).

  1. On the Schedule pop tab
    • Check Schedule Active
    • Days to Execute:  select desired days (I only do Mon-Fri)
    • When to Execute: Enter desired time (Catapult recommends after school but before 11:00 pm PST. Rather than setting the same time for all exports, PowerSchool recommends 10-minute intervals between each scheduled export.)
    • Send Output To:   SFTP name entered in the sftp step above
    • Path:   [leave blank]
    • Email Completion:  enter email if desired.

  1. Setup a schedule for each of the following Catapult templates. 
    • Staff
    • Staff To Students
    • Students
    • Schools
  2. For CONNECT customers, setup schedule for Attendance Export.