Latest Contributions by DonMorrison1

I'm getting an error *** AttributeError: 'list' object has no attribute 'to_dict' when I call  arcgis.features.managers. AttachmentManager.download.  I'm quite sure I have a valid attach manager object because I can list the attachments and add new attachments with no problem. I've tried all the combinations of input parameters I can think of with the same results, but no parameters as shown below should be valid. import arcgis.features tb_url = 'https://utility.arcgis.com/usrsvcs/servers/af1446382d3f441f859c305d15601085/rest/services/ROW_testing/UIC/FeatureServer/6' tb = arcgis.features.Table(tb_url, gis=None) att_mgr = tb.attachments att_mgr.download() ... View more

I'm trying to do something that looks pretty simple, but isn't working for me.  The code below is running a python tool then calling the API to package the tool.  The tool runs great and I get the result object as expected/ But the package request fails with this error:  *** arcgisscripting.ExecuteError: Failed to execute. Parameters are not valid. ERROR 000800: The value is not a member of _PYTHON__RESULT__{44960780-1946-4AF7-B9FD-8AAD7585504E} | _PYTHON__RESULT__{61DCE3A6-3E2E-4AE6-8E7F-DEC9042BC235}. ERROR 000840: The value is not a File. Failed to execute (PackageResult). I've tried everything I can think of to isolate the cause - but no luck. Here is the code  import arcpy import os arcpy.ImportToolbox(os.path.normpath('row_toolbox/SharedTools.pyt')) results = arcpy.sharedtools.ImportGeodatabase( 'UIC', os.path.normpath('E:/ROW_as_habitat/temp/ROWHWG_Database.gdb'), 'https://utility.arcgis.com/usrsvcs/servers/af1446382d3f441f859c305d15601085/rest/services/ROW_testing/UIC/FeatureServer', True) out_file = os.path.normpath('E:/ROW_as_habitat/temp/importgdb.gpkx') arcpy.PackageResult_management(results, out_file, convert_data='PRESERVE') ... View more

I have a python tool that we are moving from ArcMap to ArcPro.  The tool accesses our enterprise database. In my python code I can reference the database using a string like 'Database Connections\\ROW Habitat (SDE).sde\\ROW_Habitat.SDE.Site'. When I do the publish ArcGIS is smart enough to figure out where the database really resides on the server (which I don't have access to) This doesn't work on ArcPro. There appears to be no equivalent to "Database Connections".   I suspect that if I hard-code the absolute path to the sde file on my client, that the publish step would see that string and copy the sde file up to the server and figure it out from there. But we have a scheme where the absolute path is fed in from a properties file. This allows us to deploy the tool into multiple environments controlled by a local properties file.  Any suggestions on how to get this type of publish to work on ArcPro? ... View more

Based on forum activity, it looks like this is a very common error with many causes and essentially no clues logged as to what really caused it. By trial and error I was able to find the cause. This is the culprit: arcpy.env.workspace = arcpy.env.scratchWorkspace Once I removed it (it wasn't really needed as it turns out) the publish worked.  It sure seems like ESRI could do a better job logging exactly what triggers errors like this. I spend untold hours trying to comply with the directions in the help page (none of which helped) and crawling through forums and documentation looking for a clue. The good news is that the fix was easy... ... View more

I have an SQL Server view that at I want to include in my ArcGIS server's REST endpoint as a table. I'm able to do it manually using ArcMap - it appears to create a query table when I drag the view onto the table of contents. How can I do this in python? Currently I go through this sequence Start with a blank mxd file: mxd_template_obj = arcpy.mapping.MapDocument(blank_template_fn) Get the dataframe: df = ListDataFrames(mxd_template_obj)[0] Create the query table (according to the documentation is creates a TableView): arcpy.MakeQueryTable_management(db_view, table_view_name, ....) Convert it to a TableView object: table_view = arcpy.mapping.TableView(table_view_name) Add it to the map: arcpy.mapping.AddTableView(df, table_view) Save the map: mxd_template_obj.saveACopy(<mxd_file_name>) It appears to generate a good mxd file - I can go into ArcMap and everything looks correct, but when I try to stage it for publishing I get this error: ExecuteError: ERROR 001272: Analyzer errors were encountered (codes = 33, 33) Standalone table's data source is not supported I suspect that my step 4 is wrong - once I have the query table I need to do something else to get it into the map correctly but I'm not sure what that is.  ... View more

I have a feature class (SQL Server table) that contains data from multiple clients (organizations). I want to expose the data, but control access so an org can only view/update its own data. I've created a flow as shown below (this is done for each org) Create a layer file (.lyrx) with a query definition against the single table to pull out the org's data (the table has a key field - ORG_ID) Create a project (.aprx) based on the layer file and publish a REST endpoint on my ArcGIS server Create a feature service in ArcGIS Online based on the REST endpoint Share the feature service into an AGOL group where I have invited only members of the organization From that feature service I build web maps, web mapping apps, surveys etc and share them into the group also This all works very nicely and I've scripted it so it is easy to onboard new orgs. But I have one problem I can't solve.  I need to make sure that the ORG_ID is not altered for existing records (I think I can accomplish this by hiding the field in the layer definition) and I need to make sure that the ORG_ID is correct on added records. I've looked into SOE's and DB triggers. The trouble there is there isn't enough context to know what the value is supposed to be. I tried many other approaches but nothing has worked completely.   Any suggestions?  ... View more