{"id":212,"date":"2010-09-10T09:48:48","date_gmt":"2010-09-10T13:48:48","guid":{"rendered":"http:\/\/www.bobsown.net\/?p=212"},"modified":"2010-09-10T09:55:26","modified_gmt":"2010-09-10T13:55:26","slug":"tools-%e2%80%b9-bobs-own-blog-%e2%80%94-wordpress","status":"publish","type":"post","link":"https:\/\/www.bobsown.net\/?p=212","title":{"rendered":"Conversion from DBTextworks to Koha"},"content":{"rendered":"

Some (possibly) helpful hints in converting DBTextworks to Marc records.<\/span><\/span><\/p>\n

We have 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<\/span><\/span><\/p>\n


\n<\/span><\/span><\/p>\n

<\/span><\/span>In Marc Delimited Text Translator<\/span><\/span><\/strong><\/p>\n

Choose \u00a0\u00a0\u201cDelimited\u201d\u00a0 – \u00a0comma<\/span><\/span><\/p>\n

Text qualifier \u00a0– \u00a0\u00a0\u201c<\/span><\/span><\/p>\n

And tick UTF-8 encoded box<\/span><\/span><\/p>\n

Then when file is converted and you reach the Marc Tools for edit<\/strong> :<\/span><\/span><\/p>\n

<\/span><\/span>Input file C:\\ (file name).csv<\/span><\/span><\/p>\n

Output file C:\\(same file name).mrc<\/span><\/span><\/p>\n

<\/span><\/span>And tick\u00a0 Translate to UTF <\/span><\/span><\/p>\n

Then execute<\/span><\/span><\/p>\n

<\/span><\/span>And it should work (well, it did for me!).<\/span><\/span><\/p>\n

<\/span><\/span>Also when doing the first part of the conversion I found that these Export options worked for me<\/span><\/span><\/p>\n

<\/span><\/span>Record separator\u00a0 {CR} {LF}<\/span><\/span><\/p>\n

Field separator\u00a0\u00a0\u00a0\u00a0 ,<\/span><\/span><\/p>\n

Entry separator\u00a0 |<\/span><\/span><\/p>\n

Quote character\u00a0 \u201c<\/span><\/span><\/p>\n

Store field names in first row\u00a0\u00a0 tick box<\/span><\/span><\/p>\n

Steph Lambert<\/strong><\/span><\/span><\/p>\n

familyplanning.org.nz<\/span><\/span><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

Some (possibly) helpful hints in converting DBTextworks to Marc records. We have 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 … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[16],"tags":[],"class_list":["post-212","post","type-post","status-publish","format-standard","hentry","category-conversion-to-koha"],"_links":{"self":[{"href":"https:\/\/www.bobsown.net\/index.php?rest_route=\/wp\/v2\/posts\/212","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bobsown.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bobsown.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bobsown.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bobsown.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=212"}],"version-history":[{"count":7,"href":"https:\/\/www.bobsown.net\/index.php?rest_route=\/wp\/v2\/posts\/212\/revisions"}],"predecessor-version":[{"id":216,"href":"https:\/\/www.bobsown.net\/index.php?rest_route=\/wp\/v2\/posts\/212\/revisions\/216"}],"wp:attachment":[{"href":"https:\/\/www.bobsown.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=212"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bobsown.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=212"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bobsown.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=212"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}