Re: [OPEN-ILS-GENERAL] Circulation Statistics
Hi Chauncey, >From the technical end, if you are willing to share your "Debugging Info" >(available from the reports result screen), particularly the "Generated SQL" >section, several of us could verify that your report is actually counting what >you intend it to. Chris - Original Message - > From: "Chauncey Montgomery" > To: "Evergreen" > Sent: Tuesday, September 11, 2012 9:33:37 AM > Subject: [OPEN-ILS-GENERAL] Circulation Statistics > > Greetings Evergreen Community: > > Earlier this year, we migrated from TLC Library.Solution 3.3.5 to > Evergreen 2.1. The migration took place in March. Since then, > circulation counts have dropped by approximately 2,500 per month. > Originally, I thought my reports in Evergreen weren't counting > everything. However, I have run multiple reports and always get the > same numbers. I am fairly certain that our circulation hasn't truly > dropped; all other areas of library use are consistent with previous > activity, and the drop in circulation occurs at the point of > migration. > So, I am beginning to suspect that perhaps TLC counted things > differently than Evergreen. > > I am curious, are there any other libraries that had migrated from > TLC > to Evergreen and saw the same thing happen in circulation? If so, do > you > know what TLC counted that Evergreen doesn't count? Also, I have > confirmed that I am counting all circulations and renewals in my > Evergreen reports. > > No big deal, but I'd like to be able to explain this a little more > clearly to my board. > > Thanks for the input. > > Chauncey > > Chauncey G. Montgomery, MLIS > Director/Fiscal Officer > Community Library > Sunbury, Ohio > 740-965-3901 > montg...@oplin.org > -- Chris Sharp PINES Program Manager Georgia Public Library Service 1800 Century Place, Suite 150 Atlanta, Georgia 30345 (404) 235-7147 csh...@georgialibraries.org http://pines.georgialibraries.org/
Re: [OPEN-ILS-GENERAL] Circulation Statistics
On Tuesday, September 11, 2012 at 9:33:37 AM "Chauncey Montgomery" wrote: > So, I am beginning to suspect that perhaps TLC counted things > differently than Evergreen. I have never used or heard of TLC, but here are two things that I have noticed in our migration from Unicorn to Evergreen: 1. Do your libraries use "in-house" circulations to track items used for storytime and other such activities? If so, are you looking up those circulations in your report? They are stored separately from "regular" circulations and will need to be retrieved separately. 2. How about inter library loan, did the sending library get credit for that in TLC? If so, you may need to add something to the report to count that as by default Evergreen does not "credit" the sending library for that circulation in most reports. HTH Aaron Z Jr. Systems Administrator Pioneer Library System 2557 State Rt. 21 Canandaigua, New York 14424 Phone: (585) 394-8260
Re: [OPEN-ILS-GENERAL] Circulation Statistics
We have found exactly the same thing here at the SEDAR consortium in Scotland. We migrated from Horizon last December and like you noticed a marked drop in issues. We have done various tests and reports and verified that the issues are correct. The only logical conclusion we came to was that Horizon wasn't counting properly. The libraries aren't any quieter! If you find the missing issues let us know! Anne Murray Kirkintilloch Scotland On 11 September 2012 14:33, Chauncey Montgomery wrote: > Greetings Evergreen Community: > > Earlier this year, we migrated from TLC Library.Solution 3.3.5 to > Evergreen 2.1. The migration took place in March. Since then, circulation > counts have dropped by approximately 2,500 per month. Originally, I thought > my reports in Evergreen weren't counting everything. However, I have run > multiple reports and always get the same numbers. I am fairly certain that > our circulation hasn't truly dropped; all other areas of library use are > consistent with previous activity, and the drop in circulation occurs at > the point of migration. So, I am beginning to suspect that perhaps TLC > counted things differently than Evergreen. > > I am curious, are there any other libraries that had migrated from TLC to > Evergreen and saw the same thing happen in circulation? If so, do you know > what TLC counted that Evergreen doesn't count? Also, I have confirmed that > I am counting all circulations and renewals in my Evergreen reports. > > No big deal, but I'd like to be able to explain this a little more clearly > to my board. > > Thanks for the input. > > Chauncey > > Chauncey G. Montgomery, MLIS > Director/Fiscal Officer > Community Library > Sunbury, Ohio > 740-965-3901 > montg...@oplin.org >
[OPEN-ILS-GENERAL] Circulation Statistics
Greetings Evergreen Community: Earlier this year, we migrated from TLC Library.Solution 3.3.5 to Evergreen 2.1. The migration took place in March. Since then, circulation counts have dropped by approximately 2,500 per month. Originally, I thought my reports in Evergreen weren't counting everything. However, I have run multiple reports and always get the same numbers. I am fairly certain that our circulation hasn't truly dropped; all other areas of library use are consistent with previous activity, and the drop in circulation occurs at the point of migration. So, I am beginning to suspect that perhaps TLC counted things differently than Evergreen. I am curious, are there any other libraries that had migrated from TLC to Evergreen and saw the same thing happen in circulation? If so, do you know what TLC counted that Evergreen doesn't count? Also, I have confirmed that I am counting all circulations and renewals in my Evergreen reports. No big deal, but I'd like to be able to explain this a little more clearly to my board. Thanks for the input. Chauncey Chauncey G. Montgomery, MLIS Director/Fiscal Officer Community Library Sunbury, Ohio 740-965-3901 montg...@oplin.org
Re: [OPEN-ILS-GENERAL] circulation statistics
[changing stats] > Has anyone else noticed this? How do you deal with your circulation stats? > (We are > currently on vers 1.4.06) Any input would be appreciated. Changing stats could also be a sign that you're not reporting on what you think you're reporting on. There are two types of reports that people tend to run, those that depend on counting/listing things at a specific point in time (when the report runs), and those that count/list things based on dates within the data itself. Trying to do the latter where possible tends to produce more stable (and IMO accurate results), but with such things as backdated checkins and offline transactions, even those results can be mutable. Deleting data however, doesn't usually make a difference, unless you set up your report thus, since Evergreen tends to not _really_ delete anything, but merely marks data as being deleted. In Evergreen, a renewal counts as a circulation (it's a separate row in a database table) unless you explicitly filter it out (using the various boolean _renewal fields on the circ). In the trunk version of Evergreen, there is a way to group the initial checkout and subsequent renewals into one entity called a "circulation chain", and you can report on those, with the start of a circ chain being the initial checkout time, and the end of a circ chain being the checkin time on the last renewal. In trunk, we also start distinguishing between the effective checkin time due to backdating, and the actual checkin scan time, and you can report on those as well. It may help to share specific reports (even if this is currently difficult) so that others can scrutinize it and determine where the pitfalls might lay. -- Jason Etheridge | VP, Tactical Development | Equinox Software, Inc. / Your Library's Guide to Open Source | phone: 1-877-OPEN-ILS (673-6457) | email: ja...@esilibrary.com | web: http://www.esilibrary.com
Re: [OPEN-ILS-GENERAL] circulation statistics
Hi Shasta! I would recommend a single circulation report with canned results. Your library system or consortium would set up an official monthly circulation report with the results stored on a web-server or shared space that all could access. As oppose to running a new report anytime you needed the information and taking the chance that the information would change, the library system or consortium would run it once and you & the libraries within the system could access the file as many times as needed with no chance of the results changing. The January circ report would be run once and the results would be put in a "can" assessable to all. Sound good? George the Librarian Piedmont Regional Library System Winder, GA From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Shasta Brewer Sent: Wednesday, June 30, 2010 8:57 AM To: open-ils-general@list.georgialibraries.org Subject: [OPEN-ILS-GENERAL] circulation statistics Lately, I reran circ stats that I had run in January. I noticed an increase in some stats which is due to renewals being counted for the month that the original circulation took place. However, I also noticed a decrease in other stats which I can only attribute to items that have been deleted from the system. (These are items which would not have their circulating location, shelving location or circ mod changed.) Has anyone else noticed this? How do you deal with your circulation stats? (We are currently on vers 1.4.06) Any input would be appreciated. Shasta P. Brewer Deputy Director York County Library 113 E. Main St., Ste 100 PO Box 10032 Rock Hill, SC 29731 803-981-5835 Fax: 803-981-5895
[OPEN-ILS-GENERAL] circulation statistics
Lately, I reran circ stats that I had run in January. I noticed an increase in some stats which is due to renewals being counted for the month that the original circulation took place. However, I also noticed a decrease in other stats which I can only attribute to items that have been deleted from the system. (These are items which would not have their circulating location, shelving location or circ mod changed.) Has anyone else noticed this? How do you deal with your circulation stats? (We are currently on vers 1.4.06) Any input would be appreciated. Shasta P. Brewer Deputy Director York County Library 113 E. Main St., Ste 100 PO Box 10032 Rock Hill, SC 29731 803-981-5835 Fax: 803-981-5895
