Instruction/document on items (holdings) migration
Dear all, I have successfully imported our bibliographic records into Koha 3.12. However, I am having a lot of trouble importing our items (holdings). Unfortunately our old system doesn't export holdings/items with bib. records in MARC format. At this moment, I suspect my problem relates to data conversion from csv to MARC using MarcEdit. I am struggling to find any instruction/document on this matter. There are a few I found on Google search, but links are outdated. Does anyone has instruction/document on this task that I can have? Your assistance will be much appreciated. Iming ----- Iming Chan Translib Information Service Melbourne, Australia -- View this message in context: http://koha.1045719.n5.nabble.com/Instruction-document-on-items-holdings-mig... Sent from the Koha-general mailing list archive at Nabble.com.
Iming, I am not a migration guru and am happy to be corrected but I think the main problem with your marc records is that you have 952 tags over a number of lines; this will create multiple items for each record. Perhaps the step you missed was:- in MarcEdit, during the Delimited Text Translator process, if you have added multiple tags that you wish to combine into a single entry, you ctrl select each individual subfield, right click and choose 'join'. there is a helpful video here http://www.youtube.com/watch?v=5D3sUSrn_3E I hope that helps, Clint. Iming Chan wrote:
Dear all,
I have successfully imported our bibliographic records into Koha 3.12. However, I am having a lot of trouble importing our items (holdings). Unfortunately our old system doesn't export holdings/items with bib. records in MARC format. At this moment, I suspect my problem relates to data conversion from csv to MARC using MarcEdit. I am struggling to find any instruction/document on this matter. There are a few I found on Google search, but links are outdated. Does anyone has instruction/document on this task that I can have?
Your assistance will be much appreciated.
Iming
-----
Iming Chan Translib Information Service Melbourne, Australia -- View this message in context: http://koha.1045719.n5.nabble.com/Instruction-document-on-items-holdings-mig... 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
Iming Chan schreef op do 06-06-2013 om 14:42 [-0700]:
However, I am having a lot of trouble importing our items (holdings). Unfortunately our old system doesn't export holdings/items with bib. records in MARC format. At this moment, I suspect my problem relates to data conversion from csv to MARC using MarcEdit.
I know nothing about MarcEdit, but basically what Clint says is correct. You need to have your CSV be turned into a 952 entry per holding, and attached to the correct biblio record. The relevant 952 fields are documented here: http://wiki.koha-community.org/wiki/Holdings_data_fields_(9xx) If you're familiar with Perl scripting at all, I have a script that does something very similar for a migration from eLM I'm working on at the moment. It loads the items from a CSV and the biblio from MARC, rearranges things to fit Koha better, attaches the item data converted to a 952 field, and writes out a new MARC record for import into Koha. https://gitorious.org/+catalyst-koha/koha-toolbox/catalyst-koha-migration-to... -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D
Thank you Clint & Robin for your assistance. Much appreciated! I have finally imported bibliographic records and holdings/items linked correctly! Really happy on the outcome and amazed on the support and valuable assistance given. We should have been part of Koha family earlier!! Thank you. Iming ----- Iming Chan Translib Information Service Melbourne, Australia -- View this message in context: http://koha.1045719.n5.nabble.com/Instruction-document-on-items-holdings-mig... Sent from the Koha-general mailing list archive at Nabble.com.
Thank you Clint & Robin for your assistance. Much appreciated! I think I have * finally * imported the holdings/items into our databse with correctly matched bibliographic records (according to the Staged Import Management screen). However, just another question and hopefully this will be the last for this task. When I search a known title, there is no corresponding holding(s)/item(s) showing. Do I need to run another process or do something else to pull them together? Iming ----- Iming Chan Translib Information Service Melbourne, Australia -- View this message in context: http://koha.1045719.n5.nabble.com/Instruction-document-on-items-holdings-mig... Sent from the Koha-general mailing list archive at Nabble.com.
participants (3)
-
clint.deckard -
Iming Chan -
Robin Sheat