Custom Alert in PowerTeacher

Forums:

I created a custom alert and updated title_student_end_css.txt The alert now displays in the PowerSchool admin portal but does not display in Powerteacher. Which wildcard file controls the alerts that display in PowerTeacher?

Thanks,
Mike

There is no title_student_end equivalent wildcard on the Teacher side. Each backpack page needs to be updated individually.

Any way to add the custom alerts to the classattendance.html page in PowerTeacher? (Oh please say yes, please say yes! ;-)

It's been a few years since this question was posted, but I added instructions on how this can be done on 6/13/2015 [updated 9/17/2015] (scroll down to the bottom of this conversation thread).

The single day attendance page (classattendance.html) has a column showing alerts for each student. I'd like to customize this page to include our custom alerts but the new coding has me confused. ([alert])

Can this be done -- and if so, do you have directions for how to do this. My teachers mainly look at this page so if I could get all the alerts to show up on this one page, everyone would be happy.

I thought I once saw instructions on how to create a teacher wildcard so teachers could see custom alerts (without having to add the custom alert to each page on the Backpack dropdown). There also used to be a customization called "alertlist.html" that listed all alerts on the teacher page. It was complicated and I couldn't make the hover work correctly, but our teachers need to see the alerts. I can't seem to find the instructions for the teacher wildcard or for the alertlist.html. Thank you very much.

We too would like to be able to add our custom alerts to the main teacher page. We have added them to the individual pages, but have not been successful in adding them to the main teacher page where the PowerSchool supplied alerts appear. Has anyone found instructions on how to do this, or maybe it can't be done(?).

We would like to customize our alerts as well on the Single Daily Attendance page. P

We were able to add teacher alerts.

Under Teachers/Alerts add the alertfilename.html file (ex. IEPalert.html) and then we created another file named _studentpages_include.html under teachers, this is a one point reference html which allows us to add all teacher customization alerts in this page.

Then in teacher under studentpages we added a line of code to insertfile /teachers/_studentpages_include.html in each html file.

When the teachers log in, no matter what drop down they choose, all alerts are listed on each page.

This sounds interesting, but could you provide more detail as to the coding for each of the lines or pages you added? for instance, would you share the _studentpages_include.html and the line of code added to studentpages?

Linda Porter Kabaniec
lake_shore@yahoo.com

In our version of teacher alerts, I took over the alert_other so it would show in the class attendance page. At the bottom of the page, I added another roster area that I could control more easily with a column for creating a new academic alert or referral. The teacher can create the alert from there. At the very bottom of the page is an icon that generates a complete list of alerts. I had to modify some wildcards are the alert other page as well. And I had to hide this from other schools who are not using this. Here is the bottom half of the page:
~[if.~([01]schoolid)=158]
~[if.~[displayprefyearschool:att_recordmodedaily]=1]

Daily Attendance for this class.
If all students are present, none will be displayed below.

Student Name
Grade Level
Daily Attendance
Daily Attendance Code

~[tlist_sql;
SELECT s.lastfirst as student, s.grade_level as grade, attc.description as daily, attc.ATT_Code as code, att.Att_Comment
FROM Attendance att
INNER JOIN Students s
on s.ID = att.StudentID
INNER JOIN Attendance_Code attc
on att.Attendance_CodeID = attc.ID
INNER JOIN CC cc
on cc.StudentID = s.ID
WHERE att.Att_Mode_Code = 'ATT_ModeDaily' AND cc.SectionID = ~[gpv:sectionid] AND att.Att_Date = '~[gpv:att_date]' AND attc.ATT_Code IS NOT NULL
ORDER BY s.lastfirst;alternatecolor]

~(student)
~(grade)
~(code)
~(daily)

Comment: ~(Att_Comment)

[/tlist_sql]

YTD Daily Attendance Totals and Create Academic Alerts

Student Name
Tardies
Absences
Create/Edit Referrals

~[tlist_sql;
SELECT s.LastFirst, cc.CurrentTardies, cc.CurrentAbsences, s.ID, s.alert_other
FROM Students s
INNER JOIN CC cc
ON s.ID = CC.StudentID
WHERE cc.SectionID = ~[gpv:sectionid]
ORDER BY s.lastfirst;alternatecolor]

~(s.LastFirst)
~(cc.CurrentTardies)
~(cc.CurrentAbsences)

  ~(alert_other)

[/tlist_sql]

[/if]
--------------

