[GIS] Why does AddField give ERROR: 000732 Input Table: does not exist or is not supported

arcgis-10.0arcpyerror-000732

I was handed off a a bunch of state shapefiles and wrote a script to add a few new fields and calculate some attributes. The first line in my script is –

arcpy.AddField_management('C:\WB_prj\cityPts\ghosts.gdb\vietnam_adm3_citypt_albers_ghost', 'City_cnt', 'SHORT', '#', '#', '#', '#', 'NULLABLE', 'NON_REQUIRED', '#')

I have all of the state shapefiles in a geodatabase. The script runs perfect for some of the files but for others I get an error that is shown below. My pathways are correct and I can manually add the fields through ArcMap but when I try and run the script for some of them I get the error. Any ideas on how to solve this? I'm running ArcGIS 10.0

File "C:\WB_prj\scripts\ghostRegions_final.py", line 79, in
add_fields() File "C:\WB_prj\scripts\ghostRegions_final.py", line 14, in add_fields
arcpy.AddField_management('C:\WB_prj\cityPts\ghost.gdb\vietnam_adm3_citypt_albers_ghost',
'City_cnt', 'SHORT', '#', '#', '#', '#', 'NULLABLE', 'NON_REQUIRED',
'#') File "C:\Program Files
(x86)\ArcGIS\Desktop10.0\arcpy\arcpy\management.py", line 2625, in
AddField
raise e ExecuteError: Failed to execute. Parameters are not valid. ERROR 000732: Input Table: Dataset C:\WB_prj\cityPts\ghost.gdb
ietnam_adm3_citypt_albers_ghost does not exist or is not supported
Failed to execute (AddField).

Best Answer

Try:

r'C:\WB_prj\cityPts\ghosts.gdb\vietnam_adm3_citypt_albers_ghost'

'C:\\WB_prj\\cityPts\\ghosts.gdb\\vietnam_adm3_citypt_albers_ghost'

'C:/WB_prj/cityPts/ghosts.gdb/vietnam_adm3_citypt_albers_ghost'

Your syntax of 'C:\WB_prj\cityPts\ghosts.gdb\vietnam_adm3_citypt_albers_ghost' will use the single "\" as an escape character and thus not work.

Related Solutions

[GIS] ExecuteError: Failed to execute. Parameters are not valid. ERROR 000732: Layer Name or Table View: Dataset L does not exist

Here's a different way to do this by setting the dataframe equal to the current layer's extent. It a lot more simple. Also, you'd better check your path because it shows the MXD being inside the geodatabase.

import arcpy
import os

path = "C:\\Users\\Et\\Documents\\ArcGIS" #need to use two backslashes
mxd = arcpy.mapping.MapDocument(os.path.join(path, "WinterGritting.mxd")) #use os.path.join
df = arcpy.mapping.ListDataFrames(mxd, "Layers")[0]
layer_list = arcpy.mapping.ListLayers(mxd, "", df) #don't use indexing here

for layer in layer_list:
    layer_name = str(layer.name)

    for layer_check in layer_list: #turns on/off other layers
        if layer_check != layer:
           layer_check.visible = False
           layer.visible = True

    mxd.title = layer_name    
    layer_extent = layer.getExtent() #get the extent of the current layer
    df.extent = layer_extent #set the dataframe to the layer's extent
    arcpy.RefreshActiveView()
    arcpy.mapping.ExportToJPEG(mxd, os.path.join(path, "Routes", layer_name + ".jpg"))

del mxd

Updated for comment.

Add the names of whatever layers you don't want to turn off into the landbase list.

import arcpy
import os

path = "C:\\Users\\Et\\Documents\\ArcGIS" #need to use two backslashes
mxd = arcpy.mapping.MapDocument(os.path.join(path, "WinterGritting.mxd")) #use os.path.join
df = arcpy.mapping.ListDataFrames(mxd, "Layers")[0]
layer_list = arcpy.mapping.ListLayers(mxd, "", df) #don't use indexing here

landbase = ["Roads", "Lakes"] #add layer names you want always visible here

for layer in layer_list:
    layer_name = str(layer.name)

    if layer_name not in landbase:

        for layer_check in layer_list: #turns on/off other layers
            if layer_check != layer and layer_check.name not in landbase:
                layer_check.visible = False
            else:
                layer_check.visible = True

        mxd.title = layer_name
        layer_extent = layer.getExtent() #get the extent of the current layer
        df.extent = layer_extent #set the dataframe to the layer's extent
        arcpy.RefreshActiveView()
        arcpy.mapping.ExportToJPEG(mxd, os.path.join(path, "Routes", layer_name + ".jpg"))

del mxd

[GIS] Error 000732 – Input Layer “does not exist or is not supported” when using ‘ApplySymbologyFromLayer_management’

Symbology applies to a layer, not to a feature class. From the help:

This tool applies the symbology from a layer to the Input Layer. It can be applied to feature, raster, network analysis, TIN, and geostatistical layer files or layers in the ArcMap table of contents.

You will need to make a feature layer within your code (the following is untested but should get you on the right track):

dest = arcpy.GetParameterAsText(1)
destWorkspace, destName = os.path.split(dest)
arcpy.FeatureClassToFeatureClass_conversion(source, destWorkspace, destName, "", mapping)
arcpy.MakeFeatureLayer_management (dest, "out_layer")
in_symbology_layer = r"Q:\Data\lyrfiles\LiftStations.lyr"
arcpy.ApplySymbologyFromLayer_management ("out_layer", in_symbology_layer)

Best Answer

Related Solutions

[GIS] ExecuteError: Failed to execute. Parameters are not valid. ERROR 000732: Layer Name or Table View: Dataset L does not exist

[GIS] Error 000732 – Input Layer “does not exist or is not supported” when using ‘ApplySymbologyFromLayer_management’

Related Question