|
POST
|
Ended up contacting ESRI Tech Support and issued a trouble ticket for review.
... View more
11-13-2024
11:27 AM
|
0
|
0
|
385
|
|
POST
|
I understand ESRI did an AGOL update last night. This morning, one of our Superintendents was saying they cannot update the Status of the Assignments from the Workforce Hosted Feature Layer within an AGOL Web Map, even though they have editing powers. I thought this was a specific domain native to the Feature Layer that is created when a new Workforce project is created, and we have (as operators/admins) not control over. Any thoughts how we resolve this? @JeffShaner
... View more
11-13-2024
08:20 AM
|
0
|
1
|
417
|
|
POST
|
@RobertAnderson3 @IsmaelChivite @ZacharySutherby @JenniferAcunto There must be something I am missing. Using Power Automate, I keep getting an error message while using the ArcGIS Connector (orange) saying I need a Premium License. However, according to my knowledge, the ArcGIS for Microsoft 365 accepts a Creator ESRI license type. Is there a setting within Power Automate I need to update, even though I used my ESRI login credentials.
... View more
11-08-2024
08:55 AM
|
0
|
1
|
1630
|
|
POST
|
@RobertAnderson3 Thank you for the information. Appears I need to #1 talk with my IT Officer about our Power Automate License(s) before I can continue development. I see there is more that I can use. Thank You for the feedback
... View more
11-07-2024
10:26 AM
|
1
|
0
|
1643
|
|
POST
|
@RobertAnderson3 Thank you for the response. Can you clarify and point me in the right direction on what you are explaining? What I need to do is when the attributes are updated, lets say via ArcGIS Pro/Python script, to a Survey123 form, Power Automate is initiated to create a report. I have the flow configured, its the webhook and updating an existing survey/form from ArcGIS Pro that is the missing piece.
... View more
11-05-2024
11:24 AM
|
0
|
3
|
1668
|
|
POST
|
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
... View more
10-24-2024
01:52 PM
|
0
|
7
|
1808
|
|
POST
|
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
... View more
10-24-2024
07:03 AM
|
0
|
0
|
361
|
|
POST
|
@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.
... View more
10-21-2024
09:21 AM
|
0
|
1
|
942
|
|
POST
|
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
... View more
10-15-2024
01:05 PM
|
1
|
3
|
1034
|
|
POST
|
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
... View more
10-10-2024
03:19 PM
|
0
|
3
|
1504
|
|
POST
|
@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
... View more
10-10-2024
11:37 AM
|
0
|
0
|
1468
|
|
POST
|
@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.
... View more
10-10-2024
10:21 AM
|
0
|
0
|
649
|
|
POST
|
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
... View more
10-09-2024
01:52 PM
|
0
|
1
|
463
|
|
POST
|
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))
... View more
10-01-2024
07:00 AM
|
0
|
0
|
1401
|
|
POST
|
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?
... View more
09-30-2024
01:06 PM
|
0
|
6
|
1442
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 3 weeks ago | |
| 1 | 10-30-2025 12:42 PM | |
| 1 | 10-16-2025 10:51 AM | |
| 1 | 08-27-2025 08:47 AM | |
| 1 | 06-17-2025 07:40 AM |
| Online Status |
Offline
|
| Date Last Visited |
a week ago
|