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
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
View and export images and files from
your databases using
SQL Image Viewer
•
identifies images and file types automatically
•
identify images and files stored in OLE Object columns
•
export embedded images to Excel spreadsheets
•
supports Access, MySQL, MariaDB, Oracle, PostgreSQL,
SQL Server, SQL Server Compact, SQLite, and ODBC
data sources
How to automate your export tasks
- Professional Edition required
The SQL Image Viewer Professional Edition license includes a
command line interface (SQLImageViewerViewerCmd.exe)
you can use to automate your export tasks.
To start off, first write and execute a query to retrieve the data
set you want to export in the SQL Image Viewer GUI. Let’s say
we want to export out customer details into an Excel
spreadsheet.
Once we have retrieved the results, click on the Export to
Excel button.
Set up your export settings according to your needs. On the
Summary page, click on the Save settings... button.
On this page, you can define the stored values which is used
to support incremental exports. In this example, we’ll just use
the same query every time to export the data into the
spreadsheet. Click on the Save to file... button to save the
settings to disk.
Once you’ve saved the settings, you can test the export by
clicking on the Test settings button. SQL Image Viewer will
use the saved settings file to run an export using the
command line interface.
You can also run the settings file by using the command-line
interface directly.
Once you see the settings are running without errors, you can
then schedule the export process to run periodically using the
Windows Task Scheduler.
Once set up, try running the task manually to check that it can
run successfully.
SQL Image Viewer supports incremental exports i.e. export
only new data that has been added to your database. See
here for details on how to set up configure your settings file to
support incremental exports.
The fully qualified name of the export settings
file.
The name of the SQL Image Viewer command
line interface executable.
•
Check that you are using SQLImageViewerCmd.exe and
not SQLImageViewer.exe
•
Enclose the entire path and file name in double quotes.
For the ‘Start in’ value, enter the SQL Image Viewer folder
name, but DO NOT enclose the value in double quotes.
Enter the full path and file name of the export settings
file as the argument, enclosed in double quotes.