One Stop Attendance V 3.1

Submitted by jtreadwell on Wed, 02/25/2009 - 3:45pm

Oracle Version: Attendance screen that allows for the search and edit of attendance records all from one screen. Users can search for attendance by code, all codes, daily, meeting, all present codes, all absent codes, etc.

V 2.0 (01/14/2008)
– Initial Public Release

V 2.1 (01/16/2008)
– Updated attendancetoday.html to take account for blank present codes. Previously would not return any data if the present code was a blank (as powerschool recommends). Now will display present records correctly.

V 2.2 (03/07/2008)
– Added the navigation bar wildcard so that users could easily just pop in the link without having to recode the wildcard themselves.

V 3.0 (09/03/2008)
– Converted the page for Oracle.
– Added ability to choose any date in the current term.

V 3.1 (02/25/2009)
– Fixed issue when selecting all codes. If all codes is selected with a date then information from that date is shown. If all codes is selected with all term then only the current date will show (had this fixed 9/4/2008, sorry for holding it so long)Fixed issue with alert showing the student as in a class and between classes at the same time.

V 3.2 (10/5/2009)
- Updated wildcard to contain PS 6.0 content.
- Included ability to add Meeting Attendance Comments.

0
Your rating: None

Comments

Page not found error

by kschutt - 06/21/2010 - 4:30pm

That was it!  Thank you soooo much Matt!  Don't know what I'd do without you guys!

Page not found error

by kschutt - 06/21/2010 - 2:42pm

I added the Admin folder to the custom/web_root/admin folder and the Wildcard folder to the custom/web_root/wildcard folder on the server.  Went to system settings and re-synced the customizations and I still get:  "The page you requested could not be found on this server."

Any help here will GREATLY appreciated.  I am so challenged with this stuff.  I LOVE all your customization, when I can get them figured out!?!

Thank you very much for any help.

RE: Page not found error

by MattFreund - 06/21/2010 - 3:46pm

When you say you added the folder did you copy the folder itself or just files within it?  For example, within the Wildcards custom folder on your server do you have a folder now called Wildcards?  If so, you'll want to remove it and make sure the wildcard file is in the main wildcards folder instead.  The same would be true for the Admin folder.  Instead of a folder within it called admin, just copy the files from the download to the custom admin/attendance folder.  Reset the wildcard again when done.

Matt

Add to reports bundle?

by pontl - 01/29/2010 - 2:28pm

How about adding this customization to the reports bundle? I do it myself, adding it in as the first choice under the Attendance category instead of having it on the main page side bar. My HS attendance clerk loves this customization.

Leigh Pont

Different mother field

by jewell - 01/13/2010 - 1:59pm

I love this report. The only thing wrong is we use a custom field for mother and father. I replaced the mother field name with our custom field but the report no longer pulls any kids. What did i do wrong. THANKS

Meeting vs Daily Attendance

by bdmorgan - 10/13/2009 - 8:10pm

I just found out from our attendance secretary that she is entering comments using the Daily Attendance part of Attendance Today instead of in Meeting Attendance. Will this cause any problems? As a private school, we don't have to submit any attendance reports to the state or calculate ADA, etc.

Thanks,

Dan Morgan
La Salle High School
Union Gap, WA
Premier 6.0
Grades 9-12 with 200 Students
PowerPC Quad G5 2.5 Ghz with 12 GB RAM

re: Meeting vs Daily Attendance

by jtreadwell - 10/13/2009 - 8:59pm

Dan,

This should be fine. Comments are really just for you and 1 stop reads attendance the only natural way that users can enter them (other than mass updating meeting attendance). If it's not in the current version then there will be a update eventually that includes Brian Andle's customization to allow for meeting comments.

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

"All Days In This Term" only bring's today's records

by sbaloch - 09/23/2009 - 11:21am

Hello all, I am using PS 5.2.1. When I select "All Codes" and "All Days In This Term", I only get today's attendance. When I select specific codes, I do get all days for that code. Is this normal? Thank you in advance for any assistance.

Suhail Baloch

re: "All Days In This Term" only bring's today's records

by jtreadwell - 10/13/2009 - 9:01pm

This is by design and I believe I mention this in the readme.pdf that is included. All codes all days will bring up so much information that it could be a drag on your system. Especially when you consider the last day of school for a user who has the full year as the current term. That would be a ton of attendance. I set this safety in place to protect system administrators from their users trying to pull too much information and bringing the database to a screeching halt during a normal in session day.

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

Home Page Help

by aerofarm2448 - 09/21/2009 - 1:15pm

I used an older version of One Stop and my new links (PT ADMIN) (REPORTWORKS) on the start page did not show up. I uploaded the 3.1 files and Attendance today looks great, but I still don't have the links. If I turn off customization they are there, but we have too many custom areas to do that. How can I get those new version 6 links to show up?

Nate

One Stop Attendance V 3.1 PDF

