Re: [OPEN-ILS-GENERAL] Publisher in Evergreen Reports

[Mary Llewellyn]

Hi Janet,

You inspired me to tweak my Vandelay queue display. I figured out how to
combine the two publisher tags, and now I don't have any empty boxes in the
publisher column.

*//*[@tag="260" or @tag="264"]/*[@code="b"]*

I tried the same thing with the pub dates, but ended up with two dates
strung together when there are 2 264 tags for the differing types of dates.
I either need to now how to insert a space between them, or how to skip one
iteration based on indicator values.

/*/*[@tag="260"or @tag="264"]/*[@code="c"] Remove \D*  (That last part
was already in place, I don't really know what it means.)

Anyway, thanks for the inspiration!

Mary


On Tue, Jun 11, 2019 at 2:59 PM Janet Schrader  wrote:

> Hi,
> I do not do reports, but I can say that in Vandelay I have two columns for
> publisher: Publisher and Publisher RDA and likewise two columns for Pub
> date and Pub date RDA. I have this attribute definition for the RDA
> publisher. Is it possible to use this for reports?
> *264  b  //*[@tag="264"]/*[@code="b"]*
>
>
> Janet
>
>
> Janet Schrader
>
> Bibliographic Services Supervisor | CW MARS
>
> 67 Millbrook Street, Suite 201, Worcester, MA 01606
>
> P: 508-755-3323 x 325 | F: 508-757-7801
>
> --
>
> jschra...@cwmars.org  ||  http;//cwmars.org 
>
>
>
> On Tue, Jun 11, 2019 at 12:51 PM Jane Sandberg 
> wrote:
>
>> John Yorio at Equinox helped me track this down in our system.  John
>> found out that the issue was that Evergreen uses the Library of Congress'
>> MARC->MODS 3.3 mapping, which only includes 260$b publishers.  See
>> https://www.loc.gov/standards/mods/v3/mods-mapping-3-3.html#publication
>>
>> I think a bug report would be a good idea.
>>
>> On Tue, Jun 11, 2019 at 8:45 AM Patrick, Irene 
>> wrote:
>>
>>> Someone here asked me for a report that includes the Publisher
>>> information.  In the report I created, I used the Simple Record Extracts to
>>> pull the “Publisher (normalized)” field into the report.  Unfortunately, in
>>> the output, the Publisher column was mostly empty.  On investigation, it
>>> appears that records with the publisher in the 264 are not included in the
>>> output.  Only records where the publisher is in the 260 have the publisher
>>> information show up in the output.
>>>
>>>
>>>
>>> We are on Evergreen 3.1.6.  I’ve searched Launchpad, but I don’t find
>>> anything about this issue.  Has it been corrected in a later release?  Or
>>> do we need to create a bug report?
>>>
>>>
>>>
>>> Or should I use a different method to get the publisher information into
>>> the report?
>>>
>>>
>>>
>>> *Irene Patrick *
>>>
>>> Library & Information Management Systems Librarian, NC Government &
>>> Heritage Library
>>>
>>> NC Dept. of Natural and Cultural Resources
>>>
>>> 919.814.6788  |  irene.patr...@ncdcr.gov
>>>
>>>
>>>
>>> 109 E. Jones Street  | 4640 Mail Service Center
>>>
>>> Raleigh, North Carolina 27699-4600
>>>
>>> Facebook   Instagram
>>>   Twitter
>>>   YouTube
>>>   Website
>>> 
>>>
>>>
>>>
>>> *Email correspondence to and from this address is subject to the North
>>> Carolina Public Records Law and may be disclosed to third parties.*
>>>
>>>
>>>
>>
>>
>> --
>> Jane Sandberg
>> Electronic Resources Librarian
>> Linn-Benton Community College
>> sand...@linnbenton.edu / 541-917-4655
>> Pronouns: she/her/hers
>>
>

-- 
Mary Llewellyn
Database Manager
Bibliomation, Inc.
24 Wooster Ave.
Waterbury, CT 06708
mllew...@biblio.org

Re: [OPEN-ILS-GENERAL] Publisher in Evergreen Reports

[Mike Rylander]

Hi Mary, I believe I can help with your XPath questions.

If you wanted to get just the "current/latest" dates, and only publication
dates (as opposed to distribution, etc) you could do something like this:

 //*[(@tag="260" and @ind1="3") or (@tag="264" and @ind1="3" and
@ind2="1")]/*[@code="c"]

I imagine the indicator 1 values may be too strict, though.  To get just
the first found in the record (and without the perhaps-too-strict indicator
1 tests):

 //*[@tag="260" or (@tag="264" and @ind2="1")]/*[@code="c"][1]

And to get the last, presumably the 264 if it exists:

 //*[@tag="260" or (@tag="264" and @ind2="1")]/*[@code="c"][last()]

Ordering is based on document element order, FWIW.

And, finally, the "Remove \D" refers to removing non-numeric characters
from the extracted string.

HTH,

--
Mike Rylander
 | Executive Director
 | Equinox Open Library Initiative
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@equinoxinitiative.org
 | web:  http://equinoxinitiative.org


On Fri, Jun 14, 2019 at 2:48 PM Mary Llewellyn  wrote:

> Hi Janet,
>
> You inspired me to tweak my Vandelay queue display. I figured out how to
> combine the two publisher tags, and now I don't have any empty boxes in the
> publisher column.
>
> *//*[@tag="260" or @tag="264"]/*[@code="b"]*
>
> I tried the same thing with the pub dates, but ended up with two dates
> strung together when there are 2 264 tags for the differing types of dates.
> I either need to now how to insert a space between them, or how to skip one
> iteration based on indicator values.
>
> /*/*[@tag="260"or @tag="264"]/*[@code="c"] Remove \D*  (That last
> part was already in place, I don't really know what it means.)
>
> Anyway, thanks for the inspiration!
>
> Mary
>
>
> On Tue, Jun 11, 2019 at 2:59 PM Janet Schrader 
> wrote:
>
>> Hi,
>> I do not do reports, but I can say that in Vandelay I have two columns
>> for publisher: Publisher and Publisher RDA and likewise two columns for Pub
>> date and Pub date RDA. I have this attribute definition for the RDA
>> publisher. Is it possible to use this for reports?
>> *264  b  //*[@tag="264"]/*[@code="b"]*
>>
>>
>> Janet
>>
>>
>> Janet Schrader
>>
>> Bibliographic Services Supervisor | CW MARS
>>
>> 67 Millbrook Street, Suite 201, Worcester, MA 01606
>>
>> P: 508-755-3323 x 325 | F: 508-757-7801
>>
>> --
>>
>> jschra...@cwmars.org  ||  http;//cwmars.org 
>>
>>
>>
>> On Tue, Jun 11, 2019 at 12:51 PM Jane Sandberg 
>> wrote:
>>
>>> John Yorio at Equinox helped me track this down in our system.  John
>>> found out that the issue was that Evergreen uses the Library of Congress'
>>> MARC->MODS 3.3 mapping, which only includes 260$b publishers.  See
>>> https://www.loc.gov/standards/mods/v3/mods-mapping-3-3.html#publication
>>>
>>> I think a bug report would be a good idea.
>>>
>>> On Tue, Jun 11, 2019 at 8:45 AM Patrick, Irene 
>>> wrote:
>>>
 Someone here asked me for a report that includes the Publisher
 information.  In the report I created, I used the Simple Record Extracts to
 pull the “Publisher (normalized)” field into the report.  Unfortunately, in
 the output, the Publisher column was mostly empty.  On investigation, it
 appears that records with the publisher in the 264 are not included in the
 output.  Only records where the publisher is in the 260 have the publisher
 information show up in the output.



 We are on Evergreen 3.1.6.  I’ve searched Launchpad, but I don’t find
 anything about this issue.  Has it been corrected in a later release?  Or
 do we need to create a bug report?



 Or should I use a different method to get the publisher information
 into the report?



 *Irene Patrick *

 Library & Information Management Systems Librarian, NC Government &
 Heritage Library

 NC Dept. of Natural and Cultural Resources

 919.814.6788  |  irene.patr...@ncdcr.gov



 109 E. Jones Street  | 4640 Mail Service Center

 Raleigh, North Carolina 27699-4600

 Facebook   Instagram
   Twitter
   YouTube
   Website
 



 *Email correspondence to and from this address is subject to the North
 Carolina Public Records Law and may be disclosed to third parties.*



>>>
>>>
>>> --
>>> Jane Sandberg
>>> Electronic Resources Librarian
>>> Linn-Benton Community College
>>> sand...@linnbenton.edu / 541-917-4655
>>> Pronouns: she/her/hers
>>>
>>
>
> --
> Mary Llewellyn
> Database Manager
> Bibliomation, Inc.
> 24 Wooster Ave.
> Waterbury, CT 06708
> mllew...@biblio.org
>

Re: [OPEN-ILS-GENERAL] Publisher in Evergreen Reports

[Janet Schrader]

Hi Mary,

I'm glad my comment was helpful to you. Does this mean you edited the bib
record attributes? Does it affect anything else or is it just the Vandelay
display? I might be brave enough to do that. I also have the 'remove \D and
no clue what it is.

I don't think I'll try this on a Friday afternoon though, not when I'm
trying to disentangle items belonging to the color edition of the graphic
novel series The Baby Sitter's Club from the original b edition published
2006-2011 when all ISBNs and descriptions have been mushed into one serial
record in OCLC (#908950873) and someone downloaded it into our database.
Not a continuation of the series, the same titles published now in glorious
color. Does it matter? Who cares?  I'm in the process of removing the
incorrect ISBNs. Good thing there are only six volumes.


Janet


Janet Schrader

Bibliographic Services Supervisor | CW MARS

67 Millbrook Street, Suite 201, Worcester, MA 01606

P: 508-755-3323 x 325 | F: 508-757-7801

--

jschra...@cwmars.org  ||  http;//cwmars.org 



On Fri, Jun 14, 2019 at 2:48 PM Mary Llewellyn  wrote:

> Hi Janet,
>
> You inspired me to tweak my Vandelay queue display. I figured out how to
> combine the two publisher tags, and now I don't have any empty boxes in the
> publisher column.
>
> *//*[@tag="260" or @tag="264"]/*[@code="b"]*
>
> I tried the same thing with the pub dates, but ended up with two dates
> strung together when there are 2 264 tags for the differing types of dates.
> I either need to now how to insert a space between them, or how to skip one
> iteration based on indicator values.
>
> /*/*[@tag="260"or @tag="264"]/*[@code="c"] Remove \D*  (That last
> part was already in place, I don't really know what it means.)
>
> Anyway, thanks for the inspiration!
>
> Mary
>
>
> On Tue, Jun 11, 2019 at 2:59 PM Janet Schrader 
> wrote:
>
>> Hi,
>> I do not do reports, but I can say that in Vandelay I have two columns
>> for publisher: Publisher and Publisher RDA and likewise two columns for Pub
>> date and Pub date RDA. I have this attribute definition for the RDA
>> publisher. Is it possible to use this for reports?
>> *264  b  //*[@tag="264"]/*[@code="b"]*
>>
>>
>> Janet
>>
>>
>> Janet Schrader
>>
>> Bibliographic Services Supervisor | CW MARS
>>
>> 67 Millbrook Street, Suite 201, Worcester, MA 01606
>>
>> P: 508-755-3323 x 325 | F: 508-757-7801
>>
>> --
>>
>> jschra...@cwmars.org  ||  http;//cwmars.org 
>>
>>
>>
>> On Tue, Jun 11, 2019 at 12:51 PM Jane Sandberg 
>> wrote:
>>
>>> John Yorio at Equinox helped me track this down in our system.  John
>>> found out that the issue was that Evergreen uses the Library of Congress'
>>> MARC->MODS 3.3 mapping, which only includes 260$b publishers.  See
>>> https://www.loc.gov/standards/mods/v3/mods-mapping-3-3.html#publication
>>>
>>> I think a bug report would be a good idea.
>>>
>>> On Tue, Jun 11, 2019 at 8:45 AM Patrick, Irene 
>>> wrote:
>>>
 Someone here asked me for a report that includes the Publisher
 information.  In the report I created, I used the Simple Record Extracts to
 pull the “Publisher (normalized)” field into the report.  Unfortunately, in
 the output, the Publisher column was mostly empty.  On investigation, it
 appears that records with the publisher in the 264 are not included in the
 output.  Only records where the publisher is in the 260 have the publisher
 information show up in the output.



 We are on Evergreen 3.1.6.  I’ve searched Launchpad, but I don’t find
 anything about this issue.  Has it been corrected in a later release?  Or
 do we need to create a bug report?



 Or should I use a different method to get the publisher information
 into the report?



 *Irene Patrick *

 Library & Information Management Systems Librarian, NC Government &
 Heritage Library

 NC Dept. of Natural and Cultural Resources

 919.814.6788  |  irene.patr...@ncdcr.gov



 109 E. Jones Street  | 4640 Mail Service Center

 Raleigh, North Carolina 27699-4600

 Facebook   Instagram
   Twitter
   YouTube
   Website
 



 *Email correspondence to and from this address is subject to the North
 Carolina Public Records Law and may be disclosed to third parties.*



>>>
>>>
>>> --
>>> Jane Sandberg
>>> Electronic Resources Librarian
>>> Linn-Benton Community College
>>> sand...@linnbenton.edu / 541-917-4655
>>> Pronouns: she/her/hers
>>>
>>
>
> --
> Mary Llewellyn
> Database Manager
> Bibliomation, Inc.
> 24 Wooster Ave.
> Waterbury, CT 06708
> mllew...@biblio.org
>

Re: [OPEN-ILS-GENERAL] Publisher in Evergreen Reports

[Mary Llewellyn]

Hi Mike,

Thanks! I'll probably look at all this more closely next week. It's too
late on a Friday afternoon to think clearly.

Mary


On Fri, Jun 14, 2019 at 3:09 PM Mike Rylander  wrote:

> Hi Mary, I believe I can help with your XPath questions.
>
> If you wanted to get just the "current/latest" dates, and only publication
> dates (as opposed to distribution, etc) you could do something like this:
>
>  //*[(@tag="260" and @ind1="3") or (@tag="264" and @ind1="3" and
> @ind2="1")]/*[@code="c"]
>
> I imagine the indicator 1 values may be too strict, though.  To get just
> the first found in the record (and without the perhaps-too-strict indicator
> 1 tests):
>
>  //*[@tag="260" or (@tag="264" and @ind2="1")]/*[@code="c"][1]
>
> And to get the last, presumably the 264 if it exists:
>
>  //*[@tag="260" or (@tag="264" and @ind2="1")]/*[@code="c"][last()]
>
> Ordering is based on document element order, FWIW.
>
> And, finally, the "Remove \D" refers to removing non-numeric characters
> from the extracted string.
>
> HTH,
>
> --
> Mike Rylander
>  | Executive Director
>  | Equinox Open Library Initiative
>  | phone:  1-877-OPEN-ILS (673-6457)
>  | email:  mi...@equinoxinitiative.org
>  | web:  http://equinoxinitiative.org
>
>
> On Fri, Jun 14, 2019 at 2:48 PM Mary Llewellyn 
> wrote:
>
>> Hi Janet,
>>
>> You inspired me to tweak my Vandelay queue display. I figured out how to
>> combine the two publisher tags, and now I don't have any empty boxes in the
>> publisher column.
>>
>> *//*[@tag="260" or @tag="264"]/*[@code="b"]*
>>
>> I tried the same thing with the pub dates, but ended up with two dates
>> strung together when there are 2 264 tags for the differing types of dates.
>> I either need to now how to insert a space between them, or how to skip one
>> iteration based on indicator values.
>>
>> /*/*[@tag="260"or @tag="264"]/*[@code="c"] Remove \D*  (That last
>> part was already in place, I don't really know what it means.)
>>
>> Anyway, thanks for the inspiration!
>>
>> Mary
>>
>>
>> On Tue, Jun 11, 2019 at 2:59 PM Janet Schrader 
>> wrote:
>>
>>> Hi,
>>> I do not do reports, but I can say that in Vandelay I have two columns
>>> for publisher: Publisher and Publisher RDA and likewise two columns for Pub
>>> date and Pub date RDA. I have this attribute definition for the RDA
>>> publisher. Is it possible to use this for reports?
>>> *264  b  //*[@tag="264"]/*[@code="b"]*
>>>
>>>
>>> Janet
>>>
>>>
>>> Janet Schrader
>>>
>>> Bibliographic Services Supervisor | CW MARS
>>>
>>> 67 Millbrook Street, Suite 201, Worcester, MA 01606
>>>
>>> P: 508-755-3323 x 325 | F: 508-757-7801
>>>
>>> --
>>>
>>> jschra...@cwmars.org  ||  http;//cwmars.org 
>>>
>>>
>>>
>>> On Tue, Jun 11, 2019 at 12:51 PM Jane Sandberg 
>>> wrote:
>>>
 John Yorio at Equinox helped me track this down in our system.  John
 found out that the issue was that Evergreen uses the Library of Congress'
 MARC->MODS 3.3 mapping, which only includes 260$b publishers.  See
 https://www.loc.gov/standards/mods/v3/mods-mapping-3-3.html#publication

 I think a bug report would be a good idea.

 On Tue, Jun 11, 2019 at 8:45 AM Patrick, Irene 
 wrote:

> Someone here asked me for a report that includes the Publisher
> information.  In the report I created, I used the Simple Record Extracts 
> to
> pull the “Publisher (normalized)” field into the report.  Unfortunately, 
> in
> the output, the Publisher column was mostly empty.  On investigation, it
> appears that records with the publisher in the 264 are not included in the
> output.  Only records where the publisher is in the 260 have the publisher
> information show up in the output.
>
>
>
> We are on Evergreen 3.1.6.  I’ve searched Launchpad, but I don’t find
> anything about this issue.  Has it been corrected in a later release?  Or
> do we need to create a bug report?
>
>
>
> Or should I use a different method to get the publisher information
> into the report?
>
>
>
> *Irene Patrick *
>
> Library & Information Management Systems Librarian, NC Government &
> Heritage Library
>
> NC Dept. of Natural and Cultural Resources
>
> 919.814.6788  |  irene.patr...@ncdcr.gov
>
>
>
> 109 E. Jones Street  | 4640 Mail Service Center
>
> Raleigh, North Carolina 27699-4600
>
> Facebook   Instagram
>   Twitter
>   YouTube
>   Website
> 
>
>
>
> *Email correspondence to and from this address is subject to the North
> Carolina Public Records Law and may be disclosed to third parties.*
>
>
>


 --
 Jane Sandberg
 Electronic 

Re: [OPEN-ILS-GENERAL] Publisher in Evergreen Reports

[Mary Llewellyn]

Hi Janet,

I did it in the Record Display Attributes tab under Cataloging/Marc Batch
Import/Export. It should only affect the display in the bib queue. (Learned
the hard way that a typo of "ot" instead of "or" will cause the load to
fail. Oops.)

You may have already seen Mike's explanation for the * Remove \D  . *It
removes non-numeric characters from the string (like [ ], c, etc.)

Good luck with that Baby Sitter's Club herculean task. Fun way to end the
week!

Mary


On Fri, Jun 14, 2019 at 3:18 PM Janet Schrader  wrote:

> Hi Mary,
>
> I'm glad my comment was helpful to you. Does this mean you edited the bib
> record attributes? Does it affect anything else or is it just the Vandelay
> display? I might be brave enough to do that. I also have the 'remove \D and
> no clue what it is.
>
> I don't think I'll try this on a Friday afternoon though, not when I'm
> trying to disentangle items belonging to the color edition of the graphic
> novel series The Baby Sitter's Club from the original b edition published
> 2006-2011 when all ISBNs and descriptions have been mushed into one serial
> record in OCLC (#908950873) and someone downloaded it into our database.
> Not a continuation of the series, the same titles published now in glorious
> color. Does it matter? Who cares?  I'm in the process of removing the
> incorrect ISBNs. Good thing there are only six volumes.
>
>
> Janet
>
>
> Janet Schrader
>
> Bibliographic Services Supervisor | CW MARS
>
> 67 Millbrook Street, Suite 201, Worcester, MA 01606
>
> P: 508-755-3323 x 325 | F: 508-757-7801
>
> --
>
> jschra...@cwmars.org  ||  http;//cwmars.org 
>
>
>
> On Fri, Jun 14, 2019 at 2:48 PM Mary Llewellyn 
> wrote:
>
>> Hi Janet,
>>
>> You inspired me to tweak my Vandelay queue display. I figured out how to
>> combine the two publisher tags, and now I don't have any empty boxes in the
>> publisher column.
>>
>> *//*[@tag="260" or @tag="264"]/*[@code="b"]*
>>
>> I tried the same thing with the pub dates, but ended up with two dates
>> strung together when there are 2 264 tags for the differing types of dates.
>> I either need to now how to insert a space between them, or how to skip one
>> iteration based on indicator values.
>>
>> /*/*[@tag="260"or @tag="264"]/*[@code="c"] Remove \D*  (That last
>> part was already in place, I don't really know what it means.)
>>
>> Anyway, thanks for the inspiration!
>>
>> Mary
>>
>>
>> On Tue, Jun 11, 2019 at 2:59 PM Janet Schrader 
>> wrote:
>>
>>> Hi,
>>> I do not do reports, but I can say that in Vandelay I have two columns
>>> for publisher: Publisher and Publisher RDA and likewise two columns for Pub
>>> date and Pub date RDA. I have this attribute definition for the RDA
>>> publisher. Is it possible to use this for reports?
>>> *264  b  //*[@tag="264"]/*[@code="b"]*
>>>
>>>
>>> Janet
>>>
>>>
>>> Janet Schrader
>>>
>>> Bibliographic Services Supervisor | CW MARS
>>>
>>> 67 Millbrook Street, Suite 201, Worcester, MA 01606
>>>
>>> P: 508-755-3323 x 325 | F: 508-757-7801
>>>
>>> --
>>>
>>> jschra...@cwmars.org  ||  http;//cwmars.org 
>>>
>>>
>>>
>>> On Tue, Jun 11, 2019 at 12:51 PM Jane Sandberg 
>>> wrote:
>>>
 John Yorio at Equinox helped me track this down in our system.  John
 found out that the issue was that Evergreen uses the Library of Congress'
 MARC->MODS 3.3 mapping, which only includes 260$b publishers.  See
 https://www.loc.gov/standards/mods/v3/mods-mapping-3-3.html#publication

 I think a bug report would be a good idea.

 On Tue, Jun 11, 2019 at 8:45 AM Patrick, Irene 
 wrote:

> Someone here asked me for a report that includes the Publisher
> information.  In the report I created, I used the Simple Record Extracts 
> to
> pull the “Publisher (normalized)” field into the report.  Unfortunately, 
> in
> the output, the Publisher column was mostly empty.  On investigation, it
> appears that records with the publisher in the 264 are not included in the
> output.  Only records where the publisher is in the 260 have the publisher
> information show up in the output.
>
>
>
> We are on Evergreen 3.1.6.  I’ve searched Launchpad, but I don’t find
> anything about this issue.  Has it been corrected in a later release?  Or
> do we need to create a bug report?
>
>
>
> Or should I use a different method to get the publisher information
> into the report?
>
>
>
> *Irene Patrick *
>
> Library & Information Management Systems Librarian, NC Government &
> Heritage Library
>
> NC Dept. of Natural and Cultural Resources
>
> 919.814.6788  |  irene.patr...@ncdcr.gov
>
>
>
> 109 E. Jones Street  | 4640 Mail Service Center
>
> Raleigh, North Carolina 27699-4600
>
> Facebook   Instagram
>