| Task | Progress | Notes |
|---|---|---|
| Duplicate checking between programs | Finished | Check for duplicate registrations between programs (optional). |
| Rename programs | Finished | Rename program IDs as number & customize labels/pages via config variables. |
| Increase number of programs | Finished | Increase the maximum number of programs per library from 3 to 6. |
| Move config to DB | Finished | Move configuration variables to database. |
| Increase field size | Finished | Increase the size of various fields (grade, age, level, etc). |
| Increase DB size | Finished | Increase the maximum number of records each table can hold, in particular the participant & completed levels. Currently sufficient for most sites, a bit larger won't hurt. |
| Add level count to CSV | Finished | Add completed levels count to readers CSV output. |
| Add record ID to CSV | Skipped | Add record ID to completed levels CSV output. Not sure this is actually useful, skipping for 2010. |
| Add barcode search | Finished | Add barcode search to staff menu when barcode field is used. |
| Improve reporting speed | In Development | Rewrite SQL statements used to generate reports to improve speed for large amounts of data. |
| Fix session cookies | In Development | Session cookies occasionally time out when many staff are logged in, requiring re-authentication. |
| Add barcode to key | Skipped | Make the barcode part of the “uniqueness” of each record (OPTIONAL). No further interest in this feature, skipping for 2010. |
| Add library to random drawing | Finished | Select which library branch(es) to include when using the random drawing feature. |
| Add timezone support | Skipped | Add support for when library is in a different timezone than the server. RR won't be available outside Colorado in 2010, so no need for this feature yet. |
| Move reports | Finished | Move report to separate page to keep main staff menu clean. Hide disabled reports. |
| Restrict access to reports | Finished | Restrict reports access to specific logins. |
| General code housekeeping | Move & document methods, cleanup/standardize SQL syntax. Can be done as time permits, will work on throughout the year. See notes in StaffWiki. |
| Task | Progress | Notes |
|---|---|---|
| Move mailing list | Finished | Mailman server disbanded, mailing list moved to a Google Group. |
| Revise setup/customization forms | Finished | Update forms to include new configuration options. |
| Staff notes field | Finished | Ran out of time to implement in the 2008 version. |
| Simplify DB access | Finished | Use a single MySQL account per site for DB access. |
| Simplify program graphics | Finished | Find an easier way to handle resizing program graphics. |
| Per-site phone number configuration | Finished | Allow phone number field to be customized to include/exclude area code. |
| Add “no phone number” message | Finished | Add error message explaining what phone number to use if the patron doesn't have or doesn't want to give out their phone number. (All zeros or???) |
| Phone number field instructions | Finished | Added formatting instructions to the field label. Pre-populating the field with brief instructions or examples doesn't always display well & requires deletion of the info before entering the phone number. |
| Pre-populate phone number field with area code | Finished | |
| Allow registrations to be deleted | Finished | Allow staff to delete duplicate/bad registrations. Also check & delete associated levels. |
| Copy registration | Finished | Allow staff to copy an existing registration. This would be useful when registering many members of the same family. |
| Toggle between update & track | Finished | Allow staff to toggle between update & track after searching. This can currently be done by updating the registration or completed levels, but it would be nice to be able to do so without requiring an update. |
| Random drawing | Finished | Add a feature to select a random reader for prize drawings, etc. |
| Customize field labels | Finished | Per-site customization of field labels, eg: upcoming grade instead of last grade attended, etc. |
| Customize program names on staff menu | Finished | Label for staff shortcuts to [Add][Update][Track] should use program name instead of being hard-coded. |
| Require valid registration for level completion | Finished | Require the registration to be validated before levels can be marked as complete. Have options for require, warn, auto, ignore? |
| Export data to CSV file. | Finished | Manual export required for 2008. Add code to generate downloadable file. |
| Task | Progress | Notes |
|---|---|---|
| Count of all readers. | Finished | Available from the staff main menu. |
| Count of all completed levels. | Finished | Available from the staff main menu. |
| Count of readers by library. | Finished | |
| Count of completed levels by library. | Finished | |
| List of all registered readers. | Finished | |
| Count of validated & unvalidated readers. | Finished | |
| Count of completed levels by level & library. | Finished | |
| Count of readers by age. | Finished | |
| Count of readers by city. | Finished | |
| Count of readers by zipcode. | Finished | |
| Count of readers by grade. | Finished | |
| Count of readers by school. | Finished | |
| Count of completed levels by age. | Finished | |
| Count of completed levels by city. | Finished | |
| Count of completed levels by zipcode. | Finished | |
| Count of completed levels by grade. | Finished | |
| Count of completed levels by school. | Finished | |
| Export data to CSV file. | Finished | Not quite “user-friendly” for 2008, a data export must be requested. |
| Import data to spreadsheet. | Finished | Importing CSV files to MS Excel or Open Office is quite easy. |
| Task | Progress | Notes |
|---|---|---|
| Create staff login & logout pages. | Finished | |
| Track staff login/session with cookie. | Finished | |
| Create staff main index page. | Finished | |
| Create CSS file for staff pages. | Finished | |
| Create “Search” form. | Finished | |
| Create “New Registration” form. | Finished | |
| Create “Update Registration” form. | Finished | |
| Create “Track Completed Levels” form. | Finished | |
| Deny duplicate registrations/updates. | Finished | Redirect to error page if a duplicate registration is entered/updated. |
| Task | Progress | Notes |
|---|---|---|
| Create index page with program graphics. | Finished | |
| Create CSS file for patron pages. | Finished | |
| Create patron self-registration form. | Finished | |
| Validate all fields on self-registration form. | Finished | Text fields, drop-down fields, etc. |
| Allow self-registration during program only. | Finished | Early self-registration can also be allowed. |
| Deny duplicate registrations. | Finished | Redirect to error page if a duplicate registration is entered. |
| Task | Progress | Notes |
|---|---|---|
| Choose & register a domain name. | Finished | “readingrecord.org” chosen & purchased. |
| Create a ReadingRecord logo graphic. | Finished | |
| Create a ReadingRecord favicon graphic. | Finished | |
| Configure DNS servers. | Finished | Internal & external DNS servers up & running. |
| Create a server to host the project. | Finished | LAMP environment hosted on VMware. |
| Create a Wiki for the project. | Finished | DokuWiki installed & configured. Adding & updating content is ongoing. |
| Create a mailing list for the project. | Finished | Added new mailing list to existing mailman server. |
| Design database schema. | Finished | |
| Select development tools. | Finished | Komodo for PHP development & phpMyAdmin for MySQL database administration. |
| Select a version control system. | Finished | Subversion used to track changes in PHP code, CSS files, etc. |
| Create a development environment. | Finished | Apache virtual host for “dev” & “devtest” development websites. |
| Create a testing environment. | Finished | Apache virtual host for “library1” & “library2” testing websites. |
| Create setup/customization forms. | Finished | |
| Create a live environment | Finished | Apache virtual host for live sites. |