idea Update Joins with data updates in ArcGIS Pro Ideas

Update Joins with data updates

MarkLecher2 — Thu, 24 Feb 2011 15:24:29 GMT

Updating mxd documets that drive web services in and enterprise environment can be hard to manage sometimes. At 10, updating of data sources became easier with the use of pyton. However, if the mxd is built using stand alone tables joined to layers, those joins do not and cannot be easily updated when data sources change. This is especially troublesome for users in a multi-tiered environment where the mxds and services need to move from test to staging to production with data source updates at each move. Now, the joins do not get updated with the data source change and the mxd needs to be manually updated (join removed and recreated) which requires work and introduces the chance of errors being introduced in the change.

Re: Update Joins with data updates

ChrisFox — Fri, 25 Feb 2011 00:50:45 GMT

Thank you for posting the idea. One thought I had was if you replaced the data source through python could you then recreate the join as well using the Add Join tool? This might help automate the process of changing data sources and recreating the join.

Re: Update Joins with data updates

JurajKrumpolec — Fri, 25 Feb 2011 08:20:28 GMT

What if ArcGIS did it automatically, without any user intervention? No python, no programming, just a simple click and the application does it by itself. Updates everything what is needed when the data sources change - joins, symbology, definition query, labels etc. I know, I know, it would be probably too much comfort for the user when it is possible to do it manually, one by one, like everything else in ESRI's applications 😞
No intelligence, no intuitiveness, no interactivity, just pure unconsciousness.

Re: Update Joins with data updates

ChrisFox — Fri, 25 Feb 2011 22:25:47 GMT

@mlecher If I am understanding you correctly you are wanting to update an mxd's layer and joined tables with new data sources as you move from staging to production for example. The findAndReplaceWorkspacePaths should accomplish this. For example let's say all my layer's data sources and tables are in the workspace, "C:\mytest\testing.gdb" and I want to update the source to E:\Production\Production.gdb. I could use the following lines of code to make the change in Python.

import arcpy
mxd = arcpy.mapping.MapDocument(r"C:\myMXD.mxd")
mxd.findAndReplaceWorkspacePaths(r"C:\mytest\testing.gdb", r"E:\Production\Production.gdb")
mxd.save()
del mxd

Not only would the layers update to the new data source, but the stand-alone tables joined to those layers would update to the new data source. If you have tried this and are not getting the same results could you verify you are at service pack 1. If I am not understanding your workflow correctly could you write back with more details on your specific scenario.

Re: Update Joins with data updates

DavidKnudsen — Wed, 09 Mar 2011 16:04:07 GMT

Our big problem with this is that it is rare for tables to be in the same workspace as the feature classes to which they are joined. This is almost inherent in the usefulness of joins: if the tables were in the same workspace, wouldn't that probably imply that you "owned" or maintained the tables as well as the feature classes? In that case, you would probably just permanently extend the feature classes with the table attributes and delete the tables.

But in fact, usually we are joining because we own and maintain the feature classes but do not own and maintain the tables to which we are joining. (Simple example: a feature class of bike lanes, related by a key to a road feature class maintained by a separate agency.)

The original announcement of the arcpy.mapping module explicitly noted that joined tables in different workspaces from the feature class on the left of the join would not be changed by the functions of the module. I can't find any note about this in the current documentation. Is this something that was addressed in Service Pack 1?

Re: Update Joins with data updates

ChrisFox — Thu, 10 Mar 2011 23:35:50 GMT

So if I understand you correctly you have a join to a table in a different workspace then the feature class and you want to change the path of the feature class for a layer in the map document but keep the path to the joined table? If this is the case I am finding that this is the behavior at 10 service pack 1. I haven't tested at 10 without service pack 1 and I did a search for known-issues and didn't find any specific to this scenario, but it may be possible it was resolved at service pack 1. Are you finding that the join is being removed when you do this?

Re: Update Joins with data updates

DavidKnudsen — Tue, 17 Jul 2012 14:06:39 GMT

@Chris_Fox Sorry I missed your reply. I think in the case I was talking about, both the location of the feature class and the location of the table change. For example

\\old_server\share\internally_owned_data.fgdb\featureclass and
\\old_server\share\externally_supplied_data.mdb\table

both move to a new server, remaining in separate workspaces:

\\new_server\share\internally_owned_data.fgdb\featureclass and
\\new_server\share\externally_supplied_data.mdb\table.

This thread is old now, but my recollection is that the only way the source of a table on the right side of a join could be updated was if it shared the tablespace of the featureclass it was joined to; it would be updated at the same time that the source of the featureclass was fixed. Otherwise there was no direct way to access and change the source of a joined table. I don't know if my interpretation of the documentation was correct on that score and if it still holds, if so.

Re: Update Joins with data updates

Anonymous User — Tue, 07 Jul 2020 14:43:05 GMT

I see this is a bit old. Is there a newer thread related to this topic?

I am trying to find a find a simple method to update a feature class created from a joined table. The table will updated periodically, and I want to capture that without creating a new feature class every time. Ultimately, it will be used to create a hosted feature class used in dashboards, web apps, etc. Are there any standard workflows for this?

Re: Update Joins with data updates

MaximeDemers — Fri, 15 Nov 2024 16:09:48 GMT

I am using Pro 2.9.1 and this is still not possible the change a feature class dataSource without removing the joins before.

Re: Update Joins with data updates

Wayne_Rennick — Wed, 18 Dec 2024 20:57:14 GMT

@MaximeDemers Joins and relates are fundamental to databases and GIS. It's so frustrating that we can't update these file paths in ArcGIS Pro (I'm using 3.3 and can't figure out a way to do it)