How do I loop a folder of mxds

DevinUnderwood2

I want to loop many mxds within a folder to retrieve layer,connection,etc. information using python.

I just need the syntax for looping through the mxds.

RebeccaStrauch__GISP

This is part of my Python addin for data inventory and “broken-link” repair.​ tool box, but I'll include the first script here.  It inventories and lists the fgdb to out put csv, and it also coverts it to an .xsl  (not .xlsx).  Maybe you can pick out what you need from this.

EDIT: bTW replace all the myMsgs with print or arcpy add message .

'''
---------------------------------------------------------------------------
Tool:    FCInventoryReport 
Toolbox: CheckAndFixLinks.tbx
Script:  2_InventoryFCs.py
Purpose: 
   This script will walk thru all the feature classes within a folder 
   and create a text report, comma-delimted and an Excel .xls file.
   Include shapes, coverages, rasters, tables, connections, and FGDB

   Column names:  FType    FCname    FullPath
-------------------------------------------------------------------------------
 Author:  Rebecca Strauch - ADFG-DWC-GIS
 Created on: 4/10/2013 
   last modification: August 10, 2015

 Description: To create list of the features classes within a folder, including
   coverages (pts, poly, arc, anno), shapes, grids and FGDB data. Outputs list
   to a text report file (not much formatting) in the folder being scanned named
     FCInventoryYYYYMMDD_HHMM.txt
   with the date and time as part of the name. This should always create
   a new file, unless you run it twice within same minute.  

   Must have write permissions on the output folder in question.

   Known issue (with built-in workaround): for some reason some, but not  
     all (ArcInfo) grids want to duplicate the folder name before the 
     describe. I'm now checking to make sure it exists, if not, I am removing
     the duplicate portion, and letting it run.  Seems to work.
------------------------------------------------------------------------------
 Arguments:  
   [0] theWorkspace: Folder/directory to search (walk thru, includes subfolders)
   [1] outFile: output base filename, default GDBList, script appends YYYYMMDD_HHMM

 Updates:          
---------------------------------------------------------------------------
'''
# Import modules
import arcpy
import os
from _miscUtils import *
from _gpdecorators import *

# catch_errors decorator must preceed a function using the @ notation.
@catch_errors
def main():
  """
  Main function to create text file report of all Feature Classes in folder
  """
  #setup environment
  arcpy.env.overwriteOutput = True

  # Script arguments...    
  """ If running as standalone, hardcode theWorkspace and outFile  """
  theWorkspace = arcpy.GetParameterAsText(0)
  if not theWorkspace:
    theWorkspace = r"C:\__Data1\_TalkeetnaBU" # r"D:\_dataTest"    

  outFile = arcpy.GetParameterAsText(1)
  if not outFile:
    outFile = "FCInventory" 
  # Create new output name name tagged with YYYYMMDD_HHMM
  fileDateTime = curFileDateTime()
  currentDate = curDate()

  # Create new output name tagged with YYYYMMDD_HHMM
  outfileTXT = os.path.join(theWorkspace, outFile) + fileDateTime + ".txt" #theWorkspace + "\FCInventory" + fileDateTime + ".txt"
  outFileCSV = os.path.join(theWorkspace, outFile) + fileDateTime + ".csv"  #theWorkspace + "\FCInventory" + fileDateTime + ".csv"
  outFileXLS = os.path.join(theWorkspace, outFile) + fileDateTime + ".xls"
  arcpy.AddMessage(theWorkspace + ", " + outfileTXT)
  reportFile = open(outfileTXT, 'w')
  csvFile = open(outFileCSV, 'w')
  arcpy.AddMessage(  "File {0} is open? {1}".format(outfileTXT, str(not reportFile.closed)))
  arcpy.AddMessage(  "File {0} is open? {1}".format(str(outFileCSV), str(not csvFile.closed)))
  #arcpy.AddMessage(  "File " + str(csvFile) + " is closed?  " + str(csvFile.closed))     
  arcpy.AddMessage("Writing the report to: " + outfileTXT + " and " + outFileCSV)

  outText = "List of all GIS data in " + theWorkspace + " on " + currentDate + '\n'
  outText += "  Includes coverages (pts, poly, arc, anno), shapes, and FGDB data." + '\n'
  outText += "-----------------------------------------------------" + '\n'

  reportFile.write(outText)
  csvFile.write("FType, FCname, FullPath\n")

  def inventory_data(workspace, datatypes):
    for path, path_names, data_names in arcpy.da.Walk(
      workspace, datatype=datatypes):
      if "tic" in data_names:
        data_names.remove('tic')
      for data_name in data_names:
        fcName = os.path.join(path, data_name)
        #arcpy.AddMessage("Show for debug: " + fcName)
        if not arcpy.Exists(fcName):
          # workaround for raster folder name duplicating
          fcName = os.path.dirname(fcName)
        desc = arcpy.Describe(fcName)
        #arcpy.AddMessage("debug, desc it to me: " + desc.dataType)
        yield [path, data_name, desc.dataType] #, desc]

  i = 0
  for feature_class in inventory_data(theWorkspace, "FeatureClass"):
    """ last modified data not working for gdb or FC in fgdb ..."""
    #lastMod = time.strftime('%m/%d/%Y %H:%M', time.localtime(os.path.getmtime(feature_class[0])))
    if i == 0:
      #arcpy.AddMessage("{0}  modified: {1}".format(feature_class[0], lastMod)) 
      arcpy.AddMessage("{0}".format(feature_class[0]))
      outText = ' ' + feature_class[0] + '\n'
      reportFile.write(outText)
      path0 = feature_class[0]
      i =+ 1
    elif not path0 == feature_class[0]:
      #arcpy.AddMessage("{0}  modified: {1}".format(feature_class[0], lastMod)) 
      arcpy.AddMessage("{0}".format(feature_class[0]))
      outText = ' ' + feature_class[0] + '\n'
      reportFile.write(outText)
      i = 0
    if feature_class[2] == "ShapeFile":
      shpfile = arcpy.os.path.join(feature_class[0], feature_class[1])
      lastMod = time.strftime('%m/%d/%Y %H:%M', time.localtime(os.path.getmtime(shpfile)))
      arcpy.AddMessage("       {0}: {1} modified: {2}".format(feature_class[2], feature_class[1], lastMod))
      outText = ("       {0}: {1} modified: {2}\n".format(feature_class[2], feature_class[1], lastMod))
    else:
      arcpy.AddMessage("       {0}: {1}".format(feature_class[2], feature_class[1]))
      outText = ("       {0}: {1}\n".format(feature_class[2], feature_class[1]))
    reportFile.write(outText)
    csvFile.write("{},{}, {}\n".format(feature_class[2], feature_class[1], feature_class[0]))
    

  reportFile.close()
  csvFile.close()
  arcpy.AddMessage(  "File {0} is closed? {1}".format(outfileTXT, str(reportFile.closed)))
  arcpy.AddMessage(  "File {0} is closed? {1}".format(outFileCSV, str(csvFile.closed)))

  # Creates Excel .xls file from the .csv ....easier to edit (ver 1)
  arcpy.TableToExcel_conversion(outFileCSV, outFileXLS) 

  arcpy.AddMessage('!!! Success !!!  ')

# End main function

if __name__ == '__main__':
  main()