{"id":171,"date":"2018-09-06T20:33:38","date_gmt":"2018-09-06T20:33:38","guid":{"rendered":"http:\/\/www.dabbler.dk\/?p=171"},"modified":"2019-05-11T18:09:59","modified_gmt":"2019-05-11T18:09:59","slug":"cent-and-yen-in-dynamics-nav","status":"publish","type":"post","link":"https:\/\/www.dabbler.dk\/index.php\/2018\/09\/06\/cent-and-yen-in-dynamics-nav\/","title":{"rendered":"Cent and Yen in Dynamics NAV 2018"},"content":{"rendered":"<p>If you run a Danish Dynamics NAV and get objects from outside Denmark, you might experience the Danish letter \u00f8\/\u00d8 beeing replaced by \u00a2\/\u00a5 (the sign for Cent and Yen).<\/p>\n<p><strong>The fix?<\/strong><br \/>\nSimply export all your objects as text, run them through the following powershell and import them again.<\/p>\n<pre>(((Get-Content -encoding Oem \"InFile.txt\") -replace ([char]8250),([char]251)) -replace ([char]157),([char]238)) | Set-Content -encoding Oem \"OutFile.txt\"<\/pre>\n<p>&nbsp;<\/p>\n<p>Finish off by a compile and syncronize all tables.<\/p>\n<p>This is off cause on your own risk, so start by taking a full backup of your NAV system\/server.<\/p>\n<hr>\n<p>2018-12-20 Updated: powershell improved and now using unicode values of chars<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you run a Danish Dynamics NAV and get objects from outside Denmark, you might experience the Danish letter \u00f8\/\u00d8 beeing replaced by \u00a2\/\u00a5 (the sign for Cent and Yen). The fix? Simply export all your objects as text, run them through the following powershell and import them again. (((Get-Content -encoding Oem &#8220;InFile.txt&#8221;) -replace ([char]8250),([char]251)) &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/www.dabbler.dk\/index.php\/2018\/09\/06\/cent-and-yen-in-dynamics-nav\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Cent and Yen in Dynamics NAV 2018&#8221;<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":216,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,11,5],"tags":[27,25,24,26,12],"class_list":["post-171","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dynamics-nav","category-powershell","category-software","tag-bug","tag-dynamics","tag-microsoft","tag-nav","tag-powershell"],"_links":{"self":[{"href":"https:\/\/www.dabbler.dk\/index.php\/wp-json\/wp\/v2\/posts\/171","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dabbler.dk\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dabbler.dk\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dabbler.dk\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dabbler.dk\/index.php\/wp-json\/wp\/v2\/comments?post=171"}],"version-history":[{"count":7,"href":"https:\/\/www.dabbler.dk\/index.php\/wp-json\/wp\/v2\/posts\/171\/revisions"}],"predecessor-version":[{"id":220,"href":"https:\/\/www.dabbler.dk\/index.php\/wp-json\/wp\/v2\/posts\/171\/revisions\/220"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dabbler.dk\/index.php\/wp-json\/wp\/v2\/media\/216"}],"wp:attachment":[{"href":"https:\/\/www.dabbler.dk\/index.php\/wp-json\/wp\/v2\/media?parent=171"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dabbler.dk\/index.php\/wp-json\/wp\/v2\/categories?post=171"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dabbler.dk\/index.php\/wp-json\/wp\/v2\/tags?post=171"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}