Export BLOB fields

This article describes a new amazing feature of DatAdmin 5.2.7 version, export of BLOB fields. You can use this feature, if you want to export the BLOB fields from a table (or query result), for each row of the source table is created a separate file. The exporter is very easy to use, if you know, where to find it...

Step 1 - choose table and select "Export" in popup menu

Step 2 - setup export format

In Bulkcopy wizard, choose exporter named "Export BLOB fields". You must fill existing output folder, otherwise error DAE-00376 is returned. Output file name contains template of file name. You could use #FILE# and #INDEX# placeholders:

• #FILE# - file name from the table (in the next step, you configure, which column of source table will be used for this purpose)
• #INDEX# - index of exported row counted from 1

Step 3 - define columns

In this screen, you can configure columns, which fill be used for file name and file contents. Please ignore "Skip" column, it can be used in very special situations. You could use full power of DatAdmin bulkcopy feature, eg. you can use Python for count file contents eg. as concatenation of two columns. Or you can create the formatted file from more columns of row - for one row is created one output file.

Step 4 - finish export BLOB fields

That's all - click "Next" and finish, your data will be exported into selected directory. Of course, you can save this job and than run it from the command line interface or schedule as regular task in the same way as the data synchronization.