topic Get a BLOB image from QVD Challenge in QlikView

Get a BLOB image from QVD Challenge

marcel_olmo — Fri, 12 Dec 2014 12:12:30 GMT

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 :

Re: Get a BLOB image from QVD Challenge

Gysbert_Wassenaar — Fri, 12 Dec 2014 12:27:42 GMT

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.

Re: Get a BLOB image from QVD Challenge

marcel_olmo — Fri, 12 Dec 2014 12:43:25 GMT

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.

Re: Get a BLOB image from QVD Challenge

arthur_dom — Fri, 12 Dec 2014 13:04:51 GMT

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.

Re: Get a BLOB image from QVD Challenge

MarcoWedel — Fri, 12 Dec 2014 13:05:16 GMT

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

Re: Get a BLOB image from QVD Challenge

marcel_olmo — Fri, 12 Dec 2014 16:22:37 GMT

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.

Re: Get a BLOB image from QVD Challenge

MarcoWedel — Fri, 12 Dec 2014 16:25:11 GMT

Hi,

sounds good, please post the result.

thanks

regards

Marco

Re: Get a BLOB image from QVD Challenge

Anonymous — Fri, 12 Dec 2014 16:33:36 GMT

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

Re: Get a BLOB image from QVD Challenge

marcel_olmo — Fri, 12 Dec 2014 16:38:05 GMT

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.

Re: Get a BLOB image from QVD Challenge

marcel_olmo — Fri, 12 Dec 2014 16:43:38 GMT

What do you mean Antonio?

Re: Get a BLOB image from QVD Challenge

Anonymous — Fri, 12 Dec 2014 16:56:58 GMT

2 reasons:

Performance

Complexity.

use "link" (url) off the image.

Re: Get a BLOB image from QVD Challenge

marcel_olmo — Fri, 12 Dec 2014 17:04:42 GMT

The point is that I've already stored in BLOB format the image, and I'd like to show the info in my Qlikview file. How would yo do it?

Re: Get a BLOB image from QVD Challenge

Anonymous — Sat, 13 Dec 2014 02:01:22 GMT

What programing language You use?

Send me your table structure.

Re: Get a BLOB image from QVD Challenge

marcel_olmo — Sat, 13 Dec 2014 08:29:37 GMT

I can use both javascript or vbscript or QV script language, you can get the info from tje data stored in the .rar file.

Regards, Marcel.

Re: Get a BLOB image from QVD Challenge

Anonymous — Sat, 13 Dec 2014 18:04:23 GMT

Marcel,

If You are using Blob on DB use a Programming Language with jdbc / odbc connection (the first if using java).

The program must create the image file from Database (simple and fast process).

On Qlik use only the link / url from image generated.

If You need I send You the code to do this job.

Re: Get a BLOB image from QVD Challenge

marcel_olmo — Sat, 13 Dec 2014 18:38:18 GMT

Thanks Antonio! My problem is that I can't read from odbc, only from qvd. So I'm trying to generate the image from BLOB with some kind of function via macro.

Re: Get a BLOB image from QVD Challenge

Anonymous — Sat, 13 Dec 2014 23:42:13 GMT

With Macro you can call System Commands.

But only JScript or VBScript inside macro code.

With Extensions (Document or Object) JavaScript only and code will be shared and not reside inside Qvw - Implies Web use.

I prefer the second option...

Re: Get a BLOB image from QVD Challenge

marcel_olmo — Sun, 14 Dec 2014 10:05:21 GMT

Thanks Antonio! I'm trying to develop the first one, because I didn't find a solution that fits my needs. Is there any solution made in extensions? Regards, Marcel.