topic Re: Arcpy.ListWorkspaces returns wrong results in ArcGIS Enterprise Questions

Arcpy.ListWorkspaces returns wrong results

AhmadSALEH1 — Sat, 11 Dec 2021 13:30:36 GMT

Hi,

I am trying to get a list of database connections stored in the folder, the script runs successfully but it gives wrong results!

For example, "inFolder=r'C:\1\test'" has only one database connection which is u'C:\\1\\test\\Urbab.sde', but when I run the script it displays it 9 times every time! I tried to run the script from the python window in the ArcMap and I also used PyScripter and both of them gives the same result.

import arcpy, sys, os

inFolder=r'C:\1\test'
outFolder=r'C:\1\test2'
print "Connecting to geodatabase"
arcpy.env.workspace=inFolder
arcpy.env.overwriteOutput=True

for DBConn in inFolder:
       x=arcpy.ListWorkspaces("*","SDE")
       print x
‍‍‍‍‍‍‍‍‍‍‍

What might be the issue here?

Thanks,

Ahmad

Re: Arcpy.ListWorkspaces returns wrong results

RebeccaStrauch__GISP — Wed, 22 Nov 2017 20:30:26 GMT

The reason it is displaying 9 times, it is most likely because your

for DBConn in inFolder

loops thru each character of the inFolder path.

That is, if you replace the print X with print DBConn you would get (this is why you are printing the same X 9 times)

C
:
\
1
\
t
e
s
t

So, you will want to populate "x" prior to the loop, then do something like

for DBConn in x:
print DBConn

Re: Arcpy.ListWorkspaces returns wrong results

AhmadSALEH1 — Sat, 11 Dec 2021 13:30:38 GMT

Thanks Rebecca, This was helpful.

Here below how the script looks now.

import arcpy, sys, os

inFolder=r'C:\1\test'
outFolder=r'C:\1\test2'
print "Connecting to geodatabase"
arcpy.env.workspace=inFolder
arcpy.env.overwriteOutput=True

Workspace=arcpy.ListWorkspaces("*","SDE")
for DBConn in Workspace:
       print DBConn‍‍‍‍‍‍‍‍‍‍‍