https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42532 Bug ID: 42532 Summary: Map biblioitems.ean to 024$a by default (MARC21) Initiative type: --- Sponsorship --- status: Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: MARC Bibliographic data support Assignee: koha-bugs@lists.koha-community.org Reporter: caroline.cyr-la-rose@inlibro.com QA Contact: testopia@bugs.koha-community.org There is an EAN field in biblioitems but it is not mapped to anything by default. I propose to map it to 024$a in new MARC21 installations. To recreate : 1. Make the following query in the database to see what is in 024$a and what is in biblioitems.ean select extractvalue(metadata, '//datafield[@tag="024"]/subfield[@code="a"]') as 024a, ean from biblio_metadata left join biblioitems using (biblionumber) where extractvalue(metadata, '//datafield[@tag="024"]/subfield[@code="a"]') != ''; --> Returns a list of numbers in 024a and NULL in ean 2. Just to make sure, run batchRebuildBiblioTeables.pl ./misc/batchRebuildBiblioTables.pl -c 3. Redo the query in step 1 --> Still nothing in ean -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.