Loading data from a password protected website (Last FM)

Anonymous — Wed, 22 Feb 2012 08:00:29 GMT

Hi there,

I am trying to load data from my Last.FM account.

Last.fm keeps track of the music I play.

I wrote a script that loops through the pages which works great, at least for the first 50 pages....

When I use the wizard I can see the table from page 1: http://www.last.fm/user/Dennisnet/tracks?page=1

Up to page 50 : http://www.last.fm/user/Dennisnet/tracks?page=50

But from page 51 : http://www.last.fm/user/Dennisnet/tracks?page=51
I get "Cannot open HTML file"

When I am logged on to my account on the website I can visit all pages
When I am not logged on to my account I can only access the first 50 pages.

At page 51 or higher I get : "Sorry you must be logged in to do that"

Is there a way to send a login and password with my load script?
Login to the website and saving my password (Chrome and IE) doesn't solve the problem.

Any suggestions?

Thanks,

Dennis.

Loading data from a password protected website (Last FM)

disqr_rm — Wed, 22 Feb 2012 22:36:13 GMT

Try using wget or curl tool. Check here: http://community.qlik.com/message/122208#122208

QlikView will not be able to connect direcly, authenticate and load the data.

topic Loading data from a password protected website (Last FM) in QlikView

Loading data from a password protected website (Last FM)

Loading data from a password protected website (Last FM)