Alert List V 3.1.1

When I try the alertlist for teachers, I am getting no course, teacher, or sections on my alertlist screen. It also says 'There are no students enrolled in this class". Any idea what I am doing wrong?

Thank you
Aria Benjamin
Student Data Support Specialist
WWSU

Jason,

First, thanks for putting this update out. Some great stuff here and I know our teachers appreciate it.

I have two custom alerts I've set up for my districts, a Driver alert and a Special Education Alert. When I try to customize the alert list page for these it breaks the tlist.

I'm adding the following in the style at the beginning and in the extra.css file:
.driver {
position: relative;
background: url(/images/alert_driver.gif) no-repeat;
height: 24px;
width: 31px;
}

.SpEd {
position: relative;
background: url(/images/alert_sped.gif) no-repeat;
height: 24px;
width: 31px;
}

I'm adding the following columns to the header row (ignore the single quotes, I had to put them there so the text would show up in the comment):
<'td class="bold">Driver<'/td>
<'td class="bold">SpEd<'/td>

I'm addding the following items to the select statement (I don't care about the alert expiring, just if there is data in the alert field):
(CASE
WHEN to_char(s.Alert_Driver) IS NOT NULL THEN 'driver'
ELSE ''
END) DriverClass,
(CASE
WHEN to_char(s.Alert_Driver) IS NOT NULL THEN to_char(s.DCID)
ELSE ''
END) DriverAlert,
(CASE
WHEN to_char(s.Alert_SpEd) IS NOT NULL THEN 'sped'
ELSE ''
END) SpEdClass,
(CASE WHEN to_char(s.Alert_SpEd) IS NOT NULL THEN to_char(s.DCID)
ELSE ''
END) SpEdAlert

I'm adding the following to the output:
<'td align="center"><'div class="~(DriverClass;t)" id="dri~(DriverAlert;t)"><'/div><'/td>
<'td align="center"><'div class="~(SpEdClass;t)" id="spe~(SpEdAlert;t)"><'/div><'/td>

The field names are alert_driver and alert_sped and I have data in them for at least one student in the class. When I check the alert customizations I've put in my student headers on the admin and teachers side they show up.

I'm either missing something, just don't know what I'm doing, or messing with something that just can't be messed with.

If you have time to make a suggestion, I appreciate it. If not, I'm still happy to be able to display the original 4 alerts.

Chad Cole
Database Application Specialist
PowerSchool Support
Jackson County Intermediate School District
6700 Browns Lake Road
Jackson, MI 49201

It says in the instructions that "A copy of the /teachers/home.html page has been included as an example." I can not find that example. I want to create a link for the teachers to be able see the page, and that would be helpful.

Thank you

I tried to update the file but cannot for PS v6.

I have everything working for this except I cannot get my alert images to appear on the student listing page. Could you please give me idea or direction as to how to correct this?

I'm not getting a complete list of alerts for each student.

Guess I should mention that we are on the latest PowerSchool version.

Kathy Davies
System Information Manager
Lamar County Schools, Ga.

Jacqueline J. M. Brzezinski

It picks up the other alert but it is splashing the AUP alert throughout grade 8.
In Grade 7 it splashes a punch of photo alerts.

None of those alerts is set nor do I have those alerts set.. May I have them in a custom folder but not set to the students.

It does pick up some real ones. It does not do this at the elementary level only randomly at the HS and MS. I will look more tomorrow. Got a call late day from MS. I should have looked closer before I sent it out. I saw the alerts, I thought it worked..and did not really troubleshoot.

Any ideas? Jacquie