topic Re: Unknown Error When loading from Web File in QlikView

Unknown Error When loading from Web File

amit_saini — Wed, 25 Jul 2018 07:57:03 GMT

Hi Folks,

I'm having a location excel sheet located on Wiki (Web) and I'm using Web File loading to process from Qlik back-end , but not sure why I'm getting below error:

But when I'm trying to open same link (Say https://Abc) on browser than I'm able to download Excel Sheet. See below:

It means I'm having access to the Excel , but than why I'm getting "Unknown Error".

Also I have noticed one strange thing , see in the above screen shot , it is showing me option to save or open excel , but why in the browser it show a different link as working https://fed.textron.com....

Not sure what's wrong here!

Regards,

Re: Unknown Error When loading from Web File

amit_saini — Wed, 25 Jul 2018 09:20:47 GMT

any suggestions???

Regards,

Re: Unknown Error When loading from Web File

Frank_Hartmann — Wed, 25 Jul 2018 10:14:51 GMT

What happens if you mark xlsx or xls as Filetype instead of html filetype?

You are trying to load an excel file? right?

Re: Unknown Error When loading from Web File

dapostolopoylos — Wed, 25 Jul 2018 10:36:28 GMT

In order to be able to read an excel file which is web located you have to have a direct path to the location of the web server where the file is store and have proper rights on the folder of course...

You are not reading an html file but an xls/xlsx file which resides in a location described somehow like that:

httt://www.myserver.com/files/myfile.xlsx

Re: Unknown Error When loading from Web File

amit_saini — Wed, 25 Jul 2018 10:56:50 GMT

Yes , I'm trying to load an excel file.

Re: Unknown Error When loading from Web File

amit_saini — Wed, 25 Jul 2018 10:58:57 GMT

Yes, I'm agree with you , but I'm having some issues and no clue how to fix that.

Regards,

Re: Unknown Error When loading from Web File

dapostolopoylos — Wed, 25 Jul 2018 11:04:17 GMT

Do you know the exact url of the excel file you want to load?

Re: Unknown Error When loading from Web File

amit_saini — Wed, 25 Jul 2018 11:10:18 GMT

Yes , I'm using the same. Even if I open this link in browser , it is showing me option to save or open.

Re: Unknown Error When loading from Web File

dapostolopoylos — Wed, 25 Jul 2018 11:26:40 GMT

Follow the instructions on this link: how to load an excel file from network location

When you start the wizard what file type are you selecting, Web file or Table File?

Re: Unknown Error When loading from Web File

amit_saini — Wed, 25 Jul 2018 12:03:02 GMT

Web Files

Regards,

Re: Unknown Error When loading from Web File

BalaBhaskar_Qlik — Wed, 25 Jul 2018 16:23:59 GMT

May be this helps:

https://docs.rapidminer.com/latest/server/advanced-topics/qlik-integration/import-service-qlikview.html