Could you explain to me what you mean by "At the very bottom of the page is an icon that generates a complete list of alerts." Do you have custom alerts? And if so, does the list also display those?

Would you please share your "_studentpages_include.html" page with me?

Would you share your instructions on how you got teacher alerts to work? I cannot seem to get an alert to work in the gradebook. Thanks

This sounds interesting, but could you provide more detail as to the coding for each of the lines or pages you added? for instance, would you share the _studentpages_include.html and the line of code added to studentpages?

Has anyone come up with adding custom alerts to teacher pages?

Has anyone come up with adding custom alerts to teacher pages? If so could you please share code, instructions, etc.

I have spent hours trying to figure out how to get our Custom Alerts to show on Teacher pages. Would anyone please share instructions, coding, etc. if they have successfully done this?
Thanks a million.
Bev Lauby

Not sure what the ramifications are for most folks but I just customized all of my teachers/studentpages files by adding in the "title_student..." wildcards from the admin side to the top of the <body> tag like so:

    <body>
    ~[wc:teachers_header_fr_css]
    ...
    ~[wc:title_student_begin_css]
    ~[text]psx.html.teachers_studentpages.attendance.meeting_attendance1[/text]
    ...
    ~[wc:title_student_end_css]
    ...
    <!-- Start of shaded content table -->
    ~[SetPostValue:skipDontPrintFilter=1]

Since the display of all of my custom alerts are contained in my customized title_student_begin_css.txt, they show up on every teacher page exactly as I planned.

Hope this helps someone!

Randy Rowe
Sr. Applications Analyst
Topeka Public Schools
rrowe@tps501.org

Can someone instruct me specifically on how to get our custom alerts to display in the same way the PS built in alerts display on the attendance page in PowerTeacher??

Our teachers really want an alert icon, or even an asterisk to know that an alert is on that student, next to the student name in the gradebook. That applies mostly to an IEP alert that we have created. Has anybody done that?

Gradebook, is unfortunately not customizable. Hopefully in future releases Gradebook will not a Java application.

Has anyone found a way to have the alert show up on teacher pages, and then be able to click the alert to read the alert??? I've used some of the info from above to get the alert to show on a page, but when you click on it, the alert message doesn't show up, just an error.
I would love to get some help on this!!! Any help would be greatly appreciated!!!
Thanks!

Shelley Wedel
Manager, Student Information
Campbell Union School District

Perfect timing on your question. I came to PDS site this morning looking exactly for that. I have on the Admin side an icon that displays for special ed students to indicate they have a tracking teacher and clicking on the icon opens the window that shows the name of the tracking teacher.

On the PowerTeacher side I have the same icon show, but clicking on the icon only yields a window that says NOT FOUND: The requested file could not be found on this server.

Hovering above the icon shows me that it points to a link alerttrackingtchr.html and that page exists in the teachers>alerts directory of the custom pages. That page has the same code copied from the page of the same name in the admin>alerts directory.

I would really like to get this working for the teachers.

Tim Schramm
Database Manager
City of Albany School District
Albany, NY
tschramm@albany.k12.ny.us

Tim Schramm
Database Administrator
City of Albany School District

Has anyone figured out how to do this yet? Like others, I am also confused by the new coding for the alert of [alert] instead of how we added alerts to wildcards in the past. I have a custom alert I would really like to have appear in the table on the classattendance.html page along with all of the built in alerts.

Any help would be appreciated!

Michelle

Any updates to this yet? I need my sped alert to show up on teachers side as well....

Joanie,

I have been able to make the custom alerts appear on the Quick Lookup and Schedule pages in PowerTeacher, but cannot get it on the Attendance screen. This means that teachers would have to visit each individual student's page in order to see the alert. If you would like the alert to appear on the Quick Lookup screen (or another teacher screen) you have to edit the page itself because there is no wildcard for these pages.

Joanie,

I have been able to make the custom alerts appear on the Quick Lookup and Schedule pages in PowerTeacher, but cannot get it on the Attendance screen. This means that teachers would have to visit each individual student's page in order to see the alert. If you would like the alert to appear on the Quick Lookup screen (or another teacher screen) you have to edit the page itself because there is no wildcard for these pages.

Has anyone had any luck with adding a custom alert to the attendance page...in the column with the other alerts? This would be the ideal spot, instead of adding to each PowerTeacher Student page. Anyone????

Shelley Wedel
Manager, Student Information
Campbell Union School District

