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

Tue Sep 13 08:18:40 EDT 2016

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