Guest post by Cindy Weber
Here is a summary of where we stand with reports in Koha. Koha reports can be found on the Reports tab of the ILS Support web site.
High in Demand Items report (also known as Purchase Alert): This report is very close to being done. I am not able to get it to report the holds vs. items ratio correctly. I have asked the SQL experts in the Koha community and LibLime for help and hopefully will be able to resolve the problems soon.
Weeding reports: We hope to start taking weeding report requests in the next two weeks. As with the “High in Demand Items” report we are unable to print both the holds count and items count on the same report, but we can print one or the other. We are continuing to work on resolving this problem, but will offer the report as is within two weeks. Prototypes of the report have been sent to a library and I’m doing more testing and waiting for feedback.
Report of payments by fine/fee type: A prototype of the report was sent to a library but it was not showing the correct amounts for fines and fees collected. It may be showing the amount assessed for some of the numbers instead. This report is being reworked.
Daily Circulation Reports
Monthly Circulation Reports
Bibs and Items added and deleted
Long in transit Report
NEXT ON THE LIST:
Posting a reports schedule
Creating a separate reports mailing list if the libraries want one
Reorganizing the Koha Reports website
Problem item status reports (Lost, Claims returned, miscellaneous statuses, etc.)
Talking Tech statistics
FREQUENTLY ASKED QUESTIONS:
There have been a few questions that have been asked multiple times:
How will people know when new reports are posted? Some reports will have an announcement made to either link-announce or to a report specific mailing list if the libraries would rather have a specific list. I have been pulling together a list of all reports and their schedule based on the old Dynix schedule and will post that to the Koha reports page.
Are you going to be printing reports? Unlike Dynix, the reports in Koha are actually created in an electronic format and we have no plans for printing reports at this time. With the electronic reports you can separate, sort and generally work with the data easier. On Dynix we had to say no to a number of requests to make electronic versions of reports due to the time needed to create the work arounds to get the report data into a spreadsheet.
Where are the ISTAT reports?
ISTATs do not exist in Koha. The closest we can give you is the circulation by collection code. The report doesn’t have the breakdowns by Adult, YA and Children’s materials like the ISTAT report used to. In the future, the report may be broken into separate Adult, YA and Children’s reports to make subtotaling by those categories easier.
Can I request a custom/weeding report? Soon! We should be ready to start taking weeding report requests in the next two weeks.
Are we going to get a monthly spreadsheet like the old one? Depends on which spreadsheet you’re talking about. The LINK Library Statistics Summary report from Dynix has been recreated for Koha. That will be appearing every month. While the major portions of the report are recreated, the Circulation Statistics report is currently not going to be in the format you used to receive it.
Where are all of the Year To Date/same month last year statistics? I’m still working on adding those to some of the reports. They have been added to the Statistics Summary report but since the YTD numbers require adding in the statistics from Dynix as well as those from Koha, they haven’t been added to all reports yet.
Can I have all of my library’s reports in a separate folder for my library? Not currently, no. To do so at the moment would require a separate report for each library for every report. In the future this may be possible but it will take a lot of staff time to set up.
Where are the Dynix year-end reports?
All of the electronic Dynix year-end reports were posted on the Dynix ILS Support web site. We printed all of the other reports and we are keeping them at SCLS Headquarters until the end of the year. Duplicate copies of some of the reports have already been distributed.