Items migration along with records
Hello all. I am using KOHA since more than a year now. Whenever we have a client who has to migrate there data to KOHA, we are only able to convert their Records and not Items. This is one of the thing that we are not able to implement KOHA in such a large scale. Last month, we went to Bangladesh at East West University, to implement KOHA there. The records were migrated very easily as usual, but the problem was with items. They had a lot of items with all barcodes already set. They wanted all the items imported in KOHA with the same barcode. With the IT persons there, we made an excel sheet with the items and barcodes and inserted them in the "items" table. The process was successful and then all the records had items shown while browsing them. Now we have a problem. When we find a record by biblionumber, it shows the items and their barcodes, but when we find the same record in the search result it only shows 1 item. Also, while scanning the barcode, it says no items found. I have already rebuild zebra many times. What may be the solution for this? Please Help. PS: we only inserted data in "items" table, but there is a "marcxml" field in "biblioitems" whose value also has the subfield information. So, what is the actual way? When I add new item through koha interface, which tables does it affect? -- Er. Nitesh Rijal rijal.it@gmail.com http://niteshrijal.com.np http://facebook.com/openrijal http://twitter.com/open_zilla +9779841458173
Hi Nitesh, A better way would be to import the Item data along with biblio information. You can use 952 tags for item information and convert the complete data to MARC using something like MarcEdit. Them import it using Koha's bulk import or the web ui. Regards, Koustubha Kale Anant Corporation Contact Details : Address : 103, Armaan Residency, R. W Sawant Road, Nr. Golden Dyes Naka, Thane (w), Maharashtra, India, Pin : 400601. TeleFax : +91-22-21720108, +91-22-21720109 Mobile : +919820715876 Website : http://www.anantcorp.com Blog : http://www.anantcorp.com/blog/?author=2 2011/1/28 Nitesh Rijal <rijal.it@gmail.com>
Hello all.
I am using KOHA since more than a year now. Whenever we have a client who has to migrate there data to KOHA, we are only able to convert their Records and not Items. This is one of the thing that we are not able to implement KOHA in such a large scale.
Last month, we went to Bangladesh at East West University, to implement KOHA there. The records were migrated very easily as usual, but the problem was with items. They had a lot of items with all barcodes already set. They wanted all the items imported in KOHA with the same barcode.
With the IT persons there, we made an excel sheet with the items and barcodes and inserted them in the "items" table. The process was successful and then all the records had items shown while browsing them.
Now we have a problem. When we find a record by biblionumber, it shows the items and their barcodes, but when we find the same record in the search result it only shows 1 item. Also, while scanning the barcode, it says no items found.
I have already rebuild zebra many times. What may be the solution for this?
Please Help.
PS: we only inserted data in "items" table, but there is a "marcxml" field in "biblioitems" whose value also has the subfield information. So, what is the actual way? When I add new item through koha interface, which tables does it affect?
-- Er. Nitesh Rijal rijal.it@gmail.com http://niteshrijal.com.np http://facebook.com/openrijal http://twitter.com/open_zilla +9779841458173
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
For that we need to have the 952, I knew that, but faced difficulties. Please help me in this regard. Suppose the record is: 1. Importance of ILS in a Library -- by Mr. XYZ and all bibliographic records. a. it may have multiple items with barcodes 2312, 342, 2346 and so on. from marcedit, we can just edit the fields, in this case if we keep all the items then it will have multiple record, won;t it? we can get the either the items with all the bibliographic records or just the records with 1 item. how can we get items in a form that is ready for migration? do we need to do that manually one by one? or is there any "regex" that makes this possible. I am new to "regex" so cannot have good hold of it. Please help me. Regards. On Fri, Jan 28, 2011 at 12:37 PM, Koustubha Kale <kmkale@anantcorp.com>wrote:
Hi Nitesh, A better way would be to import the Item data along with biblio information. You can use 952 tags for item information and convert the complete data to MARC using something like MarcEdit. Them import it using Koha's bulk import or the web ui.
Regards, Koustubha Kale Anant Corporation
Contact Details : Address : 103, Armaan Residency, R. W Sawant Road, Nr. Golden Dyes Naka, Thane (w), Maharashtra, India, Pin : 400601. TeleFax : +91-22-21720108, +91-22-21720109 Mobile : +919820715876 Website : http://www.anantcorp.com Blog : http://www.anantcorp.com/blog/?author=2
2011/1/28 Nitesh Rijal <rijal.it@gmail.com>
Hello all.
I am using KOHA since more than a year now. Whenever we have a client who has to migrate there data to KOHA, we are only able to convert their Records and not Items. This is one of the thing that we are not able to implement KOHA in such a large scale.
Last month, we went to Bangladesh at East West University, to implement KOHA there. The records were migrated very easily as usual, but the problem was with items. They had a lot of items with all barcodes already set. They wanted all the items imported in KOHA with the same barcode.
With the IT persons there, we made an excel sheet with the items and barcodes and inserted them in the "items" table. The process was successful and then all the records had items shown while browsing them.
Now we have a problem. When we find a record by biblionumber, it shows the items and their barcodes, but when we find the same record in the search result it only shows 1 item. Also, while scanning the barcode, it says no items found.
I have already rebuild zebra many times. What may be the solution for this?
Please Help.
PS: we only inserted data in "items" table, but there is a "marcxml" field in "biblioitems" whose value also has the subfield information. So, what is the actual way? When I add new item through koha interface, which tables does it affect?
-- Er. Nitesh Rijal rijal.it@gmail.com http://niteshrijal.com.np http://facebook.com/openrijal http://twitter.com/open_zilla +9779841458173
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Er. Nitesh Rijal rijal.it@gmail.com http://niteshrijal.com.np http://facebook.com/openrijal http://twitter.com/open_zilla +9779841458173
Suppose the record is:
1. Importance of ILS in a Library -- by Mr. XYZ and all bibliographic records.
a. it may have multiple items with barcodes 2312, 342, 2346 and so on.
from marcedit, we can just edit the fields, in this case if we keep all the items then it will have multiple record, won;t it? we can get the either the items with all the bibliographic records or just the records with 1 item. how can we get items in a form that is ready for migration? do we need to do that manually one by one? or is there any "regex" that makes this possible. I am new to "regex" so cannot have good hold of it.
952 is a repeatable field. You just need to have several 952 fields for each biblio record, one per item. For example, if you get 1 biblio record with 3 linked items, you need to import 1 biblio record having 3 952 fields.
yes I understand that, but how to compose that structure in MarcEdit? I mean this is what I have: =100 \\$aMr. x =245 \\$aTest book =952 \\$p5685,5845,5487,5476 how do I get this: =100 \\$aMr. x =245 \\$aTest book =952 \\$p5685 =952 \\$p5845 =952 \\$p5487 =952 \\$p5476 This is the actual problem what I'm facing. 2011/1/28 Frédéric DEMIANS <f.demians@tamil.fr>
Suppose the record is:
1. Importance of ILS in a Library -- by Mr. XYZ and all bibliographic records.
a. it may have multiple items with barcodes 2312, 342, 2346 and so on.
from marcedit, we can just edit the fields, in this case if we keep all the items then it will have multiple record, won;t it? we can get the either the items with all the bibliographic records or just the records with 1 item. how can we get items in a form that is ready for migration? do we need to do that manually one by one? or is there any "regex" that makes this possible. I am new to "regex" so cannot have good hold of it.
952 is a repeatable field. You just need to have several 952 fields for each biblio record, one per item. For example, if you get 1 biblio record with 3 linked items, you need to import 1 biblio record having 3 952 fields.
-- Er. Nitesh Rijal rijal.it@gmail.com http://niteshrijal.com.np http://facebook.com/openrijal http://twitter.com/open_zilla +9779841458173
thank you. but how do all other people do it? people all over the world who use koha use marcedit for this thing. but may be I'm posting in a wrong place, because it is not a koha problem anymore. Thank you. Regards. 2011/1/28 Frédéric Demians <frederic@tamil.fr>
yes I understand that, but how to compose that structure in MarcEdit?
I can't say. I don't use it. Since you understand the Koha part of your issue, it's not a Koha problem anymore but a MarcEdit one. You should address your questions to MarcEdit specialists...
-- Er. Nitesh Rijal rijal.it@gmail.com http://niteshrijal.com.np http://facebook.com/openrijal http://twitter.com/open_zilla +9779841458173
but how do all other people do it? people all over the world who use koha use marcedit for this thing. but may be I'm posting in a wrong place, because it is not a koha problem anymore.
You may be in the right place. There are a lot of MarcEdit experts here. I suggest you to search thoroughly the list archive: http://markmail.org/search/?q=koha+marcedit+952 A response to your question may be already there. I also suggest you to send a new question to this list with a new subject focusing on your specific need. Something like: Using MarcEdit to create biblio records with repeatable items in 952 tag...
Sure. Thank You On 28 Jan 2011 13:30, "Frédéric Demians" <frederic@tamil.fr> wrote:
but how do all other people do it? people all over the world who use koha use marcedit for this ... You may be in the right place. There are a lot of MarcEdit experts here. I suggest you to search thoroughly the list archive:
http://markmail.org/search/?q=koha+marcedit+952 A response to your question may be already there. I also suggest you to send a new question to this list with a new subject focusing on your specific need. Something like: Using MarcEdit to create biblio records with repeatable items in 952 tag...
Salvete! I think Nitesh might know that. What I think is missing is the answer to the question of How does one take comma separated values related to the 952 and ensure that they are properly linked in a quick fashion? I never needed to use MarcEdit for that, but I don't think that the answer might be solely limited to that tool. Cheers, Brooke
1. Importance of ILS in a Library -- by Mr. XYZ and all bibliographic records.
a. it may have multiple items with barcodes 2312, 342, 2346 and so on.
from marcedit, we can just edit the fields, in this case if we keep all the items then it will have multiple record, won;t it? we can get the either the items with all the bibliographic records or just the records with 1 item. how can we get items in a form that is ready for migration? do we need to do that manually one by one? or is there any "regex" that makes this possible. I am new to "regex" so cannot have good hold of it.
952 is a repeatable field. You just need to have several 952 fields for each biblio record, one per item. For example, if you get 1 biblio record with 3 linked items, you need to import 1 biblio record having 3 952 fields.
Hi I have the same problem like Nitesh. If anyone know the solution preferably mapping by marcedit I would like to know. http://library.seu.ac.bd http://library.seu.ac.bd ----- Abdullah-Al-Modabber Deputy Librarian (Head of Library) Southeast University Library House 1, Road 17, Block C, Banani Dhaka 1213, Bangladesh Tel. +88028838013, Ext. 101 Mobile +8801819695123 E-mail: modabber@yahoo.com Web: www.seu.ac.bd -- View this message in context: http://koha.1045719.n5.nabble.com/Items-migration-along-with-records-tp33609... Sent from the Koha - Discuss mailing list archive at Nabble.com.
Now we have a problem. When we find a record by biblionumber, it shows the items and their barcodes, but when we find the same record in the search result it only shows 1 item. Also, while scanning the barcode, it says no items found.
As you've seen, items info are stored in two locations: 'items' table and with the biblio records. If you load data the way you've done it, you have to 'copy' data from items table to biblio records. There is script that can do it automatically for you: misc/maintenance/sync_items_in_marc_bib.pl The other option is to create directly items records during biblios import. You have to put your item info into 952 tag for MARC21 records (995 for UNIMARC). -- Frédéric
Hi, I am facing problem. How can we get the Barcodes while importing records in Koha? Can we change the barcode mapping from 952 $p to any other tag.. as we have our accession number in some other tag say 901 $a. Thanks! -- View this message in context: http://koha.1045719.n5.nabble.com/Items-migration-along-with-records-tp33609... Sent from the Koha - Discuss mailing list archive at Nabble.com.
If you import your barcodes into another field they will not work as you would expect. We put our barcode equivalents into the 952 $p during the conversion process and it worked fine for us. Item specific information really should be in the item record. If you're sure you will never ever have more than one copy, you could put it in the biblio. But it's not exactly the way Koha was designed to work. On Thu, Apr 28, 2011 at 5:52 AM, Shelly <shellyjain85.iari@gmail.com> wrote:
Hi, I am facing problem. How can we get the Barcodes while importing records in Koha? Can we change the barcode mapping from 952 $p to any other tag.. as we have our accession number in some other tag say 901 $a.
Thanks!
-- View this message in context: http://koha.1045719.n5.nabble.com/Items-migration-along-with-records-tp33609... Sent from the Koha - Discuss 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
-- 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 ext 36 -------------------------------------------------------------------------- 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, Thank-you. I tried on some some sample records by putting barcode (Accession no.) in 952 $p tag and it works fine. I could not install "marcEdit" to change the tag to 952 $p for the whole real record. It was giving some "Window installer " error while installing MarcEdit.msi. I have followed all the solutions available on google search, but all vain. Please help! http://koha.1045719.n5.nabble.com/file/n4375067/error_msi.jpg Thanks! -- View this message in context: http://koha.1045719.n5.nabble.com/Items-migration-along-with-records-tp33609... Sent from the Koha - Discuss mailing list archive at Nabble.com.
participants (8)
-
Abdullah-Al-Modabber -
Elaine Bradtke -
Frédéric DEMIANS -
Frédéric Demians -
Koustubha Kale -
M. Brooke Helman -
Nitesh Rijal -
Shelly