Orphaned Authority Records: Finding Them and Deleting Them
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.
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
Hello, Jonathan! Thanks for your reply. In our latest exchange, on 4 Aug. 2020, at 7:38 PM, you wrote: Did you try the script misc/migration_tools/remove_unused_authorities.pl?
No, I have not. Linux and other command line interfaces are new to me, and I don't know how to run Perl scripts from the command line. Can I ask for pointers, please? Is there a place where I can find a list of such scripts? Perhaps the Koha community site or Github? Many thanks. -- 気を付けて。 /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.
participants (2)
-
Charles Kelley -
Jonathan Druart