[OPEN-ILS-GENERAL] authority records management question

[Gordana Vitez]

Hi Dan and Robert,
 
Niagara Evergreen Consortium is also experiencing problems with our
authorities. It's not a performance issue for us. We're just not working
at all. Records have been re-ingested post-2.0.2 upgrade and authorities
were working for a little while...until last Thursday. I've posted
particulars to launchpad...should I post them anywhere else?
 
Thanks!
Gordana
 
 
Gordana Vitez
Library Services & Systems Coordinator
Niagara College Libraries
Welland Campus
300 Woodlawn Rd
Welland Ontario
L3C 7L3
Phone: (905) 735 2211 ext 7404
Fax: (905) 736 6021
gvitez at niagaracollege.ca


>>> "Soulliere, Robert" <robert.soulliere at mohawkcollege.ca> 16/05/2011
10:10 am >>>
Thanks, Dan,

I created a bug  report as you suggested. I was reluctant to do so
since I was starting with the assumption that it was a local data issue
and not a bug. I was hoping to get a few authority data munging tips I
could try before reporting it as a bug.

In regards to finding the French records or records with a catalogue
language setting, this query (provided by Mark Bucholtz) worked for us:

select * from authority.full_rec where tag = '040' and subfield = 'b'
and value = 'fre';

I am not sure if this works for every catalogue since it requires the
use of the 040 tag, but it might be another option for some.

Regards,
Robert


Robert Soulliere, BA (Hons), MLIS
Systems Librarian
Mohawk College Library
robert.soulliere at mohawkcollege.ca 
Telephone: 905 575 1212 x3936
Fax: 905 575 2011
________________________________________
From: open-ils-general-bounces at list.georgialibraries.org
[open-ils-general-bounces at list.georgialibraries.org] On Behalf Of Dan
Scott [dan at coffeecode.net] 
Sent: May 15, 2011 11:02 PM
To: Evergreen Discussion Group
Subject: Re: [OPEN-ILS-GENERAL] authority records management question

On Fri, May 13, 2011 at 12:23:21PM -0400, Soulliere, Robert wrote:
> Hi all,
>
> On my test system managing authority records isn't quite working well
yet and I wonder if I need to clean up our records using sql. Our
systems has around 900,000 rows in the authority.record_entry table
which seems extremely high. Thee contain French equivalent records which
are not needed by our library. I wonder if there is a good way to munge
those records out of the system and  if there is a way to differentiate
the French and English subject authority records? Is there some kind of
indicator in the marc fiields?

Rather than leaping to a solution for a problem that has no
description
beyond "isn't quite working well yet", could you file a bug or bugs
describing what symptoms you're experiencing? Info like the exact
version of Evergreen you're running, and whether you have reingested
the
authority records after migrating to 2.0, would be helpful elements of
these bug reports.

(As an aside, 008/08 = 'f' indicates that the language of the
catalogue
is 'French', and field 700 ind2 = 'f' is an indication that the
thesaurus
is Répertoire de vedettes-matière (RVM)).

This E-mail contains privileged and confidential information intended
only for the individual or entity named in the message.  If the reader
of this message is not the intended recipient, or the agent
responsible
to deliver it to the intended recipient, you are hereby notified that
any review, dissemination, distribution or copying of this
communication
is prohibited.  If this communication was received in error, please
notify the sender by reply E-mail immediately, and delete and destroy
the original message.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20110516/89da98da/attachment.htm