Add subtract data from two different database sources : Howto

How to perform calculations across different data sources/databases Imagine, you have a CRM database that contains all your customer and sales information and you have a different database that stores your GL and ERP data. Now add some complexity to it, your CRM database is say SQL Server or Microsoft Access or just Plain old … Read more

Build a dashboard using XML as data source

In this article we will use a XML data source and build it to display the various data sets in grid format. This tutorial is an extension to the one you see in the documentation https://www.infocaptor.com/help/xml.htm All it uses is just XPATH syntax to extract various information. Consider this XML document http://mtdemo.s3.amazonaws.com/StyleCopViolations.xml This XML contains … Read more

How to link multiple dashboards for easy navigation

This article will demonstrate how to link up multiple dashboards through a button or link bar. The button and link bar widgets are available in the “Text_Links_Buttons” section in the left panel.   Basics First let us understand some basics. Any widget inside InfoCaptor can contain a URL and this URL can be anything that … Read more

Visual alerts – Exception highlighting in reports and dashboards

In this article we will expand on the “Bells and Whistles” section of our Dashboards. There are multiple ways to alert the user when your data crosses a certain threshold. The most used technique is to change the color of the data depending on whether the data is on the target, above the target or … Read more

Action Framework for Dashboards

Dashboard Reporting comes in variety of format. There are dashboards that are for information display purpose like “Airport Terminal displays” and there are dashboards that take a step further and let you interact with the dashboard elements. InfoCaptor now allows you to interact with your dashboards in a very consistent manner. Usually in a dashboard … Read more

RSS Dashboard – API

With the RSS feature you can pretty much build a iGoogle reader for all your favourite blogs. The ideal widget to display RSS is the Box widget or the bullet items widget Or Once you drag the widget, right click on it and select “Data URL” Select “connection” as “RSS” and in the parameters section … Read more

Web Dashboard – Add Excel File Connection

This article will explain how to add new Excel File connection Visit http://127.0.0.1:4001/infocaptor/dash/connection_template.php?mode=excel   Assuming your excel file is located in the “c:samplestest_data.xls” the following entries are populated   “Connection Handle” : This is an identifier for the excel file that will be used in the dashboard so name it appropriately so you can identify. … Read more

Feedburner Metrics – API

In the same way we define the Twitter Dashboard widgets or the Facebook Dashboard Widgets we can define the metrics for Feedburner.   The Parameters would be as follows The metric list is [“circulation”,”hits”,”reach”] or you can select Feedburner All metrics   “id_list”:[“mockups”], “metric_list”:[“all”] “id_list”:[“mockups”,”dashboards”], “metric_list”:[“all”] “id_list”:[“mockups”,”dashboards”], “metric_list”:[“circulation”,”hits”]    

Facebook Metrics – API

1. Facebook – All Numeric Description: This displays all facebook related metrics for the specified set of domain URLs. The metrics displayed are [“shares”,”likes”,”comments”,”total”,”clicks”] When you use facebook service you need to specify the domain URL and metrics in the “Parameters” section as shown below “id_list”:[“https://www.infocaptor.com”], “metric_list”:[“all”]       The above screenshots show the … Read more

Twitter Metrics – API

1. Twitter – All Numeric Description: This displays all twitter related metrics for the specified set of twitter id. The metrics displayed are [“followers”,”tweets”,”following”,”listed”] When you use Twitter service you need to specify the twitter id and metrics in the “Parameters” section as shown below “id_list”:[“infocaptor”], “metric_list”:[“all”] The above screenshots show the metrics in the … Read more