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

[Elaine Hardy]

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/f345ce49/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/f345ce49/attachment-0001.jpg>