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: 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ć
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@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ć
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, library@ssst.edu.ba <library@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: library@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
Hello, I already did, just so I have all the records split by the year in which they were cataloged. It’s also going to make it easier for me to catch any errors if I’m not looking at a huge list. It’s good to hear 10k records isn’t an issue though. I expect to cross that mark this year, and aim at cataloging about a thousand books per year. Best regards Aida Đikić From: Alvaro Cornejo <cornejo.alvaro@gmail.com> Sent: Monday, June 19, 2023 4:29 PM To: library@ssst.edu.ba Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Importing records into Koha - smaller batches per year of catalogization? 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 . |----------------------------------------------------------------------------------------| [https://ci3.googleusercontent.com/mail-sig/AIorK4zO0f8Z21m2X0jK3RWGktD8bapLQ...] 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, library@ssst.edu.ba<mailto:library@ssst.edu.ba> <library@ssst.edu.ba<mailto:library@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: library@ssst.edu.ba<mailto:library@ssst.edu.ba> Sent: Monday, June 19, 2023 12:50 PM To: koha@lists.katipo.co.nz<mailto: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<mailto:Koha@lists.katipo.co.nz> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
participants (2)
-
Alvaro Cornejo -
library＠ssst.edu.ba