QVSource Facebook Starter App For QlikView
Switch branches/tags
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Failed to load latest commit information.


QVSource Facebook Fan Page & Groups Starter App For QlikView

IMPORTANT - If you are using QVSource or later you will need to update the parts of the load script in this application which use the Sentiment Analysis & Text Analytics Connector according to the instructions here. We plan to update this starter app soon with these changes.

This is a starter QlikView application showing how to get started using the QVSource Facebook Pages and Groups Connector for QlikView.

Further documentation for this template application can be found here.

It also makes use of the Sentiment and Text Analytics Connector to score comments and posts.

If you are a QlikView + QVSource user you can simply click the "Download ZIP" button on GitHub to grab this application.

The content below is copied from the change log in the first tab of the load script tab.

Change Log - 16/09/14

  • Fixed issue where Page column on "All Posts And Comments" table of the Users tab (on All Content side of data model) always showed only one of the pages.
  • Added notes to config file (vLoadPostersAndCommenterInfo) and UI that extraction of additional user info (e.g. gender, location) is no longer supported. Seems Facebook have removed this from the API (in the instance where you are getting info for posters/commenters on a Fan Page who you are not connected to). - 05/08/14

  • YOU MUST HAVE QVSource version or later to use this application
  • upgraded to ONLY WORK with the Facebook Pages and Groups Connector (v2)
  • If you are looking for a version of this application to work with Facebook Pagess and Groups Connector v1, then please look here: https://github.com/QVSource/QVSource-Facebook-Starter-App-For-QlikView/releases
  • BREAKING CHANGE: Removed Sentimental (formerly Chatterbox) connectivity - this is because Sentimental have now removed their API from Mashape and as such we are no longer able to offer it either. If you have used this then please update the config.txt file to utilise a different Sentiment Analytics API engine
  • Changed 'since' parameter to 'StartDate' for the FeedItems' load URL string
  • Replaced remaining port 5555 references to use the variable
  • Fixed issue where script was testing for feeditem comments being 'true', but should have been testing for 'True'
  • Fixed issue where the FB_Feed table had duplicate rows - 11/05/14

  • Fixed issue where real like and comment counts were not coming through if greater than 25 (by setting vLikeCountThreshold and vCommentCountThreshold to 24). - 21/03/14

  • Fixed old QVSource logos. - 19/03/14

  • Added FeedItems_comment_link and FeedItems_like_link fields to Feed Item data. This is a link which allows you to open the specific post in a browser.
  • Added response_status fields to Poster and Commenter tables. - 11/12/13

  • Changed FeedItem_comments_count2 to FeedItem_comments_count in CH26, CH27 y CH32. - 04/12/13

  • Updated badge. - 30/08/13

  • BREAKING CHANGES - This new version will not be compatible with QVDs from a previous version.
  • IMPORTANT - This version requires QVSource or later.
  • Added columns to feed table: from_id as FeedItem_from_id, status_type as FeedItem_status_type, to_id as FeedItem_to_id, to_name as FeedItem_to_name, to_category as FeedItem_to_category, story as FeedItem_story, application_name as FeedItem_application_name, application_namespace as FeedItem_application_namespace, application_id as FeedItem_application_id, has_at_least_this_many_likes as FeedItem_has_at_least_this_many_likes, has_at_least_this_many_comments as FeedItem_has_at_least_this_many_comments,
  • Added new vLikeCountThreshold and vCommentCountThreshold to config file and associated logic/loadscript. See notes in config file for more detail.
  • vIgnoreCache moved to config file.
  • Added warning notes on intro tab when vLoadCommentCountForFeedItems or vLoadLikeCountForFeedItems are not set to 1.
  • App is now set to require QVSource - 02/08/13

  • Added let vLoadCommentCountForFeedItems and vLoadLikeCountForFeedItems flags to config file. Currently recommended that these are turned off. - 01/08/13

  • vIsFirstTime flag is now based on the existence of FB_Feed.qvd instead of FB_Page.qvd

1.9.1 - 30/07/13

  • Added test to check vLocalTimeZone is recognised.
  • Fiexed error on Comments tab: if(NoOfRows('Params') > 1) then ==> if(NoOfRows('Params') > 0) then
  • Now uses new LikeCountForItem table to get feed item likes.
  • Now configured to require QVSource or later.
  • Should no longer error if no feed items are found on the initial reload. This application is however is only designed to run properly when at least one feeditem and one comment is found.
  • Moved to GitHub.
  • Config file renamed to config.txt.