Re: [Koha] Import items (holdings)
It's a fixed-field length file, so it's easily converted to CSV. If I'm understanding, Koha requires the items (holdings) to be included in the MARC 952 field before import. I'm looking into using MarcEdit to export my MARCs to text, merging in the items data and then converting back to MARC. If anyone has similar experience please give your advice. Thank you! On Tue, Aug 12, 2008 at 10:39 AM, Jesse Weaver <jesse.weaver@liblime.com>wrote:
On Mon, Aug 11, 2008 at 9:43 AM, Library Guy <library.guy.zero@gmail.com>wrote:
My current system exports the MARCs and the holdings into separate files. The MARC export routine inserts a item unique number into the 910 field, and the Item export includes this unique number in the item export file. I've imported my MARCs into Koha just fine, but I cannot figure out how to bulk import my holdings and then have them link properly to the MARCs. Can anyone help?
Thank you!
To the best of my knowledge, Koha can't deal with this automatically. Is the item export a CSV file, a marc record with holdings tags, ...?
On Tue, Aug 12, 2008 at 11:42 AM, Library Guy <library.guy.zero@gmail.com>wrote:
It's a fixed-field length file, so it's easily converted to CSV. If I'm understanding, Koha requires the items (holdings) to be included in the MARC 952 field before import.
This is correct, though _technically_ you could load the data into the `items` table (through mysql's LOAD DATA LOCAL INFILE command), then run misc/maintenance/sync_items_in_marc_bib.pl .
I'm looking into using MarcEdit to export my MARCs to text, merging in the items data and then converting back to MARC. If anyone has similar experience please give your advice.
Thank you!
This would also work.
I certainly would prefer to import into the sql table and run the sync script, but I don't see how the matching is done between the items and the bibs. The exported items CSV have only one guaranteed field in common with the MARC BIBs 910 field, so is there a command line option to instruct the script to sync based on MARC 910 matching with field xyz in the items table? Thank you! On Tue, Aug 12, 2008 at 2:11 PM, Jesse Weaver <jesse.weaver@liblime.com>wrote:
On Tue, Aug 12, 2008 at 11:42 AM, Library Guy <library.guy.zero@gmail.com>wrote:
It's a fixed-field length file, so it's easily converted to CSV. If I'm understanding, Koha requires the items (holdings) to be included in the MARC 952 field before import.
This is correct, though _technically_ you could load the data into the `items` table (through mysql's LOAD DATA LOCAL INFILE command), then run misc/maintenance/sync_items_in_marc_bib.pl .
I'm looking into using MarcEdit to export my MARCs to text, merging in the items data and then converting back to MARC. If anyone has similar experience please give your advice.
Thank you!
This would also work.
On Tue, Aug 12, 2008 at 6:36 PM, Library Guy <library.guy.zero@gmail.com>wrote:
I certainly would prefer to import into the sql table and run the sync script, but I don't see how the matching is done between the items and the bibs. The exported items CSV have only one guaranteed field in common with the MARC BIBs 910 field, so is there a command line option to instruct the script to sync based on MARC 910 matching with field xyz in the items table?
Unfortunately, no. I hadn't thought about that. MarcEdit is probably your best option.
Thank you!
On Tue, Aug 12, 2008 at 2:11 PM, Jesse Weaver <jesse.weaver@liblime.com>wrote:
On Tue, Aug 12, 2008 at 11:42 AM, Library Guy <library.guy.zero@gmail.com
wrote:
It's a fixed-field length file, so it's easily converted to CSV. If I'm understanding, Koha requires the items (holdings) to be included in the MARC 952 field before import.
This is correct, though _technically_ you could load the data into the `items` table (through mysql's LOAD DATA LOCAL INFILE command), then run misc/maintenance/sync_items_in_marc_bib.pl .
I'm looking into using MarcEdit to export my MARCs to text, merging in the items data and then converting back to MARC. If anyone has similar experience please give your advice.
Thank you!
This would also work.
Good news. I will be able to export BIBs with embedded items data, but in field 852 rather than 952. Would the correct preparation for import into Koha be to convert all 852 fields to 952, to adjust the default MARC framework for my BIBs or both? Thank you. On Wed, Aug 13, 2008 at 9:58 AM, Jesse Weaver <jesse.weaver@liblime.com>wrote:
On Tue, Aug 12, 2008 at 6:36 PM, Library Guy <library.guy.zero@gmail.com>wrote:
I certainly would prefer to import into the sql table and run the sync script, but I don't see how the matching is done between the items and the bibs. The exported items CSV have only one guaranteed field in common with the MARC BIBs 910 field, so is there a command line option to instruct the script to sync based on MARC 910 matching with field xyz in the items table?
Unfortunately, no. I hadn't thought about that. MarcEdit is probably your best option.
Thank you!
On Tue, Aug 12, 2008 at 2:11 PM, Jesse Weaver <jesse.weaver@liblime.com>wrote:
On Tue, Aug 12, 2008 at 11:42 AM, Library Guy < library.guy.zero@gmail.com> wrote:
It's a fixed-field length file, so it's easily converted to CSV. If I'm understanding, Koha requires the items (holdings) to be included in the MARC 952 field before import.
This is correct, though _technically_ you could load the data into the `items` table (through mysql's LOAD DATA LOCAL INFILE command), then run misc/maintenance/sync_items_in_marc_bib.pl .
I'm looking into using MarcEdit to export my MARCs to text, merging in the items data and then converting back to MARC. If anyone has similar experience please give your advice.
Thank you!
This would also work.
Hi, On Wed, Aug 13, 2008 at 5:39 PM, Library Guy <library.guy.zero@gmail.com> wrote:
Good news. I will be able to export BIBs with embedded items data, but in field 852 rather than 952. Would the correct preparation for import into Koha be to convert all 852 fields to 952, to adjust the default MARC framework for my BIBs or both?
To avoid having to edit both the framework and the Zebra indexing rules, I suggest converting the 852s to 952s. Regards, Galen -- Galen Charlton VP, Research & Development, LibLime galen.charlton@liblime.com p: 1-888-564-2457 x709 skype: gmcharlt
When you do this you also have to change the subfields. If you have not used MARCEdit that is quite simple and you don't want to do just a plain find/replace. Let me know if you need help it is fairly simple, but you may have to do it several times depending on the size of your file and the number of subfields you are dealing with. Galen Charlton wrote:
Hi,
On Wed, Aug 13, 2008 at 5:39 PM, Library Guy <library.guy.zero@gmail.com> wrote:
Good news. I will be able to export BIBs with embedded items data, but in field 852 rather than 952. Would the correct preparation for import into Koha be to convert all 852 fields to 952, to adjust the default MARC framework for my BIBs or both?
To avoid having to edit both the framework and the Zebra indexing rules, I suggest converting the 852s to 952s.
Regards,
Galen -- Galen Charlton VP, Research & Development, LibLime galen.charlton@liblime.com p: 1-888-564-2457 x709 skype: gmcharlt _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- View this message in context: http://www.nabble.com/Import-items-%28holdings%29-tp18928348p18973575.html Sent from the Koha - Discuss mailing list archive at Nabble.com.
Although the holdings data is all present in 952, some important data is not dedicated to a single subfield. For example, rather than Koha's $v for the price, the cost is instead held in a subfield and delimited within that subfield along with a lot of other important data. Even MarcEdit is not sophisticated enough to parse this and copy the data to alternate subfields. Does anyone know of a utility that can? I've been rethinking Jesse's idea of importing the MARC BIBs (without holdings) in Koha, then importing the holdings directly into the sql items table and running the sync script (after first exporting the biblionumbers and matching them into my exported holdings CSV, assuming that the biblionumber or the biblioitemnumber are the key field for syncing). Does anyone have any better ideas? Thank you. On Wed, Aug 13, 2008 at 6:04 PM, Galen Charlton <galen.charlton@liblime.com>wrote:
Hi,
On Wed, Aug 13, 2008 at 5:39 PM, Library Guy <library.guy.zero@gmail.com> wrote:
Good news. I will be able to export BIBs with embedded items data, but in field 852 rather than 952. Would the correct preparation for import into Koha be to convert all 852 fields to 952, to adjust the default MARC framework for my BIBs or both?
To avoid having to edit both the framework and the Zebra indexing rules, I suggest converting the 852s to 952s.
Regards,
Galen -- Galen Charlton VP, Research & Development, LibLime galen.charlton@liblime.com p: 1-888-564-2457 x709 skype: gmcharlt
On Fri, Aug 15, 2008 at 03:57:29PM -0500, Library Guy wrote:
Although the holdings data is all present in 952, some important data is not dedicated to a single subfield. For example, rather than Koha's $v for the price, the cost is instead held in a subfield and delimited within that subfield along with a lot of other important data. Even MarcEdit is not sophisticated enough to parse this and copy the data to alternate subfields. Does anyone know of a utility that can?
I've been rethinking Jesse's idea of importing the MARC BIBs (without holdings) in Koha, then importing the holdings directly into the sql items table and running the sync script (after first exporting the biblionumbers and matching them into my exported holdings CSV, assuming that the biblionumber or the biblioitemnumber are the key field for syncing).
Does anyone have any better ideas?
We developed very powerfull tool for data mungling. Unfortunately there is stil no user documentation for this, but techical documentation do exist. You can obtain it at http://svn.rot13.org/index.cgi/webpac2/browse/trunk (you will se some references about search engine and web front and, but for now just ignore this, because this part is not finished) If you manage to install this software I will be glad to help on how to use it. Of course you can also ask for help on installation issues, I will forward it to the author. Also, please send me a sample of your data and exact specification of the needed transformations, so I can see how complicated it could be (it seems to me that it could be very easy). Kind regards, Marijana --- Marijana Glavica Faculty of Humanities and Social Sciences Libraries I. Lucica 3, 10000 Zagreb, Croatia http://www.knjiznice.ffzg.hr
participants (5)
-
David Schuster -
Galen Charlton -
Jesse Weaver -
Library Guy -
Marijana Glavica