[OPEN-ILS-GENERAL] Open-ils-general Digest, Vol 107, Issue 9
Rogan Hamby
rogan.hamby at yclibrary.net
Mon May 11 20:24:34 EDT 2015
Disclaimer: This is all just my opinion based on my own experiences with
electronic resource records and SQL. You can politely tell me to shove it.
:)
One statement: I think you've already discovered some things that are
leading in the right direction from what I'm reading.
So, question: Do you really need to attach copies to the electronic
resource records?
I would say that you don't. You need to identify items by call number
range, got that. And if you were using the built in reporter I would drop
it there and say "gotcha." True, it is doable even in the reporter but
it's more of a pain. But, you're using SQL. By using UNION statements you
can do this on records without copies and join it to other queries to give
you the counts you need and still have a fire and forget script.
Something that may help that is using different bib sources for different
electronic resource vendors. It's very helpful and very convenient when
doing reports.
On Mon, May 11, 2015 at 4:57 PM, Donald Butterworth <
don.butterworth at asburyseminary.edu> wrote:
> Hi Rogan,
>
> We are still trying to get straight what best practices are when it comes
> to e-books.
>
> The decision has been made to add separate bibliographic records for all
> e-books, including those that are freely available and that match our print
> holdings. We started out just adding the 856 link to the print bib record,
> but that is not sufficient information for Evergreen to filter by. If a
> patron wants to search for just digital books, an "electronic resources"
> bib record is needed.
>
> We continue to wrestle with what call number to use in the copy/item
> record. Recently our library has been required to annually report the total
> number of titles owned by call number range and total copy/items owned by
> call number range. In the past we have used "Online" as a call number for
> e-books, because it is easy for patrons to understand. But by doing that we
> thwarted our ability to track what subject areas are being collected. But
> retrospectively replacing "Online" with a genuine LC call number is a BIG
> project. In any event a copy/item record is necessary to run the SQL query
> that pulls the call number report.
>
> We are still wrestling with ebook workflow for purchased e-books. That is,
> the ones we buy and own. Not those that are part of a block subscription
> that can changed such as Ebsco's Academic Premier collection. Ideally we
> would want the acquisitions process to be identical to print purchases, but
> there are dissimilarities. For example the need to add Asbury's proxy code
> to the 856 URL. Plus the problem with the perpetual In Process status,
> because there are no physical copies to check in.
>
> We do receive spreadsheets of the e-books we purchase from Ebsco, that
> include the e-book ISBN. So my hope is we will be able to do a batch
> search, and then do a batch status change.
>
> Don
>
>
>
>
> On Mon, May 11, 2015 at 1:36 PM, Rogan Hamby <rogan.hamby at yclibrary.net>
> wrote:
>
>> So, you're doing it to keep the electronic and physical on the same bib
>> rather than break them out?
>>
>>
>> On Monday, May 11, 2015, Teri Arp <teri.arp at asburyseminary.edu> wrote:
>>
>>> Rogan and Kathy,
>>> Yes, we do need copy records for eBooks, and yes, we are linking to them
>>> in the 856 field. We use the copy records both for statistical purposes, as
>>> well as to allow our patrons to differentiate between physical and
>>> electronic copies of the books in the search results (we do sometimes have
>>> both versions for the same title).
>>>
>>> Thanks!
>>> Teri
>>>
>>> On Mon, May 11, 2015 at 12:00 PM, <
>>> open-ils-general-request at list.georgialibraries.org> wrote:
>>>
>>>> Send Open-ils-general mailing list submissions to
>>>> open-ils-general at list.georgialibraries.org
>>>>
>>>> To subscribe or unsubscribe via the World Wide Web, visit
>>>>
>>>> http://libmail.georgialibraries.org/mailman/listinfo/open-ils-general
>>>> or, via email, send a message with subject or body 'help' to
>>>> open-ils-general-request at list.georgialibraries.org
>>>>
>>>> You can reach the person managing the list at
>>>> open-ils-general-owner at list.georgialibraries.org
>>>>
>>>> When replying, please edit your Subject line so it is more specific
>>>> than "Re: Contents of Open-ils-general digest..."
>>>>
>>>>
>>>> Today's Topics:
>>>>
>>>> 1. Reports Interest Group Google Hangout (Jessica Venturo)
>>>> 2. eBook circulation status (Teri Arp)
>>>> 3. Re: eBook circulation status (Rogan Hamby)
>>>> 4. Re: eBook circulation status (Kathy Lussier)
>>>>
>>>>
>>>> ----------------------------------------------------------------------
>>>>
>>>> Message: 1
>>>> Date: Mon, 11 May 2015 11:02:13 -0400
>>>> From: Jessica Venturo <jventuro at biblio.org>
>>>> To: Evergreen Community Reports Email List
>>>> <evergreen-reports at list.evergreen-ils.org>,
>>>> open-ils-general at list.georgialibraries.org
>>>> Subject: [OPEN-ILS-GENERAL] Reports Interest Group Google Hangout
>>>> Message-ID:
>>>> <CAPK8=
>>>> rJJX7+-7utDLyNPM21WoEuRkbAP+XCm8qtGMZFF7sFNoQ at mail.gmail.com>
>>>> Content-Type: text/plain; charset="utf-8"
>>>>
>>>> The Reports Interest Group will be offering a Google Hangout for anyone
>>>> who
>>>> cannot attend the conference, but would still like to participate in our
>>>> meeting. The meeting will be held on Thursday, May 14th from 4:45 PM to
>>>> 5:30 PM Pacific Time (that's 7:45 PM to 8:30 PM for my fellow East
>>>> Coasters). You will need a Google account to participate. If interest,
>>>> send
>>>> an email to jventuro at bibilio.org. Be sure to include your Google
>>>> username!
>>>>
>>>> See you at the conference - virtually or otherwise!
>>>>
>>>> --
>>>> Jessica Venturo
>>>> Applications Support Specialist
>>>> Bibliomation, Inc.
>>>> 24 Wooster Ave.
>>>> Waterbury, CT 06708
>>>> 203-577-4070 x105
>>>> -------------- next part --------------
>>>> An HTML attachment was scrubbed...
>>>> URL: <
>>>> http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20150511/dcbc26ec/attachment-0001.html
>>>> >
>>>>
>>>> ------------------------------
>>>>
>>>> Message: 2
>>>> Date: Mon, 11 May 2015 11:13:30 -0400
>>>> From: Teri Arp <teri.arp at asburyseminary.edu>
>>>> To: open-ils-general at list.georgialibraries.org
>>>> Subject: [OPEN-ILS-GENERAL] eBook circulation status
>>>> Message-ID:
>>>> <CADneUoZM+AOBsyWRYQ-Ve9+nu74bSuzn0=
>>>> HXANsj_g_50v0zjA at mail.gmail.com>
>>>> Content-Type: text/plain; charset="utf-8"
>>>>
>>>> When e-books are purchased from Ebsco, we follow the same workflow as
>>>> our
>>>> print books. That is, a bib record is downloaded with an attached 962
>>>> field
>>>> that generates a copy/item record on import and populates the Purchase
>>>> Order. After the titles have been received, the circulation status
>>>> appears
>>>> as "In Process".
>>>>
>>>> What is the best way to batch change e-books from "In Process" to
>>>> "Available"?
>>>>
>>>> Better still, is there a way for new e-books to default to the
>>>> "Available"
>>>> status?
>>>>
>>>> Thank you!
>>>> --
>>>> Teri Arp
>>>> Acquisitions Specialist
>>>> B. L. Fisher Library
>>>> Asbury Theological Seminary
>>>> 204 N. Lexington Ave
>>>> Wilmore KY 40390
>>>> -------------- next part --------------
>>>> An HTML attachment was scrubbed...
>>>> URL: <
>>>> http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20150511/075c9d8e/attachment-0001.html
>>>> >
>>>>
>>>> ------------------------------
>>>>
>>>> Message: 3
>>>> Date: Mon, 11 May 2015 11:47:37 -0400
>>>> From: Rogan Hamby <rogan.hamby at yclibrary.net>
>>>> To: Evergreen Discussion Group
>>>> <open-ils-general at list.georgialibraries.org>
>>>> Subject: Re: [OPEN-ILS-GENERAL] eBook circulation status
>>>> Message-ID:
>>>> <
>>>> CAFpcaPxrwz4BS4P9-4pUQx8gNbm1+mZyf3JYqji73YDtOOnCYQ at mail.gmail.com>
>>>> Content-Type: text/plain; charset="utf-8"
>>>>
>>>> My question is do you need copy records associated with them? Are you
>>>> linking out to the use link in an 856?
>>>>
>>>> On Monday, May 11, 2015, Teri Arp <teri.arp at asburyseminary.edu> wrote:
>>>>
>>>> > When e-books are purchased from Ebsco, we follow the same workflow as
>>>> our
>>>> > print books. That is, a bib record is downloaded with an attached 962
>>>> field
>>>> > that generates a copy/item record on import and populates the Purchase
>>>> > Order. After the titles have been received, the circulation status
>>>> appears
>>>> > as "In Process".
>>>> >
>>>> > What is the best way to batch change e-books from "In Process" to
>>>> > "Available"?
>>>> >
>>>> > Better still, is there a way for new e-books to default to the
>>>> "Available"
>>>> > status?
>>>> >
>>>> > Thank you!
>>>> > --
>>>> > Teri Arp
>>>> > Acquisitions Specialist
>>>> > B. L. Fisher Library
>>>> > Asbury Theological Seminary
>>>> > 204 N. Lexington Ave
>>>> > Wilmore KY 40390
>>>> >
>>>>
>>>>
>>>> --
>>>>
>>>> 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>
>>>> -------------- next part --------------
>>>> An HTML attachment was scrubbed...
>>>> URL: <
>>>> http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20150511/124a9f3c/attachment-0001.html
>>>> >
>>>>
>>>> ------------------------------
>>>>
>>>> Message: 4
>>>> Date: Mon, 11 May 2015 11:51:45 -0400
>>>> From: Kathy Lussier <klussier at masslnc.org>
>>>> To: open-ils-general at list.georgialibraries.org
>>>> Subject: Re: [OPEN-ILS-GENERAL] eBook circulation status
>>>> Message-ID: <5550D011.3050501 at masslnc.org>
>>>> Content-Type: text/plain; charset="utf-8"; Format="flowed"
>>>>
>>>> To follow up on what Rogan said, if you don't need a copy record
>>>> associated with them, I would recommend using Located URIs -
>>>>
>>>> http://docs.evergreen-ils.org/2.8/_cataloging_electronic_resources_8201_8212_8201_finding_them_in_catalog_searches.html
>>>>
>>>> Kathy
>>>>
>>>> On 05/11/2015 11:47 AM, Rogan Hamby wrote:
>>>> > My question is do you need copy records associated with them? Are you
>>>> > linking out to the use link in an 856?
>>>> >
>>>> > On Monday, May 11, 2015, Teri Arp <teri.arp at asburyseminary.edu
>>>> > <mailto:teri.arp at asburyseminary.edu>> wrote:
>>>> >
>>>> > When e-books are purchased from Ebsco, we follow the same workflow
>>>> > as our print books. That is, a bib record is downloaded with an
>>>> > attached 962 field that generates a copy/item record on import and
>>>> > populates the Purchase Order. After the titles have been received,
>>>> > the circulation status appears as "In Process".
>>>> >
>>>> > What is the best way to batch change e-books from "In Process" to
>>>> > "Available"?
>>>> >
>>>> > Better still, is there a way for new e-books to default to the
>>>> > "Available" status?
>>>> >
>>>> > Thank you!
>>>> > --
>>>> > Teri Arp
>>>> > Acquisitions Specialist
>>>> > B. L. Fisher Library
>>>> > Asbury Theological Seminary
>>>> > 204 N. Lexington Ave
>>>> > Wilmore KY 40390
>>>> >
>>>> >
>>>> >
>>>> > --
>>>> >
>>>> > 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>
>>>> >
>>>>
>>>> --
>>>> Kathy Lussier
>>>> Project Coordinator
>>>> Massachusetts Library Network Cooperative
>>>> (508) 343-0128
>>>> klussier at masslnc.org
>>>> Twitter: http://www.twitter.com/kmlussier
>>>>
>>>> -------------- next part --------------
>>>> An HTML attachment was scrubbed...
>>>> URL: <
>>>> http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20150511/dbd8b45e/attachment-0001.html
>>>> >
>>>>
>>>> End of Open-ils-general Digest, Vol 107, Issue 9
>>>> ************************************************
>>>>
>>>
>>>
>>>
>>> --
>>> Teri Arp
>>> Acquisitions Specialist
>>> B. L. Fisher Library
>>> Asbury Theological Seminary
>>> 204 N. Lexington Ave
>>> Wilmore KY 40390
>>>
>>
>>
>> --
>>
>> 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
> (859) 858-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>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20150511/b79040a6/attachment-0001.html>
More information about the Open-ils-general
mailing list