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

[Rogan Hamby]

Hi Jennifer,

There are a couple of ways to go about this.  You could do an IN LIST for
the tag value to get the 001 and 035.  If you only want the 035$a though
that could be an issue (though you may not have many non subfield 'a's).



On Tue, Sep 13, 2016 at 5:22 PM, Walz, Jennifer <jlwalz at asbury.edu> wrote:

> All –
>
>
>
> One more follow up question.    Or maybe two.  J
>
>
>
>   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> 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
>
>
>
>
>
>
> --
>
> Chris Sharp
>
> PINES System Administrator
>
> Georgia Public Library Service
>
> 1800 Century Place, Suite 150
>
> Atlanta, Georgia 30345
> (404) 235-7147
>



-- 
--------------------------------------------------------------
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/20160914/761fc595/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/20160914/761fc595/attachment-0001.jpg>