[OPEN-ILS-GENERAL] [External] Re: Publication Year in Reports

[Patrick, Irene]

Rogan,

To answer your question, I was using the built-in Evergreen reports, and was pulling the “Publication Year (normalized)” from the Bib Record--Simple Record Extracts.  I’m guessing that the normalization routine is doing something unusual when the date isn’t the standard four-digit year.


[cid:image001.png at 01D373F0.7AA81F20]Irene Patrick
Library & Information Management Systems Librarian
NC Dept. of Natural and Cultural Resources
919.807.7413  |  irene.patrick at ncdcr.gov


109 E. Jones St.  | 4640 Mail Service Center
Raleigh, North Carolina 27699-4600
Facebook<http://www.facebook.com/ncghl>  Twitter<http://www.twitter.com/ncpedia>  YouTube<http://www.youtube.com/user/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.



From: Rogan Hamby [mailto:rhamby at equinoxinitiative.org]
Sent: Tuesday, December 12, 2017 5:25 PM
To: Evergreen Discussion Group <open-ils-general at list.georgialibraries.org>
Subject: [External] Re: [OPEN-ILS-GENERAL] Publication Year in Reports

CAUTION: External email. Do not click links or open attachments unless verified. Send all suspicious email as an attachment to report.spam at nc.gov<mailto:report.spam at nc.gov>.

Hi Irene,

Are you using the reporter table for this?  I have seen this before there and not had the tuits to look into it in any depth since I've only seen it on rare occasions but checking a few data sets it's not hard to find examples under a number of scenarios and it's not hard to imagine a regular expression creating this result.  It's probably worth a launchpad bag and some discussion on how to handle it.  Maybe we should be checking for a four digit number and using it when found.

Ultimately that table might get replaced with newer functionality of course as the pub date field itself isn't RDA friendly but that's another discussion.




Rogan Hamby

Data and Project Analyst

Equinox Open Library Initiative

phone:  1-877-OPEN-ILS (673-6457)

email:  rogan at EquinoxInitiative.org<mailto:rogan at EquinoxInitiative.org>
web:  http://EquinoxInitiative.org

On Tue, Dec 12, 2017 at 4:38 PM, Patrick, Irene <irene.patrick at ncdcr.gov<mailto:irene.patrick at ncdcr.gov>> wrote:
Has anyone ever noticed that there is some strangeness with the Publication Year in Evergreen reports?  The Publication Year is normalized in the output, and there seems to be an issue with how the data gets normalized.  Some examples of what I am seeing:

264 $c  September 1, 2015    Publication Year in report:  1

264 $c  October 6, 2017         Publication Year in report:  6

264 $c October 31, 2016        Publication Year in report:  31

When the date in the 264 is not simply the year, the normalization routine seems to be pulling out only a piece of the date, not the full date.

I tried looking for any previous reports of this issue in Launchpad but didn’t find one.  Apologies if it is there and I missed it.

[cid:image001.png at 01D373F0.7AA81F20]Irene Patrick
Library & Information Management Systems Librarian
NC Dept. of Natural and Cultural Resources
919.807.7413<tel:(919)%20807-7413>  |  irene.patrick at ncdcr.gov<mailto:irene.patrick at ncdcr.gov>


109 E. Jones St<https://maps.google.com/?q=109+E.+Jones+St&entry=gmail&source=g>.  | 4640 Mail Service Center
Raleigh, North Carolina 27699-4600
Facebook<http://www.facebook.com/ncghl>  Twitter<http://www.twitter.com/ncpedia>  YouTube<http://www.youtube.com/user/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.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20171213/649f1da7/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 8625 bytes
Desc: image001.png
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20171213/649f1da7/attachment-0001.png>