Home
SQL Image Viewer online help Prev Page Prev Page
Introduction
About SQL Image Viewer
Version history
Contact us
User Guide
System requirements
Editor command selection
Exporting large number of images
Folders and files
Reference Guide
Main menu
Connect to Database
Connecting to Firebird databases
Connecting to MySQL databases
Connecting to Oracle databases
Connecting to SQLite databases
Connecting to SQL Server databases
Connecting using ODBC
Connecting to a DB2 database
Connecting to a PostgreSQL database
Options
General options
Editor options
Thumbnail options
Image view
Check for updates
About
The work area
SQL editor
Table browser
Results
Other binary data
Image viewer
Hex viewer
Export items wizard
Exporting Microsoft Access OLE data
Image options
File naming convention
Datetime format specifiers
Command line interface
Parameters, logs and exit codes
Advanced options
CROP option
Troubleshooting
Expired trial
Invalid licenses
Unidentified images or binary data

File naming convention

This dialog enables you to set up the file naming convention for images that are exported.

filenamingconvention01

The easiest way to set up the naming convention is to double click on a naming element, or drag and drop the element to the File name input box.

You can use any text column from the result set as part of the naming convention. The text columns are displayed on the left, under the heading Database columns
.

You can also use image attributes as part of the naming convention. The supported attributes are displayed on the right, under the heading System values
. An explanation of each system value is provided below the list.

For numerical values, you can also use a format specifier. E.g. the <%sequence%> tag is a sequential number of each image that is exported. Using the tag without a format specifier will result in the following values: 1, 2, 3, ... (n). If you want to format the sequence value to 4 digits, prefixed with 0s, you can amend the tag to include the format specified this way: <%sequence:0000%>. This will then result in the following values: 0001, 0002, 0003, ... (n).

For datetime values retrieved from a database column, you can also use format specifiers to determine how to display the datetime value. The default format is yyyymmdd, so for a datetime value of 31 January 1970, the displayed value is 19700131. See this page for details of the available datetime format specifiers.

The Preview
tab displays a list of the first 50 file names that would be generated using the naming convention you entered.

filenamingconvention02