by Debbie - 09/19/2009 - 4:48pm

Can you someone post a PDF of the One Stop Attendance Report results so that I can see what the results are and if it will work for us?

One Stop Attendance V 3.1 on PSv6?

by cchamuri - 07/12/2009 - 7:53am

Any test results with One Stop Attendance V 3.1 on PSv6? Thanks.

re: One Stop Attendance V 3.1 on PSv6?

by bdmorgan - 09/23/2009 - 2:10pm

I just installed One Stop Attendance 3.1 today. Do you have an updated left Admin Navigation wildcard for the new links in PowerSchool 6.0?

UPDATE: It was late last night and I didn't even think to make a copy of the original Admin Left Navigation Menu and modify that for the customization. Everything is working fine now and the Attendance Secretary and Dean of Students are ecstatic with One Stop Attendance!

Thanks,

Dan Morgan
La Salle High School
Union Gap, WA
Premier 6.0
Grades 9-12 with 200 Students
PowerPC Quad G5 2.5 Ghz

Re: One Stop Attendance V 3.1 on PSv6?

by brian_andle - 08/31/2009 - 11:45am

Yes, it works with PS 6. Been using it for about a week now with 6.0.

Brian Andle

Revision

by mpetrella - 06/03/2009 - 4:02pm

I installed the files and everything works well. I wonder how I can eliminate the comment from the Attendance Today report?

deployment of this customization slows down Absentee report

by jhill@richfield... - 05/20/2009 - 8:56am

We deployed the One Stop Attendance v 3.1. Since this deployment the Absentee report has slowed down considerably. Prior to the latest customization the Absentee report would complete in 5-10 seconds now it may take as long as 2 minutes to complete. Thoughts?

re: deployment of this customization slows down Absentee report

by jtreadwell - 05/20/2009 - 2:40pm

This customization doesn't touch the absentee report at all. In fact the only thing it does is use the same pages and functions that already exist in PowerSchool, but launches them from a more convenient location. Doing a search on the page in no way affects the other report as it is only viewing existing data.

If you are experiencing slow downs and suspect the customization you can simply remove all links to it and see if it speeds up when no one is using it. I can assure you that no customization I make edits any canned report like the absentee report so simply not using the customization would show you whether or not the change is coming from the customization.

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

Add Custom Field to Output

by pgriffin - 04/21/2009 - 7:53am

We have a custom field for "sending school". How can I add this field to the output instead of the comments section?

Wrong Student

by sbenson - 04/15/2009 - 12:24pm

When our Daily attendance schools use this, choose a code or and "All" code they will get the list of students. However when they click on the code of a particular student the Edit Attendance window that comes up will not be for that student. It will be for whomever the last student I went to to look at whatever. i.e. click on the A for Jim Jones and Sue Smith shows up in the edit attendance window. Click on Sam Clark and Sue Smith will show up. Sue will continue to show until I go to another student, then that student will always show.

We have had this issue now for quite a while, before Oracle too.

re: Wrong Student

by jtreadwell - 04/15/2009 - 1:57pm

Most likely you are not getting the wrong student, you are getting the wrong student's name at the top. This is due to how the wildcard works. PowerSchool for some reason doesn't use ~([01]LastFirst) for student name but rather ~(studentname) or something like that. I forget the specifics but it's to fix the name on 1 or 2 pages. However I have found that it causes more problems than it fixes. So I have gone into my wildcard and changed it to use ~([01]LastFirst) and then just removed that wildcard from the pages where it needed the other version and hard coded the other information. I bet changing your wildcard to not use those other codes (I think ~(studentgrade) is another) would fix your labeling. However the page should submit to the right student even if you don't do that.

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

re: Wrong Student

by cchamuri - 07/22/2009 - 7:17pm

I can confirm Jason's solution.

I fixed the problem by:
1. Copy the wildcard file "title_student_end.txt" from \PowerSchoolPremier\system\server\resources\web_root\wildcards to PowerSchoolPremier\data\custom\web_root\wildcards
2. Change ~(studentname) to ~([01]LastFirst)
3. Save
4. Reset the server.

Windows Server 2003

Fix for All Codes Pulling todays attendance...

by Phil - 01/14/2009 - 1:39pm

The fix was to replace the to_date(to_char(sysdate,'MM/DD/YYYY')) code in attendancetoday.html to be to_date('~[gpv:alldays]','MM/DD/YYYY')... That appears to be the variable that holds the date the user selected… Works like a charm in my sandbox… I have run several reports of varying options with no problem… I just wanted to post to make sure Jason could double check it to make sure there are no "unintended consequences" of making this change...

