Document Actions
Web Reporter Enhancments
July 18, 2008 04:28 PM | Automation, ILS, Projects, ReportsAurora Jacobsen, Information Services Librarian
As we implemented WebReporter, library staff had a lot of suggestions for improving reports by adding about extra fields or columns to add reports. We logged these suggestions with the hope we could address these suggestions and implement some new reports at a later date. Staffing changes, however, delayed any new changes until recently.
After staffing normalized, Mick and I went back and looked at the list of enhancements. To determine which reports would be updated, I combed through the requests that came into the Helpdesk and the requests I had while teaching the class. Some suggestions had been made by multiple people, so they were given a higher priority, as were changes that required the addition of a column rather than an entirely new report. Once these were weighted, Mick examined the reports to determine which were the most feasible to winnow the list down. This list was shared via ILS bulletin on July 1, 2008.
New Reports added:
1. New Borrower Count broken down by btype
2. New Borrower Count broken down by city/county –
3. New Borrower Count broken down by state
4. New Borrowers by State—
5. Remove Iowa Patrons from the Bad CI/CO report
6. Weeding report by statcat that includes last CKO date
7. Expired Holds w/ Pickup Location (Updated)
8. Add copyright date to the Weeding Report—this report can only be run with publication date
9. Weeding Report w/ Dates
10. A new report that provides the average copyright age of a collection by Dewey range. The primary need for this report arose from a field in this year’s State Library Report for schools. We met the need for the report by running it on off hours, but the current database structure cannot support the regular running of this report. We can send it out on request, but cannot add it to the reports suite.
Unfortunately, we have learned that there is a limit to modifications we can make to reports in this database structure. We initially proposed 5 other reports we have determined are not feasible at this time. Those are:
1. Add ability to break down CKI/CKO/IHU Report by collection code
2. Add videos, CDs and other A/V materials to Titles with Best Circ report
3. Add columns for created date, last CKO date, item status, status date, barcode and copy to the Titles with Best Circ report
4. Limit for items added since a given date in the Titles with Best Circ report
5. Collection code added to Titles with Best Circ Report
This is the first phase of the enhancements process. We look forward to re-examining other enhancement requests and implementing new reports in the future.
New Reports added:
1. New Borrower Count broken down by btype
2. New Borrower Count broken down by city/county –
3. New Borrower Count broken down by state
4. New Borrowers by State—
5. Remove Iowa Patrons from the Bad CI/CO report
6. Weeding report by statcat that includes last CKO date
7. Expired Holds w/ Pickup Location (Updated)
8. Add copyright date to the Weeding Report—this report can only be run with publication date
9. Weeding Report w/ Dates
10. A new report that provides the average copyright age of a collection by Dewey range. The primary need for this report arose from a field in this year’s State Library Report for schools. We met the need for the report by running it on off hours, but the current database structure cannot support the regular running of this report. We can send it out on request, but cannot add it to the reports suite.
Unfortunately, we have learned that there is a limit to modifications we can make to reports in this database structure. We initially proposed 5 other reports we have determined are not feasible at this time. Those are:
1. Add ability to break down CKI/CKO/IHU Report by collection code
2. Add videos, CDs and other A/V materials to Titles with Best Circ report
3. Add columns for created date, last CKO date, item status, status date, barcode and copy to the Titles with Best Circ report
4. Limit for items added since a given date in the Titles with Best Circ report
5. Collection code added to Titles with Best Circ Report
This is the first phase of the enhancements process. We look forward to re-examining other enhancement requests and implementing new reports in the future.
Comments
There are no comments yet.
