Greetings, Apparently, I'm missing something in the documentation that should be common to many library setups: Importing or creating barcodes * Using an ISBN list, we have successfully used MarcEdit to build the MARC records from the LOC * We inturn imported the .mrc file into Koha * However, without the barcodes, we can't checkin/checkout any books * We could manually edit each item and enter it (painful!). Or we could write some SQL code to enter it based on the matching ISBN number, but I read that the Zebra indexing needs to be rebuilt following that. Which leads me to believe that there is an easier way... Questions: What are the best options for going about this? 1) Does Koha have an auto-barcode generation tool? If so, where is it? 2) What is the procedure for importing a list of barcodes that correspond to the matching ISBN number? Best Regards, Tony -- View this message in context: http://koha.1045719.n5.nabble.com/Barcode-population-import-tp5801018.html Sent from the Koha-general mailing list archive at Nabble.com.
This seems tricky to me--if the barcode is the ISBN, then you can never have multiple copies of the same book (because barcodes must be unique). If you will really never have multiple copies of an item, I'd use MarcEdit to copy the ISBN into the barcode subfield. Rebuilding Zebra isn't a big deal. Katelyn Browne Middle/High School Librarian Capital City Public Charter School 100 Peabody Street NW Washington, DC 20011 (202) 387-0309 x1745 kbrowne@ccpcs.org http://www.ccpcs.org/library/ On Sun, Jun 15, 2014 at 4:33 AM, tony.h <tony.hetrick@keiin.kg> wrote:
Greetings,
Apparently, I'm missing something in the documentation that should be common to many library setups: Importing or creating barcodes
* Using an ISBN list, we have successfully used MarcEdit to build the MARC records from the LOC * We inturn imported the .mrc file into Koha * However, without the barcodes, we can't checkin/checkout any books * We could manually edit each item and enter it (painful!). Or we could write some SQL code to enter it based on the matching ISBN number, but I read that the Zebra indexing needs to be rebuilt following that. Which leads me to believe that there is an easier way...
Questions: What are the best options for going about this? 1) Does Koha have an auto-barcode generation tool? If so, where is it? 2) What is the procedure for importing a list of barcodes that correspond to the matching ISBN number?
Best Regards, Tony
-- View this message in context: http://koha.1045719.n5.nabble.com/Barcode-population-import-tp5801018.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
Katelyn Browne schreef op ma 16-06-2014 om 16:27 [-0400]:
This seems tricky to me--if the barcode is the ISBN, then you can never have multiple copies of the same book (because barcodes must be unique).
If you will really never have multiple copies of an item
In addition to this, be aware that duplicate ISBNs are a very real thing, even though it shouldn't be possible. e.g.: http://www.abebooks.com/9780943161853/Walter-Breens-Encyclopedia-Early-Unite... http://www.abebooks.co.uk/book-search/isbn/9780943161853/page-1/ -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF
Yes, what Katelyn said. When I was a beginning cataloguer they set me loose on a collection of hymn books, most of which had false ISBNs. Of course if you're dealing with mainstream publications, it's less likely. Elaine On Mon, Jun 16, 2014 at 11:56 PM, Robin Sheat <robin@catalyst.net.nz> wrote:
Katelyn Browne schreef op ma 16-06-2014 om 16:27 [-0400]:
This seems tricky to me--if the barcode is the ISBN, then you can never have multiple copies of the same book (because barcodes must be unique).
If you will really never have multiple copies of an item
In addition to this, be aware that duplicate ISBNs are a very real thing, even though it shouldn't be possible.
e.g.:
http://www.abebooks.com/9780943161853/Walter-Breens-Encyclopedia-Early-Unite... http://www.abebooks.co.uk/book-search/isbn/9780943161853/page-1/
-- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://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, On Sun, Jun 15, 2014 at 1:33 AM, tony.h <tony.hetrick@keiin.kg> wrote:
What are the best options for going about this? 1) Does Koha have an auto-barcode generation tool? If so, where is it? 2) What is the procedure for importing a list of barcodes that correspond to the matching ISBN number?
Another option is this: starting in Koha 3.14.0. there is a system preference that you can turn on called itemBarcodeFallbackSearch. Turning it on enables you to retrieve titles for checkout using a keyword search instead of a barcode lookup. Note that for this feature to work, you still need to have something in the barcode column of the items table, but it can just be a sequentially assigned number. For example, if that column is blank or null in all rows in your database, you could do something like this: UPDATE items SET barcode = itemnumber; You can then set the autoBarcode system preference to continue the sequence for any new items you add via Koha's staff interface. Regards, Galen -- Galen Charlton Manager of Implementation Equinox Software, Inc. / The Open Source Experts email: gmc@esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web: http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org
participants (5)
-
Elaine Bradtke -
Galen Charlton -
Katelyn Browne -
Robin Sheat -
tony.h