Create data picker control

Date picker is similar to the Textbox control and contains a calendar helper to pick the date  quickly.  How to add Date Picker Just drag the “Date Picker” and drop in the canvas. NOTE: You can directly type the date or pick from the popup wizard How to change the title  Double click the widget  Change … Read more

Create free text control

Textbox control is useful for selecting single value from a given list of values. This is often utilized in place of select/combo box when there are fewer set of values.  A) How to add it 1. Expand HTML_Controls section in the left panel2. Drag the “Textbox Control” and drop it in the center canvas B) … Read more

Create selectbox control

Combobox control is useful for selecting single value or multiple values from a given list of values. This is often utilized in place of select/combo box when there are lot of values to select from NOTE: Defining combobox control is very similar to radio box control and checkbox control   Select/Combobox can function as radio control so that you … Read more

CSV Upload

With the CSV Uploads your CSV data is directly loaded into MySQL database. Let say you need to upload Profit and Loss data for your company into the Social Warehouse. This would not be just one time load, you will most likely do the uploads every month, quarter or annually. CSV Uploads uses the ETL … Read more

Packaged Data Warehouse

InfoCaptor Packaged Data warehouse comes with pre-built connectors for various Social and web services.For each social service that is integrated, it has the Connector, Extractor and Processor components. Connector: This module uses Vendor API to connect to the service such as OAUTH or SOAP and saves the token for background processing.  Extractor: This module allows … Read more

Tutorials

List of How-To Articles How to build visual alerts, exception highlighting, color coding data How to maintain data in Google spreadsheet and build a dashboard on top of spreadsheet How to register InfoCaptor Self hosted version When your database is not directly accessible, How to go about connecting and building dashboard on top by writing … Read more

Install on Server

NOTE: InfoCaptor Enterprise requires a webserver to run no matter where you install. For windows, the zip file (infocaptor_enterprise.zip) comes packaged with a small webserver (server2go) so that you can simply double click and run it on your PC or laptop. But for other OS like linux and Mac, you will need to make sure … Read more

Microsoft Access

How to build dashboard using Microsoft Access Database Similar to MySQL and Excel, we start by defining the Access connection handle Once defined we can write SQL queries against the Access database the same way as MySQL

Microsoft Excel

Microsoft Excel Files can be used as database to store information and this data can be visualized on the dashboards. In order to bring data from Excel to the dashboards there are some basic rules to be followed Organize your data Rules to be followed The first row in excel should be the column names … Read more

Cloud Access

Our cloud solution is a quick one minute signup process. Once you register you are ready to go. It provides .. Ability to instantly build browser based analytics and dashboards Provide data either in Excel or Flat file such as CSV Connect directly such as Oracle, MySQL,SQL Server, DB2 There is no need to wait … Read more