Need help in writing arcpy script where i have same feature class names

Question

Hi,

I need to write a script that deletes rows from one feature class and append data from another feature class to the first feature class. Both feature class has the same name but are stored in a different location, I need to run this script in the python window, I was wondering what could be the workaround to accomplish this task. The script needs to run in a Python window and other users need to run the script as well.

Here is an example below:

Feature Class A = Need to delete rows from this feature class.

Feature Class A = Append data from this feature class to the first feature class.

I hope this makes sense

Thanks,

SAM!

SaM1 · Answer

Thanks, Johannes, I am using the SDE version and I want to create a script tool, and in tool parameters, i will let users to input the data location paths.  I am not sure how to give a path to sde version in parameters. the tutorials i found are all related to creating a new version could not find anything related to using the existing sde version in arcpy.  One option I know is to go to the sde database connection properties and select geodatabase connection properties will allow you to change the whole sde connection database to the sde version, not sure if i should do that. Any advice from you would be greatly appreciated! and also i wanted to make that tool work for my colleagues too.

Thank you!

SAM1

JohannesLindner · Answer

If you are dealing with File Geodatabases (.gdb), they have to be in a location that is accessible to your colleagues.

If you're dealing with Enterprise Geodatabases (.sde), your colleagues have to connect as data owner to use TruncateTable. If they use their own connection files, they have to update the script with the right paths.

To run the script, your colleagues need ArcGIS installed on their PCs.

To share the script, you have a few options:

* Just save it in a text file. To run it, copy paste into the ArcGIS Pro Python Window.
* Insert "import arcpy" at the start of the script and save it as a python script (.py). Now you can also run it outside of ArcGIS, either using the command line or by opening it with IDLE (automatically installed with ArcGIS) and running it there.
* Create a toolbox, turn the script into a script tool inside that toolbox, share the toolbox. Might be a bit overkill...
https://pro.arcgis.com/de/pro-app/latest/arcpy/geoprocessing_and_python/a-quick-tour-of-creating-script-tools.htm

SaM1 · Answer

Thank you, These links are helpful!

SAM!