Latest Contributions by ModernElectric

Working on revising an existing Survey123 form to uses Pulldata to auto-fill a field based on the user's selection on a previous field. However, on this modification, it is not working and not sure what I am not seeing. The goal is for the user to start typing the Inventory Description and find what they are looking for, and once selected the Inventory Number and UOM is auto-filled.  My previous survey, the user would select the Inventory Number and the Description and UOM would auto-fill from the Inventory Number. However, it has been requested to switch it around. Appreciate any help. ... View more

I am trying to figure out how to write a Python script that will use Search Cursor to go thru a Feature Class based on a list of attributes in the script and delete the entire row.  I am not the best code writer, so please bare with me. This is what I have but nothing is working: expression = ('45074.0115', '45074.0116', '45074.0117', '45074.0118', '45074.0119', '45074.0120') with arcpy.da.UpdateCursor(MEWCo_PARCELS_UPDATE, "PID", expression) as cursor: for row in cursor: row[0] = 0 cursor.deleteRow()‍‍‍) I know 100% the code is written incorrectly, just not sure what part. MEWCo_PARCELS_UPDATE is the FC PID is the field Thank You ... View more

I created a new/updated feature class within a File GDB in ArcGIS Pro 3.2 and this same FC us needing to be used in ArcMap/ArcReader. Yes, I understand ArcMap and ArcReader is considered "Obsolete" compared to what is currently being used.  When I open the FC in ArcMap to update a PMF for ArcReader, I get "Error Opening Feature class, the item doesn't have a definition"  Wanting to know what kind of work-around I can create to still utilize the data in the ArcGIS Pro FC to update a FC being used in ArcMap/ArcReader. Appreciate your help. ... View more

I am not sure why because I have NOT had a problem until I did a Windows Update and a ArcGIS Pro update. All of my scripts have been running fine. I am using Python Idle 3.9.18 and getting this code: Error 000013: Length of Field Name must not be larger than 10. Failed to execute (Calculate Field). Is there something I can do because I have a large number of scripts that use the Add Field and Calculate Field tools and none will run properly anymore because of this code. Any other upgrades I need? Thank You ... View more

I am working on reworking my code in a series of my Survey123 forms/templates. Before, I made an AGOL table and pulled information from that. I am rebuilding the forms to use the PullData function to autopopulate the fields looking at a Hosted Feature Layer. The fields that are being populated have domains and when I run the form, the Domain Code is autopopulate VERUS the Domain Description. If I am pulling the Manufacture, I am seeing 511, but need to see the description (ACC). From Spreadsheet (Calculation Field) pulldata("@layer", "getValue", "attributes.XFMR_MANUFACTURER", ${hfl_url}, ${where_clause}) Is there something I am missing? Thank You ... View more

Good Morning. I've been working on a workflow with help from a previous post dealing with updating an AGOL Hosted Feature Layer using the truncate and append tools within a stand-alone Python Script. It works just fine with a plain Hosted Feature Layer from a File GDB feature class. However, the issue I am having is updating/overwriting the Hosted Feature Layer(s) that contain attachment(s) and are part of a relationship class from the original File GDB. Finding difficulties getting additional assistance on how to do this. I can do it within ArcGIS Pro by using the tool. However, I want to write a Python script and incorporate it into my nightly Batch File(s) to update our data. Appreciate your help ... View more

I have been working on creating a Work Order form for our field crews and part of it is entering their time. I have learned a lot and figured out how to do a time calculation based on the start and end time that is entered and autopopulate into another field.  And of course my dept supervisor throws a curve-ball. What I need to do (and not sure if it is passable), is: Regular Hours Field (Calculate from the start and end time IF between a specific period of time) ELSE, Overtime Hours Field (Calculate from the start and end time IF between a specific period time). Example: Start time 3:00 PM End Time: 7:00 PM  Regular Hours: 2 Hours (Since end of schedule is 5pm) OT Hours: 2 Hours (Since OT starts of 5pm). Is this possible? ... View more

I've developed a series of Survey(1) with Survey123 Connect on my desktop and published them to our server. When going thru and testing the survey(s) and my workflow(s), the date and time is correct (used my desktop Survey123 App to fill-out the survey). I've built a workflow with Microsoft Power Automate to print a report (PDF) and send an Email when a new survey is submitted with the PDF report attachment. This works fine. HOWEVER, when I open the PDF report, the times are OFF, somewhat into the future. Need to figure out if and HOW I need to make a calculation in the Excel spreadsheet thru Survey123 Connect or something I need to do in Power Automate to make the time the same as it was entered by the Survey123 user. Please help, appreciate it.  ... View more