PSCB - Customization PowerTeacher (Class Attendance)

View PSCB Plugin Directory

Version 1.2

Description

This plugin adds a student track column to the PowerTeacher and Sub class attendance pages.

This page fragment can easily be modified to display different or additional field values.

Example 1
To add the team field.

$j(function(){
var track = [~[tlist_sql;
SELECT cc.id, s.track, s.team
FROM cc
INNER JOIN students s ON (cc.studentid = s.id)
WHERE sectionid = ~(gpv.sectionid;sqlText)]
{"id":"ccid_~(id)","track":"~(track;t) / ~(team;t)"},
[/tlist_sql]];
$j("table#attendance-table colgroup:first col:first").after('');
$j("table#attendance-table tr:first th:first").after('Track / Team');
for(i=0;i' + track[i].track + '');
}
})

Example 2
To Decode the Track values.

$j(function(){
var track = [~[tlist_sql;
SELECT cc.id, decode(s.Track,'A','Navy','B','Gold','C','All Virtual','') Track
FROM cc
INNER JOIN students s ON (cc.studentid = s.id)
WHERE sectionid = ~(gpv.sectionid;sqlText)]
{"id":"ccid_~(id)","track":"~(Track)"},
[/tlist_sql]];
$j("table#attendance-table colgroup:first col:first").after('');
$j("table#attendance-table tr:first th:first").after('Track / Cohort');
for(i=0;i' + track[i].track + '');
}
})

PSCB Development Team
Rob Staats
Manjit Basra
Michael Moore

Version Info

1.0 (2020-09-13)
- Initial Release

1.1 (2020-09-24)
- Added student track to the sub class attendance page.

1.2 (2020-10-06)
- Corrected Fill Code issue. Changed Track display format.

Powerschool Compatible Versions

19.x, 20.x

Additional Plugin Requirement

The following PSCB plugins should be installed prior to the installation of this reports bundle.

PSCB - Base Resources

Installation

Install in System > System Settings > Plugin Management Configuration

Do not unzip the plugin. Install the entire zip file. Be sure to enable the plugin once it's installed.

If you are updating, you can now click on the Plugin name and then use the Update button, and then browse to the new file and click Submit and it will then load the update and then ask you to enable it.

Instructions

Login to PowerTeacher start page.
Click on the chair icon for a selected class.

PS Verions

12.x: 
N
19.4: 
Y
Plugin: 
Y
CPM Import Friendly: 
Y
Report Type: 
Web Based Report
19.11: 
Y
20.4: 
Y

Comments

So if I wanted to add a decode to this statement how could I update the header?

~(decode;~([students]Track);A;Navy;B;Gold;C;All Virtual)

$j(function(){
var track = [~[tlist_sql;
SELECT cc.id, s.track
FROM cc
INNER JOIN students s ON (cc.studentid = s.id)
WHERE sectionid = ~(gpv.sectionid;sqlText)]
{"id":"ccid_~(id)","track":"~(track;t)"},
[/tlist_sql]];
$j("table#attendance-table colgroup:first col:first").after('');
$j("table#attendance-table tr:first th:first").after('Track / Cohort');
for(i=0;i' + track[i].track + '');
}
})

Dana Bridgeforth

Replace the current script with the following.

$j(function(){
var track = [~[tlist_sql;
SELECT cc.id, decode(s.Track,'A','Navy','B','Gold','C','All Virtual','') Track
FROM cc
INNER JOIN students s ON (cc.studentid = s.id)
WHERE sectionid = ~(gpv.sectionid;sqlText)]
{"id":"ccid_~(id)","track":"~(Track)"},
[/tlist_sql]];
$j("table#attendance-table colgroup:first col:first").after('');
$j("table#attendance-table tr:first th:first").after('Track / Cohort');
for(i=0;i' + track[i].track + '');
}
})

--
Rob Staats
PSCB Development

classattendance.PSCB_Track.content.footer.txt

See above questions..sorry for that mistake

Dana Bridgeforth

This page fragment does not support "Decode" statements.

--
Rob Staats
PSCB Development

This is beautiful!!
Is there any way that this could be added to the sub portal as well?

Thank you for your request. We are not doing sub portal customizations at this time. I will add this request to the PSCB Enhancement list.

--
Rob Staats
PSCB Development

So how are subs supposed to know what track the student is on?

Julie Payne
Falmouth Public Schools

Version 1.1 now adds the Student track Sub Class Attendance page.

--
Rob Staats
PSCB Development

Hi,
I plugged this in and Im not seeing the group by option, any troubleshooting suggestions? Thanks!

Alison Blazey
ablazey@ehtp.org
Data and Systems Manager
KIPP NYC College Prep

The Group Option is not a PSCB Customization.

The Group Option is a new feature in included in PS version 20.4.3.

If you have this version installed, you will see a Group By Cohort/Track option at the top of the Class Attendance page.

--
Rob Staats
PSCB Development

Subscribe to Comments for "PSCB - Customization PowerTeacher (Class Attendance)"