Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
gerhardl
Contributor II

Import data from online file

Hi, I have a CSV file that I download from a user interface for our call centre dialler system. I do this via a download button, but the link address does not include a file name or extension like a download link usually does.

The download link looks like this: http://172.18.101.203/Reports/DownloadFull

This then generates a file with a default name of "Download Full.csv"


Currently I download this file manually and then import to QV, but I want to import directly from the site. When I use the QV "Web File" wizard and enter the URL http://172.18.101.203/Reports/DownloadFull it doesn't work. "Cannot Open HTML File" and when I choose a delimited file type it sees the html text:

MWSnap001 2018-03-01, 10_09_13.jpg

I've tried changing the download link to include the default file name etc. but nothing seems to work.

Note that I need a username & password to log into the website.

Tags (1)
5 Replies
Highlighted
isingh30
Valued Contributor

Re: Import data from online file

This has to do with the format. Please share your app.

Thank you!

Highlighted
gerhardl
Contributor II

Re: Import data from online file

Sorry, but what format?

There is no app to share. This is the starting point of the application so it has no data and no load script, I'm simply trying to get the data.

Highlighted
isingh30
Valued Contributor

Re: Import data from online file

Did you check file type html? If possible, can you share your csv file.Let me know.

Thank you!

Highlighted
gerhardl
Contributor II

Re: Import data from online file

I did yes, it shows this:

HTML_file.jpg

I unfortunately cannot share the CSV file, but the file is not the problem, it's accessing the file on the website that's the problem. The file loads fine if I load from my drive:

load_file.jpg

isingh30
Valued Contributor

Re: Import data from online file

Check these - Did you try any web connector so far?

Connect to webservice

https://www.quickintelligence.co.uk/free-qlik-web-connectors/

Thank you!