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

[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 have 0 checkouts on Evergreen and whose last checkin date from your 
old system was less than 2014-12-04 (which may not be the actual date 
format) making sure that the items which were never checked in (because 
they were never checked out) are included.

You also need to include the create or active date from your old system, 
because you can't blame an item for not circulating before it was added 
to the collection.  In other words, you don't want to include things 
that were added in 2013 that haven't circulated yet.

The actual query depends on knowing what data you migrated, what format 
it's in and where it is.  These weeding reports that depend on working 
with data from two different systems can be tricky, but as long as you 
have that data from your old system, you ought to be able to get the 
information you need.

On 12/4/2014 9:47 AM, Donald Butterworth wrote:
> We do have SQL access. Stacks is a Copy location.
>
> On Thu, Dec 4, 2014 at 9:39 AM, Rogan Hamby <rogan.hamby at yclibrary.net
> <mailto:rogan.hamby at 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.butterworth at asburyseminary.edu
>     <mailto:don.butterworth at 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
>         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. Fisher Library
>         Asbury Theological Seminary
>         don.butterworth at asburyseminary.edu
>         <mailto:don.butterworth at asburyseminary.edu>
>         (859) 858-2227 <tel:%28859%29%20858-2227>
>
>
>
>
>     --
>
>     Rogan Hamby, MLS, CCNP, MIA
>     Managers Headquarters Library and Reference Services,
>     York County Library System
>
>     “You can never get a cup of tea large enough or a book long enough
>     to suit me.”
>     ― C.S. Lewis <http://www.goodreads.com/author/show/1069006.C_S_Lewis>
>
>
>
>
> --
> Don Butterworth
> Faculty Associate / Librarian III
> B.L. Fisher Library
> Asbury Theological Seminary
> don.butterworth at asburyseminary.edu
> <mailto:don.butterworth at asburyseminary.edu>
> (859) 858-2227


-- 
Elizabeth Thomsen, Member Services Manager
NOBLE: North of Boston Library Exchange
26 Cherry Hill Drive
Danvers MA 01923
E-mail: et at noblenet.org