topic Re: Live Sync between an Excel file and a map in ArcGIS Online Questions

Live Sync between an Excel file and a map

NWEdisonTeam — Sat, 10 Nov 2018 21:02:07 GMT

Hello

I am trying to see if there is a process to do a two way live sync between an excel/.csv file stored on a computer or server, and an Arcgis Online map? Is this possible even? Thanks!

Re: Live Sync between an Excel file and a map

shan_sarkar — Sun, 11 Nov 2018 10:55:21 GMT

Tirrell,

I assume you are storing point location in the excel and you are updating the data and want the updates to be reflected online as well?

ArcMap creates an event layer which is an in-memory layer and any updates made to the source excel/csv file is visible in almost instantaneously.

Having said that, if you are publishing the data to arcgis server with the folder which contains the excel registered with arcgis server your updates should be reflected on the service.

In case you are working with AGOL it will not work as the data is copied over to AGOL and you will have to overwrite the same service to view the updates.

You may refer:

Make XY Event Layer—Help | ArcGIS Desktop

I hope this helps!

~Shan

Re: Live Sync between an Excel file and a map

KarstenRank — Sun, 11 Nov 2018 15:48:45 GMT

Hi,

if you store your csv data on a webserver, you can take the csv file as source for web map. If you reload the map, the csv would take the new data.

Karsten

Re: Live Sync between an Excel file and a map

NWEdisonTeam — Mon, 12 Nov 2018 16:45:13 GMT

Hey,

Thanks for replying, and yes it does help. The issue here is that we don't have (and won't be getting) Arcgis server..not at least for a while. Could a SQL server be used to do the same thing?

Re: Live Sync between an Excel file and a map

NWEdisonTeam — Mon, 12 Nov 2018 16:46:49 GMT

Hey,

Thanks for responding! Could you name a web server or two?

Re: Live Sync between an Excel file and a map

KarstenRank — Mon, 12 Nov 2018 17:04:30 GMT

Hi,

I use our own webserver in our organisation. But you can take any webserver from any web hoster.

Karsten

Re: Live Sync between an Excel file and a map

NWEdisonTeam — Mon, 12 Nov 2018 17:12:09 GMT

Hey,

Could I do this datapush through Azure?

Re: Live Sync between an Excel file and a map

KarstenRank — Mon, 12 Nov 2018 17:20:05 GMT

If you can get the csv-file with http:// then yes

Re: Live Sync between an Excel file and a map

BrianBaldwin — Mon, 12 Nov 2018 18:14:10 GMT

Really old blog, but shows how this can be done via Google Docs, and the methodology would be similiar with a file that has a URL:

Using Google Docs in your ArcGIS Online maps

Re: Live Sync between an Excel file and a map

NWEdisonTeam — Mon, 12 Nov 2018 19:13:32 GMT

Hey

So I used the workflow described in the doc you linked, just one question: If I am in a scenario where I need to app or edit in the field, I am not seeing how it would allow that?

Re: Live Sync between an Excel file and a map

BrianBaldwin — Mon, 12 Nov 2018 20:57:20 GMT

That... gets a little tricky. The workflow described in the blog and with these type of registrations is really only for 'read-only'.

Technically, it gets a lot more challenging if you think of user access/rights to allow for editing the data. How does Google Docs know what users are allowed to edit? With the viewing, you are simply creating a public URL.

Re: Live Sync between an Excel file and a map

NWEdisonTeam — Mon, 12 Nov 2018 23:04:41 GMT

After tinkering around with it, I've found no way through on this one. It really does have to be in an Arc server environment to be able to do live syncs both ways, due to the permissions being built in. Essentially this works like Tableau(sp?), which for our purposes is redundant lol. Thank you for your help sir!

Re: Live Sync between an Excel file and a map

BrianBaldwin — Mon, 12 Nov 2018 23:35:30 GMT

The only comment I would offer to that, is that you could just host the features directly in ArcGIS Online? You don't need to use ArcGIS Server for editing features.

Re: Live Sync between an Excel file and a map

NWEdisonTeam — Tue, 04 Dec 2018 22:59:33 GMT

I found a way, well a more indirect way. I am going to run it through a server...essentially that will create the live data link I am looking for. Sorry for my late reply on this, it got buried in my spam box.

Re: Live Sync between an Excel file and a map

CharfeldineMahammedi — Sun, 07 Mar 2021 12:35:27 GMT

Hello, I have the same problem, may you please explain to me how to live sync between an excel/.csv file stored on my computer and an Arcgis Online.

Your helps is really appreciated

Thanks

Re: Live Sync between an Excel file and a map

RossHavery — Wed, 26 Jan 2022 12:54:21 GMT

Hi Shan,

I have attempted the above and have managed to get a CSV to display as you say above but this cannot be queried which I think is an issue with the object ID field not being read on CSVs.

I have since tried the same with an excel file from the same folder but every time I try to upload this to the server I get this error (ERROR 001487: Failed to update the published service with the server-side data location.) I am pulling the data from the same folder as the CSV so know it works but I think the server has an issue opening/reading excel sheets.

Have you managed to achieve the above with an excel sheet and if so did you need to set anything specific on the server or on the excel file?

Thanks

Ross

Re: Live Sync between an Excel file and a map

shan_sarkar — Thu, 27 Jan 2022 04:47:02 GMT

Hello Ross,

Are you using just the ArcGIS Sever separately of have you configure ArcGIS Enterprise as a whole? If you have Enterprise setup for you, you can use the Excel and publish the service to your Portal for ArcGIS and it should dynamically update service as the spreadsheet is updated.

Please refer: -