Hi You don't need to sort your records for importing. I usually only split it by a number of record blocks. I use 10K records at once for easy handle and control, but it is possible to do more at a time. I might depend on the hardware you have your koha installation on.
Regards, Alvaro . |----------------------------------------------------------------------------------------| Stay safe / Cuídate/ Reste sécurisé *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. *q *Recycle always / Recicla siempre / Recyclez toujours P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire Le lun. 19 juin 2023 à 07:36, libr...@ssst.edu.ba <libr...@ssst.edu.ba> a écrit : > Hello all, > > If I may add this breakdown of fields I've tried to map, could someone let > me know if I'm on the right track or if I need to go back to the study > board? Thank you in advance! > > https://i.ibb.co/YR6g4yt/in-house-cat-vs-koha-marc21.png > > > > Best regards > > Aida Đikić > > > -----Original Message----- > From: libr...@ssst.edu.ba > Sent: Monday, June 19, 2023 12:50 PM > To: koha@lists.katipo.co.nz > Subject: Importing records into Koha - smaller batches per year of > catalogization? > > Hello all, > > (my messages don't seem to be visible on the mailing list, only replies to > them are) > > I have finally received the export from our developers; they have provided > me with an .xls file which I'll need to prepare for MarcEdit (check for > errors and consistency such as uniform names of publishers, authors, > duplicate or skipped inventory numbers etc.). There's a total of 9326 > copies, so I was wondering if the best way to import the records would be > to break up the file into several smaller ones, separated by the year in > which they were cataloged? > > I could sort them by inventory number; the format we used for them is > B0001/20## for books. I currently have the barcode in Koha set to > <year>-0001 format (though I'm wondering whether it's better to use the EAN > barcode format. Are there any preferences re: barcodes here in the list? > > Finally, when it comes to the mapping of the fields we had in our system > and what's available in Koha, our fields were the following: > > In-house catalog Example title > Title Preservation and restoration of tooth structure / > edited by Graham J. Mount, Wyatt R. Hume, Hien C. Ngo, Mark S. Wolff > Authors Graham J. Mount; Wyatt R. Hume; Hien C. Ngo; Mark > S. Wolff; > Type Textbook > Binding Hardcover > Languages English; > Publishers Wiley-Blackwell; > Year 2016 > Publication & manufacture Chichester : Wiley-Blackwell, 2016 > Edition > Physical Description 312p., 28cm. > Notes Accompanied by companion website: > http://www.wiley.com/go/mount/preservation which includes interactive > multiple-choice questions for each > chapter and Powerpoints of all figures from the > book for downloading. > Includes bibliographical references at the end of > each chapters and index. > Pages > ISBN 10 > ISBN 13 9781118766590 > Series > Volume name > Volume number > UDC (categories) (616.31) Stomatology. Oral cavity. Mouth. Diseases > of the mouth and teeth. Including: Odontology. Diseases of the teeth. > Dentistry. Orthodontics; > Subject headings Dental caries Prevention Dental Caries prevention > & control Dental Caries therapy Dental therapeutics Dentistry, Operative > Dentistry, > Operative methods MEDICAL Surgery General Oral & > maxillofacial surgery Preventive dentistry Tooth Diseases Tooth Diseases > prevention & control > Tooth Diseases therapy > Summary Combining the approaches of preventative and restorative > dentistry, this is a revised and updated guide to the clinical techniques > and procedures > necessary for managing tooth disorders and > disease. Introduces minimally invasive dentistry as a model to control > dental disease and then restore > the mouth to optimal form, function, and > aesthetics. Contains several student-friendly features, including a new > layout, line drawings and clinical > photographs to illustrate key concepts. Covers > fundamental topics, including the evolutionary biology of the human oral > environment; caries > management and risk assessment; remineralization; > principles of cavity design; lifestyle factors; choices between restorative > materials and > restoration management. Includes a companion > website with self-assessment exercises for students and a downloadable > image bank for > instructors.--Publisher. > Catalog Entry MOUNT, Graham J. > Preservation and restoration of tooth structure / > edited by Graham J. Mount, Wyatt R. Hume, Hien C. Ngo, Mark S. Wolff.-- > Chichester : > Wiley-Blackwell, 2016.-- 312p., 28cm.-- ISBN: > (pbk.) ; 9781118766590 (pbk.) > Notes: Includes bibliographical references and > index. > Web page > Photo ..oCxvVbYpeyZn2Avx4Utqq0r7gbCUlIwft9uq5MLx.jpg > Material Copies 1 copies > Call Number 616.31 MOU Pre > Inventory Number B0116/2023 > Location DENTISTRY textbooks > Status on_loan > Tags Transfer P20-23; Donated by XY > > > I will need to break up some of them (in our catalog all authors were in > the same field, and the uncontrolled subject headings will need to be > separated into rows. This will be a problem for this example and some > others since there is no delimiter; everything is in one field in the > export even though they were entered with a carriage return in the field. > For others there are variations depending on where they were copied from > (semicolons, double hyphens, periods): > > Children -- Dental care; Dental Care for Children; Child; Infant; > Oral Hygiene; Dentist-Patient Relations; Pediatric Dentistry -- methods; > Children -- Dental care; Pedodontics; > > Mouth -- Embryology Mouth -- Anatomy and histology Tooth -- > Embryology Tooth -- Anatomy and histology > > Aesthetics. Dental Caries therapy. Dental Implants Dental > implants. Dental Materials therapeutic use. Dental Prosthesis. Dentistry > Aesthetic aspects. > Dentistry, Operative instrumentation. Dentistry, Operative > methods. Dentistry, Operative. Dentures. Esthetics, Dental. > > I'm also going to have a problem with exported UDC, because while it > appeared correctly in the frontend, it was handled within brackets in the > backend, which is what's used for auxiliaries. How would I go about > converting this: > > (616-006) Tumours. Neoplasms. Blastomata. Choristomata. > Hamartomata. Oncology.; ((091)) Presentation in chronological, historical > form. > Historical presentation in the strict sense; > > into: > > 616-006 Tumours. Neoplasms. Blastomata. Choristomata. Hamartomata. > Oncology.; (091) Presentation in chronological, historical form. > Historical presentation in the strict sense; > > > Plus I would actually need to import only the numbers, and not the > descriptions, so (616-006) and ((091)) converted to 616-006 and (091) and > imported into their respective fields 080$a and 080$x. > > ...that's a lot of questions; I hope I'll get some pointers :) > > > Best regards > > Aida Đikić > > _______________________________________________ > > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