CASE WHEN ac.Att_Code = null THEN 'paaf' ELSE ac.Att_Code END LIKE CASE WHEN '~[gpv:att_code]' = 'zzzz' THEN '%' WHEN '~[gpv:att_code]' = 'zzaz' THEN '%' WHEN '~[gpv:att_code]' = 'zzpz' THEN '%' ELSE '~[gpv:att_code]' END
AND att.Att_Date >= CASE WHEN '~[gpv:att_code]' = 'zzzz' THEN to_date('~[gpv:alldays]','MM/DD/YYYY') WHEN '~[gpv:alldays]'='01/01/1900' THEN ter.firstday ELSE to_date('~[gpv:alldays]') END
AND att.Att_Date <= CASE WHEN '~[gpv:att_code]' = 'zzzz' THEN to_date('~[gpv:alldays]','MM/DD/YYYY') WHEN '~[gpv:alldays]'='01/01/1900' THEN ter.lastday ELSE to_date('~[gpv:alldays]') END
AND att.PeriodID >= CASE WHEN to_char('~[gpv:pid]') is null THEN -1 ELSE to_number('~[gpv:pid]') END
AND att.PeriodID <= CASE WHEN (to_char('~[gpv:pid]') is null) OR (to_char('~[gpv:pid]') = -1) THEN (SELECT MAX(Period.ID) FROM Period WHERE SchoolID = ~(curschoolid) AND Year_ID = ~(curyearid)) ELSE to_number('~[gpv:pid]') END
AND ac.presence_status_cd LIKE CASE WHEN '~[gpv:att_code]' = 'zzaz' THEN 'Absent' WHEN '~[gpv:att_code]' = 'zzpz' THEN 'Present' ELSE '%' END

RE: Fix for All Codes Pulling todays attendance...

by jtreadwell - 02/25/2009 - 3:46pm

I had actually made a fix for that back on 9/4/08 but never got around to posting it. Sorry about that. It's up now in version 3.1

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

RE: Fix for All Codes Pulling todays attendance...

by rogerdodger - 02/25/2009 - 2:54am

I think the one option with this fix that won't work is the combination of "All Codes" with "All Days in this term"... with this fix in place that combination will net you zero results because it will pull in 01/01/1900 as a begin and end date and you won't have any attendance records for that day. So as long as you understand that and won't need that combination (which might overload your server anyway pulling all attendance codes for the whole term)...

To be user friendly I added this just before the hr tag.... to display a message if the All Codes and All Days combination is chosen.. so they know why nothing displays. The following is a nested decode... it should all be one line but is probably wrapping a bit on your display.

~(decode;~[gpv:att_code];zzzz;~(decode;~[gpv:alldays];01/01/1900;All Codes with All Days is too much information to display
; ); )

Roger Sprik

All Codes - One Stop Attendance V 3.0

by SlocumA - 12/18/2008 - 10:10am

When selecting "all codes" for a previous date, today's attendance is displayed. All other options seem to be working. Does anyone have any thoughts about a solution? thank you

Alan P. Slocum
Network Specialist
Chenango Forks CSD

One Stop Attendance V 3.0

by rastech - 12/05/2008 - 2:58pm

Problem Noted - One Stop Attendance Report.

Selecting All Present Codes or All Absent Codes and a previous attendance date displays the correct attendance data for the date selected.

However, when selecting All Absent Codes and a previous attendance date, the report displays attendance data for the current school date, not the selected date.

The option "All Absent Codes" appears to be defaulting to the current date instead of using the date selected for the report.

Hide Daily Always

by Ankenman - 10/13/2008 - 6:23pm

We are 100% meeting attendance.

What would be the correct coding link to default it to have hide daily checked?

This doesn't seem to work.

a href="/admin/attendance/attendancetoday.html?att_code=U&pid=-1&alldays=~[eaodate]&m=0&d=1">Attendance Today

Nevermind....d="z"

Sandy

Adding or Editing Comments

by smays - 09/10/2008 - 3:05pm

Nice customization! PowerSchool really needs to include this in the core product! Am I the only one that finds entering attendance comments very cumbersome? Would that be an easy customization to include in One Stop Attendance? A place to enter/edit comments as the attendance is recorded would be great. The only place I see now to enter comments is the Change Meeting Attendance which takes several clicks to get to and does not show you any attendance or comments that have been recorded. Is the comments anything you've considered including in this customization?

Adding or Editing Comments

by vcalzada - 08/05/2009 - 4:19pm

Is the enhancement for front offices to be able to enter/edit comments as the attendance is recorded now included in 1 Stop Attendance?

I am wondering this myself.

by jfreydhs - 08/31/2009 - 11:15am

I am wondering this myself. My attendance secretaries need to be able to enter attendance comments and there currently is no way to do so from the admin side that I am aware. Does anyone know if this customization allows for that functionality? Or if there is any other customization that would? Nothing that I have found seems clear.

Re: I am wondering this myself.

by brian_andle - 08/31/2009 - 11:45am

I know Jason has been busy working on other projects, so I went ahead and added a extra download to the page that lets you add comments to attendance records from One Stop.

Brian Andle

Syndicate content Syndicate content