Find Me Alert 2.1

Submitted by jtreadwell on Wed, 02/25/2009 - 2:57pm

There are many times when we need to find out where a student is at the current moment in time. Normally it’s a bit of a process where you need to search for the student, look at his/her schedule for the current date, figure out what period you are in, then figure out where that student is during that period. Well this alert makes it much easier. With this alert you can see exactly where the student is supposed to be at the current moment in time. If you are feeling ambitious you can give it to the teachers too, the teacher alert is included though you will need to update the student pages yourself.

Version History:
V 2.0 (02/24/2009)
– Initial Release

V 2.1 (02/25/2009)
– Fixed problem with minutes beginning with 0 being concatenated (10:05 was showing as 10:5)
– Fixed issue with alert showing the student as in a class and between classes at the same time.
– Improved efficiency

Average:

Your rating: None

Comments

Help Please

by patterson307 - 01/05/2010 - 5:02pm

I am trying to put the find me alert on our test server before it goes into the production side. I have put the images in our image server and the wildcards and the alert itself in the appropriate spots. When I checked the test server, I have a box with a red circle. When the alert is clicked, I get the non-select tlist_sql filtered out message.

I downloaded the AllowComplexTlist 1.0 and placed the misc-district list in the correct folder. ( I did not put in the .DS_Store )I updated customizations and I am still getting the red dot and the error message. We not hosted and are running 6.0.1.

Any thoughts?

re: Help Please

by jtreadwell - 01/06/2010 - 4:19pm

Did you just place the AllowComplexTlist page on your server or did you then go to that page and check the new checkbox on that page? If you didn't check that box then it still won't work.

Jason Treadwell
Custom Solutions Specialist
jason@powerdatasolutions.org
www.powerdatasolutions.org

Help Please

by patterson307 - 01/06/2010 - 5:26pm

I did place the AllowComplexTlist on the server and followed the steps from the PowerSource article on how to enable TLIST commands. This worked, we can see where the students are. However, it did not place a new checkbox on the Customization page.
We still can't get the icon to show next to the student's name. It is a box with a red dot surrounded by a box with the letter F on the right side.

re: Help Please

by jtreadwell - 01/07/2010 - 9:52am

Sounds like you've got mixed up image references. That F image is for a different customization. The image you are looking for should be a map with a pair of binoculars on top of it.I'm not sure why you would be pointing to the other image.

Jason Treadwell
Custom Solutions Specialist
jason@powerdatasolutions.org
www.powerdatasolutions.org

Help Please

by patterson307 - 01/07/2010 - 11:09am

I think we are totally mixed up! Now when I open PowerSchool in IE, next to the student's name is a red X. When you click on it, the alert comes up with the icon and all the information. In Firefox, it still has the red dot and the F.

When the alert is initally installed, do you have to change anything in the path contained in the wildcards or the html if the images are installed on the image server?

re: Help Please

by jtreadwell - 01/08/2010 - 1:51pm

Nope, PowerSchool handles the custom images vs. image server issue on it's own. The image is on your image server, not the custom/web_root/images folder - right? I actually put them in both places so if I need to update the image server I still have a copy of the custom images in a logical place.

Jason Treadwell
Custom Solutions Specialist
jason@powerdatasolutions.org
www.powerdatasolutions.org

RE: Help Please

by MattFreund - 01/06/2010 - 10:19am

Try restarting PowerSchool and if that doesn't fix it, then if you have access to the server, just run the fix via the PS menu as outlined on PowerSource.

Matt

HELP

by dmschemper - 09/02/2009 - 11:25pm

I am ASP hosted. What do I tell them to get this to work on Premiere 6.0 in the hosted environment.

Re: HELP

by brian_andle - 09/03/2009 - 3:57pm

I think you are talking about the tlist_sql filtered out message. There is a custom page on this site since you don't have access to the server. The page is called "Fix tlist_sql error from 5.2.0.9" which is really for 5.2.0.9+ including 6.

Brian Andle

re: HELP

by jtreadwell - 09/03/2009 - 12:08am

Are you set up to use the new custom page management? Also, are you hosted by Pearson or by someone else?

