CONTACT US

568-3-53 (3rd Floor) Kompleks Mutiara 3 1/2 Mile, Jalan Ipoh 51200 Kuala Lumpur, Malaysia 6012-9714904 support@yohz.com https://www.yohz.com

RESOURCES

product blogs video tutorials help files
Copyright © 2005 - 2023 Yohz Software, a division of Yohz Ventures Sdn Bhd. ALL RIGHTS RESERVED. All trademarks or registered trademarks are property of their respective owners
Naming your exported files in SQL Blob Export Say your query retrieves 2 columns - one containing the file name, and another the file data. To name your files using the file name value, simply use the column name as the naming convention. SQL Blob Export then uses the value found in the LargePhotoFileName column to name the files. Sometimes, you may want to link a file with a primary key. In this example, we retrieve both the primary key and file data. To name the files using the primary key column, just use the column name in the naming convention. What if you wanted to format the numbers to 4 digits? SQL Blob Export supports the use of format specifiers. To format a number to 4 digits, use the format specifier :0000 e.g. It’s often the case that the column containing the original file name also contains the original path e.g. Thus, you cannot use the value in the LargePhotoFileName column to name your files if the path does not exist. To name your using using just the file name value, you can use the FILENAME format specifier e.g. What if you had 2 binary data columns in a row, and you wanted to name each item differently? E.g. All you have to do is use the conditional column tag in the naming convention. In the example below, we use the convention: <ThumbnailPhotoFileName::2><LargePhotoFileName::4> This tells SQL Blob Export to use the ThumbnailPhotoFileName value if it is currently naming the item from column 2, or use the LargePhotoFileName value if it is currently naming the item from column 4. If you have any questions on how SQL Blob Export can name your files, or any other general questions, do drop us a line at support@yohz.com.
Export images and binary data in 5 easy steps using SQL Blob Export
automatically identify most image formats and file types easily export millions of images/files in a single run export from a single table or use your own query supports Access, MySQL, MariaDB, Oracle, PostgreSQL, SQL Server, SQL Server Compact, and ODBC data sources
DOWNLOAD NOW
Get started with SQL Blob Export Download a free 14-day trial now, and start extracting images and binary data from your databases faster and easier than ever before.
Got a question? If you need help, or have any questions about Access OLE Export, please get in touch. support@yohz.com
Download trial Download trial Buy now for USD 95 Buy now for USD 95 See help file See help file

CONTACT US

568-3-53 (3rd Floor), Kompleks Mutiara, 3 1/2 Mile, Jalan Ipoh 51200 Kuala Lumpur, Malaysia 6012 9714904 support@yohz.com https://www.yohz.com

RESOURCES

product blogs video tutorials help files
Copyright © 2005 - 2023 Yohz Software, a division of Yohz Ventures Sdn Bhd. ALL RIGHTS RESERVED. All trademarks or registered trademarks are property of their respective owners
Export images and binary data in 5 easy steps using SQL Blob Export
automatically identify most image formats and file types easily export millions of images/files in a single run export from a single table or use your own query supports Access, MySQL, MariaDB, Oracle, PostgreSQL, SQL Server, SQL Server Compact, SQLite, and ODBC data sources
Download trial Download trial Buy now for USD 95 Buy now for USD 95 See help file See help file

Naming your exported files in SQL Blob

Export

Say your query retrieves 2 columns - one containing the file

name, and another the file data.

To name your files using the file name value, simply use the column name as the naming convention.

SQL Blob Export then uses the value found in the

LargePhotoFileName column to name the files.

Sometimes, you may want to link a file with a primary key. In

this example, we retrieve both the primary key and file data.

To name the files using the primary key column, just use the

column name in the naming convention.

What if you wanted to format the numbers to 4 digits? SQL Blob Export supports the use of format specifiers. To format a number to 4 digits, use the format specifier :0000 e.g. It’s often the case that the column containing the original file name also contains the original path e.g. Thus, you cannot use the value in the LargePhotoFileName column to name your files if the path does not exist. To name your using using just the file name value, you can use the FILENAME format specifier e.g. What if you had 2 binary data columns in a row, and you wanted to name each item differently? E.g. All you have to do is use the conditional column tag in the naming convention. In the example below, we use the convention: <ThumbnailPhotoFileName::2><LargePhotoFileName::4> This tells SQL Blob Export to use the ThumbnailPhotoFileName value if it is currently naming the item from column 2, or use the LargePhotoFileName value if it is currently naming the item from column 4. If you have any questions on how SQL Blob Export can name your files, or any other general questions, do drop us a line at support@yohz.com.