Latest Contributions by MKF62

‎08-18-2020

Must be a glitch; when I clicked save on the project, the points fixed themselves and were appropriately symbolized.

‎08-18-2020

I have a bunch of points and I'm creating their symbology based upon a certain value. There are three values, all of the points fall into one of these values, however Pro is categorizing all of them as "all other values", so I cannot symbolize the layer correctly. I'm not sure how to fix this. Please see that all the points on the map are gray which matches the "all other values" category in the symbology pane. The "Count" column in the symbology pane says there are 0 features in the "all other values" category though and instead counts them correctly for the defined values. If I turn off "all other values" all the points disappear from the map. I have deleted and re-added this layer to the map with no luck.

‎08-18-2020

This was quite a while ago now, but if I recall correctly, that did fix the issue.

‎07-14-2020

In ArcMap you could use the Extract Data Wizard to export related feature classes to a new geodatabase and copy the schema of that geodatabase along with it. How do you do that in ArcGIS Pro? I can't find a suitable tool. Is the only way to do it to copy the entire GDB?

‎07-06-2020

I have a field tech who physically is states away so I can't exactly look at his hardware, but they reported to me that they received a generic "failed to synchronize edits" message, tried again, and it worked and they did not receive an error message the second time... however I checked our DB and half the data that was supposed to sync is missing. The type of data being synced is two related point layers, e.g. the tech collected an origin point and then collected a bunch of related points (observations) tied to the "origin" by an automatically generated ID as in a 1:M relationship. It successfully synced all of the origin points but none of their related observations. I went into our server logs and saw these error messages, suggesting that the related points never had the origin ID tied to them which should be impossible when collecting with Collector. You cannot add related points without first having an origin point when using related feature services in Collector to my knowledge. Will those observations still be salvageable by getting the runtime GDB off the phone or did it erase them from local storage when the second sync finished without error? How can I avoid issues like these in the future? We are still using Collector Classic.

‎07-06-2020

I don't believe I ever solved it, sorry.

‎06-18-2020

Apparently multiprocessing doesn't appreciate class objects (e.g. "self") as arguments, so I needed to make my function global instead of just within the scope of the class that it really applies too. Then I was able to pass a property of self in-place of self. Perhaps there is another way to do this where you can use self as an argument and get things to work how I originally wanted them to, but this was the only solution I was able to make work. Here's the final code: import arcpy, multiprocessing, os #################### # Class Definitions #################### class DomainData(object): '''This is the base class for all domain data''' def __init__(self, folderPath, gdbPath, dbCon): #properties def createDomain(self, wsRows, tblName): #Make Excel file #Save the file wb.save(self.wkbkName) savedTable = os.path.join(self.gdb, tblName) #Convert the excel file to an ArcMap table. p = multiprocessing.Process(target=excl2Tbl, args=(self.wkbkName, savedTable)) p.start() p.join() arcpy.AddMessage("process ended") #do more stuff ############################## # Global function definitions ############################## def excl2Tbl(file, tbl): '''This function converts and excel file to an ArcMap table''' arcpy.ExcelToTable_conversion(file, tbl) ############ # Main code ############ if __name__ == "__main__": #do stuff sprFA_dom.createPointDomain() #continue with the script‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

‎06-18-2020

I'm trying to start a separate process to run the ExcelToTable tool since running that tool in the same process as the rest of the script breaks all breakpoints that come after that line (supposedly this bug has been known for years but apparently no one wants to fix it) and I still need to be able to use breakpoints so... how can I get this process to run? Since I just need to run this tool a single time and wait for it to finish, I'm using the Process method instead of the Pool method. When I run my script, I get an error about being unable to pickle a geoprocessing result object. class DomainData(object): '''This is the base class for all domain data''' def __init__(self, folderPath, gdbPath, dbCon): #properties def createDomain(self, wsRows, tblName): #Make Excel file #Save the file wb.save(self.wkbkName) savedTable = os.path.join(self.gdb, tblName) #Convert the excel file to an ArcMap table. p = multiprocessing.Process(target=DomainData.excl2Tbl, args=(self, savedTable)) p.start() p.join() arcpy.AddMessage("process ended") def excl2Tbl(self, tbl): arcpy.ExcelToTable_conversion(self.wkbkName, tbl) if __name__ == "__main__": #do stuff sprFA_dom.createPointDomain()‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ #continue with the script‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ This is the error that comes back: pickle.PicklingError: Can't pickle 'geoprocessing server result object' object: <geoprocessing server result object object at 0x1E415BA8> I get that geoprocessing objects of any sort aren't pickleable, but I don't need to do anything with the object created; I don't need to return it. How do I get the process to just ignore it?

