Latest Contributions by MKF62

I'm trying to use the Excel to Table tool and I get a long error message that culminates in this: No module named expat; use SimpleXMLTreeBuilder instead   I have already repaired my ArcGIS installation and that didn't fix it so moving on... Now, I know the expat module exists in the Python 2.7 folder that ArcGIS is supposed to use. When I print the python path in the python window in ArcMap, I get this: ['', u'c:\\program files (x86)\\arcgis\\desktop10.7\\arcpy', 'c:\\program files (x86)\\arcgis\\desktop10.7\\bin', 'c:\\program files (x86)\\arcgis\\desktop10.7\\ArcPy', 'c:\\program files (x86)\\arcgis\\desktop10.7\\ArcToolbox\\Scripts', 'C:\\WINDOWS\\SYSTEM32\\python27.zip', 'C:\\Users\\mfoley10\\AppData\\Local\\Continuum\\anaconda2\\Lib', 'C:\\Users\\mfoley10\\AppData\\Local\\Continuum\\anaconda2\\DLLs', 'C:\\Python27\\ArcGIS10.7\\Lib', 'C:\\Python27\\ArcGIS10.7\\DLLs', 'C:\\Python27\\ArcGIS10.7\\Lib\\lib-tk', 'C:\\WINDOWS\\system32', 'C:\\Python27\\ArcGIS10.7', 'C:\\Python27\\ArcGIS10.7\\lib\\site-packages']‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ I see that it's going into both Python27 folder and an anaconda2 folder. When I go to my registry keys though, I don't see a python 2.7 folder and instead I see 3.7. I have set up my python interpreter in Visual Studio to point to the Python 2.7 interpreter and it works there so all good in VS. It's just the problem in ArcMap. I'm not sure what to do from here. Do I change the Default, Executable, and Window Executable all to point to Python27? It's worth noting that all the other tools I've been using in ArcMap work fine, it's just this one that I've had problems with so far. PythonPath folder has this in it: The above screenshots are in the HKEY_LOCAL_MACHINE. When I go to HKEY_CURRENT_USER, these are the install and python paths which point to anaconda. Maybe these are the ones I need to change? The Visual Studio ones are correct because I have those pointing to the ArcGIS interpreter: ... View more

I am having a heck of a time with this in field calculator and I've looked at the threads in geonet on datetime to string but none them seem to work for me. The ultimate goal is that I need to get a value out of datetime as an integer (so month would come through as an integer value of 2 for February for example). Since datetime seems to be formatted as a unicode string in Field Calculator, I think I need to get it to a regular string and then split it on the slashes so I can get the number I want and convert it to an integer before returning it. I have tried so many different solutions I couldn't write them all down here... can someone help me with this?  Date field is "Actual_Completion" and contains values displayed like so: 12/1/2015 (Long) Integer field is "Month" and needs the end value to be like so: 12 The closest I've gotten is this: int(str(!Actual_Completion!)[0])‍‍‍ and it will return the first value of the month, but that's problematic for returning something like 12. If I try def getMonth(): x = str(!Actual_Completion!).split("/")‍ x = int(x[0]) return x‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ I get an invalid syntax error on line 2. I've tried many different iterations of this: from datetime import datetime def getMonth(dateObj): x = datetime.strftime(dateObj, '%m') return int(x)‍‍‍‍‍‍‍‍‍‍ I get an error about strftime needing a datetime object and not a unicode object.  ... View more

I was wondering if there's a way to display fields but not allow them to editable in Collector. This is possible on the ArcGIS Online web map interface via the configure attributes in configure popup, but doesn't seem to pass on to Collector. Am I missing something or is it just not possible? ... View more

I am wondering if this is possible because every time I change the alias of the GlobalID field and then remove the layer and re-add it to the map, the field becomes GloablID again. Is there really no way to save it? GlobalID is just so non-descriptive when you're trying to use it in related tables. It doesn't make it obvious that GlobalID is the _NameHere_ID in the other feature class. ... View more

I was reading some documentation about ArcGIS Online credits and noticed that feature service storage sucks away credits. Is that only for hosted layers? I have published a feature service that is supported by our enterprise geodatabase and I'm hoping that does not cost credits, otherwise I don't know how anyone uses large datasets on AGOL without having deep pockets. Anybody that can inform me on this? I will not be using any of the other credit-charging functions. https://www.esri.com/en-us/arcgis/products/arcgis-online/pricing/credits ... View more