Re: [Koha] Importing books from a csv file, including bar codes
Thanks for the tip that 952$p is the barcode. But how can I edit this field in Koha once the book is in the system? This is what I did: - I went to the demo at http://intranet.bywatersolutions.com/cgi-bin/koha/mainpage.pl (username: bywater password: bywater) - I click Checkin - I enter the barcode: TVSN5000215858 - I do that just to find the book. I click on the barcode in the record to get the details of the book. - I click Edit Edit Record. - This brings up the MARC edit page. In the 9 tab, there is no 952$p, a.k.a. barcode. Why not? Clearly this book has one. If I add a single book in Koha and print my own barcodes, I will want to create the item, then edit it to tell Koha the barcode. How can I do this? (And what are those two tiny text fields for, in the MARC edit page next to each number?) Thanks! -- View this message in context: http://koha.1045719.n5.nabble.com/Importing-books-from-a-csv-file-including-bar-codes-tp5775895p5776456.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Importing books from a csv file, including bar codes
Hi , to see the items of a bib record and edit them you must click on edit items not edit record :) see details about this in the manual : http://manual.koha-community.org/3.12/en/catitems.html On Wed, Oct 30, 2013 at 10:08 AM, magmatic magma...@timkoop.com wrote: Thanks for the tip that 952$p is the barcode. But how can I edit this field in Koha once the book is in the system? This is what I did: - I went to the demo at http://intranet.bywatersolutions.com/cgi-bin/koha/mainpage.pl (username: bywater password: bywater) - I click Checkin - I enter the barcode: TVSN5000215858 - I do that just to find the book. I click on the barcode in the record to get the details of the book. - I click Edit Edit Record. - This brings up the MARC edit page. In the 9 tab, there is no 952$p, a.k.a. barcode. Why not? Clearly this book has one. If I add a single book in Koha and print my own barcodes, I will want to create the item, then edit it to tell Koha the barcode. How can I do this? (And what are those two tiny text fields for, in the MARC edit page next to each number?) Thanks! -- View this message in context: http://koha.1045719.n5.nabble.com/Importing-books-from-a-csv-file-including-bar-codes-tp5775895p5776456.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- *Karam Qubsi* ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Importing books from a csv file, including bar codes
Hi It doesn't look like it is a part of MARC. And since it is not a part of MARC, I can't really just import a MARC file, can I? Yes you can import data in marc format includes Item data by using the 952 field at the end of each bib record . so if you have 3 Items in your first record your record should end with something like this : 952 \\$aMain $bBrunch $p1001 $t C-1 $o020 ABC.D 952 \\$aMain $bBrunch $p1002 $t C-2 $o020 ABC.D 952 \\$aMain $bBrunch $p1003 $t C-3 $o020 ABC.D that's it , and as what guys told you , you can use marcedit to make it easy mapping your fields to marc and local koha fields (like item field ) the 952 sub-fields are : 0 - Withdrawn status 2 - Source of classification or shelving scheme 3 - Materials specified (bound volume or other part) 4 - Damaged status 5 - Use restrictions 7 - Not for loan 8 - Collection code a - Permanent location b - Current location c - Shelving location d - Date acquired ... e - Source of acquisition f - Coded location qualifier g - Cost, normal purchase price h - Serial Enumeration / chronology i - Inventory number j - Shelving control number o - Full call number p - Barcode ... t - Copy number u - Uniform Resource Identifier v - Cost, replacement price w - Price effective from x - Non-public note y - Koha item type z - Public note Best Regards On Fri, Oct 25, 2013 at 5:04 AM, magmatic magma...@timkoop.com wrote: I'm trying to import books into Koha. We have a few thousand books with bar code stickers stuck onto them and we don't want to change them. If I got a csv file with the authors, titles, and bar codes, how can I import this? I looked around at how to set the bar code of a book in Koha, but I couldn't find it. It doesn't look like it is a part of MARC. And since it is not a part of MARC, I can't really just import a MARC file, can I? Help! -- Tim -- View this message in context: http://koha.1045719.n5.nabble.com/Importing-books-from-a-csv-file-including-bar-codes-tp5775895.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- *Karam Qubsi* ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