‎06-18-2020

That's a good idea, I can give that a shot. Thanks.

‎06-18-2020

Do you have an example of using the multiprocessing module that you can share?

‎06-18-2020

If you're talking about Data Store proper (the thing that comes with ArcGIS Enterprise), we don't have that or portal installed. Just Server. But all the databases are registered with the server.

‎06-17-2020

Database authentication is used for geoprocessing services.

‎06-17-2020

Problem still exists in 2020. Using Visual Studio Enterprise to code in python. Any call to ExcelToTable or TableToExcel makes all breakpoints afterward non-functional. If I comment out those lines, the breakpoints will work again.

‎06-05-2020

"Solved" this by some miracle and sheer dumb luck after hours of fiddling around and exiting in and out of ArcMap. 1) Load up your toolbox and run the script. Open the results window. 2) Share result as a geoprocessing service and set all your settings 3) Hit "Publish" and wait for the errors to appear 4) Exit out of the publishing dialog but SAVE the service draft 5) Exit out of ArcMap 6) Reopen ArcMap and go into your server connection 7) Open the "Drafts" folder in your server connection and double click on the draft 😎 Run "Analyze" again. This time no errors appear 9) Publish. It will succeed and run as expected for absolutely no reason. Thanks ESRI.

‎06-05-2020

I have created a python script that contains all of my database connection strings and when I'm working locally, I can just import those strings like you would any regular module and use them. When I publish a geoprocessing service though, I can't figure out how to use an imported module like this because those connection strings won't be made into g_ESRI variables. My goal is to have one central place to update all my connection string paths if they change in the future, rather than going into 50 different scripts and changing each one. This is what my database connection python file (DatabaseConnections.py) looks like: hb_db_con = r'C:\Users\xxx\AppData\Roaming\ESRI\Desktop10.7\ArcCatalog\FocalAreas_HabitatWriter.sde' fa_db_con = r'C:\Users\xxx\AppData\Roaming\ESRI\Desktop10.7\ArcCatalog\HbMon_HabitatWriter.sde' #So on and so forth‍‍‍‍ The top of the geoprocessing service I publish imports those connections like so: from DatabaseConnections import hb_db_con, fa_db_con fc1 = hb_db_con + "\blah.DBO.blahblah" fc2 = fa_db_con + "\blah2.DBO.blahblahblah"‍‍‍‍‍‍‍‍ I have copied DatabaseConnections.py to the server's python library so it can find the connection strings, but obviously it doesn't convert them to where the server should find the data and instead just takes the hard-copied connection string and goes searching, coming up with nothing. Is there a way to centralize database connection strings in your code and still make it publishable?

Online Status	Offline
Date Last Visited	‎09-16-2025 02:16 PM

My Ideas

Latest Contributions by MKF62

Re: Unique value symbology not categorizing correctly

Unique value symbology not categorizing correctly

Re: Layer cannot be added to map

Exporting Related Feature Classes

Collector Sync Failure - Dangling Relationships

Re: Layer's Data Source Not Supported (Feature Service) FGDB

Re: Multiprocessing help

Multiprocessing help

Re: Centralizing database connection strings and publishing GP Services

Re: Debugging with ArcPy breakpoints after Point to Line

Re: Centralizing database connection strings and publishing GP Services

Re: Centralizing database connection strings and publishing GP Services

Re: Debugging with ArcPy breakpoints after Point to Line

Re: Project data source cached when trying to publish GP service?

Centralizing database connection strings and publishing GP Services

Re: Multiprocessing help

Re: Is Microsoft Web Deploy v. 4.0 compatible with...

Re: Is Microsoft Web Deploy v. 4.0 compatible with...

Re: Cannot publish map service with new tile cache

It's 2024, how does ArcGIS do with spaces in file ...