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
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.
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
DOWNLOAD NOW
Get started with SQL Image Viewer Work with blobs faster - try SQL Image Viewer free for 14 days
Got a question? If you need help, or have any questions about SQL Image Viewer, please get in touch. support@yohz.com
Download trial Download trial Buy now, from USD 45 Buy now, from USD 45 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
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
Download trial Download trial See help file See help file Buy now, from USD 45 Buy now, from USD 45
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.