In an ongoing effort to help our partners write reports in Koha, I’d like to highlight the relationships between database tables in Koha. A review of the basics of SQL Just for review, let’s look at some elementary SQL. Let’s say that we have two tables, person and person_dates. The […]
Educator: Jessie 3/27 To learn all about Koha 16.11 view the other videos in this series and make sure to review the manual and the release notes.
This tutorial video will show you a few new enhancements including searching, saving and logs for Reports in Koha 3.22. To learn all about Koha 3.22 view the other videos in this series and make sure to review the manual and the release notes.
This recorded webinar will cover new features and enhancements in the 3.22 Koha upgrade for tools, reports, administration and system preferences. Koha 3.22 can take advantage of Plack to run faster than ever, here is link to read more. Some of the highlights from this session include custom sound notifications […]
Reports have always been one of my favorite parts of Koha. The unfettered access to all of the tables and data in the system was a refreshing change from proprietary ILSes I had worked with in the past. From day one I was writing reports to track everything in the […]
This week’s tutorial is brought to us from Spencer Smith at the Little Elm Public Library. From Spencer: This video will detail how I use evidence based collection management in Koha. In this video I am calculating turnover by shelving location. Eventually this data will all tie in to ordering […]
Today’s guest post comes from Christopher Brannon at Cooperative Information Network (CIN). Christopher asked us if there was a way to not have enter the date 2 times in a report like this one: SELECT ai.location AS ‘Shelf Location’, COUNT(ai.dateaccessioned) AS ‘Count’ FROM (SELECT dateaccessioned, homebranch, location, timestamp FROM items […]
I recently received an email asking me if there were any tutorials on how to share reports on the Koha wiki. There were not … so of course I created one. This tutorial will show you how to edit the Koha reports library on the official wiki so that you […]
It’s time for another post ripped right from the support system at ByWater. We’ve had a bunch of partners report to us that they can no longer sort their saved reports in Koha 3.14 by creation date. I have to admit I never even used this function so I didn’t […]
I’ve been teaching our partners all about Koha 3.14 and one of the great upgrades that comes with 3.14 is a new interface for lists in the staff client. I happen to love this new look and feel, but a few of our partners noted that the new printable version […]