[GIS] Why “DataBase Connections” mapped to “Dataset DataBase Connections” in ArcCatalog

arccatalogarcgis-10.0arcgis-desktopenterprise-geodatabase

I am trying to Export data from a geodatabase by a existed sde file(created by ArcCatalog),
the Error Messges:

Executing: ExportCAD 'DataBase Connections\Connection to
GIS-WANG.sde\SDE.water\SDE.ControlValve' DWG_R2010 D:\117.DWG
Ignore_Filenames_in_Tables Overwrite_Existing_Files # Start Time: Thu
Oct 13 16:46:59 2011 ERROR 000622: Failed to execute (ExportCAD).
Parameters are not valid. ERROR 000732: Input Features: Dataset
'DataBase Connections\Connection to
GIS-WANG.sde\SDE.water\SDE.ControlValve' does not exist or is not
supported Failed to execute (ExportCAD). Failed at Thu Oct 13 16:46:59
2011 (Elapsed Time: 0.00 seconds)

Why "DataBase Connections" mapped to "Dataset DataBase Connections"?

Best Answer

The problem is occuring, because the script does not know where "DataBase Connections" is. (ArcCatlog/ArcMAP know where it is, and this is why, it works if you use the same syntax within these applications. This is one my pet peeves when working with ArcGIS)

The actual SDE connection file is usually in %appdata%/ESRI/ArcCatlog .. or something similar.

What I usually do, is either give the entire path to the .sde file, or copy the .sde file to some location, and use that path in the script.

For example, I'll copy the .sde file from the above location, to say D:\Con and then use the following script

ExportCAD 'D:\Con\Connection to GIS-WANG.sde\SDE.water\SDE.ControlValve' DWG_R2010 D:\117.DWG Ignore_Filenames_in_Tables Overwrite_Existing_Files

Related Solutions

[GIS] Delete SDE feature class features with ArcPy

If you have delete rights, (and that isthe first thing you should check) and still the script does not run, then the problem is in the way that you are giving the path of the featureclass.

"Dataset Database Connections\Connection to sde.sde\User.MyFeatureDataset\User.MyFeatureClass" is a path that ArcCatlog & ArcMap undertsand, but not a standalone script.

What you need to do, is to give the complete path, including the location of the SDE connection. The SDE connection is usually in C:\Users\\AppData\Roaming\ESRI\Desktop10.0\ArcCatlog

You need to give the path of the featureclass as: "C:\Users\<User>\AppData\Roaming\ESRI\Desktop10.0\ArcCatlog\Connection to sde.sde\User.MyFeatureDataset\User.MyFeatureClass"

I have found that this path works when running stand alone scripts.

This question might explain the issue further: Define Workspace for SDE Connection in Python

[GIS] Copying ArcSDE datasets and features in Python give ERROR 000732

The errors you are encountering are a direct result of not inputting the correct number of parameters into the tool you are calling. Create Feature Dataset requires both out_dataset_path and out_name.

In addition to this there are some other issues with your code.

The help documentation for the Feature Class to Geodatabase tool states:

The inputs can include shapefiles, coverage feature classes, VPF feature classes, or geodatabase feature classes

You are attempting to input a feature dataset. Since you're choosing to loop through your feature classes I would think the input to this process would be a feature class.

Try this modified version of your code where a feature class in used in place of the feature dataset.

    dsList = arcpy.ListDatasets()
    print dsList
    for dsGEO in dsList:
        arcpy.CreateFeatureDataset_management(dsGEO, **out_name**)
        fcListGEO = arcpy.ListFeatureClasses(dsGEO)
        for fcGEO in fcListGEO:
            arcpy.FeatureClassToGeodatabase_conversion(fcGeo, **output_geodatabase**)

Pending the rest of your code is correct this will loop through each feature class inside of each feature dataset and add it to your geodatabase.

Best Answer

Related Solutions

[GIS] Delete SDE feature class features with ArcPy

[GIS] Copying ArcSDE datasets and features in Python give ERROR 000732

Related Question