Qlik Community

QlikView Extensions

Discussion Board for collaboration on QlikView Extensions.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Employee
Employee

Live Twitter Feed in QlikView

UPDATE: Twitter discontinued this use of the their APIs with the 2.0 changes causing this extension to break. I will however still leave it up here in case you want to look at the code for your own projects.

So, we are putting up some new monitors on our office wall to show off boring stuff like sales pipeline, booking rate on consultants etc etc AND we built a small twitter extension to show off what's being said on twitter. Why we built it in QlikView I have no idea, probably because we could

Displays a twitter feed for your search criteria that updates in real time. I hard coded the number of feed items and refresh rate but you could change that easily in the script. Seems the Japanese just woke up when I took the screenshot

twitt.PNG

12 Replies
Luminary
Luminary

Re: Live Twitter Feed in QlikView

Nice demo, except that I cannot get it to work.

In the reload script there is a reference to a file called C:\Users\akl\Desktop\zip.csv, guess that is not even used in the application..?

A more serious problem is that I cannot get around is the error message in the attached file.

Any ideas?

To me it looks like the server name "qlikview" (i.e. http://qlikview/...) seems a bit short... I just can't figure out where to change it to a URL matching the QV Server the app is deployed on.

Also, would this extension work in QV Desktop, or is deployment to QVS needed to see it in action?

thanks,

Göran

Edit: I was using QV10, by the way... That might be causing the issues.. But even so - shouldn't it work there as well as on v11?

LiveTwitter error.jpg

Employee
Employee

Re: Live Twitter Feed in QlikView

Hey,

That's strange, it should work on QV10 aswell. I referenced jQuery directly from Google in this updated sample so it should run on QV10 now.

Works in both the desktop client and on server installations. The qar file should unpack in correct directory by default. You need to enable web view in the Desktop client though for it to show up.

And yeah the data in the script is not used, just test data to check that the extension worked upon updates aswell.

The data is coordinates for all the zip codes in Sweden so it's a freebie

Luminary
Luminary

Re: Live Twitter Feed in QlikView

Confirmed, your udpdated version works also in QV10.

Something about the paths differing between QV10 and QV11, maybe?

erik_wetterberg
Honored Contributor

Re: Live Twitter Feed in QlikView

Haven't tested this, but the reason might be that jQuery is bundled in Qv 11 ajax files, while it is not in version 10. So, if you use jQuery, you need to load it in version 10, but you might not need that in version 11.

Erik Wetterberg
https://extendingqlik.upper88.com/
hariharasudan_p
New Contributor III

Re: Live Twitter Feed in QlikView

It was working well for last one week.

Suddenly from yesterday it stopped working. May be some restrictions in server where twitter page is not accessible or ?

Employee
Employee

Re: Live Twitter Feed in QlikView

Twitter killed the support for their 1.0 version of the API, and then also this extension, and have moved over to 1.1.

With version 1.1 we can't do un-autenticated calls against the API anymore, , so there is no way of implementing this functionality into QV without having a server side component handeling authentication.

Not applicable

Re: Live Twitter Feed in QlikView

Hello Alexander,

I was trying to fetch the Twitter and Facebook live feeds in the qlikview application, can you help me on it, I was trying to use the extension object which you have shared, but I was unable to fetch the information.

Thanks and Regards,

Preethi

magavi_framsteg
Contributor III

Re: Live Twitter Feed in QlikView

Hi Alexander.

Theoretically, the same thing could be accomplished using the example web page viewer extension, or this replacement by @stefanwalther: QlikDev/WebPageViewer2 · GitHub

Employee
Employee

Re: Live Twitter Feed in QlikView

Theoretically yes, you could frame in the entire twitter homepage with a search query.

However it will look... ugly

With the changes to the Twitter API that broke this extension I would instead set up my own server side component that streams tweets back to clients over websockets or as a rest api. The obvious benefit being that it's not QlikView specific anymore and could be used with any type of client, your phone, your TV or your big screen streaming in search queries (or into a database for that matter for later analysis).

Community Browser