Dynamic data import / export

datenbank

simply more productive
Up to 10,000 records can be processed with the freeware version!
Welcome, Guest
Username: Password: Remember me
Welcome to the FlowHeater support forum.

Questions about using FlowHeater are answered here.

TOPIC: Combine two MySQL fields (TEXT with BLOB)

Combine two MySQL fields (TEXT with BLOB) 1 year 3 months ago #2436

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
Hi,

We have a BLOB that we want to access with a reporting tool without decent converter to read these Binary file.
  1. We have a table with two fields that we want to combine to one field (see example)

  2. This job has to be scheduled every night after a data-cube is produced for reporting

  3. The database is MySQL on a Linux system (but we also run windows like configs)
RecordTable A : Field (File_name)Table A : Field (BLOB)Table A : Field (new File_name + BLOB)
1Name1.extBinary.i4 / downloadCombine to Name1.ext / download
2Name2.extBinary.i4 / downloadCombine to Name2.ext / download
...NameX.extBinary.i4 / downloadCombine to NameX.ext / download

Kind regards
Frank
Request received by Email
Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
Last Edit: 1 year 3 months ago by FlowHeater-Team.
The administrator has disabled public write access.

Combine two MySQL fields (TEXT with BLOB) 1 year 3 months ago #2437

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
Hi Frank,

Sorry I don`t know what´s your purpose :unsure:

First of all you cannot mix TEXT (char, varchar) with BLOB (binary) values. For BLOB (binary values) the certain application has to know how the data should be interpreted. For example the data can be an Excel or Word document a picture (jpg, png, bmp) or something else. Of course FlowHeater can build a TEXT field with the filename + base64 or Hex coded binary values.

e.g.
Hex coded: filename.txt – 0xA10104B2….
Base64: filename.txt - 8apAi...aqeQ==

The text content (string) of such field can be very long and I guess this is not what you really need?

It would also be possible to store the BLOB (binary) field into a file and save the whole path into the certain field.

Please describe a bit more in detail your needed solution.

Question 2) You can run every FlowHeater Definition automated with Batch Module and a Windows scheduled task. Here you’ll find a short example how it works: Automated batch CSV import into MS Access

Question 3) FlowHeater can access MySQL databases on Linux systems as well. Just the Designer or the Batch module has to run on Windows.
Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
Last Edit: 1 year 3 months ago by FlowHeater-Team.
The administrator has disabled public write access.
Moderators: FlowHeater-Team
Time to create page: 0.091 seconds