import image on the fly from web

[#1]

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

[#2 · Accepted solution]

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

[#3]

Hi:

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

Thanks [:'(]

[#4]

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

[#5]

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