Hi Charles, Did you try the script misc/migration_tools/remove_unused_authorities.pl?
Regards, Jonathan Le mar. 4 août 2020 à 11:02, Charles Kelley <[email protected]> a écrit : > > Hello, all! > > I have been trying to detect, isolate, and delete orphaned authority > headings, i.e., authority records to which no record is attached. I tried > adapting the duplicate authority record report from the SQL Reports > Library. I thought changing this one line would do the trick, but alas, it > did not. > > HAVING count(authid) > 1 > > > > I changed it to > > HAVING count(authid) < 1 > > HAVING count(authid) = 1 > > HAVING authid IS NULL OR authid = '' > > Alas, an empty report. Is there something I can do to find and then > delete the orphaned authority records? Many of these orphaned authority > records are duplicates that I am painstakingly merging two at a time. If I > could get some help in speeding up the merge and deletion because going > through the records two at a time is terribly inefficient. > > Many thanks for your help. > > -- > > 気を付けて。 /ki wo tukete/ = Take care. > > -- Charles. > > Charles Kelley, MLS > PSC 704 Box 1029 > APO AP 96338 > > Charles Kelley > Tsukimino 1-Chome 5-2 > Tsukimino Gaadenia #210 > Yamato-shi, Kanagawa-ken > 〒242-0002 JAPAN > > +1-301-741-7122 [US cell] > +81-80-4356-2178 [JPN cell] > > [email protected] [h] > [email protected] [p] > > linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> > Meeting Your Information Needs. Virtually. > _______________________________________________ > > Koha mailing list http://koha-community.org > [email protected] > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org [email protected] Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
