Questions tagged [powerschool]

Pearson PowerSchool SIS

PowerSchool is a student information system (for scheduling classes, storing grades and attendance records, etc.) Local customizations can be added using a proprietary tag language.

The backend is an Oracle database.

36 questions
0
votes
1 answer

Why is my datasource not returning all my data in Angular grid application>?

Let me first preface this by saying...I'm a noob and have been pouring over documentation already but I have not found a resolution. I have built a custom report in PowerSchool SIS using AngularJS to form my grid and am using JSON data to fill it.…
b0nham
  • 1
  • 1
0
votes
2 answers

How do I divide by two count statements? Getting error

I am trying to get Total # of Presents divided by Total # of Days. The Count statements work separately, but when I try to divide the two counts, the report does not run. Any ideas? ((SELECT COUNT(*) FROM ATTENDANCE LEFT OUTER JOIN…
0
votes
2 answers

httpclient delivering different results

I am having issues interfacing with a PowerSchool system using Apache HttpClient 4.5.6. I have left out methods that aren't necessary for this question, but I am 100% sure that they work as intended. When using Postman or requests.py, using the…
dnsge
  • 3
  • 2
  • 4
0
votes
2 answers

Looking for whether a row exists in a subquery

Spoiler alert: I am fairly new to Oracle. I have four tables: enrollments, courses/sections, standards, and grades. We are running Honor Roll. I have queries on the first three tables that add various constraints needed to meet honor roll…
Melissa
  • 33
  • 6
0
votes
0 answers

Powerschool Swift 4 Xcode9 oauth issues

Powerschool is a site that keeps track of letter days to indicate lab days for my high school. It also keeps track of people's grades, but I just want to scrape the letter day. So I am trying to access info contained on html off the site…
0
votes
1 answer

Using decode with to_date

If anyone could help me with the following, I'd be grateful: I'm trying to write a code (create an alert in PowerSchool) that will indicate if a student is younger or older than average for their current grade level. (For example, as student born…
user8953573
0
votes
1 answer

JQuery field containing single quote breaks my code

I can't figure out how to escape this particular '. I have the following code: //Insert Home Room Teacher $j("tr:contains('Home Room')").after('Home Room Teacher
Dfoles
  • 1
  • 2
0
votes
0 answers

How to insert multiple records at the same time?

I have a problem with insert statement when I want to do insert on more than one record. My current code works fine if I have one record for insert but if I have more than one I'm getting this error: HTTP Status 500 - Unexpected exception occurred:…
espresso_coffee
  • 5,980
  • 11
  • 83
  • 193
0
votes
2 answers

Send Grades Using Google Classroom's API to Power Teacher Gradebook

With the new Google Classroom API is there a way to integrate directly with an SIS like Power Teacher, to send grades directly from Google Classroom to Power Teacher? I know we can download and upload into PT, but this is a bit much form some…
0
votes
3 answers

How do I implement this app despite its limitations?

Goal: Hall monitors at a large school can scan student ID and easily enter tardy information in PowerSchool. Limitations: -I get no access to PowerSchool due to legal limitations -Can't pass ID as a parameter into the URL because database ID…
rb612
  • 5,280
  • 3
  • 30
  • 68
0
votes
2 answers

Combining javascript and jquery to fill multiple hidden fields - bad idea?

I'm trying to find the best way to make my teachers' lives a little easier. I've got a select field and list of options generated by a tlist sql query. The select field itself already has a javascript attached to it, which fleshes out other field…
DataBased
  • 33
  • 1
  • 6
0
votes
0 answers

Hidden Parameters for drop down selections using tlist/SQL

To give you some perspective on the question on hand, I created a report for a student information system which pulls student logs, based on the selectable criteria from a set of drop downs, on an html page. The drop down lists are populated using…
0
votes
1 answer

SQL Drop down to include hidden parameters

the code listed below currently populates the drop down list like All Sports Sports - Baseball Sports - Bowling Sports - Basketball which is really Logtypid=3935 - subtypeid=x I am in need for the subtype id to pull 2 additional subtypes, that do…
4dmk
  • 1
  • 1
0
votes
1 answer

How do I get a UITableViewCell in a UITableViewCell?

I would like to replicate the design of the powerschool app as it seems there is a cell inside a cell. How do I do this?
0
votes
1 answer

Trouble with HMAC for password being sent to website

I am trying to make an app for my school that interacts with PowerSchool, a software that allows user's to view their grades, teachers, schedules, and much more. I found a library for the basics of interacting with PowerSchool written in PHP and…
SierraMike
  • 1,539
  • 1
  • 11
  • 18