[Koha] Importing records into Koha - smaller batches per year of catalogization?

[library at ssst.edu.ba]

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: library at ssst.edu.ba 
Sent: Monday, June 19, 2023 12:50 PM
To: koha at 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ć