topic Re: Pull Table from Qlik.com into Application in Water Cooler

Pull Table from Qlik.com into Application

Anonymous — Sun, 30 Mar 2014 03:28:43 GMT

Is it possible to get the content table into an Application?

http://community.qlik.com/content

Re: Pull Table from Qlik.com into Application

fkeuroglian — Sun, 30 Mar 2014 05:17:47 GMT

Hi, i do not understand the question.. but if you wan to know if you could put web content of any page in qlikview the answer is YES

in the edit script option you have the possibility to put archive web and add the url of the page that you want to add to a document and the work with that page and for example store as a qvd or other type

Good luck

Fernando

Re: Pull Table from Qlik.com into Application

Anonymous — Sun, 30 Mar 2014 15:33:24 GMT

Not sure if it is inherit to me but if I try to open this specific thread or the content page I linked earlier I get the error. "cannot open HTML file"

I tested it out on Wikipedia pages and it works fine. Qlik.com is the only webpage that is giving me this error.

Re: Pull Table from Qlik.com into Application

Anonymous — Sun, 30 Mar 2014 16:41:19 GMT

Michael

Would loading it from the RSS feed with this script help ?

LOAD term,

scheme,

%Key_entry_DBF4DB52A7786704 // Key to parent table: feed/entry

FROM [http://community.qlik.com/view-browse-feed.jspa?userID=76197&browseSite=content&filterID=all&browseViewID=content] (XmlSimple, Table is [feed/entry/category]);

entry:

LOAD title,

updated,

published,

summary,

date,

dateToText,

replyCount,

objectType,

[summary/type] as type,

[author/name] as name,

[author/uri],

[author/email] as email,

[link/rel],

[link/href],

%Key_feed_353A984E43E5258F, // Key to parent table: feed

%Key_entry_DBF4DB52A7786704 // Key for this table: feed/entry

FROM [http://community.qlik.com/view-browse-feed.jspa?userID=76197&browseSite=content&filterID=all&browseViewID=content] (XmlSimple, Table is [feed/entry]);

feed:

LOAD xmlns,

[xmlns:dc],

[xmlns:clearspace],

title,

subtitle,

id,

generator,

updated,

date,

language,

[generator/uri],

[generator/version] as version,

[link/rel],

[link/href],

%Key_feed_353A984E43E5258F // Key for this table: feed

FROM [http://community.qlik.com/view-browse-feed.jspa?userID=76197&browseSite=content&filterID=all&browseViewID=content] (XmlSimple, Table is [feed]);

Best Regards, Bill

Re: Pull Table from Qlik.com into Application

Anonymous — Sun, 30 Mar 2014 17:23:30 GMT

It looks like I might be undertaking a project that is a little bit outside my expertise nor do I have the proper rights and access to the Jive data.

I've never done anything like the approach suggested and I'm only vaguely familiar with html, javascript, rss feeds, web development, etc... It will take me some time to digest it. Is there any documentation that I can read that will help?

Re: Pull Table from Qlik.com into Application

Anonymous — Sun, 30 Mar 2014 18:05:24 GMT

Michael

Have a look at www.w3schools.com it has loads of tutorials and reference materials for web'ey stuff.

Best Regards, Bill