Latest Contributions by ModernElectric

@JenniferAcunto  I appreciate your assistance on getting me started. Using ArcGIS Survey123 Connect, there are examples that have JavaScripts associated with the spreadsheets in different downloadable examples. I will do some research to see how I can learn JavaScript and write a script to tell the spreadsheet if the date is within working hours or overtime hours.  ... View more

@JenniferAcunto  Jen: Thank You!! Looks like you are understanding exactly what I am trying to accomplish. I was able to take your example and build a test and it does exactly as you illustrated. If we could, and escalate it just a little? Our field crew's working hours are Monday to Friday from 7:30 AM to 4:00 PM PST. Anything outside of those hours and on weekends is all considered automatic overtime.  In order for this form, and future forms to be more user friendly, we want them to be able to enter their start time and end time and allow the formulas to do the calculations for them to determine their regular hours and if it during off-time, their OT hours calculated.  Appreciate your ongoing assistance ... View more

@JakeSkinner I have been able to get the code to work on a GDB that does not have any attachments or relationship classes. However, when I move onto a different GDB that does have relationship classes, I get the Error Code: 400 which indicates the Layer Truncate isn't supported on an origin layer in a relationship.  When I go thru ArcGIS Pro to Share/Ovewrite the Hosted Feature Layer from the GDB that has attachments and relationships, works out fine. However, the purpose of doing via the Python Script outside of ArcGIS Pro is to be able to run it from a Batch file. At this time, is there a work around for this, that way I can keep the relationship class intact? Appreciate your help ... View more

I have had issues with this in the past. One of the work-arounds we have found that works for us is to go into the app settings (Android) and clear the cache. The other SOP we have done is each morning, the user (mainly the foreman) is to log-out of workforce and log back in. This typically re-syncs up with the server, sometimes. I haven't had any other issues since we started doing these (2) items. However, what might work for us might not work for you, just be advised. Good Luck. ... View more

Thank you for the information and the video, has been a real help in designing my workflow. One of the issues I am having, and not sure if its something in Power Automate or the Survey123 Connect app/excel I need to do.  In the time fields, it allows the user to enter the time normally (ie 8:05 AM). However, when the report is printed, either from Survey123 (website) or thru my workflow in Power Automate, the time comes out in military time format. Looking thru the syntax, it doesn't allow me to format the time, as I can with a date entry. Any idea how I can fix this, since it was asked that I format the time entry on the printed PDF report to not be in military time. Thank You ... View more

@JakeSkinner  Wanted to provide a follow-up and see if you can identify what I am still doing wrong. First part of the batch file is to unregister the replicas. This works fine. Next is to run the script you provided and update the feature layer from the GDB Feature Class (FC without attachments). DisableSyc = True. The script runs fine without crashing and it appears the Feature Layer is updated in AGOL. However, here is the new issue I am having: These feature layers are used in ArcGIS Workforce and have editing abilities. When the project in workforce is opened, or attempted to be opened right after running the update script(s), it says the Feature Layer cannot be loaded. I have to go back in and remove and readd the layer and save the web map for it to work. Any ideas? Update: I have been doing a bunch of trial and error with this issue and havent been able to figure out why its happening. Specifically, the Field Worker project on an android phone/tablet is where I am running into issues. After running the script, doing the Sync feature on the app, does not reload the fresh data. Backing out and doing a Reload of the project, gives the error. Appreciate ALL of your help. ... View more

BINGO!! I went thru and recreated the Feature Class in ArcGIS Pro without the attachments, reshared it to AGOL and updated the script and it updated without crashing, I assume because I did not have an attachment table associated with the FC.  However, the attachment(s) are a key component to the feature(s). Is there a workaround to be able to include these in the script update process? ... View more

Jake: This appears to fix the problem. Regarding the rest of the script: It works on a Polyline feature class/feature service. However, on a point feature class/feature service with and without attachments, I get an Exception: Unknown Error (Error Code: 500) at Line 190 (Appending Features). The Field Mapping has not changed. ... View more

Jake: Thank you for providing this script. It is very helpful. However, I am having (1) minor issue. When I set the disableSync variable to False, I get an error that says cannot disable sync on the feature layer due to Outstanding Replicas. However, If I leave it as false, the script runs properly, but does not appear to properly update the data from the ArcGIS Pro Feature Class. Any suggestions? ... View more

I've been testing this with some of my feature class(s). Yes, in order for the Truncate/Append Python script to work - it has to be from a single GDB Feature Class to a single AGOL Feature Layer.  This seems to be very very inefficient. Instead of having one Hosted Feature Layer with dozens of layers/tables/relationships, I will need to upload each individual feature class to a unique Feature Layer and build a script to update each individual feature layer.  ... View more

The goal is to set a script/batch file to update the whole database. Issue with that is after having to update the working dataset (new development), I would have to update the AGOL dataset as well. Seems to be inefficient to 2 it twice. Plus, the attributes for billing and services information changes alot.  I did find a script (Truncate/Append) that allows me to update the whole Hosted Feature Layer even when it has sync enabled. The problem is I have to upload each individual feature class to AGOL as a unique Hosted Feature Layer to utilize the script. Would have have (1) script for the whole Hosted Feature Layer (Composed of a few dozen Feature Classes and tables and relationships classes). ... View more