topic Re: Python, CopyFeatures in Python Questions

Python, CopyFeatures

Williams_Gregory — Thu, 21 Mar 2024 14:21:53 GMT

I'm trying to copy some feature layers from an SQL server to a file geodatabase on my C drive. The problem I'm running into is when there are some of the feature layers within a dataset on the server and I try to copy the file(s) to a dataset folder on the file geodatabase. I does working work when there are no dataset folders.

It seems like the "arcpy.management.CopyFeatures()" function doesn't like working with datasets. I keep getting the following error message:

ERROR 000354: The name contains invalid characters
Failed to execute (CopyFeatures).

Is there a different function for datasets?

Thanks,

Re: Python, CopyFeatures

DanPatterson — Thu, 21 Mar 2024 14:28:49 GMT

can you provide the input and output paths?

000354: The name contains invalid characters.—ArcGIS Pro | Documentation

databases etc may have their own acceptable limits regarding names

Re: Python, CopyFeatures

Williams_Gregory — Thu, 21 Mar 2024 14:36:02 GMT

import arcpy, os, sys

arcpy.env.workspace = r"Database Connections\Server - sdeVector.sde\sdeVector.SDEDATAOWNER.Administrative"

arcpy.management.CopyFeatures("sdeVector.SDEDATAOWNER.MunicipalArea", r"C:\Datafiles\GISPro_GeoDatabase\Local_Basemap.gdb\MunicipalArea")

print("Done")

"Administrative" is the subfolder or dataset on the server, and I created a dataset on the file geodatabase with the same name.

Re: Python, CopyFeatures

JoshuaBixby — Thu, 21 Mar 2024 14:46:07 GMT

There are several tools available for moving data around, maybe give Export Features (Conversion)—ArcGIS Pro | Documentation a try.

Re: Python, CopyFeatures

Williams_Gregory — Thu, 21 Mar 2024 17:13:51 GMT

Tried the export function, but it didn't work. Keeps giving me an error message about the folder(or file?) already existing. But it's not there when I click refresh in ArcCatalog.

ERROR 000725: Output Feature Class: Dataset C:\Datafiles\GISPro_GeoDatabase\Local_Basemap.gdb\Administrative already exists.
Failed to execute (ExportFeatures).

Re: Python, CopyFeatures

forestknutsen1 — Fri, 22 Mar 2024 16:03:19 GMT

What about using feature class to feature class?
https://pro.arcgis.com/en/pro-app/3.1/tool-reference/conversion/feature-class-to-feature-class.htm

https://desktop.arcgis.com/en/arcmap/latest/tools/conversion-toolbox/feature-class-to-feature-class.htm

Re: Python, CopyFeatures

Williams_Gregory — Wed, 17 Apr 2024 13:17:45 GMT

Sorry for the delay with an update, I was able to get the datasets updated. What I did was delete the old dataset folders and their contents, then re-create the empty dataset folders. And finally use the arcpy.management.CopyFeatures function for each feature layer in each dataset. It does take a long to run this update, but it does work so i will live with it.

Thanks for all the suggestions!