I got this working using a tlist_sql query and the [ccid] variable with a case statement on the /teachers/classattendance.html page for the single entry tab. Just add the tlist_sql after the [alerts] tag which is around line 245 on the original page.

I wrote up a post on it that also adds the custom alert icon to the Admin side using a wildcard page fragment, an area to toggle the alert on the Other Information page using a custom insertion point and another page fragment and on the PowerTeacher Class Attendance page using the tlist_sql case statement.

Let me know if you have any questions. I have tested this on 8.1.1 and 7.11.1

There is no "easy" way to do this, but I was able to create a plugin that adds a Special Ed alert to each student page in the Teacher Portal.

At the same time I was able to "tap" into the Attendance page and include it there. Here's what I did for that piece.

For the Attendance Page, I used tlist_sql to create a "hidden" table that I used like an array, making the Student Name the id of the first cell (the key) on each row and filling that cell with the actual alert (setting "frn=001~(DCID)"), and the flag indicating if the alert should be displayed as the second cell in each row.

I then used jQuery to traverse every row in the visible table (id="attendance-table") and matched the Student Name (column 0) in the visible table with the one in my hidden table having that student name as its id. If the second cell containing the flag indicates the alert should be displayed, I appended my alert to the contents of the visible alerts, otherwise I ignored that alert. Finally, I removed the hidden table when complete.

I put all this into a page insertion file in the /teachers folder:
classattendance.SpEd_Alert.content.footer.txt

<table id="tbl_sped_alerts" style="display:none">
<tr><th>Alerts</th><th>SpEd?</th></tr>
~[tlist_sql;
select s.lastfirst, s.DCID, ps_customfields.getcf('STUDENTS',s.id,'MI_SRSD_PrgmElig_SpEd') sped
from PERIOD p
inner join SECTION_MEETING sm on sm.SchoolID = p.SchoolID and sm.year_id = p.year_id and sm.period_number = p.period_number
inner join SECTIONS se on se.id = sm.SectionID
inner join CC on CC.SectionID = se.id
inner join STUDENTS s on s.ID = CC.StudentID
where p.ID = ~[gpv:Period_ID]and sm.sectionid = ~[gpv:sectionId]
order by s.lastfirst;
]
<tr>
<td id="~(lastfirst;t)"> <a class="dialogM" title="SpEd Alert" dialogcontent="" href="/~[directory]/alerts/SPEDalert.html?frn=001~(DCID,t)"><img src="/images/SPED_trans.png" height="16" width="20" alt="SpEd Info" border="0"></a></td>
<td id="sped">~(sped;i)</td>
</tr>
[/tlist_sql]
</table>
<script>
$j('#attendance-table > tbody > tr').each(function() {
// Make sure we're past the header row.
if($j(this).index() > 0) {
// Find the row in the hidden table containing the matching Student's info
var row = $j('#tbl_sped_alerts').find('td[id="'+$j(this).find('td').eq(0).text()+'"]').closest('tr');
// If SpEd then append the contents of the link cell into the viewable table's Alert cell
if( row.find('#sped').text() == '1') {
$j(this).find('td').eq(1).append( row.find('td').eq(0).contents() );
}
}
});
$j('#tbl_sped_alerts').remove();
</script>

I know this thread is a bit older, but this answer helped me finally solve an issue I was asked to solve and had somewhat given up on. Here's a modified version of the above answer that allows for multiple alerts and is somewhat streamlined. We have three alerts we wanted to show, a 504 alert, a High Ability alert, and a boundary waiver alert.

Edit: Removed a commented out line I didn't mean to leave in there.

var students = [~[tlist_sql;
select cc.id,
s.lastfirst,
s.DCID,
ps_customfields.getcf('STUDENTS',s.id,'UT_504') fiveofour,
ps_customfields.getcf('STUDENTS',s.id,'alert_halassessed') hal,
ps_customfields.getcf('STUDENTS',s.id,'Boundary_Waiver') boundary
from PERIOD p
inner join SECTION_MEETING sm on sm.SchoolID = p.SchoolID and sm.year_id = p.year_id and sm.period_number = p.period_number
inner join SECTIONS se on se.id = sm.SectionID
inner join CC on CC.SectionID = se.id
inner join STUDENTS s on s.ID = CC.StudentID
where p.ID = ~[gpv:Period_ID]and sm.sectionid = ~[gpv:sectionId]
order by s.lastfirst;
]{
"ccid": "~(ccid)",
"last_first": "~(lastfirst)",
"dcid": "~(dcid)",
"fiveofour": "~(fiveofour)",
"hal": "~(hal)",
"boundary": "~(boundary)"
},[/tlist_sql]{}
];
students.pop();

