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 <cmkelleymls@gmail.com> 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]
mnogojazyk@aol.com [h] cmkelleymls@gmail.com [p]
linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually. _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha