{"id":1068,"date":"2020-12-02T11:11:00","date_gmt":"2020-12-02T03:11:00","guid":{"rendered":"https:\/\/www.yohz.com\/blogs\/?p=1068"},"modified":"2023-10-12T22:27:36","modified_gmt":"2023-10-12T14:27:36","slug":"exporting-content-from-navision-incoming-document-attachment-table","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2020\/12\/02\/exporting-content-from-navision-incoming-document-attachment-table\/","title":{"rendered":"Exporting content from Navision Incoming Document Attachment table"},"content":{"rendered":"<p>In <a href=\"https:\/\/www.yohz.com\/siv8_details.htm\">SQL Image Viewer<\/a> 10.3, we added support for Navision compressed files stored in the <strong>Incoming Document Attachment<\/strong> table.<\/p>\n<p># Note that this applies only to Navision 2013 and newer databases.<\/p>\n<p>When you run a query on the <strong>Incoming Document Attachment<\/strong> table, the <strong>Content<\/strong> field will display the following if it contains compressed data.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1069\" src=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/11\/navision01.png\" alt=\"\" width=\"525\" height=\"373\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/11\/navision01.png 525w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/11\/navision01-300x213.png 300w\" sizes=\"(max-width: 525px) 100vw, 525px\" \/><\/p>\n<p>To extract the contents, click on the <strong>Export images and files<\/strong> button.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1070\" src=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/11\/navision02.png\" alt=\"\" width=\"525\" height=\"176\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/11\/navision02.png 525w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/11\/navision02-300x101.png 300w\" sizes=\"(max-width: 525px) 100vw, 525px\" \/><\/p>\n<p>This opens the <strong>Export images and files<\/strong> dialog.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1071\" src=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/11\/navision03.png\" alt=\"\" width=\"706\" height=\"621\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/11\/navision03.png 706w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/11\/navision03-300x264.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/11\/navision03-624x549.png 624w\" sizes=\"(max-width: 706px) 100vw, 706px\" \/><\/p>\n<p>Walk through the steps, and SQL Image Viewer will extract and export the files stored in the <strong>Content<\/strong> field for you.<\/p>\n<p>Learn more about SQL Image Viewer <a href=\"https:\/\/www.yohz.com\/siv8_details.htm\">here<\/a>, and <a href=\"https:\/\/www.yohz.com\/downloads\/sqlblobviewer\/SQLImageViewerSetup.zip\">download<\/a> a free 14-day trial now and see how SQL Image Viewer can export your Navision compressed content in minutes.<\/p>\n<div class=\"fcbkbttn_buttons_block\" id=\"fcbkbttn_left\"><div class=\"fcbkbttn_like \"><fb:like href=\"https:\/\/www.yohz.com\/blogs\/2020\/12\/02\/exporting-content-from-navision-incoming-document-attachment-table\/\" action=\"like\" colorscheme=\"light\" layout=\"button\"  size=\"small\"><\/fb:like><\/div><div class=\"fb-share-button  \" data-href=\"https:\/\/www.yohz.com\/blogs\/2020\/12\/02\/exporting-content-from-navision-incoming-document-attachment-table\/\" data-type=\"button\" data-size=\"small\"><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>In SQL Image Viewer 10.3, we added support for Navision compressed files stored in the Incoming Document Attachment table. # Note that this applies only to Navision 2013 and newer databases. When you run a query on the Incoming Document Attachment table, the Content field will display the following if it contains compressed data. To [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[5,11],"tags":[7,12],"_links":{"self":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/1068"}],"collection":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/comments?post=1068"}],"version-history":[{"count":3,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/1068\/revisions"}],"predecessor-version":[{"id":2045,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/1068\/revisions\/2045"}],"wp:attachment":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/media?parent=1068"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/categories?post=1068"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/tags?post=1068"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}