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

Tue Jun 20 02:29:00 NZST 2023

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 at ssst.edu.ba <library at 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 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ć
>
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>