Live Sync between an Excel file and a map

[NWEdisonTeam]

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!

[BrianBaldwin]

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 

[NWEdisonTeam]

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?

[BrianBaldwin]

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.

[NWEdisonTeam]

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!

[BrianBaldwin]

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.

[NWEdisonTeam]

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. 

[CharfeldineMahammedi]

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