You can tell that I’m more of a cataloger than a sysadmin. I gave a thorough answer to a completely different definition of clean. Sorry about that!
Fred, cataloger and sysadmin—in that order Get Outlook for iOS<https://aka.ms/o0ukef> ________________________________ From: Koha <koha-boun...@lists.katipo.co.nz> on behalf of Caroline Cyr La Rose <caroline.cyr-la-r...@inlibro.com> Sent: Monday, July 15, 2024 9:20:57 AM To: koha@lists.katipo.co.nz <koha@lists.katipo.co.nz> Subject: Re: [Koha] [EXTERNAL] Enquiry Hi! Do you mean that you want to clean all the batches? I don't think there is a way to do it from the staff interface. However, the cleanup_database script has an option to remove imported batches (see https: //urldefense. com/v3/__https: //koha-community. org/manual/latest/en/html/cron_jobs. html*cron-clean-up-database-label__;Iw!!D7IIWT94AA!8keHKQhM4kPada5-BIcxLIdA2E9YeBqwpk6mVjwH-zQFJ-qYr013xGFTLeex1UAUbbxwnN_eptTx0FeT0pdwM7FWSnSbwg$[koha-community[. ]org] Hi! Do you mean that you want to clean all the batches? I don't think there is a way to do it from the staff interface. However, the cleanup_database script has an option to remove imported batches (see https://urldefense.com/v3/__https://koha-community.org/manual/latest/en/html/cron_jobs.html*cron-clean-up-database-label__;Iw!!D7IIWT94AA!8keHKQhM4kPada5-BIcxLIdA2E9YeBqwpk6mVjwH-zQFJ-qYr013xGFTLeex1UAUbbxwnN_eptTx0FeT0pdwM7FWSnSbwg$[koha-community[.]org] with the option --import). Regards, Caroline On 2024-07-15 01:34, Himanshu Aggarwal wrote: > Yes Katrin you got my point but is there a way to batch the clean it > > On Sat, Jul 13, 2024 at 3:02 PM Katrin Fischer <katrin.fischer...@web.de> > wrote: > >> Hi, >> >> I think you mean the "Clean" button in the list of import batches? >> >> When you clean an import it will leave the batch, but remove the >> information about your imported records from the database. Once a batch >> has been cleaned, you can no longer undo an import, so you should only >> do so when this action is no longer required. >> >> Cleaning imports can help to keep your database a bit smaller, as >> storing a lot of MARC records in the import tables can take up space. >> >> Hope this helps, >> >> Katrin >> >> On 13.07.24 09:11, Himanshu Aggarwal wrote: >>> My records are imported successfully. There are no problems. Hence, I ask >>> about it. >>> >>> On Fri, Jul 12, 2024 at 11:44 PM Lauren Denny <lauren_de...@sil.org> >> wrote: >>>> When I've imported from one system something that is sort of unique to >>>> Koha, is the field used for the item records. Koha uses 952 many other >>>> systems use 942 or 852. If you want items to appear on the records you >>>> need to move the item info to 952. The 952 field has to have the >> correct >>>> codes for library, item type, and any other authorized values used for >> item >>>> records that you set up in Koha or the records will not import like Fred >>>> said.. >>>> >>>> Koha also likes records to have a leader (LDR or 000) and 008 fields. >> If >>>> these are missing, it messes with your search results. I added a >> record in >>>> Koha with a generic leader and then copyed it and added the field to >> all my >>>> records in MarcEdit and do the same with the 008. >>>> >>>> Another common thing to clean is the indicators especially for 245. >>>> Depending on what your records look like or if you want to 'skip' any >>>> leading articles - a, an, the, you need to use the correct indicators. >>>> >>>> Hope this helps, >>>> Lauren >>>> >>>> >>>> >>>> On Fri, Jul 12, 2024 at 9:12 AM King, Fred <fred.k...@medstar.net> >> wrote: >>>>> My experience is that if the MARC fields are structurally accurate, >> it’s >>>>> a good idea but not necessary. For example, as long as a 650 field has >>>>> something that Koha recognizes as possibly having something to do with >> a >>>>> subject heading, it will import. Also, if the record lacks mandatory >> fields >>>>> such as the 942, it will import but if you try to edit the record, >> you’ll >>>>> need to put in the itype before you can save it. >>>>> >>>>> However, if the structure of the record is faulty, importing will stop. >>>>> Then you have to figure where the faulty record is, correct it, and >> try to >>>>> import again. When I was importing an especially annoying batch of MARC >>>>> records I had to break them down into groups—I think it was 100 >> records >>>>> per group—then upload them, find the group with the problem record, >> divide >>>>> the group in half, upload that half, etc., narrowing things down until >> I >>>>> found the problem. >>>>> >>>>> I haven’t had that problem recently, and later versions of Koha may >> point >>>>> out where the faulty record is (I hope so!). Koha is a small but >>>>> interesting part of my job, and even after ten years of being a >> sysadmin I >>>>> still only learn things when I need to. >>>>> >>>>> Again, my experience only. >>>>> >>>>> --Fred >>>>> >>>>> Fred King, MSLS, AHIP >>>>> Medical Librarian, MedStar Washington Hospital Center >>>>> fred.k...@medstar.net >>>>> 202-877-6670 >>>>> ORCID 0000-0001-5266-0279 >>>>> MedStar Authors Catalog: >>>>> https://urldefense.com/v3/__http://medstarauthors.org__;!!D7IIWT94AA!8keHKQhM4kPada5-BIcxLIdA2E9YeBqwpk6mVjwH-zQFJ-qYr013xGFTLeex1UAUbbxwnN_eptTx0FeT0pdwM7Ehpb0q0w$[medstarauthors[.]org] >>>>> >>>>> The greatest enemy of knowledge is not ignorance, it is the illusion of >>>>> knowledge. >>>>> —Stephen Hawking >>>>> >>>>> From: Koha <koha-boun...@lists.katipo.co.nz> On Behalf Of Himanshu >>>>> Aggarwal >>>>> Sent: Friday, July 12, 2024 7:24 AM >>>>> To: Koha <koha@lists.katipo.co.nz> >>>>> Subject: [EXTERNAL] [Koha] Enquiry >>>>> >>>>> Is it necessary to clean staged MARC records -- Assistant Librarian, >>>>> Confucius Institute Scholar 13-14, R. D. National College, Bandra (W. ) >>>>> _______________________________________________ Koha mailing list >> https: >>>>> //urldefense. com/v3/__http: //koha-community. >>>>> >> org__;!!D7IIWT94AA!-Wq5Ou4VhDefYA9gyTRYmlglu5dIxvQgvTXx0_0s5hI5u6R0Gx4vClJ7tlhkgM-1my_UFnr1xDzXZBS5OWmgJA8$[koha-community[. >>>>> ]org] >>>>> >>>>> >>>>> Is it necessary to clean staged MARC records >>>>> >>>>> >>>>> >>>>> -- >>>>> >>>>> Assistant Librarian, >>>>> >>>>> Confucius Institute Scholar 13-14, >>>>> >>>>> R.D. National College, >>>>> >>>>> Bandra (W.) >>>>> >>>>> _______________________________________________ >>>>> >>>>> >>>>> >>>>> Koha mailing list >>>>> >> https://urldefense.com/v3/__http://koha-community.org__;!!D7IIWT94AA!-Wq5Ou4VhDefYA9gyTRYmlglu5dIxvQgvTXx0_0s5hI5u6R0Gx4vClJ7tlhkgM-1my_UFnr1xDzXZBS5OWmgJA8$ >>>>>< >>>>> >> https://urldefense.com/v3/__http:/koha-community.org__;!!D7IIWT94AA!-Wq5Ou4VhDefYA9gyTRYmlglu5dIxvQgvTXx0_0s5hI5u6R0Gx4vClJ7tlhkgM-1my_UFnr1xDzXZBS5OWmgJA8$ >>>>>>[koha-community[.]org] >>>>> Koha@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz> >>>>> >>>>> Unsubscribe: >>>>> >> https://urldefense.com/v3/__https://lists.katipo.co.nz/mailman/listinfo/koha__;!!D7IIWT94AA!-Wq5Ou4VhDefYA9gyTRYmlglu5dIxvQgvTXx0_0s5hI5u6R0Gx4vClJ7tlhkgM-1my_UFnr1xDzXZBS5d503n30$ >>>>>< >>>>> >> https://urldefense.com/v3/__https:/lists.katipo.co.nz/mailman/listinfo/koha__;!!D7IIWT94AA!-Wq5Ou4VhDefYA9gyTRYmlglu5dIxvQgvTXx0_0s5hI5u6R0Gx4vClJ7tlhkgM-1my_UFnr1xDzXZBS5d503n30$ >>>>>>[lists[.]katipo[.]co[.]nz] >>>>> _______________________________________________ >>>>> >>>>> Koha mailing list >>>>> https://urldefense.com/v3/__http://koha-community.org__;!!D7IIWT94AA!8keHKQhM4kPada5-BIcxLIdA2E9YeBqwpk6mVjwH-zQFJ-qYr013xGFTLeex1UAUbbxwnN_eptTx0FeT0pdwM7EGtplSjg$[koha-community[.]org] >>>>> Koha@lists.katipo.co.nz >>>>> Unsubscribe: >>>>> https://urldefense.com/v3/__https://lists.katipo.co.nz/mailman/listinfo/koha__;!!D7IIWT94AA!8keHKQhM4kPada5-BIcxLIdA2E9YeBqwpk6mVjwH-zQFJ-qYr013xGFTLeex1UAUbbxwnN_eptTx0FeT0pdwM7E65VjfHQ$[lists[.]katipo[.]co[.]nz] >>>>> >> _______________________________________________ >> >> Koha mailing list >> https://urldefense.com/v3/__http://koha-community.org__;!!D7IIWT94AA!8keHKQhM4kPada5-BIcxLIdA2E9YeBqwpk6mVjwH-zQFJ-qYr013xGFTLeex1UAUbbxwnN_eptTx0FeT0pdwM7EGtplSjg$[koha-community[.]org] >> Koha@lists.katipo.co.nz >> Unsubscribe: >> https://urldefense.com/v3/__https://lists.katipo.co.nz/mailman/listinfo/koha__;!!D7IIWT94AA!8keHKQhM4kPada5-BIcxLIdA2E9YeBqwpk6mVjwH-zQFJ-qYr013xGFTLeex1UAUbbxwnN_eptTx0FeT0pdwM7E65VjfHQ$[lists[.]katipo[.]co[.]nz] >> > Caroline Cyr-La-Rose, M.L.I.S. (she/her) Librarian | Product Manager 1-833-INLIBRO (465-4276), ext. 221 caroline.cyr-la-r...@inlibro.com https://urldefense.com/v3/__https://www.inLibro.com__;!!D7IIWT94AA!8keHKQhM4kPada5-BIcxLIdA2E9YeBqwpk6mVjwH-zQFJ-qYr013xGFTLeex1UAUbbxwnN_eptTx0FeT0pdwM7GTvk5CZQ$[inlibro[.]com] _______________________________________________ Koha mailing list https://urldefense.com/v3/__http://koha-community.org__;!!D7IIWT94AA!8keHKQhM4kPada5-BIcxLIdA2E9YeBqwpk6mVjwH-zQFJ-qYr013xGFTLeex1UAUbbxwnN_eptTx0FeT0pdwM7EGtplSjg$[koha-community[.]org] Koha@lists.katipo.co.nz Unsubscribe: https://urldefense.com/v3/__https://lists.katipo.co.nz/mailman/listinfo/koha__;!!D7IIWT94AA!8keHKQhM4kPada5-BIcxLIdA2E9YeBqwpk6mVjwH-zQFJ-qYr013xGFTLeex1UAUbbxwnN_eptTx0FeT0pdwM7E65VjfHQ$[lists[.]katipo[.]co[.]nz] _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
