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 [email protected]
>>> "Soulliere, Robert" <[email protected]> 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 [email protected] Telephone: 905 575 1212 x3936 Fax: 905 575 2011 ________________________________________ From: [email protected] [[email protected]] On Behalf Of Dan Scott [[email protected]] 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.
