<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:D="DAV:" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=utf-8">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:1599486913;
mso-list-template-ids:771907658;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1
{mso-list-id:2136555349;
mso-list-template-ids:-1615565444;}
@list l1:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>The original records didn’t have a location/branch code because this
branch was the only library in the DB. So, I added subfield $a to field 852 and
swapped 852 with 952 through MarcEdit. The weird thing is it isn’t all of the
books but is about half that are having this issue.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>When I do a search on say Sports it list for me all the records that
have the word sports attached to it. In the Location column the ones that are
missing the info give me the following info:<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal>1 item<o:p></o:p></p>
<p class=MsoNormal>1 available: <o:p></o:p></p>
<ul style='margin-top:0in' type=disc>
<li class=MsoNormal style='margin-top:4.8pt;margin-bottom:4.8pt;mso-list:l0 level1 lfo1'>(1)<o:p></o:p></li>
</ul>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>But the ones that have the info look like this:<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal>2 items<o:p></o:p></p>
<p class=MsoNormal>2 available: <o:p></o:p></p>
<ul style='margin-top:0in' type=disc>
<li class=MsoNormal style='margin-top:4.8pt;margin-bottom:4.8pt;mso-list:l1 level1 lfo2'>Solanco
High School (1)<o:p></o:p></li>
</ul>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>I have confirm in the DB that field 952 $a has the correct info
for the records that are missing the info.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Thanks<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Ed<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Edward J. Roche<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Network Administrator<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Solanco School District<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>717.786.2151 x2437<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>"At the End of the Day, Did You Play to Win or Not to
Lose?" <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Joe Atzberger
[mailto:ohiocore@gmail.com] <br>
<b>Sent:</b> Tuesday, March 17, 2009 11:44 AM<br>
<b>To:</b> Roche III, Edward<br>
<b>Cc:</b> koha@lists.katipo.co.nz<br>
<b>Subject:</b> Re: [Koha] Migration from Follett to Koha 3<o:p></o:p></span></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal style='margin-bottom:12.0pt'>Did you define the branch with
a branchcode that matches the itemdata? If not the result is predictable,
since the foreign key relationship on branchcode would be violated.<br>
<br>
--Joe<o:p></o:p></p>
<div>
<p class=MsoNormal>2009/3/17 Roche III, Edward <<a
href="mailto:edward_roche@solanco.k12.pa.us">edward_roche@solanco.k12.pa.us</a>><o:p></o:p></p>
<div>
<div>
<p>Good Morning All<o:p></o:p></p>
<p> <o:p></o:p></p>
<p>Has anyone come across an issue when you import your Follett catalog export
in Koha 3 a large number of your holdings info doesn’t get imported? I double
checked Follett and the info is there and there is a bibliography record in
Koha just no entry in the items table.<o:p></o:p></p>
<p> <o:p></o:p></p>
<p>Any ideas?<o:p></o:p></p>
<p> <o:p></o:p></p>
<p>Here is a sample of a record that is having this issue:<o:p></o:p></p>
<p> <o:p></o:p></p>
<p><span style='font-size:10.0pt'>=LDR 01365pam 2200325 a 4500</span><o:p></o:p></p>
<p><span style='font-size:10.0pt'>=001 854153E690C34B779B07B5A7D53BDD9C</span><o:p></o:p></p>
<p><span style='font-size:10.0pt'>=005 20081125124707.0</span><o:p></o:p></p>
<p><span style='font-size:10.0pt'>=008
071231t20082007nyu\\\\c\\\\\\000\1\eng\\</span><o:p></o:p></p>
<p><span style='font-size:10.0pt'>=010 \\$a 2007046493</span><o:p></o:p></p>
<p><span style='font-size:10.0pt'>=020 \\$a9780545051637</span><o:p></o:p></p>
<p><span style='font-size:10.0pt'>=035 \\$a(ICrlF)fol11914404 </span><o:p></o:p></p>
<p><span style='font-size:10.0pt'>=035 \\$a(ICrlF)12174W</span><o:p></o:p></p>
<p><span style='font-size:10.0pt'>=040 \\$aDLC$cDLC$dDLC$dICrlF</span><o:p></o:p></p>
<p><span style='font-size:10.0pt'>=042 \\$alcac</span><o:p></o:p></p>
<p><span style='font-size:10.0pt'>=043 \\$ar------</span><o:p></o:p></p>
<p><span style='font-size:10.0pt'>=050 00$aPZ7.D6475$bFe 2008</span><o:p></o:p></p>
<p><span style='font-size:10.0pt'>=082 00$a[Fic]$222</span><o:p></o:p></p>
<p><span style='font-size:10.0pt'>=100 1\$aD'Lacey, Chris.</span><o:p></o:p></p>
<p><span style='font-size:10.0pt'>=245 14$aThe fire eternal /$cChris
d'Lacey.</span><o:p></o:p></p>
<p><span style='font-size:10.0pt'>=250 \\$a1st Scholastic ed.</span><o:p></o:p></p>
<p><span style='font-size:10.0pt'>=260 \\$aNew York :$bOrchard Books,$c2008,
c2007.</span><o:p></o:p></p>
<p><span style='font-size:10.0pt'>=300 \\$a506 p. ;$c22 cm.</span><o:p></o:p></p>
<p><span style='font-size:10.0pt'>=500 \\$aFour book series includes: The
Fire Within, Icefire. Fire Star, The Fire Eternal.</span><o:p></o:p></p>
<p><span style='font-size:10.0pt'>=520 \\$aAs the weather grows wilder
and the ice caps melt, Arctic bears starve, dragons awake, the earth goddess Gaia
becomes restless, and Alexa, the daughter of best-selling author David Rain,
uses her special abilities in an attempt to save the world from the forces of
evil.</span><o:p></o:p></p>
<p><span style='font-size:10.0pt'>=650 \7$aSupernatural$vFiction.$2sears</span><o:p></o:p></p>
<p><span style='font-size:10.0pt'>=650 \7$aDragons$vFiction.$2sears</span><o:p></o:p></p>
<p><span style='font-size:10.0pt'>=650 \7$aClimate$vFiction.$2sears</span><o:p></o:p></p>
<p><span style='font-size:10.0pt'>=650 \7$aEnvironmental
degradation$vFiction.$2sears</span><o:p></o:p></p>
<p><span style='font-size:10.0pt'>=651 \7$aArctic
Regions$vFiction.$2sears</span><o:p></o:p></p>
<p><span style='font-size:10.0pt'>=952 \\$bFiction$hFIC
DLA$pT0025982$t1$xFSC@aR@b148@c20081014@i1@jHardcover@fFollett$xFUND:
District$aSHS</span><o:p></o:p></p>
<p> <o:p></o:p></p>
<p> <o:p></o:p></p>
<p> <o:p></o:p></p>
<p>Thanks<o:p></o:p></p>
<p>Ed<o:p></o:p></p>
<p> <o:p></o:p></p>
<p>Edward J. Roche<o:p></o:p></p>
<p>Network Administrator<o:p></o:p></p>
<p>Solanco School District<o:p></o:p></p>
<p>717.786.2151 x2437<o:p></o:p></p>
<p> <o:p></o:p></p>
<p> <o:p></o:p></p>
<p>"At the End of the Day, Did You Play to Win or Not to Lose?" <o:p></o:p></p>
<p> <o:p></o:p></p>
<p> <o:p></o:p></p>
</div>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><br>
_______________________________________________<br>
Koha mailing list<br>
<a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>
<a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><o:p></o:p></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</body>
</html>