[Koha] Orphaned Authority Records: Finding Them and Deleting Them

[Jonathan Druart]

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 at 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 at aol.com [h]
>     cmkelleymls at 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 at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha