Re: [OPEN-ILS-GENERAL] Circulation Reports
That depends on your report. Renewals are circulations flagged as opac, desk, or phone renewal. Thomas Berezansky Merrimack Valley Library Consortium Quoting Chauncey Montgomery montg...@oplin.org: Do you know if renewals are counted as a circulation in Evergreen? We recently migrated from TLC, where renewals were counted separate from circulation in the reports. Just curious. 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 Reports
If you don't specifically exclude them, they are counted just like any other circ. You can separate them out if you like. In the reporter there are 3 fields in the Circulation source, OPAC Renewal, Phone Renewal, and Desk Renewal. If they are ignored renewals are counted, if you filter against all three of them being false, renewals are ignored. If you want to only count renewals, it's easier to subtract non-renewals from all, because there isn't really any way to do an or in the reporter. You could only count renewals manually with SQL though. Jason -- Jason Boyer, IT Specialist Jackson County Public Library 303 W Second St Seymour, IN 47274 jas...@myjclibrary.org p (812) 522-3412 ext. 227 f (812) 522-5456 On Thu, May 3, 2012 at 10:29 AM, Chauncey Montgomery montg...@oplin.orgwrote: Do you know if renewals are counted as a circulation in Evergreen? We recently migrated from TLC, where renewals were counted separate from circulation in the reports. Just curious. 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 Reports
So if I ran a report that counted CIRC ID from the CIRCULATION source, would that only include the counts of circulations and not renewals? In other words, would I need to also include counts of phone, desk, and OPAC renewals to get a full count of activity? Thanks. CM On 05/03/2012 11:03 AM, Thomas Berezansky wrote: That depends on your report. Renewals are circulations flagged as opac, desk, or phone renewal. Thomas Berezansky Merrimack Valley Library Consortium Quoting Chauncey Montgomery montg...@oplin.org: Do you know if renewals are counted as a circulation in Evergreen? We recently migrated from TLC, where renewals were counted separate from circulation in the reports. Just curious. 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 Reports
On Thu, May 3, 2012 at 11:11 AM, Chauncey Montgomery montg...@oplin.org wrote: So if I ran a report that counted CIRC ID from the CIRCULATION source, would that only include the counts of circulations and not renewals? In other words, would I need to also include counts of phone, desk, and OPAC renewals to get a full count of activity? If you just counted Circ ID, that would include renewals, as each renewal causes a new row in the circ table. You could filter them out (doesn't sound like you want to) with the fields previously mentioned (or, you could filter them out based on the Parent Circulation field, since original circs and their renewals are linked through that). -- Jason Etheridge | Equinox Software, Inc. / The Open Source Experts | phone: 1-877-OPEN-ILS (673-6457) | email: ja...@esilibrary.com | web: http://www.esilibrary.com | Supporting Koha and Evergreen: http://koha-community.org http://evergreen-ils.org
Re: [OPEN-ILS-GENERAL] Circulation Reports
Excellent. That's exactly what I needed to know. Thanks for all your help and time. CM On 05/03/2012 11:33 AM, Jason Etheridge wrote: On Thu, May 3, 2012 at 11:11 AM, Chauncey Montgomerymontg...@oplin.org wrote: So if I ran a report that counted CIRC ID from the CIRCULATION source, would that only include the counts of circulations and not renewals? In other words, would I need to also include counts of phone, desk, and OPAC renewals to get a full count of activity? If you just counted Circ ID, that would include renewals, as each renewal causes a new row in the circ table. You could filter them out (doesn't sound like you want to) with the fields previously mentioned (or, you could filter them out based on the Parent Circulation field, since original circs and their renewals are linked through that).