Import records and update items
Hi, I'm running Koha 16.05.05 and would like to add barcodes to all existing items afterwards. I export bibliographic data for one library, including items in marc format. Then I edit the records using MarcEdit and add some barcodes. I reimport the records using the stage marc records for import tool with matching rule on controlnumber 001. I select "Ignore incoming records" and "Replace items if matching bib was found (only for existing items)". After the import is complete, Koha displays "number of records ignored" = 1 and "number of items replaced" = 1. But when I view the record in staff and OPAC view, nothing changed. According to this mail matching on items is done checking 952 $p https://lists.katipo.co.nz/public/koha/2015-April/042590.html. But my existing items don't have any barcodes yet. Do you know a workaround for this? Regards, Felix -- Felix Hemme Thüringer Universitäts- und Landesbibliothek (ThULB) Bibliotheksplatz 2 · 07743 Jena · Postfach · 07737 Jena Tel: 03641 940-126 · Fax: 03641 940-022 http://www.thulb.uni-jena.de<http://www.thulb.uni-jena.de/>
That is going to be difficult - Koha does not recognize the incoming item records with barcodes as being the same items without barcodes. Do you have a separate test system? You could try to replace the records, rather than ignore them, but I fear you would loose any circulation information connected to those items. If it is only a few items that are out on loan you could run a report to create a list of the items, date due, and borrower, and then reissue them once the barcodes are in place. But that sounds like a lot of work. Perhaps wiser heads than mine can help. On Fri, Nov 18, 2016 at 12:36 PM, Felix Hemme <felix.hemme@thulb.uni-jena.de
wrote:
Hi,
I'm running Koha 16.05.05 and would like to add barcodes to all existing items afterwards.
I export bibliographic data for one library, including items in marc format. Then I edit the records using MarcEdit and add some barcodes. I reimport the records using the stage marc records for import tool with matching rule on controlnumber 001. I select "Ignore incoming records" and "Replace items if matching bib was found (only for existing items)". After the import is complete, Koha displays "number of records ignored" = 1 and "number of items replaced" = 1. But when I view the record in staff and OPAC view, nothing changed.
According to this mail matching on items is done checking 952 $p https://lists.katipo.co.nz/public/koha/2015-April/042590.html. But my existing items don't have any barcodes yet.
Do you know a workaround for this?
Regards, Felix -- Felix Hemme Thüringer Universitäts- und Landesbibliothek (ThULB) Bibliotheksplatz 2 · 07743 Jena · Postfach · 07737 Jena Tel: 03641 940-126 · Fax: 03641 940-022 http://www.thulb.uni-jena.de<http://www.thulb.uni-jena.de/>
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
Hi Felix, I *think* that the matching should also work with the itemnumber. I have found the initial bug report, maybe it has some useful information: Bug 7131 -way to overlay items in in marc import https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7131 There is also a newer bug report: Bug 16828 - Item Overlay does not respect Bibliographic Record Match https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16828 You could also use SQL to update the items in the database directly. If you choose this option, you should reindex after making the changes, so the indexes are up to date and you can search for the barcodes. Hope this helps, Katrin On 21.11.2016 19:28, Elaine Bradtke wrote:
That is going to be difficult - Koha does not recognize the incoming item records with barcodes as being the same items without barcodes.
Do you have a separate test system? You could try to replace the records, rather than ignore them, but I fear you would loose any circulation information connected to those items. If it is only a few items that are out on loan you could run a report to create a list of the items, date due, and borrower, and then reissue them once the barcodes are in place. But that sounds like a lot of work. Perhaps wiser heads than mine can help.
On Fri, Nov 18, 2016 at 12:36 PM, Felix Hemme <felix.hemme@thulb.uni-jena.de
wrote: Hi,
I'm running Koha 16.05.05 and would like to add barcodes to all existing items afterwards.
I export bibliographic data for one library, including items in marc format. Then I edit the records using MarcEdit and add some barcodes. I reimport the records using the stage marc records for import tool with matching rule on controlnumber 001. I select "Ignore incoming records" and "Replace items if matching bib was found (only for existing items)". After the import is complete, Koha displays "number of records ignored" = 1 and "number of items replaced" = 1. But when I view the record in staff and OPAC view, nothing changed.
According to this mail matching on items is done checking 952 $p https://lists.katipo.co.nz/public/koha/2015-April/042590.html. But my existing items don't have any barcodes yet.
Do you know a workaround for this?
Regards, Felix -- Felix Hemme Thüringer Universitäts- und Landesbibliothek (ThULB) Bibliotheksplatz 2 · 07743 Jena · Postfach · 07737 Jena Tel: 03641 940-126 · Fax: 03641 940-022 http://www.thulb.uni-jena.de<http://www.thulb.uni-jena.de/>
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Hi Katrin, after doing some data-cleanup we did the insert with SQL directly in the database. Thank you for this suggestion, Felix -----Ursprüngliche Nachricht----- Von: Koha [mailto:koha-bounces@lists.katipo.co.nz] Im Auftrag von Katrin Gesendet: Montag, 21. November 2016 21:27 An: koha@lists.katipo.co.nz Betreff: Re: [Koha] Import records and update items Hi Felix, I *think* that the matching should also work with the itemnumber. I have found the initial bug report, maybe it has some useful information: Bug 7131 -way to overlay items in in marc import https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7131 There is also a newer bug report: Bug 16828 - Item Overlay does not respect Bibliographic Record Match https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16828 You could also use SQL to update the items in the database directly. If you choose this option, you should reindex after making the changes, so the indexes are up to date and you can search for the barcodes. Hope this helps, Katrin _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
participants (3)
-
Elaine Bradtke -
Felix Hemme -
Katrin