{"id":1389,"date":"2021-06-11T16:42:29","date_gmt":"2021-06-11T08:42:29","guid":{"rendered":"https:\/\/www.yohz.com\/blogs\/?p=1389"},"modified":"2021-06-11T16:42:29","modified_gmt":"2021-06-11T08:42:29","slug":"improved-debugging-in-access-ole-export-sql-blob-export","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2021\/06\/11\/improved-debugging-in-access-ole-export-sql-blob-export\/","title":{"rendered":"Improved debugging in Access OLE Export \/ SQL Blob Export"},"content":{"rendered":"<p>Sometimes it happens that you may have some items that <a href=\"https:\/\/www.yohz.com\/aole_details.htm\">Access OLE Export<\/a> or <a href=\"https:\/\/www.yohz.com\/sbe_details.htm\">SQL Blob Export<\/a> is unable to export correctly.\u00a0 This can be due to many reasons e.g.<\/p>\n<ul>\n<li>the binary data has been compressed by the uploading application<\/li>\n<li>the binary data has been encrypted by the uploading application<\/li>\n<li>the uploading application has appended additional header bytes to the data<\/li>\n<li>an unsupported OLE server was used to upload the file<\/li>\n<\/ul>\n<p>To troubleshoot these issues, we would ask the user to send us the raw data exactly as stored in the database.\u00a0 This usually involves using <a href=\"https:\/\/www.yohz.com\/siv8_details.htm\">SQL Image Viewer<\/a> to perform the extraction.<\/p>\n<p>We&#8217;ve now added the option to extract the raw data using <a href=\"https:\/\/www.yohz.com\/aole_details.htm\">Access OLE Export<\/a> \/ <a href=\"https:\/\/www.yohz.com\/sbe_details.htm\">SQL Blob Export<\/a>.\u00a0 You can do this by selecting the <strong>debugging &#8211; create bin files for analysis<\/strong> item.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1392\" src=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2021\/06\/debug01-1.png\" alt=\"\" width=\"621\" height=\"446\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2021\/06\/debug01-1.png 621w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2021\/06\/debug01-1-300x215.png 300w\" sizes=\"(max-width: 621px) 100vw, 621px\" \/><\/p>\n<p>Now when you have problems exporting your files, selecting this option will cause a raw copy of the data to be exported together, with the <strong>.debug.bin<\/strong> extension.\u00a0 You can then send us these <strong>.debug.bin<\/strong> files for further analysis.<\/p>\n<div class=\"fcbkbttn_buttons_block\" id=\"fcbkbttn_left\"><div class=\"fcbkbttn_like \"><fb:like href=\"https:\/\/www.yohz.com\/blogs\/2021\/06\/11\/improved-debugging-in-access-ole-export-sql-blob-export\/\" action=\"like\" colorscheme=\"light\" layout=\"button\"  size=\"small\"><\/fb:like><\/div><div class=\"fb-share-button  \" data-href=\"https:\/\/www.yohz.com\/blogs\/2021\/06\/11\/improved-debugging-in-access-ole-export-sql-blob-export\/\" data-type=\"button\" data-size=\"small\"><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Sometimes it happens that you may have some items that Access OLE Export or SQL Blob Export is unable to export correctly.\u00a0 This can be due to many reasons e.g. the binary data has been compressed by the uploading application the binary data has been encrypted by the uploading application the uploading application has appended [&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":[17,44],"tags":[18,48],"_links":{"self":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/1389"}],"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=1389"}],"version-history":[{"count":2,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/1389\/revisions"}],"predecessor-version":[{"id":1393,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/1389\/revisions\/1393"}],"wp:attachment":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/media?parent=1389"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/categories?post=1389"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/tags?post=1389"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}