I am trying to load image files into an Oracle 11g database as BLOBs. In CloverETL, utilizing the byte metadata type, I can successfully read BLOBs from a database and create image files, and load those BLOBs into other tables/DBs, but I was trying to find out if there is a way to read an existing image file as a byte stream or byte datatype into CloverETL.
Hi,
Please take a look here: viewtopic.php?f=4&t=6644&hilit=blob#p10447 It is describing handling RTF file, but picture should work the same way.
Thanks for the reply, I have that working reading a single image… Now I just need to find a way to read all the images in a given directory.
Scratch that, I overlooked the simple solution to reading all files in a directory. My issue is completely resolved.
Thanks!
A quick follow-up in case someone runs into the same situation trying to read in an image file and its name:
I added a field to my metadata with auto_fill=“source_name”. When I did this, I had to add a delimiter, which makes sense. The default delimiters in the metadata editor seemed to break up the actual file byte field, I’m assuming because those delimiters can be found in some sequence of bytes from that field. I had to manually put in a multi-character delimiter that was unique enough that Clover wouldn’t get confused.
I’m not sure that was the best answer, but it worked for me.
Hi Benjamin,
It seems behavior you described is bug. I have created https://bug.javlin.eu/browse/CLO-3071 Please see attached test_ok.grf for working sample of binary file reading and having populated filename in the same time.