Manage Err 404 when importing data from a URL

[alex_millan]

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

[alex_millan]

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.

[Peter_Cammaert]

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

[alex_millan]

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

Thanks anyway for your hint!

[sorrakis01]

Hi Alex,

I have the same problem could you resolve it?

Thanks