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

[Rogan Hamby]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20160912/f126487b/attachment.html>