{"id":10391,"date":"2016-08-29T12:03:36","date_gmt":"2016-08-29T11:03:36","guid":{"rendered":"https:\/\/help.instantatlas.com\/report-builder-agol\/?page_id=10391"},"modified":"2016-08-29T12:03:36","modified_gmt":"2016-08-29T11:03:36","slug":"how-to-add-csv-data-from-ckan-open-source-data-portal","status":"publish","type":"page","link":"https:\/\/help.reports.esriuk.com\/report-builder\/how-to-add-csv-data-from-ckan-open-source-data-portal\/","title":{"rendered":"How to add CSV data from CKAN open-source data portal?"},"content":{"rendered":"<p><strong>Report Builder<\/strong>\u00a0allows you to add\u00a0live CSV data from\u00a0the <strong>CKAN<\/strong> open-source data portal to the report. This saves you from having to upload the CSV file to your\u00a0<strong>ArcGIS Online<\/strong>\u00a0account before using it in the report. It also means that\u00a0any data updates in the <strong>CKAN<\/strong> portal will automatically reflect in the associated report, so you don\u2019t have to manually update data in <strong>ArcGIS Online<\/strong>.<\/p>\n<p>A list of data portal websites using <strong>CKAN<\/strong> can be found at\u00a0<a href=\"http:\/\/ckan.org\/instances\/#\" target=\"_blank\" rel=\"noopener\">http:\/\/ckan.org\/instances\/#<\/a><a href=\"http:\/\/ckan.org\/instances\/#\" target=\"_blank\" rel=\"noopener\"><\/a><\/p>\n<p><strong>Before you add a CSV from CKAN portal<\/strong><\/p>\n<p>1. Make sure that the first field column in the CSV file contains the same values as the report <strong>Feature ID<\/strong> field. This will be used as a common identifier to connect the CSV file to the report.<\/p>\n<p><strong>To add a CSV file from CKAN portal<\/strong><\/p>\n<p>1. On the <strong>Data Manager<\/strong> dialog, click <strong>Add CSV<\/strong> <img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/help.instantatlas.com\/dashboard-builder\/wp-content\/uploads\/sites\/11\/2016\/05\/AddCSVButton.png\" alt=\"AddCSVButton\" class=\"alignnone size-full wp-image-14541\" height=\"42\" width=\"137\" \/>.<\/p>\n<p>2. Enter the CSV URL from the data portal into the the <strong>Enter URL<\/strong> box, in the <strong>Choose CSV Data<\/strong> dialog<strong>.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/help.instantatlas.com\/report-builder\/wp-content\/uploads\/sites\/21\/2016\/06\/RB_CSV_Link.png\" alt=\"CSV Link\" class=\"alignnone wp-image-14981 size-full\" height=\"562\" width=\"1078\" \/><\/p>\n<p>3. \u00a0Click <strong>Next\u00a0<\/strong><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/help.instantatlas.com\/dashboard-builder\/wp-content\/uploads\/sites\/11\/2016\/05\/NextButton.png\" alt=\"NextButton\" class=\"alignnone size-full wp-image-14571\" height=\"46\" width=\"87\" \/>.<\/p>\n<p>4. Click <strong>Finish\u00a0<\/strong><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/help.instantatlas.com\/dashboard-builder\/wp-content\/uploads\/sites\/11\/2016\/05\/FinishButton.png\" alt=\"FinishButton\" class=\"alignnone size-full wp-image-14581\" height=\"47\" width=\"81\" \/>.<\/p>\n<p>5. The CSV data should now appear in the <strong>Data Sources <\/strong>section ready to be utilised in the report widgets.<\/p>\n<p><span>Depending on how the CKAN portal is set up you may need to contact us to enable the CKAN site you are interested in. \u00a0Alternatively you may be able to get it working if you ensure the csv is coming from a <a href=\"https:\/\/help.instantatlas.com\/report-builder-agol\/cross-origin-resource-sharing-cors\/\">CORS enabled site<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Report Builder\u00a0allows you to add\u00a0live CSV data from\u00a0the CKAN open-source data portal to the report. This saves you from having to upload the CSV file to your\u00a0ArcGIS Online\u00a0account before using it in the report. It also means that\u00a0any data updates in the CKAN portal will automatically reflect in the associated report, so you don\u2019t have [&hellip;]<\/p>\n","protected":false},"author":22,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-10391","page","type-page","status-publish","hentry","entry"],"_links":{"self":[{"href":"https:\/\/help.reports.esriuk.com\/report-builder\/wp-json\/wp\/v2\/pages\/10391","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.reports.esriuk.com\/report-builder\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/help.reports.esriuk.com\/report-builder\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/help.reports.esriuk.com\/report-builder\/wp-json\/wp\/v2\/users\/22"}],"replies":[{"embeddable":true,"href":"https:\/\/help.reports.esriuk.com\/report-builder\/wp-json\/wp\/v2\/comments?post=10391"}],"version-history":[{"count":0,"href":"https:\/\/help.reports.esriuk.com\/report-builder\/wp-json\/wp\/v2\/pages\/10391\/revisions"}],"wp:attachment":[{"href":"https:\/\/help.reports.esriuk.com\/report-builder\/wp-json\/wp\/v2\/media?parent=10391"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}