Latest Contributions by JohnLay

I've written a long script that selects a bunch of different feature classes and exports them to a file geodatabase by an attribute. Then I export those feature classes to shapefiles. Next, I zip the geodatabase into its own file and all the shapes into their own file. Finally, I delete the geodatabase and shapes so that all I'm left with is the 2 zip files (We do this for a FEMA product) in the output folder. No problems. Recently I learned that I needed to include several tables in the database as well, so I inserted some code that searches one table for an attribute and writes the output to a list. Then I use that list to query ANOTHER table to create a table in the database. The problem is, now with this new bit of code, the geodatabase will not delete and I receive ExecuteError: ERROR 000601: Cannot delete C:\~Working\FRIS\Test2\Alamance\NCFlood_Prelim_Alamance_GDB.gdb. May be locked by another application. Failed to execute (Delete). New bit of code: # L_COMM_INFO CIDList = [] S_POL_AR = os.path.join(FRIS_FGDB, "S_POL_AR") S_POL_ARTable = arcpy.SearchCursor(S_POL_AR) for ID in S_POL_ARTable:     FIELD = "CID"     Val = ID.getValue(FIELD)     CIDList.append(Val) NewCIDList = list(set(CIDList)) L_COMMUNITY_INFO = "Database Connections\NC_FLOOD.sde\NC_FLOOD.DBO.L_COMMUNITY_INFO" L_COMMUNITY_INFOView = os.path.join(FRIS_FGDB, "L_COMM_INFOView") L_COMMUNITY_INFOTable = os.path.join(FRIS_FGDB, "L_COMM_INFO") arcpy.TableToTable_conversion (L_COMMUNITY_INFO, FRIS_FGDB, "L_COMM_INFO") arcpy.TruncateTable_management (L_COMMUNITY_INFOTable) arcpy.MakeTableView_management (L_COMMUNITY_INFO, L_COMMUNITY_INFOView) for ITEM in NewCIDList:     CLAUSE = ("{0} = '{1}'".format ("CID", ITEM))     arcpy.SelectLayerByAttribute_management (L_COMMUNITY_INFOView, "NEW_SELECTION", CLAUSE)     arcpy.Append_management (L_COMMUNITY_INFOView, L_COMMUNITY_INFOTable) arcpy.Delete_management (L_COMMUNITY_INFOView, "") del L_COMMUNITY_INFOTable The delete code looks like this: # Delete Files Delete_Shapes = [] for shapefile in os.listdir(OUTPATH):     if fnmatch.fnmatch(shapefile, '*.shp'):         Delete_Shapes.append(shapefile)     elif fnmatch.fnmatch(shapefile, '*.gdb'):         Delete_Shapes.append(shapefile)     else:         pass del shapefile for shapefile in Delete_Shapes:     get_file = os.path.join(OUTPATH, shapefile)     arcpy.AddMessage("Deleting " + shapefile)     arcpy.Delete_management(get_file) The error occurs every time with the new code and never without. When I use Unlocker.exe to unlock and delete the folder so that I can start all over again, I am told that RuntimeLocalServer.exe is the process locking the database. What is wrong with the new bit of code that causes the RuntimeLocalServer lock? And how do I fix it? ... View more

Having a weird problem running a TableToTable conversion using a python script. The script has worked without issue for months. This morning I continue to get a 000732 : <value>: Dataset <value> does not exist or is not supported error. I have tried recreating the excel spread sheet, moving it to a different location, rewriting the script, exporting the code from model builder, etc. If I try to run the process from ToolBox I get the same error. The weird thing is if I run the same process on the same xlsx in model builder, I have no problem. Suggestions? OUTFILE = arcpy.GetParameterAsText(0) NCFMPFolder = arcpy.GetParameterAsText(1) DATE = str(datetime.date.today()) Sheet1 = os.path.join(NCFMPFolder,"DeliveryTracking.xlsx\Sheet1$") DeliveryTrackinggdb = os.path.join(NCFMPFolder,"DeliveryTracking.gdb") # Process: Table to Table arcpy.TableToTable_conversion(Sheet1, DeliveryTrackinggdb, "Tracking", "", "DO \"DO\" true true false 8 Double 6 15 ,First,#,Sheet1,DO,-1,-1;TASK \"TASK\" true true false 255 Text 0 0 ,First,#,Sheet1,TASK,-1,-1;SUB_TASK \"SUB_TASK\" true true false 255 Text 0 0 ,First,#,Sheet1,SUB_TASK,-1,-1;CONT \"CONT\" true true false 255 Text 0 0 ,First,#,Sheet1,CONT,-1,-1;COUNTY \"COUNTY\" true true false 255 Text 0 0 ,First,#,Sheet1,COUNTY,-1,-1;APPRVD \"APPRVD\" true true false 8 Date 0 0 ,First,#,Sheet1,APPRVD,-1,-1;STATUS \"STATUS\" true true false 255 Text 0 0 ,First,#,Sheet1,STATUS,-1,-1", "") ... View more