[Koha] From DBTextworks to Marc records

[Steph Lambert]

Good day everyone

 

Some (possibly) helpful hints in converting DBTextworks to Marc records.

 

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

 

In Marc Delimited Text Translator

Choose   "Delimited"  -  comma

Text qualifier  -   "

And tick UTF-8 encoded box

 

Then when file is converted and you reach the Marc Tools for edit :

 

Input file C:\ (file name).csv

Output file C:\(same file name).mrc

 

And tick  Translate to UTF 

Then execute

 

And it should work (well, it did for me!).

 

Also when doing the first part of the conversion I found that these
Export options worked for me

 

Record separator  {CR} {LF}

Field separator     ,

Entry separator  |

Quote character  "

Store field names in first row   tick box

 

Hopefully the next step will be less fraught!

 

regards

 

Steph Lambert

Information Services Advisor

Family Planning - Positive Sexual Health

203-209 Willis Street

P.O. Box 11 515

Wellington

New Zealand

phone : (04)384 4349

 

 

</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>
<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>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20100826/257283ea/attachment-0001.htm