[OPEN-ILS-GENERAL] Getting OCLC numbers out of the Reports

Tue Sep 13 13:49:05 EDT 2016

To follow up with what Elaine said, if you are configured like we are so
that the OCLC number goes into the title control number field, then if you
are using the Item source, you can get the TCN field at Item > Call Number
/ Volume > Bib Record > TCN Value.   (And if you have Classic Item List
enabled, it's easier because TCN is one of the main/top-level fields.)

Terran McCanna
PINES Program Manager
Georgia Public Library Service
1800 Century Place, Suite 150
Atlanta, GA 30345
404-235-7138
tmccanna at georgialibraries.org

On Tue, Sep 13, 2016 at 1:33 PM, Elaine Hardy <ehardy at georgialibraries.org>
wrote:

> Prior to a record being imported from OCLC, the OCLC tcn is in the 001. If
> you have the Global setting "Maintain 001-003-035 according MARC" set to
> true, then the OCLC tcn will be transferred to 035s (one with the ocm/ocn
> prefix and one without) and a locally assigned record id number will be in
> the 001. The 003 will be or local control number identifier for the 001
> (from https://www.loc.gov/marc/bibliographic/ecbdorg.html). Since PINES
> has this set for true, I am not sure what the behavior is for false, other
> than that the locally assigned 001 becomes the record TCN in your database.
> I don't know what happens to the OCLC tcn -- it may be retained in an 035.
>
> Both the 001 and the 035 are system supplied. The 001 is not editable --
> attempts to edit will add an additional 035 while retaining the system
> supplied 001.
>
> If all your records are from OCLC, and the flag set to true, then all
> your records should have an 035 with the OCLC tcn. If you have the global
> flag set to true, for those records imported since you migrated to
> Evergreen, you will likely have two 035s, such as:
>
> 035        ‡a(OCoLC)ocn276335043
>
> 035        ‡a(OCoLC)276335043
>
>
>
>
>
>
> J. Elaine Hardy
> PINES & Collaborative Projects Manager
> Georgia Public Library Service/PINES
> 1800 Century Place, Ste. 150
> Atlanta, GA 30045
>
> 404.235.7128 Office
> 404.548.4241 Cell
> 404.235.7201 FAX
>
> On Tue, Sep 13, 2016 at 8:18 AM, Rogan Hamby <rhamby at esilibrary.com>
> wrote:
>
>>
>> The tag can just be equals.  If you're not familiar with MARC record
>> conventions I'd like to recommend bringing a few up in the staff client.
>> That will give you an idea of how the tags and subfields are structured and
>> you can see some examples of your own records and where the oclc might be
>> stored.
>>
>> Unfortunately with MARC data there is no universal truth, at least as
>> long as we are relying on people to put things places.  This is where I
>> insert my usual low key rant about the value of a good cataloger
>> maintaining consistency in a database.  :)
>>
>> You will want to tailor your reports around your data so I can't tell you
>> the best course of action in that regard.  There are Evergreen settings
>> that can affect what is where.  The 001 may have a tcn or may have a bib id
>> depending on your settings.
>>
>> In the spirit of many ways to do things you may also want to look at the
>> tcn value in the bib record data source.
>>
>> A quick aside about OCLC numbers ... we throw around discussing OCLC
>> numbers as control numbers because they are by far the single most common
>> kind and OCLC's reach is pretty far but there is no guarentee of an OCLC
>> number anywhere in a MARC record.  035 is the system control number which
>> may be OCLC or may not, if your system is predominately OCLC records then
>> it might be useful for that.  There are valid subfields other than $a so if
>> you don't filter by $a you may get others.  Some you may want, for example,
>> the $z is the canceled or invalid control number, which depending on your
>> purpose may be useful (it's also rare in my experience but not unknown).
>>
>> In contrast to the System Control Number the 001 is the Control Number or
>> Title Control Number.  It is not uncommon to find an OCLC number in there,
>> especially in heavy OCLC use systems.  I've seen libraries with less than
>> 1% OCLC numbers and libraries with less than 1% that aren't.  Since I don't
>> know your data I can't tell you what you'll find.
>>
>> I know you wanted more of a "here is a definitive answer" kind of answer
>> but without seeing your data I can't do that.  Even then depending on the
>> consistency of the records there may not be an answer your want (or your
>> records may be perfect and there is!).
>>
>>
>>
>> On Mon, Sep 12, 2016 at 7:44 PM, Walz, Jennifer <jlwalz at asbury.edu>
>> wrote:
>>
>>> Rogan,
>>>
>>>
>>>
>>> Do I have to do BOTH the tag and the subfield?   And is 035 the only
>>> place in the marc where the oclc number is?   I was told it was in 001.
>>> And this is how I have been doing it thus far, but getting weird results:
>>>
>>>
>>>
>>>
>>>
>>> (my results were at least to show me something from that field!)
>>> Should I just do “raw data” and “equals” and “035” or “001”?     When I did
>>> that, it was giving me an error…
>>>
>>>
>>>
>>> Thanks!
>>>
>>>
>>>
>>> Jennifer
>>>
>>>
>>>
>>> *From:* Open-ils-general [mailto:open-ils-general-bounc
>>> es at list.georgialibraries.org] *On Behalf Of *Rogan Hamby
>>> *Sent:* Monday, September 12, 2016 7:11 PM
>>>
>>> *To:* Evergreen Discussion Group
>>> *Subject:* Re: [OPEN-ILS-GENERAL] Getting OCLC numbers out of the
>>> Reports
>>>
>>>
>>>
>>> Jennifer,
>>>
>>>
>>>
>>> There isn't much more to it.  Use the flattened attributes as a filter
>>> and filter by tag = '035' and subfield = 'a' in addition to the other
>>> filters you use.  Display the normalized value.  That's it.  Add that onto
>>> your existing report for the others values to get the 035.  One downside is
>>> that if a record doesn't have a 035 it won't display though.
>>>
>>>
>>>
>>> On Mon, Sep 12, 2016 at 6:41 PM, Walz, Jennifer <jlwalz at asbury.edu>
>>> wrote:
>>>
>>> Rogan,
>>>
>>>
>>>
>>> Thanks for the reply.   I already figured that I should probably be
>>> looking at the flattened MARC fields section, but how do I use those to
>>> extract the OCLC number from the MARC field?    Can I select a particular
>>> MARC field to appear only in the output?  How do I tell the system to show
>>> me just that one field and not all of them?
>>>
>>>
>>>
>>>   Specifics please.  J
>>>
>>>
>>>
>>>   Thanks!
>>>
>>>
>>>
>>> Jennifer
>>>
>>> --------------------------------------------------
>>> Jennifer Walz, MLS - Head of ILS confusion
>>> Kinlaw Library  - Asbury University
>>> 1 Macklem Drive, Wilmore, KY 40390
>>> 859-858-3511 ext. 2269
>>> jlwalz at asbury.edu
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> *From:* Open-ils-general [mailto:open-ils-general-bounc
>>> es at list.georgialibraries.org] *On Behalf Of *Rogan Hamby
>>> *Sent:* Monday, September 12, 2016 6:34 PM
>>> *To:* Evergreen Discussion Group
>>> *Subject:* Re: [OPEN-ILS-GENERAL] Getting OCLC numbers out of the
>>> Reports
>>>
>>>
>>>
>>> From the Bibliographic Record data source if you go to Flattened MARC
>>> Fields you can filter by Subfield / Tag etc... to get the 035 if you want.
>>> The rest of what you mentioned (title, author, pub date) I would grab from
>>> the Simple Record Extracts.
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> On Mon, Sep 12, 2016 at 3:35 PM, Walz, Jennifer <jlwalz at asbury.edu>
>>> wrote:
>>>
>>> All –
>>>
>>>
>>>
>>> I would like to run a report to get some basic bibliographic info
>>> (title, author, pub date) PLUS the oclc number.  Which source is best?
>>> And then how to I get the OCLC number to show up in the output?  I cannot
>>> seem to find the right fields and such to get to that data.    How do I get
>>> the OCLC number to display in the output for each title?     Can anyone
>>> point me in the right direction?
>>>
>>>
>>>
>>>   We would like to filter on shelving location and possibly include the
>>> call number and barcode.
>>>
>>>
>>> Thanks!
>>>
>>>
>>>
>>> Jennifer
>>>
>>> --------------------------------------------------
>>> Jennifer Walz, MLS - Head of Research & Distance Services
>>> Kinlaw Library -  *Asbury University*
>>> One Macklem Drive, Wilmore, KY 40390
>>> 859-858-3511 ext. 2269
>>> jlwalz at asbury.edu
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> --
>>>
>>> --------------------------------------------------------------
>>>
>>> Rogan R. Hamby, Data and Project Analyst
>>>
>>> Equinox - Open Your Library
>>>
>>> rogan at esilibrary.com
>>>
>>> 1-877-OPEN-ILS | www.esilibrary.com
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> --
>>>
>>> --------------------------------------------------------------
>>>
>>> Rogan R. Hamby, Data and Project Analyst
>>>
>>> Equinox - Open Your Library
>>>
>>> rogan at esilibrary.com
>>>
>>> 1-877-OPEN-ILS | www.esilibrary.com
>>>
>>>
>>>
>>
>>
>>
>> --
>> --------------------------------------------------------------
>> Rogan R. Hamby, Data and Project Analyst
>> Equinox - Open Your Library
>> rogan at esilibrary.com
>> 1-877-OPEN-ILS | www.esilibrary.com
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20160913/cfeb2656/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 23431 bytes
Desc: not available
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20160913/cfeb2656/attachment-0001.jpg>