Export Photos from SQL Table to local Disk

[Iwo]

Please help.

1. I need to export jpeg photos as binary data from a SQL Server Table to local disk. Which Node will be good for this?
2. PS I will also ask for a node with a loop selecting the next photos for export

Table1: RowID / Name / extension / Binaries_data /

[mlauber71]

@Iwo you can take a look at this example. On the right side of the workflow you see how to extract image files from SQLite

Python Script - export images in table

@ActionAndi what you can do is store the PNG file in a SQLite database and then read it back into KNIME. [image] Just make sure that you have an actual PNG file (binary) and store it as a BLOB data type in SQLite. If you read it back to KNIME make sure the column “data” with the image is defined as a PNG file: [image] You might be able to combine these approaches: You can extract the current surroundings from a node. I have also created a component for that:

About loops you can read

KNIME, Paths and Loops — Automate Everything

[Iwo]

Hi mlauber71. These are binary photo files in JPG format in unknown encoding, not PNG.
I tried the “binary objects to Files” node, but unfortunately the final file on disk is not recognized by image viewers

[mlauber71]

@Iwo I have created an example how to load and retrieve JPG/JPEG files into a SQLite database.

If you have jpeg files as binary columns in a SQLite database you could retrieve them like this. Define the image as BLOG (or try Binary) in the DB Table Selector.

Then you can convert the binary cells to jpg files with the Binary Objects to Files node

DB SQL - SQLite - store and read JPEG Files in databases - also using Python.knwf (480.8 KB)

DB SQL - SQLite - store and read JPEG Files in databases - also using Python...