Re: [CODE4LIB] circulation statistics
The replies received have all been very helpful. Thank you! —Eric M.
Re: [CODE4LIB] circulation statistics
Koha has a very robust SQL-based reporting module, so generating statistics like these is generally a fairly routine process. This report lists the top 10 circulating items in the last 6 months, for example -- SELECT count(s.datetime) AS circs, b.title, b.author, i.ccode FROM statistics s JOIN items i ON (i.itemnumber=s.itemnumber) LEFT JOIN biblio b ON (b.biblionumber=i.biblionumber) WHERE DATE(s.datetime) DATE_SUB(CURRENT_DATE(),INTERVAL 6 MONTH) AND DATE(s.datetime)=CURRENT_DATE() AND s.itemnumber IS NOT NULL GROUP BY b.biblionumber ORDER BY circs DESC LIMIT 10 Constantly growing list of user-contributed reports here: http://wiki.koha-community.org/wiki/SQL_Reports_Library/ Can't speak to Aleph, but there is a Developer's Network which should point you in the right direction: https://developers.exlibrisgroup.com/ Best, Cab Vinton Plaistow Public Library
Re: [CODE4LIB] circulation statistics
Eric, We do something similar to Ken from our iii catalogue, to produce our top 10 lists http://www.bury.gov.uk/index.aspx?articleid=6311 Though this is based on a monthly marc extract of the entire catalogue and then loaded into a database, which we also use to help with weeding promotion etc (though there is no web front end at the moment). There are a number of commercial products that do this as well. regards Alan Alan Brown Libraries System Liaison Officer Bury Libraries Resource Services Textile Hall Manchester Rd BL9 0DG http://www.bury.gov.uk/libraries http://library.bury.gov.uk -Original Message- From: Ken Irwin [mailto:kir...@wittenberg.edu] Sent: 14 January 2015 01:12 Subject: Re: circulation statistics Eric, It's not Aleph, but... III's catalog has a create list function that lets you create a list of records (bib records, item records, patron records, etc) that meet certain criteria (patrons who live is x zip code, items in the main stacks with more than 5 checkouts, etc.) To do what your friend is trying to do, it would help to have some way of flagging the relevant records (popular lit) -- maybe they are the books in a particular location, or maybe he's added a local subject heading, etc -- something that lets him point to a particular subset of the collection. So his process might look something like: * find all the books that match: - published since 1980 - location = popular fiction collection - total circ 2 * and then export selected fields: - author - title - publisher - year - total circs - total renews Or something like that. This is exactly the kind of search and extraction that I designed my Weeding Helper tool to work with -- only there I'm looking at *un*-popular materials: https://github.com/kenirwin/Weeding-Helper Demo: http://www6.wittenberg.edu/lib/iii/weed/demo/view.php?table=art_orders It takes that sort of search-and-export data from the catalog and makes it sortable and subject to note-taking so you can take a computer or tablet up to the stacks and weed a range of books and have their circ history in front of you. Ken -Original Message- From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of Eric Lease Morgan Sent: Tuesday, January 13, 2015 5:08 PM To: CODE4LIB@LISTSERV.ND.EDU Subject: [CODE4LIB] circulation statistics Does anybody here know how to extract circulation statistics from an library catalog? Specifically, given a date range, are you able to create a list of the most frequently borrowed books ordered by the number of times they’ve been circulated? I have a colleague who wants to digitize sets of modern literature and then do text analysis against the result. In an effort to do the analysis against popular literature, he wants to create a list of… popular titles. Getting a list of such a thing from library circulation statistics sounds like a logical option to me. Does somebody here know how to do this? If you know how to do it against Ex Libris’s Aleph, then that is a bonus. — Eric Morgan - Why not visit our website www.bury.gov.uk - Incoming and outgoing e-mail messages are routinely monitored for compliance with our information security policy. The information contained in this e-mail and any files transmitted with it is for the intended recipient(s) alone. It may contain confidential information that is exempt from the disclosure under English law and may also be covered by legal,professional or other privilege. If you are not the intended recipient, you must not copy, distribute or take any action in reliance on it. If you have received this e-mail in error, please notify us immediately by using the reply facility on your e-mail system. If this message is being transmitted over the Internet, be aware that it may be intercepted by third parties. As a public body, the Council may be required to disclose this e-mail or any response to it under the Freedom of Information Act 2000 unless the information in it is covered by one of the exemptions in the Act. Electronic service accepted only at legal.servi...@bury.gov.uk and on fax number 0161 253 5119 . *
Re: [CODE4LIB] circulation statistics
In aleph you would need to query Z36H using SQL to get information about historical loans or possibly you could use ARC (the exlibris reporting tool) or an external BI tool over the aleph database to query the historical loans table. hth Tulie Tulie Amichal | Library Computer Systems Coordinator Phone: 03-6407063 | Fax: 03-6407840 | Email: tu...@tauex.tau.ac.il | Skype: tulieami The Brender-Moss Library for Social Sciences and Management - Tel Aviv University -Original Message- From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of Ken Irwin Sent: Wednesday, January 14, 2015 3:12 AM To: CODE4LIB@LISTSERV.ND.EDU Subject: Re: [CODE4LIB] circulation statistics Eric, It's not Aleph, but... III's catalog has a create list function that lets you create a list of records (bib records, item records, patron records, etc) that meet certain criteria (patrons who live is x zip code, items in the main stacks with more than 5 checkouts, etc.) To do what your friend is trying to do, it would help to have some way of flagging the relevant records (popular lit) -- maybe they are the books in a particular location, or maybe he's added a local subject heading, etc -- something that lets him point to a particular subset of the collection. So his process might look something like: * find all the books that match: - published since 1980 - location = popular fiction collection - total circ 2 * and then export selected fields: - author - title - publisher - year - total circs - total renews Or something like that. This is exactly the kind of search and extraction that I designed my Weeding Helper tool to work with -- only there I'm looking at *un*-popular materials: https://github.com/kenirwin/Weeding-Helper Demo: http://www6.wittenberg.edu/lib/iii/weed/demo/view.php?table=art_orders It takes that sort of search-and-export data from the catalog and makes it sortable and subject to note-taking so you can take a computer or tablet up to the stacks and weed a range of books and have their circ history in front of you. Ken -Original Message- From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of Eric Lease Morgan Sent: Tuesday, January 13, 2015 5:08 PM To: CODE4LIB@LISTSERV.ND.EDU Subject: [CODE4LIB] circulation statistics Does anybody here know how to extract circulation statistics from an library catalog? Specifically, given a date range, are you able to create a list of the most frequently borrowed books ordered by the number of times they’ve been circulated? I have a colleague who wants to digitize sets of modern literature and then do text analysis against the result. In an effort to do the analysis against popular literature, he wants to create a list of… popular titles. Getting a list of such a thing from library circulation statistics sounds like a logical option to me. Does somebody here know how to do this? If you know how to do it against Ex Libris’s Aleph, then that is a bonus. — Eric Morgan
[CODE4LIB] circulation statistics
Does anybody here know how to extract circulation statistics from an library catalog? Specifically, given a date range, are you able to create a list of the most frequently borrowed books ordered by the number of times they’ve been circulated? I have a colleague who wants to digitize sets of modern literature and then do text analysis against the result. In an effort to do the analysis against popular literature, he wants to create a list of… popular titles. Getting a list of such a thing from library circulation statistics sounds like a logical option to me. Does somebody here know how to do this? If you know how to do it against Ex Libris’s Aleph, then that is a bonus. — Eric Morgan
Re: [CODE4LIB] circulation statistics
Does Aleph have an Access reporting component? That's how we do this in XL Voyager. -Original Message- From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of Eric Lease Morgan Sent: Tuesday, January 13, 2015 2:08 PM To: CODE4LIB@LISTSERV.ND.EDU Subject: [CODE4LIB] circulation statistics Does anybody here know how to extract circulation statistics from an library catalog? Specifically, given a date range, are you able to create a list of the most frequently borrowed books ordered by the number of times they’ve been circulated? I have a colleague who wants to digitize sets of modern literature and then do text analysis against the result. In an effort to do the analysis against popular literature, he wants to create a list of… popular titles. Getting a list of such a thing from library circulation statistics sounds like a logical option to me. Does somebody here know how to do this? If you know how to do it against Ex Libris’s Aleph, then that is a bonus. — Eric Morgan
Re: [CODE4LIB] circulation statistics
Seems kinda a hard way to go about it - and you'd only have an edition (not large print + audio + ebook +... ) (not frbr-ized, I think)... I would think it would make more sense to look in WorldCat for number of libraries owning or to just use best seller and Oprah lists from the past few years? Christina -Original Message- From: Code for Libraries [mailto:CODE4LIB@listserv.nd.edu] On Behalf Of Bornheimer, Bee Sent: Tuesday, January 13, 2015 5:16 PM To: CODE4LIB@listserv.nd.edu Subject: Re: [CODE4LIB] circulation statistics Does Aleph have an Access reporting component? That's how we do this in XL Voyager. -Original Message- From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of Eric Lease Morgan Sent: Tuesday, January 13, 2015 2:08 PM To: CODE4LIB@LISTSERV.ND.EDU Subject: [CODE4LIB] circulation statistics Does anybody here know how to extract circulation statistics from an library catalog? Specifically, given a date range, are you able to create a list of the most frequently borrowed books ordered by the number of times they’ve been circulated? I have a colleague who wants to digitize sets of modern literature and then do text analysis against the result. In an effort to do the analysis against popular literature, he wants to create a list of… popular titles. Getting a list of such a thing from library circulation statistics sounds like a logical option to me. Does somebody here know how to do this? If you know how to do it against Ex Libris’s Aleph, then that is a bonus. — Eric Morgan
