Latest Contributions by ModernElectric

‎11-21-2023

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

‎10-27-2023

I've created a new project for with some infrastructure data included that is used as reference information for the viewer. I've added the Hosted Feature layers to the Web Map and configured the fields, including a relationship class to a table. Work just fine in the Web Map. However, when clicking on the feature in Workforce to pull-up the attributes, the main attributes to the Hosted Feature Layer are present, BUT not able to drill-down to the related table attributes. Is this something that isn't available OR maybe in the workings???

‎10-03-2023

I have a project in Workforce that has background electric infrastructure hosted feature layers that are used by our field crew(s) for reference data. I also have a script created that updated the hosted feature layer from a file GDB created in ArcGIS Pro (Removes replicas, disables sync, truncates/appends data and enables sync). Script works fine. However, when the user of the project on an Android App version of Workforce needs to see the changes that were uploaded, before going into the project they have to "Reload" the project. When this happens, there is an error message that says the feature layer (that was just recently updated from the script) cannot be loaded. I have to go back into the Web Map and reload/reconfigure the feature layer for it to work. Any idea on why this is happening and/or what I can do to correct it? Goal is to run the scripts/batch files on the nightly basis so our field crews have up to date information. Thank You

‎09-26-2023

@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.

‎09-21-2023

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?

‎09-21-2023

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.

‎09-20-2023

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?

‎09-15-2023

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.

‎09-15-2023

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).

‎09-15-2023

Good Morning: Background: I have a series of Hosted Feature Layers that are published to AGOL that originated from a File GDB in ArcGIS Pro. These Hosted Feature Layers are Editing Enabled and SYNC Enabled due to the fact the layers are used in Field Maps and Workforce. Issues/Problems: It is a known fact that if the hosted feature layer is Sync Enabled, it cannot be updated via ArcGIS Pro (Overwrite Web Layer). In order to do this, the the Sync Enabled needs to be disabled in the settings of the Hosted Feature Layer. However, when doing this, the data from ArcGIS Pro is NOT updated. The process is more like truncating the dataset on AGOL. Only way is to fully delete the Hosted Feature Layer and Recreate the Web Layer from ArcGIS Pro and redo ALL of the web maps and workforce projects. Trying to use the Truncate tool in ArcGIS Pro on a hosted feature layer is a NO go. Other option is to use the Append tool from ArcGIS Pro which just ads duplicate records and then need to go into the Hosted Feature Layer to remove. All of these issues/problems are inefficient. Request: Need to know what the best efficient workflow/process for updating data from a File GDB Feature Layer in ArcGIS Pro TO a Hosted Feature Layer that has sync enabled in ArcGIS Online without interrupting the user's that are using the data in Field Maps and Workforce. ArcGIS Pro Data Model; Python script; etc. Appreciate your help because I have deleted my data on AGOL, recreated and rebuilt the maps too many times now.

‎09-13-2023

I have our Electric Infrastructure Hosted Feature Layer (Produced from ArcGIS Pro) added as a reference layer inside our Electric Service Order(s) project in Workforce. Its so our foreman can click on a feature (Transformer) to get attribute data or a Service Meter feature to get customer information. This way, they don't have to jump our of Workforce and go into a different map. I added the Hosted Feature Layer by opening the Dispatcher and Mobile Worker Web Map via AGOL since the settings were already configured in ArcGIS Pro prior to uploading.

‎09-12-2023

I am going to throw one final curve ball - thanks to my manager. If the user starts typing in the Inventory Description and finds in the drop-down what they want (I need to reprogram that for a drop-down), that it would auto-populate the Inventory Number. SO basically, the user would have a choice to enter the Inventory Number and AutoPopulate the Description OR in reverse. Is this able to be programmed?

‎09-12-2023

Appreciate it. I believe this will set the foundation for what I need to accomplish.

‎09-12-2023

That looks like it did the trick. That is exactly what I was trying to accomplish. (2) follow-up questions: 1: Is there a way to hide the where clause in the survey so it doesn't confuse or crowd the form for the user (Attachment). 2: In the past, when I could create and publish a survey from Survey123 Connnect and record data, other users complained they could not see recorded surveys from others. Is this a known issue or more of a lack of knowledge on my part? Appreciate it.

‎09-12-2023

I am beyond frustrated with this even after all the research and and tutorials I have been reviewing and nothing is working. This should be a very simple concept and I am missing something. Attachment: Enter Inventory Number - The user is to enter the company inventory number (lets say 1050). From there, I would like it to automatically populate the field (Modern's Inventory Description). I have a hosted feature layer on AGOL that has the Inventory Number and Description. In the calculation: pulldata("@layer", "getValueAt", "attributes.DESCRIPTION", "PATH TO AGOL", ${Inventory}) However, when I enter 1050 into the survey, the Inventory Description remains blank. Please help since I am really lost here. Thank You

Online Status	Offline
Date Last Visited	a week ago

My Ideas

Latest Contributions by ModernElectric

Re: Survey123 Create Report action in Microsoft Power Automate (Preview)

Relationship to table - similar to Field Maps

Worker Map - Android App - Fail to load updated Feature Service Data

Re: Overwrite ArcGIS Online Feature Service using Truncate and Append

Re: Overwrite ArcGIS Online Feature Service using Truncate and Append

Re: Overwrite ArcGIS Online Feature Service using Truncate and Append

Re: Overwrite ArcGIS Online Feature Service using Truncate and Append

Re: Update Hosted Feature Layer Data from ArcGIS Pro Sync Enabled

Re: Update Hosted Feature Layer Data from ArcGIS Pro Sync Enabled

Update Hosted Feature Layer Data from ArcGIS Pro Sync Enabled

Re: Hosted Feature Layer Attributes in Project NOT viewable

Re: PullData AGOL Layer AutoPopulate Field

Re: PullData AGOL Layer AutoPopulate Field

Re: PullData AGOL Layer AutoPopulate Field

PullData AGOL Layer AutoPopulate Field

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

Re: Create Assignment in Line