topic Re: Import and Convert Images into Blob in QlikView

Import and Convert Images into Blob

Sun, 08 Jul 2012 10:00:01 GMT

Hi There,

How can I go about importing images and at the same time converting the to a BLOB data type?

Kind Regards

Re: Import and Convert Images into Blob

jonathandienst — Sun, 08 Jul 2012 15:59:57 GMT

To import images into a QV model, use bundle load (images loaded into model) or info load (image file references into model).

I do not understand the second question. Bundle load will store the binary data for the image in the QVW file. Is this what you mean?

See this link: http://community.qlik.com/message/130937#130937

Hope that helps

Jonathan

Re: Import and Convert Images into Blob

Sun, 08 Jul 2012 19:19:41 GMT

Hi Jonathan,

Thanks so much for your reply.

I am sitting with the following scenario. I have a directory with 10000+ bitmap images. Each of these images links to an item number.

The file name for each image corresponds to that item number.

Is it possible to load all these images into qlikview and save the file names into a seperate column?

Kindest Regards

Re: Import and Convert Images into Blob

jonathandienst — Mon, 09 Jul 2012 06:52:14 GMT

Werner

With so many images, you probably don't want to embed them in the Qv model as it would make the model very large. You could probably just load the file names as a field linked to the other data.

To display in a straight table, use the file name field and select Image in the representation list on the expressions tab.

Hope that helps

Jonathan

Re: Import and Convert Images into Blob

Mon, 09 Jul 2012 14:53:19 GMT

This is the code that i used to import the file references as well as the file names.

Thank you for pointing me in the right direction