Latest Contributions by LanceCole

Try this to see if works from a new map.  Took a few guesses as to what you need in a couple of places.  Code is not tested as I am traveling at the moment.  Code can also be substantially reduced but did not want to re-write your code entirely.  Assume you have more planed as you created fields but did not do anything with them. You really do not need to add the table and feature class to the Map but I left it as you had it.  You can do all the data manipulation in the GDB or even in memory only saving the final product.  Once the script runs, look at the default database for the project to see the location of the table and feature class. import arcpy, os class Toolbox(object): def __init__(self): """Define the toolbox (the name of the toolbox is the name of the .pyt file).""" self.label = 'actionPuree' self.alias = 'actionPureeToolBox' # List of tool classes associated with this toolbox self.tools = [grindMixPuree] class grindMixPuree(object): def __init__(self): """Define the tool (tool name is the name of the class).""" self.label = 'grindMixPuree' self.description = 'Slices, dices, juliannes ' + \ 'purees during the matinee ' + \ 'and ready to serve' self.canRunInBackground = False def getParameterInfo(self): """Define parameter definitions""" parameters = [] # Reference States layer baseStatesLayer = arcpy.Parameter( displayName="Base States Layer", name="baseStatesLayer", # You will need "DEShapefile" here as your input is a shapefile, datatype="DEShapefile", parameterType="Required", direction="Input") parameters.append(baseStatesLayer) # Data dump CSV file inputDataDumpFile = arcpy.Parameter( displayName="Data Dump File", name="inputDataDumpFile", # You will need "DEFile" here as a CSV is a file, datatype="DEFile", parameterType="Required", direction="Input") parameters.append(inputDataDumpFile) return parameters def isLicensed(self): """Set whether tool is licensed to execute.""" return True def updateParameters(self, parameters): """Modify the values and properties of parameters before internal validation is performed. This method is called whenever a parameter has been changed.""" return def updateMessages(self, parameters): """Modify the messages created by internal validation for each tool parameter. This method is called after internal validation.""" return def execute(self, parameters, messages): """The source code of the tool.""" # Get and set current project and geodatabase info arcpy.env.overwriteOutput = True aprx = arcpy.mp.ArcGISProject('CURRENT') defaultGeoDb = arcpy.env.workspace aprx.defaultGeodatabase = defaultGeoDb currentMap = aprx.activeMap #Create target names based on name of input table (assuming you want the CSV filename) tempStr = os.path.splitext(os.path.basename(parameters[1].valueAsText))[0] newMapName= 'lyr_' + tempStr newTableName = 'tbl_' + tempStr # convert CSV data into table and add to default database - look in database to see it was added arcpy.TableToTable_conversion(parameters[1].valueAsText,defaultGeoDb,newTableName) # Add fields to the new table arcpy.AddField_management(newTableName,'Calc01Perc','DOUBLE') arcpy.AddField_management(newTableName,'Calc02','DOUBLE') # Add table to current Map - not really needed. Use full path name to table in GDB currentMap.addDataFromPath(os.path.join(defaultGeoDb, newTableName)) #Join table with shapefile newJoinLayer = arcpy.management.AddJoin(parameters[0].valueAsText, 'STUSPS', newTableName, 'Abbr', 'KEEP_ALL') # Copy the shaperfile with join to a new permanent feature class in GDB - join will not be needed after arcpy.CopyFeatures_management(newJoinLayer, newMapName) # Add new feature class to Map - full path need to FC in database currentMap.addDataFromPath(os.path.join(defaultGeoDb, newMapName)) return ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

I typically use the following for crawling through unknown database feature datasets and feature classes: arcpy.env.workspace = gdbFrom for ds in arcpy.ListDatasets(feature_type='feature')    do what you need with each feature dataset    for fc in arcpy.ListFeatureClasses(feature_dataset=ds):       do what you need here for each feature class in a dataset To define a spacial reference for a dataset: cs = arcpy.SpatialReference(4326)   # for GCS_WGS_1984 as an example arcpy.DefineProjection_management(dataset, cs) If you are not modifying the data just applying a coodinate system and/or transformation to the dataset you could use Project—Help | ArcGIS for Desktop on each feature dataset setting your gbdFrom and gbdTo, in and out coordinate system and transformation if needed.  Do not forget about applying a transformation if need or your data may end up in the wrong part of the world. cs = arcpy.SpatialReference(4326)   # for GCS_WGS_1984 as an example arcpy.Project_management(gdbFrom/in_dataset, gbdTo/out_dataset, cs)   ListDatasets—Help | ArcGIS Desktop ListFeatureClasses—ArcPy Functions | ArcGIS Desktop  SpatialReference—Help | ArcGIS Desktop  Define Projection—Help | ArcGIS Desktop  Project—Help | ArcGIS for Desktop ... View more