topic Re: cannot access geodatabase using windows command line in Python Questions

cannot access geodatabase using windows command line

geogeekgeogeek — Fri, 29 Jun 2012 07:28:03 GMT

While i can set the workspace and get all the feature classes of geodatabase using Arcmap python window, i can set the workspace using windows commmand line window but i can't get the feature classes, to check if i've made a connection with the geodatabase.

the script above returns in Arcmap python windows array containing feature classes , but in commande line window it returns an empty array.

>>import arcpy 
>>arcpy.env.workspace = u'C:\\Users\\hp\\Documents\\ArcGIS\\Default.gdb'
>>arcpy.ListFeatureClasses()
>>[]

i've checked global variables in windows 7:

PYTHONPATH = C:\Program Files (x86)\ArcGIS\Desktop10.0\bin;C:\Program Files (x86)\ArcGIS\Desktop10.0\arcpy;C:\Program Files (x86)\ArcGIS\Desktop10.0\ArcToolbox\Scripts
the concerned part of PATH = C:\Python26\ArcGIS10.0;C:\Python26\ArcGIS10.0\Scripts;C:\Program Files (x86)\ArcGIS\ArcSDE\pgexe\bin

Available for more details

please help i'm stuck in this problem since a week

geogeek

Re: cannot access geodatabase using windows command line

KimOllivier — Sun, 12 Dec 2021 04:46:02 GMT

Setting a workspace is just a variable, it does not test if the workspace exists.
Try a test first to debug your path. I got the same null response when using XP because of course the path is different.

>>> import arcpy
>>> arcpy.env.workspace = "c:/users/kimo/documents/arcgis/default.gdb"
>>> arcpy.ListFeatureClasses()
[]
>>> arcpy.env.workspace = r"C:\Documents and Settings\kimo\My Documents\ArcGIS\Default.gdb"
>>> arcpy.ListFeatureClasses()
[u'sea1_Buffer', u'amenity2_EliminatePolygonPar']
>>> ws = r"C:\Documents and Settings\kimo\My Documents\ArcGIS\Default.gdb"
>>> if arcpy.Exists(ws):
...     arcpy.ListFeatureClasses()
... else:
...     print "Workspace not found"
...
[u'sea1_Buffer', u'amenity2_EliminatePolygonPar']

The path does not have to be unicode u"path" but you do have to be careful with path separators.

Re: cannot access geodatabase using windows command line

geogeekgeogeek — Fri, 29 Jun 2012 21:38:12 GMT

Hello Mr Kim,

i've tried to check if the workspace exists like you have mentioned , i debug the code in Arcmap python window, when i'm sure that the code works , then i try it in windows console , but it gimme always an empty array :(.

Re: cannot access geodatabase using windows command line

KimOllivier — Sun, 12 Dec 2021 04:46:04 GMT

Debug it in the console as well. Use Pythonwin because it is easier to check the syntax is correct and debug. Check if it exists again there. If the path contains backslashes then they have to be handled as escape characters in a string. Use forward slashes instead, or a raw tag r"C:\path" or two backslashes "c:\\path".

Put the script in a python file and execute that.
You must have a really simple error that is so obvious that you cannot see it.
Maybe the path is to an empty geodatabase because you are looking at different users.
Browse to it using ArcCatalog and look there to see if there is anything there.

The path on my machine to the default.gdb is

r"C:\Users\kimo\My Documents\ArcGIS\Default.gdb"

Re: cannot access geodatabase using windows command line

geogeekgeogeek — Tue, 10 Jul 2012 14:31:04 GMT

Thanks Mr Kim

i've applied your recommendations but without a result.

Thanks a lot

Re: cannot access geodatabase using windows command line

RichardDaniels — Thu, 30 Jul 2015 21:42:23 GMT

trying changing it to

'C:/Users/kimo/Documents/ArcGIS/Default.gdb'