I've worked with non-Pearson hosted servers by getting FTP access to upload my own pages before. Pearson doesn't allow that and I heard a rumor that they are pushing people to go to 6.0 and use the custom page management features.

Jason Treadwell
Custom Solutions Specialist
jason@powerdatasolutions.org
www.powerdatasolutions.org

Didn't work for me

by brucem - 08/13/2009 - 3:53pm

I installed this per the PDF and nothing happened, no errors, nothing.

Re: Didn't work for me

by brian_andle - 08/13/2009 - 5:06pm

Has School started? The find me uses the calendar and the cc.dateenrolled and cc.dateleft.

Brian Andle

yes today was our first day

by brucem - 08/13/2009 - 6:14pm

yes today was our first day. I removed it and reinstalled it, of course the day is over so I can't see anything now. I do have an image server and moved the images to that folder.

Re: yes today was our first day

by brian_andle - 08/13/2009 - 6:55pm

I bet it's the sql security. Check out PowerSource Doc ID 55553 or Fix tlist_sql error from 5.2.0.9 from this site. It says 5.2.0.9 but its really 5.2.0.9 and above.

Brian Andle

I am running 6.0 is it safe

by brucem - 08/13/2009 - 11:24pm

I am running 6.0 is it safe to do the tlist_sql error fix on 6.0?

Re: I am running 6.0 is it safe

by brian_andle - 08/14/2009 - 8:02am

Yes, its a fix for 5.2.0.9 and above including the 6.0 branch.

Brian Andle

Installed and went to misc

by brucem - 08/14/2009 - 9:25am

Installed and went to misc settings and set the check mark and submit... Still no go on the mod...

What else might I look at?

I resynced the custom pages

by brucem - 08/14/2009 - 9:37am

I resynced the custom pages and now it is working this is SWEET!!!!!!!!

Time zone issues

by jkikpole - 06/13/2009 - 5:39pm

This would be a great tool, but it keeps acting as if its one hour earlier than it is.

My school is in the Eastern time zone. Our Pearson-hosted server is in the Central time zone. Pearson refuses to move our data server to Eastern or the add an hour or anything like that.

