nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Print a list of SDE datasources

RebeccaWatson

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

Find more posts tagged with

Accepted answers

markdenil

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

All comments

IanMurray

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.

markdenil

IanMurray

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.

RebeccaWatson

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

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.