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