{"id":1077,"date":"2020-12-02T11:30:38","date_gmt":"2020-12-02T03:30:38","guid":{"rendered":"https:\/\/www.yohz.com\/blogs\/?p=1077"},"modified":"2020-12-03T17:39:21","modified_gmt":"2020-12-03T09:39:21","slug":"redirecting-ole-object-linked-files-during-export","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2020\/12\/02\/redirecting-ole-object-linked-files-during-export\/","title":{"rendered":"Redirecting OLE-Object linked files during export"},"content":{"rendered":"

In SQL Image Viewer<\/a> 10.3, and Access OLE Export<\/a>\/SQL Blob Export<\/a> 3.18 we added the option to redirect where to look for OLE-Object linked files during the export process.<\/p>\n

A common issue when using OLE-Object linked files is that the location of the linked files have changed.\u00a0 For e.g. you may have previously linked files from the g:\\customer_invoices\\<\/strong> folder, but say those files have now been moved to g:\\archive\\customer_invoices\\2018\\<\/strong>.<\/p>\n

Previous versions of SQL Image Viewer<\/a> will fail to locate these items during the export process.\u00a0 In version 10.3, you will now find a redirect<\/strong> button in the Image and File Options<\/strong> screen.<\/p>\n

\"\"<\/p>\n

In Access OLE Export<\/a>\/SQL Blob Export<\/a>, you will find the Redirect<\/strong> button in the Options<\/strong> screen.\"\"<\/p>\n

Click on that button to bring up the Redirect<\/strong> window.\u00a0 Here, you can define how the old folders map to the new folders.\u00a0 For our previous example, we would enter the following:<\/p>\n

\"\"<\/p>\n

Now during the export process, when SQL Image Viewer<\/a> fails to find the files in the original folder, it will look to the redirection rules defined here and look in the new folder for the files.\u00a0 It will then export the files that it finds.\u00a0 You can enter multiple redirection entries, and each entry must be on a new line.<\/p>\n

Note that the redirection entries are essentially a search\/replace process.\u00a0 Anything entered prior to the redirection symbol (>) is replaced with the value entered after the symbol.\u00a0 Thus, the entries are not just limited to redirecting entire paths.<\/p>\n

<\/fb:like><\/div>
<\/div><\/div>","protected":false},"excerpt":{"rendered":"

In SQL Image Viewer 10.3, and Access OLE Export\/SQL Blob Export 3.18 we added the option to redirect where to look for OLE-Object linked files during the export process. A common issue when using OLE-Object linked files is that the location of the linked files have changed.\u00a0 For e.g. you may have previously linked files […]<\/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,5,11],"tags":[18,48,7,12],"_links":{"self":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/1077"}],"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=1077"}],"version-history":[{"count":3,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/1077\/revisions"}],"predecessor-version":[{"id":1083,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/1077\/revisions\/1083"}],"wp:attachment":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/media?parent=1077"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/categories?post=1077"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/tags?post=1077"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}