topic import image on the fly from web in QlikView

import image on the fly from web

Wed, 18 Aug 2010 20:48:32 GMT

Hi All

I have images on an oracle server I can access via a web interface by building a url.

Currently I have hyperlinks that open IE using the constructed URL, but it's a bit messy with multiple web pages opening when you view a few different images.

I can't import all the images as this would take far too long on the reload.

Is there a way I can display the image within my qlikview document? Can I screen scrape the image on the fly from the web?

Many thanks

import image on the fly from web

Wed, 18 Aug 2010 22:59:42 GMT

Yes, you can.

Try the Table as below.

Pict:
LOAD * INLINE [
Nr, Picture
1, http://www.c-rural.es/moodle/file.php/1/hammer.png
2, http://trinities.org/blog/wp-content/uploads/hammer.jpg
];

Now, you have a table with two fields. Nr contains an identiefier to your picture, the field Picture the link to the picture you want to load.

Create a text object on the QV sheet.

AS Text enter "=Picture"

As Representation select "Picture" (default is Text)

Now show the Field "Nr" on the QV sheet. If you select one Number, the corresponding picture is shown.

Good luck

Michael

import image on the fly from web

Wed, 18 Aug 2010 23:59:27 GMT

Hi:

Please, if I want to take a Excel file from the web, can I apply the same sentence?

Thanks [:'(]

import image on the fly from web

Thu, 19 Aug 2010 07:03:42 GMT

Hi Michael, thanks for your answer.

Can this be applied in VBScript? I can't load the pictures in the main load script as I would have to load 1000000's.

Dominic

import image on the fly from web

Fri, 20 Aug 2010 22:58:53 GMT

Hi Dominic,

i'm not aware what's the problem, sorry.

You just have to load the link of the picture into a field. The link could be read out of a database or could be calculated or whatever you want.

So, the script above is just an example to show how it works.To load all the picture physcally into memory could be a nightmare and also uses a giant amount of memory.

So, if the pciture stored on a filesystem, share or a website, just load the link and reference to the pciture.

If that answer wont help, just explain what your special situation and i would try to help.

Nice weekend & best regards

Michael