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