Latest Contributions by BlakeTerhune

Okay, maybe something like this then. if parameters[0].value: if not parameters[0].hasBeenValidated: param0_default, param1_default = default[parameters[0].valueAsText] parameters[1].value = param0_default parameters[2].value = param1_default else: parameters[1].value = None parameters[2].value = None Using the hasBeenValidated property will tell you if it was just changed. So with this, if the category was just changed, set the default measured values. After that, if the user changes the default measured values, they should be left alone. The measured values would only get changed if the user changed the category again. ... View more

Please fix the indentation in this code. ... View more

I might be missing something, but can't you use Append()? If you need to modify values, just run calculate field (or UpdateCursor) after you append the data. ... View more

Reading the documentation, it says: Once a parameter has been altered, it remains altered until the user empties (removes) the value in which case it returns to an unaltered state. Programmatically changing a value with validation code will change the altered state. That is, if you set a value for a parameter, the altered state of the parameter will be updated. So when you set the value of the parameter in getParameterInfo(), I think it's coming through as altered in updateParameters(). Try removing the lines where you set the value of param0 and param1. You can also use the hasBeenValidated property to determine if it was changed. Maybe to simplify this, try checking if there is a value and, if not, set the default. if parameters[0].value: if not parameters[1].value: parameters[1].value = default[parameters[0].valueAsText][0] if not parameters[2].value: parameters[2].value = default[parameters[0].valueAsText][1] else: parameters[1].value = None parameters[2].value = None ... View more

I had to log into the machine as the user running the script, launch ArcGIS Pro, and set the licensing. There's also a way to modify the registry so all users have the same licensing config, but I haven't tried that yet. How To: Lock Licensing Options in ArcGIS Pro (esri.com) ... View more

@PabloParra wrote: why is it necessary to change the variable name? The idea is to avoid reserved keywords the language uses for normal interpretation of the code. Although I don't see "long" as being one of them, it certainly sounds like a keyword so it's better to avoid it. As for the error, "'NoneType' object has no atribute for arcpy.PointGeometry" is saying that somewhere you're calling arcpy.PointGeometry with a variable that has a value of None (null). Look at the line it errors and inspect the variables you're using. I suspect one of them is null. ... View more

This is untested, but you get the idea. tables_found = [] for wildcard_name in ["*TBL_BMP_*", "*SDE_BMP_Component*", "*SDE_BMP_Inventory*"]: tables_found += arcpy.ListTables(wildcard_name) ... View more

Does it work if you define POAexpression and POAcode as String? ... View more

I think you would first create a Python Toolbox or Script Tool with your script, then host it as a geoprocessing service. Once hosted, you can use it in your web app. I see there is also a Web Tool in Portal that might be an option outside of a web app. ... View more

I noticed that if the connection properties are slightly different, it thinks it's a new source. Double check that the connection properties in the two sde connections are identical. In my case, with an sde connection to Oracle, one of the connections had .world at the end of the db instance name and the other did not. ... View more

I don't see why it wouldn't work. Seems easy enough to test as-is though. Can you clarify what you're having trouble with? ... View more

If you change your input to be from a geodatabase on disk rather than in memory workspace, does that work? ... View more

Maybe try getting the parameter object instead of the text in case describe() isn't complete with just the text. Also make sure that the layer you are inputting is correct (is in an enterprise geodatabase). ... View more

Oh, glad you got it working! As another suggestion, consider handling your exceptions a more specific, targeted manner. With your snippet, you will never know if there was some other problem with updateConnectionProperties() because you're printing a generic message for all exceptions. You need to know if something unexpected is happening, which your error handling will not show. I've started doing this as a pattern to add more information/context to errors. import arcpy aprx = arcpy.mp.ArcGISProject("CURRENT") for m in aprx.listMaps("Mobile_Map"): for lyr in m.listLayers(): if lyr.supports("connectionProperties"): try: print(lyr.connectionProperties["connection_info"]) lyr_update = lyr.connectionProperties lyr_update['connection_info']['password']='<password>' lyr_update['connection_info']['user']='dr' lyr.updateConnectionProperties(lyr.connectionProperties, lyr_update) except Exception as e: raise Exception("Not an sde database or the database connection does not need to be updated.") from e aprx.save() del aprx If you really want to pass on some specific error, you can handle that specifically. In this example, all arcpy errors will get passed and the code will continue running, but it will stop if the exception is not from arcpy (unhandled). except arcpy.ExecuteError as arcpy_e: print(arcpy_e) print("Not an sde database or the database connection does not need to be updated.") pass ... View more