Latest Contributions by DevinUnderwood2

Thank you for taking the time to further explain.  Will this work in a script that I am using with a tool I created? To automatically display message to results?  I tested out the function but it is not automatic when run and seen in python shell. However, as mentioned, my actual goal is to use it as a tool. I will take a look at the Blog, thanks. ... View more

Thank you for the input. However I am not familiar enough with the time module nor what the % means. I am not aware of .format either. As you can see I am beginner and I am just learning and attempting to properly use the Add Message, which I am still working on. ... View more

Yes equivalent of a print statement within arcmap. I just want to view results. I will take a look about AddMessage, thank you. ... View more

I broke the code apart into 2 separate parts. Part 1) Looped the mxds and successfully printed the feature classes Part 2) Using Search Cursor works fine on a shapefile but not a feature class. The problem is accessing a feature class in an sde environment is what I conclude. It cannot open the feature class. I will keep testing why is this the case, I may need to recheck how I set path using sde feature classes and their connection, may need special set up . ... View more

I would see the "print out" (results) in the python shell which would be written to the csv file also. ... View more

Thank you for the advice. I went ahead and changed according to your code, yet still get the same code error. I would not want the layer names, but rather the feature class name. I want the fullpath which has the mxd name. Ultimately, the print out would have the mxd name and feature class name. There are subfolders and group layers. ... View more

Yes, that is exactly what I am trying to do. It seems like I am trying something that is difficult or not possible  to do. At least I know it isn't just me being a beginner. ... View more

Does this mean I need to restructure the loop syntax of the mxds to connection files first then mxd path ? ... View more

I changed it to just read the lyr_source yet still same error. ... View more

I want both so I get the mxd name and feature class path fullpath  is C:\Users\dunderwood\Documents\MY_TEMPLATES\CityWorks\CW_ENV_FMSE_EDIT.mxd lyr_source is    Database Connections\CW_ENV_uCW_ENV_vCW_ENV.sde\PW.EnvironmentalCompliance\PW.ServiceEstablishments I am not sure SDE vs regular file path. ... View more

# Import Modules import arcpy,os,csv #Set folder space folder = r'C:\MY_TEMPLATES\CW' #Loop All Mxd's in a folder and print out Info. for filename in os.listdir(folder):     fullpath = os.path.join(folder, filename)     if os.path.isfile(fullpath):         basename, extension = os.path.splitext(fullpath)         if extension.lower() == ".mxd":             mxd = arcpy.mapping.MapDocument(fullpath)             dfs = arcpy.mapping.ListDataFrames(mxd)             for df in dfs:                 layers = arcpy.mapping.ListLayers(mxd, "", df)                 for layer in layers:                     if layer.isFeatureLayer:                         lyr_source = layer.dataSource                         lyr_name = layer.name.encode("utf8", "replace")                         s = (fullpath + lyr_source)                         print s                         with open('TEST.csv', 'w') as csvfile:                              csvwriter = csv.writer(csvfile, delimiter=',', lineterminator='\n')                              fields = ['*']                              with arcpy.da.SearchCursor(s, fields) as s_cursor:                                  for row in s_cursor:                                      csvwriter.writerow(row)                                       #Close Excel File csvfile.close() print "Closed or Not: ",csvfile.closed Run Script:  (I get the following which I want looped to write to csv, but the cursor currently retrieves fields) C:\MY_TEMPLATES\CW\CW_ENV_FMSE_EDIT.mxdDatabase Connections\CW_ENV_uCW_ENV_vCW_ENV.sde\PW.EnvironmentalCompliance\PW.ServiceEstablishments Traceback (most recent call last):   File "C:\Users\dunderwood\Desktop\LoopMXDListLayers.py", line 30, in <module>     with arcpy.da.SearchCursor(s, fields) as s_cursor: RuntimeError: cannot open 'C:\MY_TEMPLATES\CW\CW_ENV_FMSE_EDIT.mxdDatabase Connections\CW_ENV_uCW_ENV_vCW_ENV.sde\PW.EnvironmentalCompliance\PW.ServiceEstablishments' ... View more

I have been looking at how to post code in geo net and building paths correctly. (Thanks Blake) I have only successfully formatted my original posting and still looking at building paths correctly. I always use the raw as a path r'C:\...' ... View more

Traceback (most recent call last): File "C:\Users\dunderwood\Desktop\LoopMXDListLayers.py", line 39, in <module> with arcpy.da.SearchCursor(s, fields) as s_cursor: RuntimeError: cannot open 'C:\... ... View more

I have the following and choose a random field name that is in one of the many feature classes I need returned. I still have the error. with open('TEST.csv', 'w') as csvfile:                              csvwriter = csv.writer(csvfile, delimiter=',', lineterminator='\n')                              fields = ['APN']                              with arcpy.da.SearchCursor(s, fields) as s_cursor:                                  for row in s_cursor:                                     csvwriter.writerow(fields) ... View more