[OPEN-ILS-GENERAL] Circulation Statistics

2012-09-11 Thread Chauncey Montgomery
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

Re: [OPEN-ILS-GENERAL] Circulation Statistics

2012-09-11 Thread Aaron Zsembery
On Tuesday, September 11, 2012 at 9:33:37 AM Chauncey Montgomery montg...@oplin.org 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

Re: [OPEN-ILS-GENERAL] Circulation Statistics

2012-09-11 Thread Sharp, Chris
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 -

[OPEN-ILS-GENERAL] Acq.

2012-09-11 Thread Lori Kane
What is the difference between Funding Sources, Fund Tags and Funds? Thank you. --Lori

Re: [OPEN-ILS-GENERAL] Acq.

2012-09-11 Thread Mark Cooper
I'm in the process of evaluating Acquisitions right now and have found Sitka's documentation to be a big help in fast-tracking my understanding of how it works in Evergreen (don't think they'll mind me posting this): http://docs.sitka.bclibraries.ca/Acq/current/html/ and in particular:

Re: [OPEN-ILS-GENERAL] Weeding Report

2012-09-11 Thread Sharp, Chris
Rebecca, Would you be willing to share the Generated SQL from your Debugging Info? It's possible someone can make a recommendation based on that. Thanks, Chris - Original Message - From: Rebecca Larocque rebecca.laroc...@cityofnorthbay.ca To: Open-ILS General Listserv

Re: [OPEN-ILS-GENERAL] Acq.

2012-09-11 Thread Mary Llewellyn
I tell my libraries to think of the funding source as the big pot of money. You take that pot and divide into the individual funds. The fund tags are labels you can make up to group funds for reporting purposes, such as adult, child, book, AV. You can then devise a report showing what was spent on

[OPEN-ILS-GENERAL] SQL help needed

2012-09-11 Thread Mary Llewellyn
Hi all, I've just found out that one of our libraries has dropped its subscription to a downloadable e-resource service. I need a way to find and delete their URLs in several thousand records while leaving intact the URLs belonging to the other libraries that still subscribe. I see 2 ways

[OPEN-ILS-GENERAL] egcon2013 update: earlybird registration deadline Sept 15th

2012-09-11 Thread Tara Robertson
Hi, A few quick updates on the conference that's happening next April 10-13th in Vancouver, BC. Registration Early bird registration rates are in effect until September 15th: http://eg2013.eventbrite.com/ Please book your hotel room too (so we organizers can exhale as the room block fills up):

Re: [OPEN-ILS-GENERAL] SQL help needed

2012-09-11 Thread Bill Ott
On 9/11/12 7:18 PM, Mary Llewellyn wrote: I see 2 ways to go: find and export all the bibs involved, delete the obsolete 856s in a third-party MARC editor, then load the bibs back in and replace the bibs in the database. Or, develop some backdoor way to remove the 856s using SQL, just for the