[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 <mrylander at gmail.com> 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:  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
>>
>

-- 
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/2eb540c4/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/2eb540c4/attachment-0001.png>