<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16809" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi, the item mapping document referenced below is
essential for mapping the 952 tag. However I have an observation and
question about the date formats. The document says the date format entered
in the 952 subfields depends on the system preferences:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>"* Dates formats are controlled by the system
preferences (Administration – Global system preferences – 118N/L10N –
dateformat). Three date formats are available: </FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>US - mm/dd/yyyy <BR>Metric - dd/mm/yyy <BR>ISO -
yyyy/mm/dd) "</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I have found for data loading that the internal
date format of YYYY-MM-DD works and I think is expected. If I use this
format in the 952 subfields the correct date shows up in the mysql
database and it shows correctly for the staff and OPAC according to the
system preference above.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I have also observed that if I put date in the 952
subfield in the format for system preference (eg dd/mm/yyyy) then it is accepted
but goes into the mysql database in the same format (ie dd/mm/yyyy) so it makes
me wonder what it would do with date processing on it.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>The question is: Can anyone confirm whether the
dates entered in the 952 subfields should really be in the YYYY-MM-DD format and
if not can you shine any light on the observations above.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Many thanks.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Ian</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=lauraj@tcoek12.org
href="mailto:lauraj@tcoek12.org">lauraj@tcoek12.org</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=dearden@sarsf.org
href="mailto:dearden@sarsf.org">Doug Dearden</A> ; <A
title=info@bywatersolutions.com
href="mailto:info@bywatersolutions.com">Brendan Gallagher</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Cc:</B> <A title=Koha@lists.katipo.co.nz
href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, February 24, 2009 1:29
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [Koha] mapping data in Koha
3.0</DIV>
<DIV><BR></DIV>
<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 <<A
href="mailto:dearden@sarsf.org">dearden@sarsf.org</A>>:<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>
<P>
<HR>
<P></P>_______________________________________________<BR>Koha mailing
list<BR>Koha@lists.katipo.co.nz<BR>http://lists.katipo.co.nz/mailman/listinfo/koha<BR>
<P>
<HR>
<P></P><BR>No virus found in this incoming message.<BR>Checked by AVG -
www.avg.com <BR>Version: 8.0.237 / Virus Database: 270.11.3/1967 - Release
Date: 02/23/09 07:17:00<BR></BLOCKQUOTE></BODY></HTML>