<p>Thank you for the quick responses from you and Brendan will help alot!
</p><p>I think I may start with the MarcEdit and then try the Koha Mapping. I
want to make sure my data is readable with the Koha database, not like my first
import. </p><p>Thanks again for your help!</p><p>Quoting Doug Dearden
<dearden@sarsf.org>:<br /><br />> Laura,<br />><br />> Take a
look at this page in the doc: <br />> <a
href="https://sites.google.com/a/liblime.com/koha-manual/Home/Table-of-Contents/Cataloging/item-fields-data-migration"
target="_blank">https://sites.google.com/a/liblime.com/koha-manual/Home/Table-of-Contents/Cataloging/item-fields-data-migration</a><br
/>><br />> Koha stores the item info in the 952 field. It looks like your
item <br />> info is in the 999 field. You need to work out a mapping to
move <br />> the info from the subfields in the 999 field to the right
subfield <br />> in the 952 (or other) field. You can use MarcEdit to do
this, I <br />> think by making individual passes at the file to move the
subfield <br />> info one at a time. Or you can generate a script from
MarcEdit and <br />> modify it.<br />><br />> Also take a look at the
Koha to Marc mapping in the Administration <br />> page of the Staff
client. This is where the links between the two <br />> are defined. If
your item types are in 245$h, Koha won't be looking <br />> there. The
default is to look in 942$c for the item type, and at <br />> the item level
to look in the 952$y field. In the koha to marc <br />> mapping there are
three screens, biblio, biblioitems and items that <br />> you access with
the drop down menu. Be careful changing these <br />> links. If you can
use MarcEdit to modify your incoming file to <br />> match that is probably
best.<br />><br />> You might try making a file with just one or two
records, manually <br />> editing them and then use MarkMaker to make a
file. Import that and <br />> see how it looks. Tweak your mapping until
it is right then use <br />> MarcEdit to move the subfields around in
mass.<br />><br />> Best,<br />><br />> Doug Dearden<br />><br
/>><br />><br />>>>> "Laura Johnson"
<lauraj@tcoek12.org> 2/23/2009 2:22:43 PM >>><br />> Hello,<br
/>><br />><br />><br />> I have installed Koha on 3.0 and I am ready
to import my records (again) and<br />> would like some advice on the best
practice of mapping my data. I have the<br />> title listed under 245$a and
the media type under 245$h. Here is a sample<br />> of the items we carry in
our library. Our library consists of Video<br />> Cassettes and audio
books.<br />><br />><br />><br />><br />><br />><br />><br
/>> =LDR 00660ngm 2200169 4500<br />><br />><br />> =005
20030703081938.0<br />><br />><br />> =007 vuucuuuuu<br />><br
/>><br />> =008 991123s1989\\\\\\\030<br />><br />><br />> =050
\\$bVC3194$c0<br />><br />><br />> =245 \\$aReading Rainbow: Humphrey
The Lost Whale: A True Story$hVC<br />><br />><br />> =260
\\$bGPN$c1989<br />><br />><br />> =300 \\$a30$bcol$e1<br />><br
/>><br />> =520 \\$aBased on the true story of a California Humpback
whale that gets<br />> lost, the book by Wendy Tokuda and Richard Hall
inspires Levar to spend a<br />> day at sea whale watching.<br />><br
/>><br />> =521 \\$aPrimary<br />><br />><br />> =650 \\$aLIFE
SCIENCE, BIOLOGY-MAMMALS<br />><br />><br />> =650 \\$aLANGUAGE AND
LITERATURE-CHILDREN'S LITERATURE<br />><br />><br />> =999
\\$pVC319401$cMain Library$k01$r0.00$a01/01/1980$b12/31/2022$yVC3194<br
/>><br />><br />><br />> Last time I imported the data, only the
description is visible. I ended up<br />> deleting the Koha database and so I
can start with a fresh database. I would<br />> like to use the mapping tool
in Koha, but if I need to use MarcEdit to<br />> change the tag numbers
please let me know. I just want to make sure that I<br />> am using the tools
correctly.<br />><br />><br />><br />> Has anyone had the same
experience of importing similar data into Koha and<br />> if you have a
detailed description of the best practice for this procedure.<br />><br
/>><br />><br />> Thank you in advanced and for your patience with my
limited knowledge of the<br />> Koha Software.<br />><br />><br
/>><br />> Sincerely,<br />><br />><br />><br />> Laura
Johnson<br />><br />> System Administrator and Health Assistant<br
/>><br />> Trinity County Office of Education<br />><br />> 201
Memorial Dr.<br />><br />> P.O. Box 1256<br />><br />> Weaverville,
CA 96093<br />><br />> www.tcoek12.org<br />><br />> (530) 623-2861
ext236<br />><br />> (530 ) 623-4489 FAX<br />><br />><br />><br
/>><br />><br /></p>