topic Re: Is there a way using Export XML Workspace Document to export every database connection from within a folder? in Python Questions

Is there a way using Export XML Workspace Document to export every database connection from within a folder?

MichaelRivera — Mon, 17 Nov 2014 15:01:06 GMT

Say I have 40 database connections in a folder, is there some way to just export every database that has a connection?

Instead of writing

in_data = "c:/data/StJohns.gdb" out_file = "c:/data/StJohns.xml" export_option = "SCHEMA_ONLY" storage_type = "BINARY" export_metadata = "METADATA" # Execute ExportXMLWorkspaceDocument arcpy.ExportXMLWorkspaceDocument_management(in_data, out_file, export_option, storage_type, export_metadata)

40 times?

Re: Is there a way using Export XML Workspace Document to export every database connection from within a folder?

DuncanHornby — Mon, 17 Nov 2014 19:09:43 GMT

A simple model should suffice as shown below:

Use the Iterate Workspace to return File GeoDatabases and tick on recursive if you want drill down into the sub-folders. You would then use inline substitution to ensure a unique file name for the Output file.

If you want to do this in just python then look at this function here.

Re: Is there a way using Export XML Workspace Document to export every database connection from within a folder?

MichaelRivera — Mon, 17 Nov 2014 20:39:11 GMT

I'd like to do it with Python. The Python function you listed is shown working for arcpy.Compact_management which would get the its "in_workspace" from

workspaces = arcpy.ListWorkspaces("*", "FileGDB")

but arcpy.ExportXMLWorkspaceDocument_management requires a "out_file" variable, so how would that work with workspaces = arcpy.ListWorkspaces("*", "FileGDB")?

Re: Is there a way using Export XML Workspace Document to export every database connection from within a folder?

Anonymous User — Tue, 18 Nov 2014 01:01:37 GMT

Hi Michael,

Try this:

import arcpy, os

arcpy.env.workspace = r"<path>"

workspaces = arcpy.ListWorkspaces("*", "FileGDB")

for workspace in workspaces:

print workspace

n,t = os.path.basename(workspace).split(".")

xml = arcpy.env.workspace + os.sep + "{0}.xml"

arcpy.ExportXMLWorkspaceDocument_management(workspace, xml.format(n))

Re: Is there a way using Export XML Workspace Document to export every database connection from within a folder?

MichaelRivera — Fri, 21 Nov 2014 13:38:58 GMT

Is my path formatting incorrect?

I've tried

arcpy.env.workspace = r"D:/Valor/"

and the script bales pretty quick, don't even see a error message.

Re: Is there a way using Export XML Workspace Document to export every database connection from within a folder?

Zeke — Fri, 21 Nov 2014 13:58:30 GMT

If you use r before the string, use the regular Windows backslash in your path - \. Using a forward slash is for when you don't use r. Using it the way you have above, python interprets the forward slash as just that, a forward slash, which does not work on Windows.

Re: Is there a way using Export XML Workspace Document to export every database connection from within a folder?

MichaelRivera — Tue, 25 Nov 2014 18:41:56 GMT

Windows 7 machine.

I've tried

arcpy.env.workspace = r"D:\Valor\"
and arcpy.env.workspace = r"D:/Valor/"
and arcpy.env.workspace = "D:/Valor/"

None of them work. The black box opens up quickly with no error message before closing. Nothing happens

Re: Is there a way using Export XML Workspace Document to export every database connection from within a folder?

Zeke — Tue, 25 Nov 2014 21:08:00 GMT

Instead of setting the workspace, try just putting the path there. In another thread. Richard Fairhurst stated that setting the env environment settings in a stand-alone script didn't actually do anything.

Re: Is there a way using Export XML Workspace Document to export every database connection from within a folder?

Anonymous User — Tue, 25 Nov 2014 21:42:28 GMT

Where are you attempting to run the script? In an IDE like IDLE or PyScripter? Or directly in the python window in ArcMap?

If you want to run the script in the Command Prompt you will have to change directories to the location of the script and call it:

I would recommend running the script in an IDE...I like PyScripter but some people like IDLE or PythonWin.

Re: Is there a way using Export XML Workspace Document to export every database connection from within a folder?

MichaelRivera — Fri, 28 Nov 2014 21:26:58 GMT

Running the script by just double-clicking on it from its Windows folder.

Re: Is there a way using Export XML Workspace Document to export every database connection from within a folder?

MichaelRivera — Tue, 02 Dec 2014 19:59:12 GMT

Where do you get pythonwin? It used to be included on the ArcGIS install CD but hasn't been for awhile. I can't find where to download it.

Re: Is there a way using Export XML Workspace Document to export every database connection from within a folder?

Anonymous User — Tue, 02 Dec 2014 20:06:50 GMT

Here is a link to PyScripter

pyscripter - An open-source Python Integrated Development Environment (IDE) - Google Project Hosting