Latest Contributions by ModernElectric

‎10-24-2024

UPDATE: @IsmaelChivite @ZacharySutherby @JenniferAcunto I have a Power Automate flow created that a PDF report is created (Action) when a form is submitted (Trigger). Works fine. Also, as part of the webhook, if the data is edited/updated from the Survey123 app or website, the Power Automate Flow will execute and produce another PDF report. HOWEVER: I have had to build a sub-process that exports the data from the AGOL portal to my local drive, run some data modifications and uploads the data from ArcGIS Pro back to the AGOL portal by using the Append tool. My thought was update/append/webhook Existing record edited would all mean the same time. Apparently not. If I run a geoprocessing tool from ArcGIS Pro and/or Python script, how can I set the webhook or Power Automate Trigger to execute the flow???? Any advice

‎10-24-2024

I have a DTSX package created in Visual Studio and wondering if there is a way to execute the package thru a Python script? It basically takes an Excel spreadsheet import, runs a derived Column tool and exports the results to a new Excel spreadsheet. Thank You

‎10-21-2024

@Robert_LeClair @DanPatterson Thank you for the information. I've tried the script you sent, and also found another script: with arcpy.da.SearchCursor(feature_class, [date_field]) as cursor: max_date = None for row in cursor: date_value = row[0] if max_date is None or date_value > max_date: max_date = date_value print("Maximum date: ", max_date) arcpy.SelectLayerByAttribute_management(feature_class, "NEW_SELECTION", date_value) arcpy.conversion.ExportFeatures(feature_class, layername_export) print("EXPORT") Both of the scripts exports all of the rows from the feature class to a new feature class. The goal is to only select and export the newest date regardless if there is 1 feature or 200 features in the feature class. As time progresses, this feature class is going to grow overtime and the next script(s) will rely on having (1) record and it needs to be the most recent record. Question, does that need to be a DATE_ONLY field type or is it okay to be a DATE-TIME field type? Not sure if this makes a difference.

‎10-15-2024

There is nothing more frustrating in working with a GDB FC/Table then dealing with a date field. I am simply trying to run a Select Layer by Attribute tool via Python to select the most recent date in a file GDB feature class in a date field type. All my research have failed in being successful. I have a Make Feature Layer and Select Layer by Attribute tool. The recent expression: arcpy.management.SelectLayerByAttribute(SURVEY123_EWO_REGULAR_HOURS_FL, "NEW_SELECTION", "date_ewo = (SELECT MAX(date_ewo) FROM SURVEY123_EWO_REGULAR_HOURS)") Presently, I have (3) entries in the Feature Layer and still the selection exports all (3) entries versus just (1). In the future, this FC is going to grow and I need to be able to select the most recent entry each time I run the tool. Appreciate any help

‎10-10-2024

Is there an example to help me on how to use Python scripting to create a printed report from a report template? I have the process complete via the Survey123 Application and Power Automate to create a PDF report from a Microsoft Word Report Template. However, due to the need to do edits/modifications on specific entries that couldn't be done thru formula(s) or coding in the XLX forms, I had to export the data into ArcGIS Pro to run processes via Python and Visual Studios. The challenge NOW is to get the modified field entries back into the overall hosted feature layer in AGOL to print the report. The work-around I am thinking of is to export the entire entry for the form and run the create report process thru a Python script. I just do not know how to start. Any help or advice? Thank You

‎10-10-2024

@AK-SavannahThomasDataProjects Thank you for adding your response(s) to this post. I was running into the exact same issue and seeing your solution solved my problems. Appreciate it

‎10-10-2024

@JoshuaClifford1 @JeffShaner We are having numerous issues with this. We have a constant internet connection, either thru WIFI or the service provider connection on the device. So, lack of connectivity is not an issue.

‎10-09-2024

I am working with a File GDB Feature Class thru Field Calculate (Python or Arcade) and trying to figure out HOW to calculate the difference between the Start Time and End Time. Example: Start Time: 7:00 AM End Time: 2:15 PM Time Difference: 2.25 How do I go about doing this? My other research results in just a flat hour or minutes and cannot figure out how to convert to the actual decimal difference. Thank You

‎10-01-2024

Thank you @RobertAnderson3 I will experiment with my flow I am trying to build to see if I can get it to work. Anything to do with a Date/Time field with Survey123 and integrating it with any other program is really really frustrating. Not sure if anyone else is having a hard time with it or if it is just me. Results: Is my function correct? addSeconds('1970-1-1',Div(triggerBody()?['feature']?['TIME CALLED']?['MM-dd-yyyy'] ,1000))

‎09-30-2024

I have been working on a flow in Microsoft Power Automate to export a submitted form to a Microsoft Excel file. The flow appears to work. However, the dateTime field type from the Survey123 Connection XLX does not export out from the form to the excel file properly. Instead of the data and time, it is just one long number. Even formatting the field type in excel, it doesn't update. Any suggestions?

‎09-18-2024

Disregard. Please forgive my ignorance, lack of proof-reading abilities 😉 Updated Script is working perfectly for updating our AGOL dataset.

‎09-18-2024

@BigLouC We have been struggling with this as well lately. My boss(s) and foreman are complaining to me that new and completed assignments are not doing the 15-minute auto-sync. The only thing I can figure out to do is to ensure there is a reliable and constant network/internet connection and to have the mobile user do a force sync.

‎09-18-2024

@LizArmstrong @CraigGillgrass Are there any updates from ESRI regarding this issue?

‎09-17-2024

@JakeSkinner Been using the latest script to rebuild my update workflow. On one of my Web Maps/Hosted Feature Layers - using this updated script - why am I getting: mp = prj.listMaps(map)(0) IndexError: list index out of range

‎09-03-2024

If I wanted to take a raster imagery file (.TIFF) and convert it to a polygon feature class clarifying the difference between vegetation, structures, roads, etc what is the best geoprocessing tool and/or ArcGIS Pro extension to use? The Raster to Polygon (Conversion Tools) does not really give the full clarification of a lawn, versus a building versus a roadway. Thank You

Online Status	Offline
Date Last Visited	Tuesday

My Ideas

Latest Contributions by ModernElectric

Power Automate - Trigger - Webhook

Execute DTSX from Python

Re: Select by recent date - specific date field

Select by recent date - specific date field

Python Script to Create Report

Re: Issue with GlobalID field generated in Survey123 not indexed uniquely

Re: Mobile Auto Sync not working and creating errors

Time Difference to decimal

Re: Power Automate Export Survey Excel dateTime field

Power Automate Export Survey Excel dateTime field

Re: Overwrite ArcGIS Online Feature Service using ArcGIS Pro Project

Re: Mobile Auto Sync not working and creating errors

Re: Workforce not syncing

Re: Overwrite ArcGIS Online Feature Service using ArcGIS Pro Project

Raster Imagery file to GDB Feature Class Polygon

Re: Using Workforce? Check out the new, upcoming t...

Re: Flow error/fail to run notification

Re: Water Utility Network - Model Blow-Off

Re: Workforce Project Sync Delay & Ongoing Issues

Survey123 Power Automate Notification