<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:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="country-region"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="Street"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="address"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Garamond;
panose-1:2 2 4 4 3 3 1 1 8 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:Garamond;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</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><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Good day everyone<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Some (possibly) helpful hints in converting DBTextworks to
Marc records.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Our very clever IT chap has cracked the problem I had with
converting the DBTextwork file I had created (which looked fine until the
Marcedit was run over it and all the fields just ran into each other)) by doing
the following in Marcedit<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>In Marc Delimited Text Translator<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Choose “Delimited” - comma<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Text qualifier - “<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>And tick UTF-8 encoded box<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Then when file is converted and you reach the Marc Tools for
edit :<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Input file C:\ (file name).csv<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Output file C:\(same file name).mrc<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>And tick Translate to UTF <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Then execute<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>And it should work (well, it did for me!).<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Also when doing the first part of the conversion I found
that these Export options worked for me<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Record separator {CR} {LF}<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Field separator ,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Entry separator |<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Quote character “<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Store field names in first row tick box<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Hopefully the next step will be less fraught!<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>regards<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face=Garamond><span style='font-size:12.0pt'>Steph
Lambert<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face=Garamond><span style='font-size:12.0pt'>Information
Services Advisor<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face=Garamond><span style='font-size:12.0pt'>Family
Planning - <em><i><font face=Garamond><span style='font-family:Garamond'>Positive
Sexual Health</span></font></i></em><o:p></o:p></span></font></p>
<p class=MsoNormal><st1:Street w:st="on"><st1:address w:st="on"><font size=3
face=Garamond><span style='font-size:12.0pt'>203-209 Willis Street</span></font></st1:address></st1:Street><o:p></o:p></p>
<p class=MsoNormal><st1:address w:st="on"><st1:Street w:st="on"><font size=3
face=Garamond><span style='font-size:12.0pt'>P.O. Box</span></font></st1:Street>
11</st1:address> 515<o:p></o:p></p>
<p class=MsoNormal><st1:City w:st="on"><st1:place w:st="on"><font size=3
face=Garamond><span style='font-size:12.0pt'>Wellington</span></font></st1:place></st1:City><o:p></o:p></p>
<p class=MsoNormal><st1:country-region w:st="on"><st1:place w:st="on"><font
size=3 face=Garamond><span style='font-size:12.0pt'>New Zealand</span></font></st1:place></st1:country-region><o:p></o:p></p>
<p class=MsoNormal><font size=3 face=Garamond><span style='font-size:12.0pt'>phone
: (04)384 4349<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face=Garamond><span style='font-size:12.0pt'> </span><o:p></o:p></font></p>
<p class=MsoNormal><font size=3 face=Garamond><span style='font-size:12.0pt'><o:p> </o:p></span></font></p>
</div>
<pre></pre>
<div style='font-family:Garamond, verdana;'>
<p>Earlybird registrations for Family Planning Conference 2010 OPEN NOW. Register online at <a href='http://www.familyplanning.org.nz'>www.familyplanning.org.nz</a><br/><a href='http://www.familyplanning.org.nz'><img src='http://www.kiwiwebservices.com/imagehost/images/ki83g37nzx3rdlmwb4ux.jpg' border='0' alt='Family Planning Conference 2010'></a></p>
</div>
<pre>
</pre><pre></pre>
<div style="font-family:Garamond, Tahoma, Verdana, Sans-Serif;">
<p>The content of this email is confidential and may be legally privileged.
If it is not intended for you, please email the sender immediately and destroy the original message.<br/>Family Planning is a Registered Charity CC11104</p>
</div>
<pre>
</pre></body>
</html>