topic loading information from website in QlikView

loading information from website

Tue, 26 Oct 2010 10:32:51 GMT

Very much a programming/DB novice here and would really like some assistance.

I am looking to pull information from the Dell website based on the Dell serial number of computers we have in stock.

I have found the part of the page I need, the issue I am having is calling the URL based on a variable loaded in another tab.

Any help would be gratefully appreciated

this is what I have at the moment:

let

LOAD
[Your Warranty],
[Your Warranty1],
[Your Warranty2],
[Your Warranty3]

FROM
$(url)(html, codepage is 1252, embedded labels, table is @57);

url = 'http://support.euro.dell.com/support/DPP/Index.aspx?c=ie&l=en&s=gen&ServiceTag=' & '$(BIOSSerialNum)';

loading information from website

prieper — Tue, 26 Oct 2010 10:52:51 GMT

You need to create kind of loop through a table with Serial-numbers, script might look like:



Serials:
 LOAD
 SerialNo
 FROM
 ......;

FOR i = 0 TO NoOfRows('Serials') - 1

 LET sURL = 'http://support.euro.dell.com/support/DPP/Index.aspx?c=ie&l=en&s=gen&ServiceTag=' & PEEK('SerialNo', i, 'Serials');

 LOAD [Your Warranty],
 [Your Warranty1],
 [Your Warranty2],
 [Your Warranty3]
 FROM
 $(sURL)
 (html, codepage is 1252, embedded labels, table is @57);

NEXT i

HTH
Peter

loading information from website

Tue, 26 Oct 2010 11:28:49 GMT

Thanks Peter, I will give that a go and let you know how I get on

loading information from website

Thu, 28 Oct 2010 11:02:00 GMT

Hi Peter

Thanks for that, your suggestion worked. I am successfully pulling the information from the website.

Now, I just have to concentrate on applying the correct links.

Thanks again