<div dir="ltr">On Tue, Aug 12, 2008 at 6:36 PM, Library Guy <span dir="ltr"><<a href="mailto:library.guy.zero@gmail.com">library.guy.zero@gmail.com</a>></span> wrote:<br><div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div dir="ltr">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?</div>
</blockquote><div><br>Unfortunately, no. I hadn't thought about that. MarcEdit is probably your best option.<br> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div dir="ltr"><br>
<br>Thank you!<div><div></div><div class="Wj3C7c"><br><br><div class="gmail_quote">On Tue, Aug 12, 2008 at 2:11 PM, Jesse Weaver <span dir="ltr"><<a href="mailto:jesse.weaver@liblime.com" target="_blank">jesse.weaver@liblime.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div dir="ltr"><div>On Tue, Aug 12, 2008 at 11:42 AM, Library Guy <span dir="ltr"><<a href="mailto:library.guy.zero@gmail.com" target="_blank">library.guy.zero@gmail.com</a>></span> wrote:<br></div><div class="gmail_quote">
<div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div dir="ltr">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. </div></blockquote>
</div><div><br>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 .<br> </div><div>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div dir="ltr"> 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.<br>
<br>Thank you!<div><div></div><br></div></div></blockquote></div></div><br>This would also work.<br></div>
</blockquote></div><br></div></div></div>
</blockquote></div><br></div>