Latest Contributions by BlakeTerhune

So your taking data from the shapefile and writing it to Excel? Can it be a new Excel file or do you have to write it into the existing Excel file? ... View more

@BriamR wrote: @BlakeTerhune  The process that you propose to me in python sounds interesting, could you help me with the way or an example to be able to achieve it. Thank you Here's a snippet to change the file extension with Python. I would put that in a try/finally block to ensure it gets changed back to the correct file extension when the script exits. However, I'm still not completely clear on what exactly you're trying to do. Are you updating the fields of existing records in the shapefile or creating new records? If they are new records, what are you using for geometry (X,Y)? ... View more

I just tested changing the file extension from xlsm to xlsx and ArcMap was able to read the data. If you're comfortable, you could use Python to change the file extension, read the data, then change the file extension back when finished. ... View more

The documentation says Excel Workbooks (.xlsx) and Microsoft Excel 5.0/95 Workbook (.xls) formats are supported as input. A quick test with an .xlsm file seems to support this. ArcMap doesn't even show the .xlsm file to interact with. You'll have to save the Excel file as a supported format. ... View more

It seems that simply removing the apiKey and logging in manually allows the search widget to work normally. I'm not sure why this is happening. Hopefully someone else has an idea. EDIT: That apiKey is supposed to be private so I recommend redacting that. ... View more

Try Geometry toJSON() For a regular 2D polygon, you'll get something like this { "rings" : [[[-97.06138,32.837],[-97.06133,32.836],[-97.06124,32.834],[-97.06127,32.832], [-97.06138,32.837]],[[-97.06326,32.759],[-97.06298,32.755],[-97.06153,32.749], [-97.06326,32.759]]], "spatialReference" : {"wkid" : 4326} }   ... View more

Looks like that error is referring to a field you have listed as APLIC that maybe doesn't exist in one of the feature classes. ... View more

SetLogMetadata is a big one for us. We have many scripts running as scheduled tasks doing maintenance work every night. The metadata for these tasks was building up and slowing everything down. We now do arcpy.SetLogMetadata(False) for everything running as a scheduled task. ... View more

I would also like to add that you probably want to be using "PYTHON_9.3" as the expression_type parameter for CalculateField. ... View more

Are you able to apply this solution you found to this discussion? ... View more

Sorry, I should have clarified that we have the ArcGIS License Manager running on an internal server that all machines can access. I have no trouble configuring ArcGIS Pro to use the concurrent use licenses. The problem is currently I have to set that license configuration for each different user on the same computer running ArcGIS Pro. I would like to be able to configure the licensing option in ArcGIS Pro once and have it apply for all users on that computer. ... View more

@jaykapalczynski I mentioned before that using Dissolve seems like it would get you the output you want. Have you tried that? ... View more