[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:  miker at equinoxinitiative.org
 | web:  http://equinoxinitiative.org


On Fri, Jun 14, 2019 at 2:48 PM Mary Llewellyn <mllewell at biblio.org> 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 <jschrader at cwmars.org>
> 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
>>
>> ------------------------------
>>
>> jschrader at cwmars.org  ||  http;//cwmars.org <http://www.cwmars.org/>
>>
>>
>>
>> On Tue, Jun 11, 2019 at 12:51 PM Jane Sandberg <sandbej at linnbenton.edu>
>> 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 <irene.patrick at ncdcr.gov>
>>> 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.patrick at ncdcr.gov
>>>>
>>>>
>>>>
>>>> 109 E. Jones Street  | 4640 Mail Service Center
>>>>
>>>> Raleigh, North Carolina 27699-4600
>>>>
>>>> Facebook <http://www.facebook.com/ncghl>  Instagram
>>>> <https://www.instagram.com/foreverythingnc/>  Twitter
>>>> <https://twitter.com/ForEverythingNC>  YouTube
>>>> <https://www.youtube.com/statelibrarync>  Website
>>>> <https://statelibrary.ncdcr.gov/>
>>>>
>>>>
>>>>
>>>> *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
>>> sandbej at linnbenton.edu / 541-917-4655
>>> Pronouns: she/her/hers
>>>
>>
>
> --
> Mary Llewellyn
> Database Manager
> Bibliomation, Inc.
> 24 Wooster Ave.
> Waterbury, CT 06708
> mllewell at biblio.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20190614/1418f0b0/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 8625 bytes
Desc: not available
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20190614/1418f0b0/attachment-0001.png>