Is there a modification that we could make to the code to compensate for this? (I'm very comfortable modifying source code in SQL, PHP, HTML, Perl, Shell, etc.)

Re: Time Zone issue

by danberms - 06/15/2009 - 12:54pm

Maybe you can look at the ALTER SESSION SET TIME_ZONE = '-5:0';
It's shown under the the Current date section of http://www.psoug.org/reference/date_func.html

If works, it would probably be the easiest solution, you may have to change the value at the end.

The other thing I could think of is that you can do the math to accommodate, such as changing:
THEN bsi.Start_Time <= (to_char(sysdate,'HH24')*3600)+(to_char(sysdate,'MI')*60)

THEN bsi.Start_Time <= (to_char(sysdate,'HH24')*3600)+(to_char(sysdate,'MI')*60)+3600
Or
THEN bsi.Start_Time-3600 <= (to_char(sysdate,'HH24')*3600)+(to_char(sysdate,'MI')*60)

Basically, depending on the context of the line, subtracting/adding 1 hour or 3600 seconds. Though that would entail deciphering all of the SQL code, and making sure you modify it the proper way. I would suggest trying to modify the start_time/end_time since it's already in seconds and should be easier to calculate the changes instead of modifying the code for the sysdate which is in date/time format, and then converted into a number of different formats.

Good luck.

Dan

"Non-select tlist_sql filtered out"

by loristolcpart - 04/30/2009 - 2:47pm

We are running Premier 5.2.1.4 and when we click on the binoculars we get the message "Non-select tlist_sql filtered out".

PowerSource has responded with (since we are an ASP), "I have performed the steps specified in kbase article 55553. IF you notice at the bottom there is a disclaimer, so I do not know if this will help you.

"The use of tlist SQL in the URL is not permitted in Premier 5.2.0.9 or higher whether or not the [Prefs] record is set."

Will there be an update to address this? (hoping with fingers crossed!)

Re: "Non-select tlist_sql filtered out"

by brian_andle - 04/30/2009 - 4:21pm

There is a custom page on this site called "Fix Tlist_SQL" that you can have ASP upload and you can turn the pref on and off from the district office.

Brian Andle

Find Me Alert (Question)

by ilovecats - 04/27/2009 - 1:53pm

Thank you for making my life easier. We love this alert but we have a question. Can this alert be modified to show the Course Name for the period instead of the period number? (i.e. - Math instead of Period 4) We know what period it is when we pull up the alert we just want to know what subject is being disturbed.

re: Find Me Alert (Question)

by jtreadwell - 04/27/2009 - 3:49pm

That could probably be added in.

Jason Treadwell
Custom Solutions Specialist
jason@powerdatasolutions.org
www.powerdatasolutions.org

re: re: Find Me Alert (Question)

by ilovecats - 04/28/2009 - 7:54am

If you could give me some pointers on how to add this I would greatly appreciate it.

I am not able to see the

by evanderv - 04/17/2009 - 4:08pm

I am not able to see the alert icon at all. Rebuilt custom pages and still nothing.
Eric Vanderveer
IT Consultant
Chowen and Associates

I am not able to see the

by jhill@richfield... - 04/20/2009 - 6:51pm

Are you running an image server? Have you placed the alert image at this location or did you add it to webroot/images on your PowerSchool data server?

Help with wildcards

by hshick - 04/06/2009 - 10:38am

I already have existing wildcards/title_student_end.txt and title_student_end_popup.txt in my custom/webroot folder that I believe I installed last year to add an alert for an accommodation we have. How do I combine both the old and the new file?

Thanks

Harvey

re: Help with wildcards

by jtreadwell - 04/06/2009 - 7:41pm

If you find the stuff after the ~[studentalert] that will be the custom stuff. Grab that from 1 and add it to the other.

Jason Treadwell
Custom Solutions Specialist
jason@powerdatasolutions.org
www.powerdatasolutions.org

PwrTeacher FindMe alert

by brubd@fc.dvfs.org - 03/18/2009 - 2:04pm

I installed the FindMe alert on PT, QuickLookup page using wild cards, but am getting the same Quick Lookup page when I click on the icon instead of the desired information. It works for PS Admin users.

daveb

wild card

by brubd@fc.dvfs.org - 03/17/2009 - 6:39pm

The wild card code was not working.
Then I ran the Wild card initializing script. That did it!

daveb

Poll

What feature would your school need the most if Parking Management system was added to PowerSchool?

The basics only. Track parking stickers and vehicle information for students and staff.

63%

Assign and track allowable parking locations for each sticker.

18%

Historical tracking of parking stickers.

Ability to record and track parking violations.

10%

Other.(Please comment)

Total votes: 60

Login or register to post comments
Older polls

Recent Customizations

How Do I Install the Oracle ODBC Driver?

07/31/2010 - 12:51pm
Enhanced Parent Portal V 2.04

07/26/2010 - 11:31am
Historical Grades Tabs V 1.0.1

07/20/2010 - 5:40pm
Parent Portal Student Directory

07/19/2010 - 10:19am
sqlReports for 6.x

07/14/2010 - 11:13am
All Enrollment Tabs V 1.1

07/14/2010 - 10:59am
Calendar Copy - Oracle V 1.2

07/08/2010 - 9:38am
Refresh Report Queue v 2.3.3

06/25/2010 - 11:11am
Universal Transcript v1.0.5

06/15/2010 - 1:05pm
Web Gradebook Assignment Upgrade V 2_7 - Obsolete

05/28/2010 - 11:55am

Random FAQs

All FAQs

Recent FAQs

All FAQs

Calendar

August

S	M	T	W	T	F	S
1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21
22	23	24	25	26	27	28
29	30	31

Primary links

Recent blog posts

New forum topics

PowerDataSolutions newsletter

Find Me Alert 2.1

Comments

Poll

Popular content

Today's:

All time:

Last viewed:

Recent comments

Recent Customizations

Random FAQs

Recent FAQs

Calendar