for(s=0;s';
}
if(student.hal!==''){
alerts+='';
}
if(student.boundary=="1"){
alerts+='';
}
if(alerts!==''){
$j($j('#ccid_'+student.ccid).find('td')[1]).append(alerts);
}
}

I know this is a few year old , but I am looking at this and trying to find where the code is to pull the image file for the 3 alerts you have.

Margaret Hopkins

I created and added a custom alert for our remote learners. I also have it added to one page in the teacher portal. I was trying to get it to show up on the single day attendance page for teachers, but could not get it to work. That is one issue. The second issue, is that now I have done something to where the student page headings are no longer bold and the student picture does not show up anymore. Any advise? What page controls the heading font/size for all the student pages?

Nevermind, I was able to fix it.

Good Day,
I just hopped to search for exactly what you did.
I need to add a custom alert to the PowerTeacher attendance page to flag for our remote learners.
Can you share your coding?
It would be greatly appreciated!

Hello,
I am also hoping to find a way to add the student's Cohort to the teachers attendance page in Powerteacher.
Can you share your coding?
Thank you

Here is what I did to get the alert to show up on the teacher class attendance page:
1. Under the teachers folder, create a file like the one below. Input your alert name where I have my sped alert information.

classattendance.Alert_SPED_KL01.content.footer.txt

2. Then go thru the below script and input your alert information where you see mine. Once you have it updated, then copy and paste into the file you created above.

~[if#singlemeet.~[gpv:pagetype]=meeting]

$j(function(){
var alertRows = {
~[tlist_sql;
select cc.id, s.dcid
from students s
inner join cc on cc.studentid=s.id and cc.sectionid = ~(gpv.sectionid;sqlText)
and to_date('~(gpv.att_date;sqlText)','~[datetext:mmddyyyy]') between cc.dateenrolled and cc.dateleft-1
and ps_customfields.getCf('students', s.id, 'alert_sped_kl01') is not null
]
"~(1)":"~(2)",[/tlist_sql]"":""};
$j.each(alertRows, function(ccid, studcid) {
$j('tr[id=ccid_' + ccid + '] td:eq(1)').append('');
});

$j('a.dialogAlert').live('click',psDialog);
});

[/if#singlemeet]

Edited code- finally got this to work:
1. File name is classattendance.DistanceLearning_Method.content.footer.txt; saved in the teachers folder in custom page management.
2. The field name of my alert is U_StudentsUserFields.DistanceLearning_Method
3. Note the LEFT OUTER JOIN to link the Students table to the U_StudentsUserFields table, in order to pull the DistanceLearning_Method field. If your field is in the Students table, you can erase the LEFT OUTER JOIN line below.
4. My image for the alert is in the custom page management - images folder. It is named ONL.png.

To customize:
1) replace U_StudentsUserFields.DistanceLearning_Method with the field name of your alert.
2) replace /images/ONL.png with the name of your image file for your alert. Make sure the image resides in custom page management, in the images folder.
3) Save the file as classattendance._________.content.footer.txt in the teachers folder in custom page management. Insert the name of your alert from 1) above.

======================================================

~[if#singlemeet.~[gpv:pagetype]=meeting]

<script>

$j(function(){
var alertRows = {
~[tlist_sql;
select cc.id, s.dcid
from students s
LEFT OUTER JOIN U_StudentsUserFields on s.dcid = U_StudentsUserFields.studentsdcid
inner join cc on cc.studentid=s.id and cc.sectionid = ~(gpv.sectionid;sqlText)
and to_date('~(gpv.att_date;sqlText)','~[datetext:mmddyyyy]') between cc.dateenrolled and cc.dateleft-1
and U_StudentsUserFields.DistanceLearning_Method is not null
]
"~(1)":"~(2)",[/tlist_sql]"":""};
$j.each(alertRows, function(ccid, studcid) {
$j('tr[id=ccid_' + ccid + '] td:eq(1)').append(" <img src='/images/ONL.png' />");
});

$j('a.dialogAlert').live('click',psDialog);
});

</script>

[/if#singlemeet]

Subscribe to Comments for "Custom Alert in PowerTeacher"