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: 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ć