topic Re: How can I edit and continuously add data from my excel sheet so that it updates in my attribute table/map? in ArcGIS Pro Questions

How can I edit and continuously add data from my excel sheet so that it updates in my attribute table/map?

Anonymous User — Fri, 03 Jul 2020 20:03:49 GMT

I know ArcGIS maps does not let you add more data directly to excel files on attribute tables because they are "read only's." However, I am creating a time series map that requires I continuously add data to my attribute table every day to show the continuous change. How can I do this using an excel file? If not with excel, does downloading the data as a geo-file allow you to add data in the attribute table? Only thing I know is that when you add/edit an attribute table it only allows you to add on an additional field. But what if I don't want to create an additional field, but rather add on to the data within a field?

Re: How can I edit and continuously add data from my excel sheet so that it updates in my attribute table/map?

DanPatterson — Fri, 03 Jul 2020 20:57:25 GMT

Is the data point data?

Are you adept at scripting?

What is your current workflow?

Re: How can I edit and continuously add data from my excel sheet so that it updates in my attribute table/map?

DavidPike — Sat, 04 Jul 2020 10:53:37 GMT

you should be able to do this with a Relate with the feature and table, or create a tool or script to run an arcpy.da.UpdateCursor or InsertCursor.

Re: How can I edit and continuously add data from my excel sheet so that it updates in my attribute table/map?

Anonymous User — Sat, 04 Jul 2020 11:04:47 GMT

Yes. I am working with data points. And I am not too skilled at scripting. Can you please send some info on scripting?

Re: How can I edit and continuously add data from my excel sheet so that it updates in my attribute table/map?

DanPatterson — Sat, 04 Jul 2020 11:09:16 GMT

Quite a bit

ArcGIS Pro Python reference—ArcGIS Pro | Documentation

Modelbuilder might be a better first approach if you use tools from arctoolbox

ModelBuilder quick tour—ArcGIS Pro | Documentation

Re: How can I edit and continuously add data from my excel sheet so that it updates in my attribute table/map?

jcarlson — Sat, 04 Jul 2020 13:46:43 GMT

Can you give an example of your data, and what your daily update looks like? It's not clear to me if you're editing existing records or simply adding new records to your table.

The ArcGIS Pro documentation discusses excel files in a good amount of detail on this page. Once you have your Excel table added to your map, it will refresh with any updated edits to the spreadsheet when Pro opens. You should be able to continue using Excel to enter your data without much trouble.

Re: How can I edit and continuously add data from my excel sheet so that it updates in my attribute table/map?

Anonymous User — Sat, 04 Jul 2020 15:46:27 GMT

I am tracking the movements of the protest in NYC everyday. So im constantly updating the location and time of protest. And thank you for the info!

Re: How can I edit and continuously add data from my excel sheet so that it updates in my attribute table/map?

Anonymous User — Sat, 04 Jul 2020 15:51:44 GMT

In other words, Im adding a new date every day with a new location and new time of a new protest in NYC.

Re: How can I edit and continuously add data from my excel sheet so that it updates in my attribute table/map?

BruceHarold — Mon, 06 Jul 2020 13:32:53 GMT

People on this thread, consider if what you really need is event-driven geoprocessing, and if so start an Idea with your use case. I took a look at using the watchdog module for this but it blocked the groprocessing thread and needed to be made into a Windows service, which just got too hard (for me).

Re: How can I edit and continuously add data from my excel sheet so that it updates in my attribute table/map?

Kara_Shindle — Mon, 06 Jul 2020 19:57:07 GMT

I use a script that takes excel documents like time entries on projects filled in by others and uploads it to AGOL where it updates a metrics dashboard for admins. I have the script set via Task Scheduler to run every hour. This is just one way I came up with solving a similar issue.

Re: How can I edit and continuously add data from my excel sheet so that it updates in my attribute table/map?

CarolineMaps — Wed, 27 Mar 2024 14:13:32 GMT

Hi Kara (or anyone), could you share more info on this so I might replicate? What the script is, how you use it? Thank you! I have an excel file that various people are updating with new event information I need to map either on ArcGIS Pro or Online, doesn't really matter. I just want the easiest system that I and others less familiar with GIS can do. I could do manual updates periodically, but if there is a way to automate it that would be ideal. The data is not perfectly clean which poses another challenge.