====== Project Status ====== ===== 2010 Changes & Improvements ===== ^ 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. | ===== 2009 Changes & Improvements ===== ^ 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. | ===== Reports ===== ^ 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. | ===== Staff Functions ===== ^ 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. | ===== Patron Functions ===== ^ 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. | ===== General Tasks ===== ^ 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. |