Select to view content in your preferred language

How to Export/Print Version differences between child version and default version from ArcGIS Pro to an Excel spreadsheet or .csv file

1392
2
05-16-2022 12:24 PM
Labels (3)
by Anonymous User
Not applicable

How to Export/Print Version differences between child version and default version from ArcGIS pro to an Excel spreadsheet?

When I have a version other than the default, and click on version changes in the versioning tab. The window is opened to two tabs with target version tab, and differences tab.

The differences tab shows a tree list of the version changes by feature class, and on the side there is another window that has a table of columns with the first column being the schema of the attribute table, then the second column is what is currently in the table, then the next column is the selected target version, then there is the common ancestor version.

The view of columns looks like it could easily be exported into an Excel spreadsheet for each update. Does anyone have any leads on python scripts or tools that could help do this?

I looked into the diagnose version tables, but ArcGIS Pro wouldn't let me put any type of file into the diagnose version table log field.

 

2 Replies
DougAsay
Emerging Contributor

This is an important item to have the ability to extract the differences, this could be for Documentation or for Approval Process to let folks know what changed

0 Kudos
Kevin_MacLeod
Frequent Contributor

Versioning is a huge area I hope Esri can put some development focus on.  Branch adds some niceties. But this kind of thing is actually more important.  And ability to filter what is approved or posted, and how. It would be a great QA QC system. As it is now, it's not. It's too easy to not see or fully see "what hapened" ie where the differences are. 

 

Would be nice for example to select and/or export the changes as Feature Classes, not just an Excel table.  Or track lineage of a feature. ERDAS Imagine can track lineage of a raster. Arc even sort of does. Why not do that with a feature? Especially if archiving is enabled. I am well aware how Archiving works. What would be cool is to see leverage versioning and archiving together (I enabled both) in order to WHAT has changed and where; and then zoom in and spin the Historical Moment wheel (should be a slider that changes dynamically and updates live not how it is now) and see oh hey looks like these new points or these points that are moved around and attributed differently, makes sense, or does not make sense.  Also if symbology dynamically updated, you could colors or shapes change as the attribute values changed.  So a point moving around would change color if for example it both moved X,Y and also it's "Asset Status" was changed. 

 

Surprising this has not been more fully developed considering RDMBSs since the 90s would have supported this kind of thing on the backend; and as data scales QA is necessary. I kind of wonder how everyone else does it. 3rd party tools? 

0 Kudos