topic Re: Store Images Into QVDs in QlikView

Store Images Into QVDs

Wed, 24 Oct 2012 15:41:20 GMT

Hi,

Does anyone know how to store images that have been imported into QlikView (Desktop) into a QVD?

I'm trying to do the following:

FOR i = 1 TO $(NrRows);

LET FilePath = PEEK('FILEPATH', $(i) - 1, 'INSPECTION IMAGES');
LET ID = PEEK('IMAGEID', $(i) - 1, 'INSPECTION IMAGES');

"IMPORT INSPECTION IMAGES":

BUNDLE INFO LOAD *
INLINE [IMAGEID, FILEPATH
$(ID), $(FilePath)] ;

NEXT i

STORE * FROM [IMPORT INSPECTION IMAGES] INTO '$(iQVDPath)IMPORT INSPECTION IMAGES.QVD';

The import function works perfectly (i.e. everything before the STORE statement). However, when I try to store the table [IMPORT INSPECTION IMAGES] into a QVD, I get an error which states that the [IMPORT INSPECTION IMAGES] tablet cannot be found, as follows:

Table not found

STORE * FROM [IMPORT INSPECTION IMAGES] INTO 'C:\Program Files\QlikView\QVD Files\IMPORT INSPECTION IMAGES.QVD'

My purpose for this requirement is to be able to import all my data, including pictures, into a QlikView model. Then I want to create the relevant QVDs, again including pictures, and FTP the QVD files to another site. At the new site, I want to download the QVDs from the FTP site and import them into the same QlikView Model.

This allows for easy data transfer. However, it is critical that the pictures are transferred as well.

Any ideas?

Kind regards,

Johan

Re: Store Images Into QVDs

rwunderlich — Wed, 24 Oct 2012 21:20:20 GMT

If you open the table viewer you will not see a table named "IMPORT INSPECTION IMAGES". Info Load does not create a traditional table. Rather it creates a link between a field value and the image -- which I think is stored in the special $Info table.

I haven't tried it, but you might try BINARY load of a qvw that contains INFO LOADed dat and see if you can use that as a data source.

-Rob

Re: Store Images Into QVDs

Thu, 25 Oct 2012 06:54:23 GMT

Hi Rob,

Thank you for the quick response.

I've played around with the BINARY load and it seems to work well. My only concern is that I need to send incremental data which will require multiple BINARY loads which it seems isn't possible in QlikView.

What I do like about the solution is that I can send one QVW instead of multiple QVDs at a time. Also, the QVW takes the picture with it (using BUNDLE INFO LOAD).

Any ideas on how to load multiple QVW files into one new QVW using a BINARY load?

Kind regards,

Johan

Re: Store Images Into QVDs

rwunderlich — Thu, 25 Oct 2012 14:44:51 GMT

Start by binary loading the existing qvw. Then run the script to load the latest data. All tables should autoconcatenate. At the end, you'll have one qvw. The downside is you'll have to ftp that entire qvw every time.

-Rob

Re: Store Images Into QVDs

Thu, 25 Oct 2012 14:50:25 GMT

Hi Rob,

Thank you for your further feedback.

So I won't be able to send incremental QVW files via FTP and then load them into a single QVW via multiple BINARY loads?

E.g.

binary ;

SQL SELECT .... ;

Regards,

Johan

Re: Store Images Into QVDs

rwunderlich — Thu, 25 Oct 2012 14:55:02 GMT

Correct, you cannot load multiple using BINARY. You can have only one BINARY in a script.

-Rob

Re: Store Images Into QVDs

Thu, 25 Oct 2012 14:59:08 GMT

Hi Rob,

Ok, thank you.

Is there possibly any other method of transferring the picture that you can think of? The QVW files become very big due to the pictures, so I won't be able to resend the whole QVW each evening.

Regards,

Johan