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:
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.