In Chapter 8, Dashboard Connectivity, we discussed a number of data connectivity options for Dashboard Design dashboards. In addition to these standard data connections, Centigon Solutions developed an add-on that allows us to use Comma-Separated Value (CSV) files to grab data from. This recipe will give you a quick walkthrough of the features of this add-on.
Go to the Centigon Solutions website (http://www.centigonsolutions.com/) and browse for the CSV connector. Download the free trial and install it with the Add-On Manager. You also need a sample CSV file to use in this recipe.
Open a new Dashboard Design file and go to the spreadsheet area. Enter the location of the CSV file in cell C1.
Open the Data Manager and click on the Add button. Under Add-On connection, you will see the CSV Connector. Select it.
Give this connection a name. Bind the CSV Data URL field to cell C1.
Also, check the Delimiter setting. This should...