topic Re: Print a list of SDE datasources in Python Questions

Print a list of SDE datasources

RebeccaWatson — Wed, 02 Jul 2014 14:49:41 GMT

Hi,
I am trying to print out a list of SDE datasources used by some MXDs in a folder. I can successfully print out a list of all the datasources, but I am having no luck separating out the sde connections. I have tried the following and a few other variations on the theme but I can't get anything to print out:

for lyr in arcpy.mapping.ListLayers(mxd):      if lyr.supports("WORKSPACEPATH"):           wsp = lyr.workspacePath           if wsp == ("*.sde"):                print lyr.dataSource

It seems like this should be pretty straight forward but I'm having no luck.
Can anyone point me in the right direction?
Thanks

Re: Print a list of SDE datasources

IanMurray — Wed, 02 Jul 2014 15:04:12 GMT

It may or may not be this simply but

if lyr.supports("WORKSPACEPATH"):

might need to be

if lyr.supports("WORKSPACEPATH") == True:

since the support method returns a Boolean data type. Currently you are not actually checking it against anything for the if statement.

Re: Print a list of SDE datasources

markdenil — Wed, 02 Jul 2014 17:26:22 GMT

I would suggest that
if wsp == ("*.sde"):
is not a useful test.

perhaps
if wsp.endswith('.sde'):
would serve better

It is, by the way, perfectly fine to test a boolean baldly, as in:
if True: do something

Re: Print a list of SDE datasources

IanMurray — Wed, 02 Jul 2014 18:23:29 GMT

Thanks for the python nugget Mark, I thought that my suggestion was a bit too simple, but it was the only thing that struck me when i looked at it.

Re: Print a list of SDE datasources

RebeccaWatson — Thu, 03 Jul 2014 07:09:48 GMT

Thanks Mark that's done the trick, they are listing perfectly now.