PowerQueries

From California PowerSchool User Group
Jump to: navigation, search

PowerQueries Presentations

Examples

Valley Christian PowerQueries

These PowerQueries are in use at Valley Christian, they may not work "as is" for your school, and are provided as real-life examples.

  • jss_classes_1_a.zip - JAMF Classes
  • ASM_1_0.zip - Apple School Manager (Example of 6 queries in one plugin)
  • hmh_1_0.zip - HMH ThinkCentral (PowerQuery portion, see Auto-send portion below)
  • VCS_Scripts.zip - Batch files and scripts used by Valley Christian to process and upload DEM exports to external systems.
HMH ThinkCentral Additional Info
The Auto-Send portion of our HMH Think Central Integration for student records - this is the field list. We used Auto-Send for part of it because student passwords are not exportable through PowerQuery.
~(f.add;~(curyearid);1990)
~(decode;1;1;S;)
student_number
blank
first_name
middle_name
last_name
^(decode;^(grade_level);-1;PK;0;K;^(grade_level))
student_web_id
student_web_password
~(decode;1;1;MDR;)
~(decode;1;1;01429045;)
blank
~(decode;1;1;TC;)
Screenshot of the first part of the Auto-send setup

HMH AutoSend Screenshot.jpg