Basic Information
Using the links on this page, you can do the following:
- Import absences for a specific date <-- this will be done automatically, but can be accessed manually for error correction
- Display the dates for which absence records were reported and have been imported
- Display the names of schools who did not report absences (DNRs) for a specific date or date range, with the option to view/download that information as a plain text CSV file.
History
2009.11.05Updated the 'Display DNRs' page so that when schools are listed and have more than 1 absence for a given date range, the school name becomes a link which allows the user to see the list of dates for which the school did not report absences.
2009.11.05Secured all pages except 'Home' using LDAP and authenticated sessions. 'Home' is visible to anyone on the network for informative puposes. All other pages are only accessible via an authorized Active Directory login. 2009.10.26Created a php script, derived from 'Import Absences,' which imports the absences for today. This is called by a batch file which was created as a scheduled task to run daily at 10:30. The log file, script, and batch file are available at C:\_sched.
2009.10.26Updated look and function of Navbar to show current location and have nicer mouseovers.
2009.10.07Corrected 'Import Absences' page bug which was preventing non-'today' date imports from working properly.
2009.10.07Removed '0000-00-00' dates from db to clean up after said bug.
2009.09.16Updated 'Display Dates' page to link to DNR report for each date listed.
2009.09.14Added links at top of page to reduce the need to scroll to the bottom of the page to navigate.
2009.09.08Updated 'Import Absences' page so that when 'use today' is clicked, the default is a today dated file or a non dated file. Further, duplicates can occur but are thrown out by the DB upon insert.
2009.09.08Updated 'Import Absences' page to allow a more refined 'override' switch to include file name and date.
2009.08.24Updated 'Import Absences' page to correct a bug with the jQuery date picker.
2009.08.03Updated 'Import Absences' page so that today isn't assumed, but is a clickable link.
2009.08.03Added a input box on the 'Import Absences' page with jQuery date picker.
2009.07.27Ability to add view/download DNR information as a CSV file added.
2009.07.24Bug with data consistency corrected. Data is verified using two different methods during each DNR pull.
Planned Updates
- Add a link from any DNR Report to list the specific dates which a given school did not report absences by 10:00am.
- Modify Import Absences and DB (and any other related pages) to only use Date, Student ID, and School Name (or, better yet, School Number -- but start with name).
- Add 'Totals' column for 'Display Dates' page.
- Move to server [must support PHP and MySQL] and verify working daily status.
- [ ? ] Add 'Totals' to 'Display DNRs' page and CSV output.