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)).
