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 xxxxx 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 . *************************************************************
