topic Re: Workflow for updating excel table in ArcGIS for SharePoint Questions

Workflow for updating excel table

LeoLadefian1 — Mon, 09 Dec 2013 16:36:29 GMT

I have an excel table with Lat Long coordinates among other columns. I'm trying to create a workflow where I can update the table, add new rows and edit fields, and update the layer in arcgis online. However the update layer button doesn't seem to be working when I add a new Lat and Long and fill out the fields. It simply overwrites the service. Any ideas?

Re: Workflow for updating excel table

SusanJones — Mon, 09 Dec 2013 22:02:52 GMT

Howzit

Source your locational-aware data from a database table,
Add the Database table to Excel through ODBC,
Add excel (lontigude and latitude) data to the embedded map in Excel,
Refresh and Refresh All will dynamically update both Excel and the Map layers,

It means, you only need to add the table once and the map layer once.

Susan

Re: Workflow for updating excel table

LeoLadefian1 — Wed, 11 Dec 2013 12:21:14 GMT

Thank You!

This was very helpful, now I assume I should be updating the access database with new information?

Re: Workflow for updating excel table

SusanJones — Wed, 11 Dec 2013 17:13:51 GMT

Yeah, you will need to be updating the data source directly. ie the Database Table stored in with sqlserver, oracle, ms access etc

Excel is the end user client. You can schedule the data source to be refreshed from within Excel.
In summary, store the data external to Excel and office, if possible - we need to get away from standalone excel data files.

We use this for viewing the locations from Google Analytics. We refresh data once a day in MS Sql Server. Excel reports and ESRI Maps for Office do the rest.

Susan

Re: Workflow for updating excel table

AndrewHargreaves — Thu, 19 Dec 2013 13:50:15 GMT

Excel is the end user client. You can schedule the data source to be refreshed from within Excel.

Hi,
can you expand on this some more - how do I schedule Excel, and specifically Maps for Office, to update my shared layer with ArcGIS Online?

Thanks

Re: Workflow for updating excel table

SusanJones — Thu, 19 Dec 2013 21:03:11 GMT

Please look at the Connection Properties for the data source from Excel. Get the option from the Refresh All button.

Attached is a small screen shot of the dialogue box inside of Excel.

The map inside of Excel will then update itself when the data source is updated.

Just to reiterate, We are not making a copy of the data inside of Excel, just linking to the table.

Susan

Re: Workflow for updating excel table

SusanJones — Wed, 08 Jan 2014 20:11:14 GMT

... and don't forget to set the refresh interval in ArcGIS Online.