[Koha] Import items (holdings)
jesse.weaver at liblime.com
Thu Aug 14 02:58:20 NZST 2008
On Tue, Aug 12, 2008 at 6:36 PM, Library Guy <library.guy.zero at 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
> Thank you!
> On Tue, Aug 12, 2008 at 2:11 PM, Jesse Weaver <jesse.weaver at liblime.com>wrote:
>> On Tue, Aug 12, 2008 at 11:42 AM, Library Guy <library.guy.zero at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Koha