topic Re: Manage Err 404 when importing data from a URL in QlikView

Manage Err 404 when importing data from a URL

alex_millan — Mon, 29 Sep 2014 15:07:42 GMT

Hi all,

I'm trying to make a script to import some data from an internet page to a qlikview application.

I import the data for each day from a txt file, each file is in a different URL.

For example,

the data for 2014-09-01 is in the URL: "http://***.*****.***/***/20140901.txt"

the data for 2014-09-02 is in the URL: "http://***.*****.***/***/20140902.txt"

and so on...

Problem is that these files only exists for working days, so when I seek for 2014-09-07 (a Sunday) for example, there's no such URL nor txt file and the script loads garbage.

Anyone can give me a tip to handle those '404 - Page not found' errors?

Attach my app just in case someone want to take a look at it.

Any help will be most welcome.

Thanks a lot and best regards

Re: Manage Err 404 when importing data from a URL

alex_millan — Tue, 30 Sep 2014 08:15:16 GMT

Anyone can give me a hand on this?

I know I can control Saturdays and Sundays but I'm seeking for a general solution that works also when the date is a holiday for example.

Thanks in advance.

Re: Manage Err 404 when importing data from a URL

Peter_Cammaert — Tue, 30 Sep 2014 08:29:58 GMT

IMHO Holidays and General Solution cannot be easily combined. I still think that you should try to avoid loading non-existent files instead of trying to detect 404-pages. One way to attack this problem is with an extra input file that lists holidays/special days for your region and for each successive year. An applymap() or exists() call will do the rest.

Best,

Peter

Re: Manage Err 404 when importing data from a URL

alex_millan — Tue, 30 Sep 2014 08:34:26 GMT

Sure that would work Peter but I was seeking for an alternative approach.

Thanks anyway for your hint!

Re: Manage Err 404 when importing data from a URL

sorrakis01 — Mon, 06 Oct 2014 14:35:30 GMT

Hi Alex,

I have the same problem could you resolve it?

Thanks