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

2016-09-13 Thread Walz, Jennifer 
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-boun...@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 
<jlw...@asbury.edu<mailto:jlw...@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@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-boun...@list.georgialibraries.org<mailto:open-ils-general-boun...@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 
<jlw...@asbury.edu<mailto:jlw...@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>
jlw...@asbury.edu<mailto:jlw...@asbury.edu>



From: Open-ils-general 
[mailto:open-ils-general-boun...@list.georgialibraries.org<mailto:open-ils-general-boun...@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 
<jlw...@asbury.edu<mailto:jlw...@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>
jlw...@asbury.edu<mailto:jlw...@asbury.edu>




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




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

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

2016-09-13 Thread 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 <rha...@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 <jlw...@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
>> e...@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,
>>
>>
>>
>

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

2016-09-13 Thread Rogan Hamby 
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 <jlw...@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-
> boun...@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 <jlw...@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
> jlw...@asbury.edu
>
>
>
>
>
>
>
> *From:* Open-ils-general [mailto:open-ils-general-
> boun...@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.
>
>

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

2016-09-13 Thread Chris Sharp 
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 <jlw...@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-
> boun...@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 <jlw...@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
> jlw...@asbury.edu
>
>
>
>
>
>
>
> *From:* Open-ils-general [mailto:open-ils-general-
> boun...@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 <jlw...@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
> jlw...@asbury.edu
>
>
>
>
>
>
>
> --
>
> --
>
> Rogan R. Hamby, Data and Project Analyst
>
> Equinox - Open Your Library
>
> ro...@esilibrary.com
>
> 1-877-OPEN-ILS | www.esilibrary.com
>
>
>
>
>
>
>
> --
>
> --
>
> Rogan R. Hamby, Data and Project Analyst
>
> Equinox - Open Your Library
>
> ro...@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

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

2016-09-12 Thread Walz, Jennifer 
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@01D20D2E.15E21340]

(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-boun...@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 
<jlw...@asbury.edu<mailto:jlw...@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>
jlw...@asbury.edu<mailto:jlw...@asbury.edu>



From: Open-ils-general 
[mailto:open-ils-general-boun...@list.georgialibraries.org<mailto:open-ils-general-boun...@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 
<jlw...@asbury.edu<mailto:jlw...@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>
jlw...@asbury.edu<mailto:jlw...@asbury.edu>




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




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

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

2016-09-12 Thread 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 <jlw...@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
> jlw...@asbury.edu
>
>
>
>
>
>
>
> *From:* Open-ils-general [mailto:open-ils-general-
> boun...@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 <jlw...@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
> jlw...@asbury.edu
>
>
>
>
>
>
>
> --
>
> --
>
> Rogan R. Hamby, Data and Project Analyst
>
> Equinox - Open Your Library
>
> ro...@esilibrary.com
>
> 1-877-OPEN-ILS | www.esilibrary.com
>
>
>



-- 
--
Rogan R. Hamby, Data and Project Analyst
Equinox - Open Your Library
ro...@esilibrary.com
1-877-OPEN-ILS | www.esilibrary.com

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

2016-09-12 Thread Walz, Jennifer 
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
jlw...@asbury.edu



From: Open-ils-general 
[mailto:open-ils-general-boun...@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 
<jlw...@asbury.edu<mailto:jlw...@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>
jlw...@asbury.edu<mailto:jlw...@asbury.edu>




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

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

2016-09-12 Thread Rogan Hamby 
>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  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
> jlw...@asbury.edu
>
>
>



-- 
--
Rogan R. Hamby, Data and Project Analyst
Equinox - Open Your Library
ro...@esilibrary.com
1-877-OPEN-ILS | www.esilibrary.com