[OPEN-ILS-GENERAL] authority records management question

[Soulliere, Robert]

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.