{"id":1041,"date":"2020-10-07T22:00:48","date_gmt":"2020-10-07T14:00:48","guid":{"rendered":"https:\/\/www.yohz.com\/blogs\/?p=1041"},"modified":"2022-07-07T10:35:11","modified_gmt":"2022-07-07T02:35:11","slug":"using-the-column-name-in-your-file-naming-convention-in-access-ole-export-sql-blob-export","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2020\/10\/07\/using-the-column-name-in-your-file-naming-convention-in-access-ole-export-sql-blob-export\/","title":{"rendered":"Using the column name in your file naming convention in Access OLE Export \/ SQL Blob Export"},"content":{"rendered":"<p>When you export images and files 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> and each row of your table or result set contains multiple columns that contain the blob data e.g.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1044\" src=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/10\/aoe_colname01.png\" alt=\"\" width=\"619\" height=\"490\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/10\/aoe_colname01.png 619w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/10\/aoe_colname01-300x237.png 300w\" sizes=\"(max-width: 619px) 100vw, 619px\" \/><\/p>\n<p>you could previously only use the column index in the file naming convention to identify the source column of the exported file e.g.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1045\" src=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/10\/aoe_colname02.png\" alt=\"\" width=\"575\" height=\"232\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/10\/aoe_colname02.png 575w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/10\/aoe_colname02-300x121.png 300w\" sizes=\"(max-width: 575px) 100vw, 575px\" \/><\/p>\n<p>which would then name the exported files this way:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1032\" src=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/10\/colname_01.png\" alt=\"\" width=\"537\" height=\"191\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/10\/colname_01.png 537w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/10\/colname_01-300x107.png 300w\" sizes=\"(max-width: 537px) 100vw, 537px\" \/><\/p>\n<p>Files with the suffix <strong>0002<\/strong> indicates that it was exported from the 2nd column (<strong>ThumbnailPhoto<\/strong>), and <strong>0003<\/strong> from the 3rd column (<strong>LargePhoto<\/strong>).<\/p>\n<p>From version 3.17 onwards, you can now use the column name in the naming convention, using the <strong>&lt;%columnname%&gt;<\/strong> tag e.g.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1046\" src=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/10\/aoe_colname03.png\" alt=\"\" width=\"582\" height=\"545\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/10\/aoe_colname03.png 582w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/10\/aoe_colname03-300x281.png 300w\" sizes=\"(max-width: 582px) 100vw, 582px\" \/><\/p>\n<p>The exported files are then named this way:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1035\" src=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/10\/colname_04.png\" alt=\"\" width=\"601\" height=\"219\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/10\/colname_04.png 601w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2020\/10\/colname_04-300x109.png 300w\" sizes=\"(max-width: 601px) 100vw, 601px\" \/><\/p>\n<p>which is more meaningful.<\/p>\n<p>See also:<\/p>\n<ul>\n<li><a href=\"https:\/\/www.yohz.com\/blogs\/2020\/05\/08\/naming-the-exported-files-in-access-ole-export-and-sql-blob-export\/\">custom naming convention for your exported files<\/a><\/li>\n<\/ul>\n<div class=\"fcbkbttn_buttons_block\" id=\"fcbkbttn_left\"><div class=\"fcbkbttn_like \"><fb:like href=\"https:\/\/www.yohz.com\/blogs\/2020\/10\/07\/using-the-column-name-in-your-file-naming-convention-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\/2020\/10\/07\/using-the-column-name-in-your-file-naming-convention-in-access-ole-export-sql-blob-export\/\" data-type=\"button\" data-size=\"small\"><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>When you export images and files using Access OLE Export \/ SQL Blob Export and each row of your table or result set contains multiple columns that contain the blob data e.g. you could previously only use the column index in the file naming convention to identify the source column of the exported file e.g. [&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\/1041"}],"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=1041"}],"version-history":[{"count":2,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/1041\/revisions"}],"predecessor-version":[{"id":1755,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/1041\/revisions\/1755"}],"wp:attachment":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/media?parent=1041"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/categories?post=1041"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/tags?post=1041"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}