Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gerhardl
Creator II
Creator 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.

5 Replies
isingh30
Specialist
Specialist

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

Thank you!

gerhardl
Creator II
Creator II
Author

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.

isingh30
Specialist
Specialist

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

Thank you!

gerhardl
Creator II
Creator II
Author

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
Specialist
Specialist

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

Connect to webservice

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

Thank you!