{"id":14962,"date":"2019-04-30T11:12:18","date_gmt":"2019-04-30T10:12:18","guid":{"rendered":"https:\/\/help.instantatlas.com\/dashboard-builder-agol\/?page_id=14962"},"modified":"2019-04-30T21:23:51","modified_gmt":"2019-04-30T20:23:51","slug":"tips-tricks-for-instantatlas-desktop-users-using-dashboard-builder","status":"publish","type":"page","link":"https:\/\/help.instantatlas.com\/dashboard-builder-agol\/tips-tricks-for-instantatlas-desktop-users-using-dashboard-builder\/","title":{"rendered":"Tips & Tricks for InstantAtlas Desktop users using Dashboard Builder"},"content":{"rendered":"

Overview<\/strong><\/p>\n

As an InstantAtlas Desktop user you might have been working on projects that you would like to replicate in Dashboard Builder. There are a few tricks that will help you to save time doing that.<\/p>\n

Get your Excel Data Manager data into your dashboard<\/strong><\/p>\n

You are probably already using our Excel Data Manager Add-In that allows you to export data from an Excel workbook into an InstantAtlas Desktop report. We have improved this Add-In now so that it will also allow you to export the data into a file that can be uploaded to the InstantAtlas Dashboard Builder.<\/p>\n

To use it please follow these steps:<\/p>\n

    \n
  1. Check that you have the InstantAtlas Data Manager add-in version 6.10.0 or later installed. If not, download the latest Add-In file from here<\/a> and install it in Excel. For information on how to do this please refer to this help page<\/a>.<\/li>\n
  2. In Excel, under the Add-ins tab, you can now find a new button called IA Export for RB+<\/strong>:
    \n    \"\"<\/a><\/li>\n
  3. Open your Excel workbook for InstantAtlas Desktop and add the following lines into the Metadata<\/strong> worksheet:
    \n\n\n\n\n\n\n
    ElementType<\/strong><\/td>\nElement<\/strong><\/td>\nMetadataElement<\/strong><\/td>\nValue<\/strong><\/td>\n<\/tr>\n
    ArcGISOnline<\/td>\nMapLayer<\/td>\nidField<\/td>\n<\/td>\n<\/tr>\n
    ArcGISOnline<\/td>\nMapLayer<\/td>\nnameField<\/td>\n<\/td>\n<\/tr>\n
    ArcGISOnline<\/td>\nDataLayer<\/td>\nurl<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/li>\n
  4. Fill the idField<\/strong> and nameField<\/strong> values with the correct code and name fields from the Feature Service that you use as your Data Layer in Dashboard Builder. Leave the url<\/strong> value blank for now.<\/li>\n
  5. Click the IA Export for RB+<\/strong> button in the Excel Data Manager add-in and save the files in a location that you can easily find. The tool will create a CSV file and a JSON file with the same names but different file extensions. The JSON file is still missing the URL of the CSV file so it can\u2019t be used just yet.<\/li>\n
  6. Upload the CSV file to your ArcGIS Online account. Do not publish it as a hosted layer (remove the tick ‘Publish this file as a hosted layer…’).
    \n\"\"<\/a>
    \nOnce uploaded, share it with Everyone (public)<\/strong>.<\/li>\n
  7. On the ArcGIS Online details page of the CSV file, scroll down until you see the URL<\/strong> in the right-hand side pane. Click the button to the right of it to copy the URL into your clipboard.
    \n    \"\"<\/a><\/a><\/li>\n
  8. Paste the URL to the CSV file into your Metadata worksheet as the value for url<\/strong>.<\/li>\n
  9. Click the IA Export for RB+<\/strong> button again and generate the two files again. We suggest you choose the same file name so that the old files are overwritten and you won\u2019t pick the wrong one at the next step. The CSV file will be identical to the one created before, however the JSON file will now contain the correct URL to the CSV file within ArcGIS Online.<\/li>\n
  10. Open (or newly create) your dashboard using Dashboard Builder<\/strong>. Click on the Data<\/strong> button at the top and then the Upload<\/strong> button at the bottom right of the dialog.
    \n    \"\"<\/a>
    \nSelect your JSON file to upload it. The themes, indicators, dates, associates, indicator notes links and metadata will be applied to the dashboard as defined in your Excel workbook.<\/li>\n<\/ol>\n

    Limitations<\/u>:<\/p>\n