Latest Contributions by BenjaminSimpson

Hi all, I have a load of VB.NET code that is currently utilized in ArcDesktop. The code does a range of jobs, including the use of ArcObjects. My company is contemplating transferring this code from ArcDesktop to ArcPro. I have been tasked with working out whether or not the functionality that the code currently uses from ArcObjects can be re-created in ArcPro. I am confident that, for the most part, this will be achievable. Part of what the VB code currently uses ArcObjects for is visualization and creating graphs. Would anyone be able to clarify that it is possible to re-create the core/majority of ArcObjects functionality in ArcPro and/or any functionality that is not supported can be created with some sort of VB or Python addin? I am particularly interested in any thoughts as to why transferring the VB code to ArcPro would be a bad idea over leaving it in ArcDesktop. Thanks in advance for any advice. Ben ... View more

Hi, I have a python addin which is running a custom toolbox. Part of the python script linked to the toolbox is suppose to use the arcpy.MakeXYEventLayer_management tool to create a point feature class from a table in my personal geodatabase. The problem I am having is that it keeps coming up with the error saying that the dataset does not exist or is not supported (below). When I do the same process manually it works fine and the MakeXYEventLayer tool creates the point feature class. I am not sure why it is unable to detect the database table. ERROR 000732: XY Table: Dataset D:\SAGIS Conversion\SAGIS Models Test\Model_2_Wick River_T1 - Copy (17)\SAGIS_Wick_River_2.mdb\SimWaterBodiesT1 does not exist or is not supported Failed to execute (MakeXYEventLayer). Here is a snippet of my code: import arcpy import os import sys SAGIS_model_new = [arcpy.GetParameterAsText(0)] model_pos = 0 for model in SAGIS_model_new:      featureList = arcpy.ListFeatureClasses()      if "SimWaterBodiesCent" in featureList:           arcpy.AddMessage("SimWaterBodiesCent feature class already exists within " + Model_Name)      else:           SimWaterBodies = os.path.join(SAGIS_model_new[model_pos], "SimWaterBodies")           SimWaterBodiesT1 = os.path.join(SAGIS_model_new[model_pos], "SimWaterBodiesT1")           x_coords = "CentroidX"           y_coords = "CentroidY"           out_Layer = "SimWaterBodiesCent"           spatial_reference = arcpy.Describe(SimWaterBodies).spatialReference           arcpy.MakeXYEventLayer_management(SimWaterBodiesT1, x_coords, y_coords, out_Layer, spatial_reference, "")           arcpy.FeatureClassToFeatureClass_conversion(out_Layer, simcat, "SimWaterBodiesCent")           model_pos = model_pos +1 Can someone help me work out why this error message is persisting: Thanks in advance for any help. Ben. ... View more

Hi, In my python script I have some code which, using a SQL statement copies a table from one Access database to another. In the original database there are several fields which are Yes/No fields. The problem I am having is that when I copy over the table to the new database these fields revert to Access's default boolean code (-1/0). I know how to manually change the fields format in Access but I am struggling to work out how to do it from my python script. I need to get these fields back to displaying Yes/No. I copy the table across using the """SELECT * INTO (table name) IN (new database) FROM (table name) IN (original database)""". I have tried using the FORMAT(table name,'Yes/No') clause in SELECT statements, ALTER TABLE statements and UPDATE statements but with no luck. At this point I am not too sure what I am suppose to do. It is most likely that I am doing something very obvious wrong but I am clueless as to what it is. Thanks in advance for any help, Ben. This is a snippet of my current script: import os import sys import arcpy import pyodbc common_db_new = [arcpy.GetParameterAsText(0)] direc = os.path.dirname(__file__) Broom_db = direc + "\\River_Broom_126.mdb" Broom_common = direc + "\\River_Broom_126_CommonTables2k.mdb" Broom_conn = pyodbc.connect('DRIVER={Microsoft Access Driver (*.mdb)};DBQ='+Broom_common) Broom_cursor = Broom_conn.cursor() common_conn = pyodbc.connect('DRIVER={Microsoft Access Driver (*.mdb)};DBQ='+common_db_new[0]) common_cursor = common_conn.cursor() SQL = """SELECT * INTO DeterminandsForSimcat IN '{0}' FROM DeterminandsForSimcat IN '{1}'""".format(common_db_new[0], Broom_common) common_cursor.execute(SQL) common_cursor.commit() SQL = """SELECT Include FORMAT(Include,'Yes/No') FROM DeterminandsForSimcat""" common_cursor.execute(SQL) common_cursor.commit() common_cursor.close() common_conn.close() Broom_cursor.close() Broom_conn.close() ... View more

Hi, I am trying to build a python toolbox which is called from a python addin toolbar button in ArcMap. At the moment I am just trying to test the python toolbox to get it to work from the toolbar button. The problem I am currently having is that everytime I press the toolbar button ArcMap closed down/crashes with nothing else, such as an error message appearing.Below I have the code that I am currently using. Toolbar Script: import arcpy import pythonaddins import os import sys class AppendModelsOracle(object):     """Implementation for Append_Models_Oracle.button (Button)"""     def __init__(self):         self.enabled = True         self.checked = False     def onClick(self):         # Toolbox name         toolboxName = "Toolbox"         # Name of tool to be executed         toolName = "Tool"         # Create string with path to toolbox         relPath = os.path.dirname(__file__)         pyt = relPath + os.sep + toolboxName + ".pyt"         # Call geoprocessing tool         pythonaddins.GPToolDialog(pyt, toolName)         pass Python Toolbox Script: import arcpy import pythonaddins import os import sys class Toolbox(object): def __init__(self):   """Define the toolbox (the name of the toolbox is the name of the   .pyt file)."""   self.label = "Toolbox"   self.alias = ""   # List of tool classes associated with this toolbox   self.tools = [Tool] class Tool(object): def __init__(self):   """Define the tool (tool name is the name of the class)."""   self.label = "Tool"   self.description = ""   self.canRunInBackground = False def getParameterInfo(self):   """Define parameter definitions"""   model_list = arcpy.Parameter(    displayName="Input GDB",    name="in_gdb",    datatype="DEWorkspace",    parameterType="Required",    direction="Input",    multiValue="Yes")      model_list.filter.type = "Workspace"   model_list.filter.list = ["Local Database"]     return [model_list] 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."""   model_list_len = len(model_list)   model_list_pos = 0   model_count = 1   for model in model_list:    msg1 = ("\nFirst model in list of selected models is: {0}".format(os.path.basename(model)))    msg2 = ("\n{0} out of {1} models identified.".format(model_list_pos, model_list_len))    arcpy.AddMessage(msg1 + msg2)    model_list_pos = model_list_pos + 1    arcpy.AddMessage(model_list_pos)    model_count = model_count + 1    arcpy.AddMessage(os.path.basename(model))   arcpy.AddMessage("\nAll models identified." + "\nTest Successful.")   pythonaddins.MessageBox("Bloody well work.","Test box 2",0)   return Can anyone see a reason why my toolbar and/or toolbox would be causing ArcMap to shut down? Thanks in advance for any help, Ben. ... View more