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”]    

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

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

Excel ODBC DSN connection string with PHP

When using Excel ODBC with PHP please use the following settings All settings are done in the connection_methods.php Windows 7 and Excel 2007 (support for .xls, .xlsx, .xlsm, .xlsb)   $db_url=”DRIVER={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};FIL=Excel 12.0;DriverID=1046;Dbq={$excelFile};DefaultDir={$excelDir};ImportMixedTypes=Text”;   Windows XP and older Excel (just .xls)   $db_url=”Driver={Microsoft Excel Driver (*.{$fileinfo[‘extension’]})} ;DriverId=790;Dbq={$excelFile};DefaultDir={$excelDir};ImportMixedTypes=Text”;

Excel Cell Ranges using SQL – Named – Unnamed – ODBC – JDBC

How to query Excel files using ODBC – JDBC? Summary : Why use square brackets for SQL against Excel? How to access range of cells from Excel? How to use un-named range of cells? This topic is covered in various tutorial for InfoCaptor. These following snippets are taken directly from Microsoft website as easy reference … Read more

JDBC with SQLserver – Connection refused: connect

If you are trying to use SQLserver with InfoCaptor and are using the SQL Studio Express 2005 then you might encounter connection refused error Please try the following setup before attempting to connect open the Configuration Manager Start -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Configuration Manager 2. Then at the … Read more

Dashboards & Competition: Who are Dashboard Vendors

There are tons of vendors providing Dashboard technology in one form or other. Most of these vendors are huge software companies and they charge a hefty license fee for their software. Do you want to spend 100K to million dollars on their software? This is just the license fee. You need to account for the … Read more