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 < [email protected]> 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 <[email protected]> > 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 <[email protected]> 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, < >>> [email protected]> wrote: >>> >>>> Send Open-ils-general mailing list submissions to >>>> [email protected] >>>> >>>> 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 >>>> [email protected] >>>> >>>> You can reach the person managing the list at >>>> [email protected] >>>> >>>> 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 <[email protected]> >>>> To: Evergreen Community Reports Email List >>>> <[email protected]>, >>>> [email protected] >>>> Subject: [OPEN-ILS-GENERAL] Reports Interest Group Google Hangout >>>> Message-ID: >>>> <CAPK8= >>>> [email protected]> >>>> 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 [email protected]. 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 <[email protected]> >>>> To: [email protected] >>>> Subject: [OPEN-ILS-GENERAL] eBook circulation status >>>> Message-ID: >>>> <CADneUoZM+AOBsyWRYQ-Ve9+nu74bSuzn0= >>>> [email protected]> >>>> 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 <[email protected]> >>>> To: Evergreen Discussion Group >>>> <[email protected]> >>>> Subject: Re: [OPEN-ILS-GENERAL] eBook circulation status >>>> Message-ID: >>>> < >>>> cafpcapxrwz4bs4p9-4puqx8gnbm1+mzyf3jyqji73ydtoon...@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 <[email protected]> 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 <[email protected]> >>>> To: [email protected] >>>> Subject: Re: [OPEN-ILS-GENERAL] eBook circulation status >>>> Message-ID: <[email protected]> >>>> 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 <[email protected] >>>> > <mailto:[email protected]>> 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 >>>> [email protected] >>>> 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 > [email protected] > (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>
