[OPEN-ILS-GENERAL] Improving LC Call Number Displays Behaviors

2014-12-04 Thread Donald Butterworth
Colleagues, Another priority that emerged from the Evergreen for Academics survey is Library of Congress Call Numbers displays and behaviors. My assignment is to identify issues. To that end an Evergreen DokuWiki was created entitled Improve LC Call Number Displays Behaviors

[OPEN-ILS-GENERAL] Call Number/Checkout report

2014-12-04 Thread Donald Butterworth
Colleagues, We need to send a bunch of titles to offsite storage. Can anyone share a report that lets us limit by Books in the Stacks, Call Number range (BS001 to BS100), Checked out zero times, over the last 10 years. Thanks! Don -- Don Butterworth Faculty Associate / Librarian III B.L.

Re: [OPEN-ILS-GENERAL] Call Number/Checkout report

2014-12-04 Thread Rogan Hamby
Do you have SQL access? Is Books in the Stacks a copy location? On Thu, Dec 4, 2014 at 9:09 AM, Donald Butterworth don.butterwo...@asburyseminary.edu wrote: Colleagues, We need to send a bunch of titles to offsite storage. Can anyone share a report that lets us limit by Books in the

Re: [OPEN-ILS-GENERAL] Call Number/Checkout report

2014-12-04 Thread Donald Butterworth
We do have SQL access. Stacks is a Copy location. On Thu, Dec 4, 2014 at 9:39 AM, Rogan Hamby rogan.ha...@yclibrary.net wrote: Do you have SQL access? Is Books in the Stacks a copy location? On Thu, Dec 4, 2014 at 9:09 AM, Donald Butterworth don.butterwo...@asburyseminary.edu wrote:

Re: [OPEN-ILS-GENERAL] Call Number/Checkout report

2014-12-04 Thread Elizabeth B. Thomsen
The tricky part of this one is the last element, finding items that were not checked out in the past 10 years, because you need to work with data which may or may not have been migrated from your old system. Once you know where that is and what format it's in, you need to look for items that

Re: [OPEN-ILS-GENERAL] Call Number/Checkout report

2014-12-04 Thread Rogan Hamby
Assuming your data data is good you may actually want to check for two different things, items that haven't circulated in ten + years and items that have never circulated. I also recommend checking to see the age of the item and if it was added 10 + years ago. Again, this may or may not be

[OPEN-ILS-GENERAL] ***SPAM*** Re: Call Number/Checkout report

2014-12-04 Thread Donald Butterworth
Many, many thanks Rogan, I will pass this on to a SQL wizard. We tried pretty hard to migrate values that could be used for this kind of report. Don On Thu, Dec 4, 2014 at 1:33 PM, Rogan Hamby rogan.ha...@yclibrary.net wrote: Assuming your data data is good you may actually want to check for

[OPEN-ILS-GENERAL] Web Staff Client Documentation Day - Tomorrow!

2014-12-04 Thread Remington Steed
Hello Evergreen, Tomorrow is Web Staff Client Documentation Day. You are invited to help! We will be working on an introduction to the new web staff client that is being developed. What: Web Staff Client Documentation Day When: Friday, December 5, 2014 (approx. 8am - 5pm EST) Where: Online!