I have a Qlikview application that contains a list of http:\\ ... "URLS". Each URL is expected to link to an image or a PDF document, but sometimes the links are "invalid", the picture or document can have been removed, the web server can be offline, or the link is not spelled correctly etc.
I need to add a quality control in my Qlikview document and let the Qlikview users know if the links are ok and give statistics on how many links are unavailable etc.
Is it possible to let Qlikview do this check somehow for me, perhaps with the help of a macro -triggered by a macro button or do you think this hasto be done before the load script with a external application (if so, can anyone recommend a software for this....?)
The links are supplied to me by a ordinary text file.
Any hints and tips that guide me in the right direction is appreciated!
so you get a lot of 'broken' results though the link is valid?
The referenced code snippet only checks for html return code = 200 (OK), if a redirect is returned, you get html return codes in the 3xx range. Maybe it's just enough then to change the check in the macro code from equal 200 to < 400. Give it a try.
And/ or you may try to debug into the code and have a look what's returned in your real environment.
I am also new to Qlikview and have similar situation. Where can I find PingSite script that will work in Qlikview script? Or maybe I need references on how to include the PingSite VBScript from Qlikview document.