How to add CSV data from CKAN open-source data portal?

Report Builder allows you to add live CSV data from the CKAN open-source data portal to the report. This saves you from having to upload the CSV file to your ArcGIS Online account before using it in the report. It also means that any data updates in the CKAN portal will automatically reflect in the associated report, so you don’t have to manually update data in ArcGIS Online.

A list of data portal websites using CKAN can be found at http://ckan.org/instances/#

Before you add a CSV from CKAN portal

1. Make sure that the first field column in the CSV file contains the same values as the report Feature ID field. This will be used as a common identifier to connect the CSV file to the report.

To add a CSV file from CKAN portal

1. On the Data Manager dialog, click Add CSV AddCSVButton.

2. Enter the CSV URL from the data portal into the the Enter URL box, in the Choose CSV Data dialog.

CSV Link

3.  Click Next NextButton.

4. Click Finish FinishButton.

5. The CSV data should now appear in the Data Sources section ready to be utilised in the report widgets.

Depending on how the CKAN portal is set up you may need to contact us to enable the CKAN site you are interested in.  Alternatively you may be able to get it working if you ensure the csv is coming from a CORS enabled site