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

Tue Sep 13 17:22:13 EDT 2016

All –

One more follow up question.    Or maybe two.  ☺

  Is there a way to get the reports to spit out all items – including those with a blank field?     In other words, how to show all and not just those that have data in that field.

  And second, is there a way to look for BOTH the 001 and the 035 and spit out both in the results?

Thanks!

Jennifer

From: Open-ils-general [mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of Chris Sharp
Sent: Tuesday, September 13, 2016 8:17 AM
To: Evergreen Discussion Group
Subject: Re: [OPEN-ILS-GENERAL] Getting OCLC numbers out of the Reports

Jennifer,
Just leave the Field Transform as "Raw Data" and the Operator as "Equals" and it should work as you're expecting.  For a MARC field with subfields, you would want to add an additional filter of subfield as Rogan's example suggests.
Hope that helps!
Chris

On Mon, Sep 12, 2016 at 7:44 PM, Walz, Jennifer <jlwalz at asbury.edu<mailto: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:

[cid:image001.jpg at 01D20DE3.715B93D0]

(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<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<mailto: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.  ☺

  Thanks!

Jennifer
--------------------------------------------------
Jennifer Walz, MLS - Head of ILS confusion
Kinlaw Library  - Asbury University
1 Macklem Drive, Wilmore, KY 40390
859-858-3511 ext. 2269<tel:859-858-3511%20ext.%202269>
jlwalz at asbury.edu<mailto:jlwalz at asbury.edu>

From: Open-ils-general [mailto:open-ils-general-bounces at list.georgialibraries.org<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<mailto: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<tel:859-858-3511%20ext.%202269>
jlwalz at asbury.edu<mailto:jlwalz at asbury.edu>

--
--------------------------------------------------------------
Rogan R. Hamby, Data and Project Analyst
Equinox - Open Your Library
rogan at esilibrary.com<mailto:rogan at esilibrary.com>
1-877-OPEN-ILS | www.esilibrary.com<http://www.esilibrary.com>

--
--------------------------------------------------------------
Rogan R. Hamby, Data and Project Analyst
Equinox - Open Your Library
rogan at esilibrary.com<mailto:rogan at esilibrary.com>
1-877-OPEN-ILS | www.esilibrary.com<http://www.esilibrary.com>

--
Chris Sharp
PINES System Administrator
Georgia Public Library Service
1800 Century Place, Suite 150
Atlanta, Georgia 30345
(404) 235-7147
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20160913/7f214a0a/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 23431 bytes
Desc: image001.jpg
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20160913/7f214a0a/attachment-0001.jpg>