Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Get a BLOB image from QVD Challenge

Hi guys, as I've read in the Qlikview User Reference Manual, it says the only way you can load successfully a blob image is via ODBC.

In my case I can't get the BLOB image via ODBC, it has to be by plain text file.

Is there any trick that I can do in order to get my desired result?

I've attach my sample with a qvd with two blob images and a qv document trying to load it with bundle() and info() functions.

Here you have the part of users manual that says it has to be loaded only with odbc :

BLOB.png

17 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Get a BLOB image from QVD Challenge

Your qvd does not contain an image blob. When images are loaded into qlikview using the info or bundle keyword they're stored in a special internal $info table. That $info table can't be stored into a qvd with the STORE command.


talk is cheap, supply exceeds demand
Highlighted
Partner
Partner

Re: Get a BLOB image from QVD Challenge

Thanks Gysbert for answering so quickly,

I'm sorry I didn't understand what you exactly mean.

In the field Photo you have an hexadecimal number of 1496324 numbers of longitude. And it's supposed to contain the image as BLOB defined in the database, isn't it? Wich is the difference between the number you see in the photo field and the number stored in the database?

I didn't pretend to store the image (stored in $info table), only showing it properly in Qlikview.

Regards, Marcel.

Highlighted
Creator III
Creator III

Re: Get a BLOB image from QVD Challenge

Try when connecting with database the following script

Photo:

Bundle Info

Load Photo ID, PHoto blob from

sql select  ----- ;

then on design create a text field and put

'qmem://[Photo ID]/1' as a test.

The bunble command will store the image from database on QMEM.

Highlighted

Re: Get a BLOB image from QVD Challenge

Hi,

I also don't think it's possible to bundle load an image from a qvd directly.

However, I once tried to import pictures stored as octet strings in AD by using a VB macro to store it temporarily to disk and bundle load it from the file:

Importing user pictures from active directory

maybe this helps

regards

Marco

Highlighted
Partner
Partner

Re: Get a BLOB image from QVD Challenge

Thanks Marco! I'll try creating a function in vbscript that reads blob image and exports to an image file. I bet there's something in the web that can do this.

Regards, Marcel.

Highlighted

Re: Get a BLOB image from QVD Challenge

Hi,

sounds good, please post the result.

thanks

regards

Marco

Highlighted
Creator II
Creator II

Re: Get a BLOB image from QVD Challenge

DON'T use ODBC for images (BLOB format).

Highlighted
Partner
Partner

Re: Get a BLOB image from QVD Challenge

Thanks Arthur for your answer, is mandatory to have the odbc connection? It would be lovely if I can do it from a qvd file. Could you post an example?

Regards, Marcel.

Highlighted
Partner
Partner

Re: Get a BLOB image from QVD Challenge

What do you mean Antonio?