Hi, I can see a few things that could cause you issues: 952 $2 = Koha expects the code of the classification scheme here, not the description. You can find all the available codes under administration > classification configuration. For DDC it's ddc. $d = The accession is probably the wrong format. We usually use YYYY-MM-DD. I haven't tested if the date in the format chosen in the DateFormat system preference works as well. How many records do you have in your file? The process bar might appear stuck at 0% for a big file. I think I'd set the index in the matching rule without the :w and use just Title-cover. Hope this helps, Katrin On 09.11.23 17:06, Olcese Martina EXT wrote:
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.
Steps:
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.
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha