|
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
|
1658
|
|
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
|
1750
|
|
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
|
2600
|
|
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
|
2565
|
|
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
|
1169
|
|
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
|
763
|
|
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
|
2539
|
|
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
|
2580
|
|
DOC
|
Disregard. Please forgive my ignorance, lack of proof-reading abilities 😉 Updated Script is working perfectly for updating our AGOL dataset.
... View more
09-18-2024
08:33 AM
|
0
|
0
|
21472
|
|
POST
|
@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.
... View more
09-18-2024
07:53 AM
|
0
|
0
|
1232
|
|
POST
|
@LizArmstrong @CraigGillgrass Are there any updates from ESRI regarding this issue?
... View more
09-18-2024
07:46 AM
|
0
|
0
|
2412
|
|
DOC
|
@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
... View more
09-17-2024
02:42 PM
|
0
|
0
|
21509
|
|
POST
|
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
... View more
09-03-2024
12:20 PM
|
0
|
1
|
785
|
|
POST
|
I know, from unfortunate experiences, doing a name/file change in other programs, can radically effect a program/file. IF, I needed to rename a Workforce Project either thru Workforce or AGOL, what are the consequences of doing that, if any?
... View more
08-29-2024
08:27 AM
|
0
|
0
|
486
|
|
POST
|
@LizArmstrong Question about the 15-minute auto-sync on a Workforce Project. Does the particular project need to be open on the device (lets say an android tablet) in order for it t sync? Was informed by one of our field workers that he had the project "open in the background" but not actually open and it did not sync until it was open and visible on their device. If a project is "sleeping" and not being used, does it or does it not follow the 15-minute auto sync process? Thank You
... View more
08-29-2024
07:28 AM
|
1
|
0
|
2496
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 03-23-2026 10:58 AM | |
| 1 | 11-20-2025 02:52 PM | |
| 1 | 10-30-2025 12:42 PM | |
| 1 | 10-16-2025 10:51 AM | |
| 1 | 08-27-2025 08:47 AM |
| Online Status |
Offline
|
| Date Last Visited |
3 weeks ago
|