Bulk Deletion of Authorities Not Linked to a Title
Hi, all! I think I wrote about this awhile ago, but I have lost my notes. In any event, is it possible to do a bulk deletion or mass deletion of authority records not linked to an authority records? Our catalog has quite a few of such authority records, and we would like to delete them. I'm trying to avoid a search-by-search project. Some are duplicates when we initially migrated to Koha and we turned on the preference/setting/option to add authority records upon upload. Some are just typos, extra downloads by mistakes, and so on. Many thanks. -- よろしくお願いします。 -- 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, There's a script for this actually: /migration_tools/ remove_unused_authorities.pl (that path may have changed or be incomplete, I'm looking at notes on my phone) We run it as a cron job to keep our auth records clean. The "did you mean" search suggestions use authorities but don't filter out ones that aren't linked to any records, that's one good reason to prune them regularly. Best, Eric Phetteplace Systems Librarian California College of the Arts On Tue, Jun 14, 2022, 16:53 Charles Kelley <cmkelleymls@gmail.com> wrote:
Hi, all!
I think I wrote about this awhile ago, but I have lost my notes. In any event, is it possible to do a bulk deletion or mass deletion of authority records not linked to an authority records?
Our catalog has quite a few of such authority records, and we would like to delete them. I'm trying to avoid a search-by-search project. Some are duplicates when we initially migrated to Koha and we turned on the preference/setting/option to add authority records upon upload. Some are just typos, extra downloads by mistakes, and so on.
Many thanks.
--
よろしくお願いします。
-- 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, Eric! In our latest exchange, on 15 June 2022 at 09:41 [JST], you wrote: There's a script for this actually: /migration_tools/
remove_unused_authorities.pl (that path may have changed or be incomplete, I'm looking at notes on my phone) We run it as a cron job to keep our auth records clean. The "did you mean" search suggestions use authorities but don't filter out ones that aren't linked to any records, that's one good reason to prune them regularly.
I found it! Here's the complete path: /usr/share/koha/bin/migration_tools/remove_unused_authorities.pl I'll run it on the development machine before the production machine. I'll also set up a cron job for once a month. Many thanks! -- よろしくお願いします。 -- 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.
Hello again, Eric! In our latest exchange, on 15 June 2022 at 10:42 [JST], I foolishly wrote: I found it! Here's the complete path:
/usr/share/koha/bin/migration_tools/remove_unused_authorities.pl
I'll run it on the development machine before the production machine. I'll also set up a cron job for once a month.
Many thanks!
I was premature. There is a *.pl file by that name in the path I reproduced above; and I ran it from the terminal shell. I got a error message that begins "Can't locate Koha/Scripts.pm @INC (you may need to install the Koha::Script module) ..." I have only a slight idea of what the error refers to; and, more to the point, I don't know how to install such a module. I can't find documentation on how to do so. Any suggestions, anyone? -- よろしくお願いします。 -- 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.
Were you using the Koha shell? As a super user type koha-shell library. Change library with the name used for your Koha instance. On 6/14/22 9:08 PM, Charles Kelley wrote:
Hello again, Eric!
In our latest exchange, on 15 June 2022 at 10:42 [JST], I foolishly wrote:
I found it! Here's the complete path:
/usr/share/koha/bin/migration_tools/remove_unused_authorities.pl
I'll run it on the development machine before the production machine. I'll also set up a cron job for once a month.
Many thanks!
I was premature. There is a *.pl file by that name in the path I reproduced above; and I ran it from the terminal shell. I got a error message that begins
"Can't locate Koha/Scripts.pm @INC (you may need to install the Koha::Script module) ..."
I have only a slight idea of what the error refers to; and, more to the point, I don't know how to install such a module. I can't find documentation on how to do so.
Any suggestions, anyone?
-- *Tim McMahon* West Liberty Public Library
participants (3)
-
Charles Kelley -
Eric Phetteplace -
Tim McMahon