[Koha] Demand - on Koha import

Olcese Martina EXT Martina.Olcese at iter.org
Fri Nov 10 05:06:24 NZDT 2023

Dear Ladies and Sirs,

Following the exchange on the Koha mailing list on bulk upload, I wish to request your advice regarding own import process.


1.            We converted our source excel into Marc .mrk format via Marcedit.
=LDR  00000nam a2200000Ia 4500
=008  231106s9999||||xx\||||||||||||||\||und||
=020  \\$a9780691228662<file://$a9780691228662>
=100  \\$aGoldin<file://$aGoldin>, Claudia
=245  \0$aCareer and Family.$bWomen's Century-Long Journey toward Equity
=260  \\$aPrincenton$bPrincenton<file://$aPrincenton$bPrincenton> University Press$c2021
=300  \\$bBook<file://$bBook>
=700  \\$aCameron<file://$aCameron>, Bruce G.Selva, Daniel
=942  \\$cBK<file://$cBK>
=952  \\$10$2Dewy<file://$10$2Dewy> Decimal Classification$aITER-LIBRARY$bITER-LIBRARY$d10/31/23$i02250$o331.42$p02250$yBK

=LDR  00000nam a2200000Ia 4500
=008  231106s9999||||xx\||||||||||||||\||und||
=020  \\$a9781292110844<file://$a9781292110844>
=100  \\$aCrawley<file://$aCrawley>, Edward F.
=245  \0$aSystem architecture.$bStrategy and product development for complex systems
=260  \\$aEdinburgh$bGlobal<file://$aEdinburgh$bGlobal> Edition$c2015
=300  \\$bBook<file://$bBook>
=942  \\$cBK<file://$cBK>
=952  \\$10$2Dewy<file://$10$2Dewy> Decimal Classification$aITER-LIBRARY$bITER-LIBRARY$d10/31/23$i02252$o620$p02252$yBK

2.            and then staged the .mrc file as per instructions on various sites
Home<https://koha-admin.iter.org/cgi-bin/koha/mainpage.pl>  - Tools<https://koha-admin.iter.org/cgi-bin/koha/tools/tools-home.pl> - Stage MARC records for import<https://koha-admin.iter.org/cgi-bin/koha/tools/stage-marc-import.pl>
No profile - Bibliographic - UTF-8 - MARC - 245a matching rule  - replace existing record with incoming record if match- add incoming record if no match  - check imbedded items

3.            The staging of the two sample files was successful:
MARC staging results
Processing bibliographic records
2 records in file
0 records not staged because of MARC error
2 records staged
0 records with at least one match in catalog per matching rule "245"
0 item records found and staged

4.            Yet, the batch import into the catalogue did not work. The import batch into catalog remained blocked at 0%.
Home<https://koha-admin.iter.org/cgi-bin/koha/mainpage.pl> Tools<https://koha-admin.iter.org/cgi-bin/koha/tools/tools-home.pl> Manage staged MARC records<https://koha-admin.iter.org/cgi-bin/koha/tools/manage-marc-import.pl> Batch 40<https://koha-admin.iter.org/cgi-bin/koha/tools/manage-marc-import.pl?import_batch_id=40>

Would you please help us to clarify why the process does not work? Is there an error in the .mrk file?

5.                   Further, I notice that the 245a matching rule is not working, as it seems not able to retrieve records with the same title already on Koha

Home<https://koha-admin.iter.org/cgi-bin/koha/mainpage.pl> Administration<https://koha-admin.iter.org/cgi-bin/koha/admin/admin-home.pl> Record matching rules<https://koha-admin.iter.org/cgi-bin/koha/admin/matching-rules.pl> Modify record matching rule<https://koha-admin.iter.org/cgi-bin/koha/admin/matching-rules.pl?op=edit_matching_rule&matcher_id=4>
Description: 245a - Match threshold 1000  - Search index Title-cover:w  -  Score 1000  - Tag 245 - subfield a - normalization none
May I ask you either there is a mistake on the setting of the matching rule?

Thank you very much in advance for your kind help.

More information about the Koha mailing list