topic Re: Python script to Compact geodatabases in multiple directories? in Python Questions

Python script to Compact geodatabases in multiple directories?

JasonDowdy — Sat, 11 Dec 2021 12:54:23 GMT

I am trying to write a python script to walk through all folders in my workspace and find and compact all geodatabases in my workspace. I am using the 10.2.2 release.

import acrpy, os 
from arcpy import env  

arcpy.env.workspace "C:"  

for (path, dirs, files) in os.walk(arcpy.env.workspace) 
    for file in files if ".gdb" in file:
        workspaces = arcpy.ListWorkspaces("*", "FileGDB") 
        for workspace in workspaces: 
            arcpy.Compact_management(workspace)

Re: Python script to Compact geodatabases in multiple directories?

JakeSkinner — Sat, 11 Dec 2021 12:54:25 GMT

Hi Jason,

You can use the arcpy.da.Walk function to walk through the directories and then compact each geodatabase. Here is an example:

import arcpy, os
workspace = r"C:\temp\python"
for dirpath, dirnames, filenames in arcpy.da.Walk(workspace, datatype="Container"):
    for dirname in dirnames:
        if ".gdb" in dirname:
            arcpy.Compact_management(os.path.join(dirpath, dirname))
            print "Successfully compacted " + dirname

Re: Python script to Compact geodatabases in multiple directories?

JasonDowdy — Thu, 08 Jan 2015 14:01:27 GMT

Works great, I did finally get the other method working but this is much better than what I was trying to do. Much appreciated!