[Koha] Import items (holdings)

Jesse Weaver 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
best option.


>
>
> 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...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20080813/c8382ce5/attachment.htm 


More information about the Koha mailing list