Latest Contributions by DominicRobergeIADOT

‎01-30-2023

Hi, I created a web map to edit a few feature classes, and attributes. I have a Date Field, but in Web Map, there's no Date Picker anymore? If I use the same map in Web Map Classic I do have the date picker and it's working fine in Field Maps as well.... JUST NOT WORKING IN NEW WEB MAP... Am I missing something? Thanks! D

‎01-25-2023

that was it: I add a cast to int and everything started working as expected. Thank you so much for all your help D

‎01-25-2023

Hey Jeff Your solution saved me a bunch if time, thank you. However, I have an issue with only ONE dictionary section (the Route data). The code returns None all the records, but the dictionary has the value related to the specific record ONLY THE ROUTE section return None for every records value returned by Dictionary ({10299: {'OBJECTID': 10299, 'id': 'IAL-331'}, 10300: {'OBJECTID': 10300, 'id': 'NEL-309'}, 10301: {'OBJECTID': 10301, 'id': 'NEL-312B'}, 10302: {'OBJECTID': 10302, 'id': 'NEL-314'}, 10303: {'OBJECTID': 10303, 'id': 'NEL-313'}, 10304: {'OBJECTID': 10304, 'id': 'SDT-208'}, 10305: {'OBJECTID': 10305, 'id': 'SDT-207'}, 10306: {'OBJECTID': 10306, 'id': 'SDL-336'}, 10307: {'OBJECTID': 10307, 'id': 'SDT-209'}, 10308: {'OBJECTID': 10308, 'id': 'SDL-335'}, 10309: {'OBJECTID': 10309, 'id': 'SDT-210'}, 10310: {'OBJECTID': 10310, 'id': 'NDT-211'}, 10311: {'OBJECTID': 10311, 'id': 'MNL-321A'}, 10312: {'OBJECTID': 10312, 'id': 'IAT-205'}, 10313: {'OBJECTID': 10313, 'id': 'SDL-320'}, 10314: {'OBJECTID': 10314, 'id': 'SDT-206'}, 10315: {'OBJECTID': 10315, 'id': 'NEL-333'}, 10316: {'OBJECTID': 10316, 'id': 'NEL-310'}, 10317: {'OBJECTID': 10317, 'id': 'NEL-312A'}, 10318: {'OBJECTID': 10318, 'id': 'NDL-324'}, 10319: {'OBJECTID': 10319, 'id': 'NDL-325B'}, 10320: {'OBJECTID': 10320, 'id': 'NDL-327A'}, 10321: {'OBJECTID': 10321, 'id': 'NDL-323'}, 10322: {'OBJECTID': 10322, 'id': 'NDL-326'}, 10323: {'OBJECTID': 10323, 'id': 'MNL-321B'}, 10324: {'OBJECTID': 10324, 'id': 'NDL-325A'}, 10325: {'OBJECTID': 10325, 'id': 'NDL-327B'}, 10326: {'OBJECTID': 10326, 'id': 'NEL-316B'}, 10327: {'OBJECTID': 10327, 'id': 'NEL-316A'}, 10328: {'OBJECTID': 10328, 'id': 'NEL-315'}, 10329: {'OBJECTID': 10329, 'id': 'IAL-318A'}, 10330: {'OBJECTID': 10330, 'id': 'SDM-104B'}, 10331: {'OBJECTID': 10331, 'id': 'SDM-105B'}, 10332: {'OBJECTID': 10332, 'id': 'NDM-106'}, 10333: {'OBJECTID': 10333, 'id': 'SDM-105A'}, 10334: {'OBJECTID': 10334, 'id': 'NDL-328'}, 10335: {'OBJECTID': 10335, 'id': 'SDM-104A'}, 10336: {'OBJECTID': 10336, 'id': 'IAL-318B'}, 10337: {'OBJECTID': 10337, 'id': 'IAL-329'}, 10338: {'OBJECTID': 10338, 'id': 'IAT-201'}, 10339: {'OBJECTID': 10339, 'id': 'IAT-202'}, 10340: {'OBJECTID': 10340, 'id': 'IAL-306'}, 10341: {'OBJECTID': 10341, 'id': 'IAM-102'}, 10342: {'OBJECTID': 10342, 'id': 'IAM-103A'}, 10343: {'OBJECTID': 10343, 'id': 'IAT-203'}, 10344: {'OBJECTID': 10344, 'id': 'MNL-305'}, 10345: {'OBJECTID': 10345, 'id': 'MNL-303B'}, 10346: {'OBJECTID': 10346, 'id': 'IAL-308A'}, 10347: {'OBJECTID': 10347, 'id': 'IAT-204B'}, 10348: {'OBJECTID': 10348, 'id': 'IAM-101B'}, 10349: {'OBJECTID': 10349, 'id': 'IAL-301B'}, 10350: {'OBJECTID': 10350, 'id': 'IAM-103B'}, 10351: {'OBJECTID': 10351, 'id': 'MNL-303A'}, 10352: {'OBJECTID': 10352, 'id': 'IAL-301A'}, 10353: {'OBJECTID': 10353, 'id': 'LITTLE SIOUX CAPFAC'}, 10354: {'OBJECTID': 10354, 'id': 'IAL-340'}, 10355: {'OBJECTID': 10355, 'id': 'IAM-101A1'}, 10356: {'OBJECTID': 10356, 'id': 'IAM-101A2'}, 10357: {'OBJECTID': 10357, 'id': 'IAL-302B'}, 10358: {'OBJECTID': 10358, 'id': 'IAL-308B'}, 10359: {'OBJECTID': 10359, 'id': 'MNL-304'}, 10360: {'OBJECTID': 10360, 'id': 'IAT-204A'}, 10361: {'OBJECTID': 10361, 'id': 'IAL-302A'}, 10362: {'OBJECTID': 10362, 'id': 'MNL-337'}}) this is what that UpdateCursor returns: before 30833, 58150, 617.5505629486523, 10346, 610.630249122789, 0, 0, 0, 0 MP dict value: {'OBJECTID': 58150, 'mile_post': 73.6} Route dict value: None Parcels dict value: None County dict value: {'FID_Structures_NAD83_Update': 30833, 'CountyName_1': 'Crawford', 'stateAbbr': 'IA'} after 30833, 73.6, 2026.0845889444565, 10346, 610.630249122789, 0, 0, Crawford, Iowa with arcpy.da.UpdateCursor(flStructure, fieldsUpdate) as cursorU: for rowU in cursorU: print(u'before {0}, {1}, {2}, {3}, {4}, {5}, {6}, {7}, {8}'.format(rowU[0],rowU[1],rowU[2],rowU[3],rowU[4],rowU[5],rowU[6],rowU[7],rowU[8])) strMatch = milepostDct.get(rowU[1],None) print("MP dict value: " + str(strMatch)) if strMatch: rowU[1] = strMatch['mile_post'] rowU[2] = rowU[2] * 3.28084 strRoute1 = rteDct.get(rowU[3], None) print("Route dict value: " +str(strRoute1)) if strRoute1: rowU[3] = strRoute1['id'] rowU[4] = rowU[4] * 3.28084 strParcel = parcelDct.get(rowU[0], None) print("Parcels dict value: " +str(strParcel)) if strParcel: rowU[5] = strParcel['LANDOWNER_NAME_1'] rowU[6] = strParcel['PARCEL_NUMBER_1'] strCounty = cntyDct.get(rowU[0], None) print("County dict value: " +str(strCounty)) if strCounty: rowU[7] = strCounty['CountyName_1'] rowU[8] = stateDict.get(strCounty['stateAbbr']) print(u'after {0}, {1}, {2}, {3}, {4}, {5}, {6}, {7}, {8}'.format(rowU[0], rowU[1], rowU[2], rowU[3],rowU[4], rowU[5], rowU[6], rowU[7],rowU[8])) #cursorU.updateRow(rowU) One I figure this issue, the script will run within 2 minutes Thanks!

‎01-25-2023

Thank you all for the information and quick response. I will try the dictionary approach and let you know how it goes. just a little bit of background on that project, I am running the Near geoprocessing on my Route and Mile Markers (and the RouteID is updated with the OBJECTID of the route, that's why I have to go back and update that RouteID with the RouteName... same with my Mile Markers) Then I do two intersects (structures with Parcels and Structures with Counties)... that's why I have to go back and update the structure fields I need from the parcels and counties data. Thanks!

‎01-24-2023

Hello, I have to update a feature class (16K records) based on four other feature classes. I am using the following code, which is working, but quite slow (about 35 min to complete). So, I was wondering if you guys could suggest some improvement to speed this up. Thanks! fieldsUpdate = ['OBJECTID','dr_Milepost','DR_distance_MP','Dr_Route','DR_DistanceFromRoute','DR_LANDOWNER_NAME','DR_PARCEL_NUMBER','DR_CountyName','DR_StateName'] fieldsM = ['OBJECTID', 'mile_post'] fieldsRoute = ['OBJECTID', 'id'] fieldsParcels = ['FID_Structures_NAD83_Update', 'LANDOWNER_NAME_1', 'PARCEL_NUMBER_1'] fieldsCounty = ['FID_Structures_NAD83_Update', 'CountyName_1', 'stateAbbr'] with arcpy.da.UpdateCursor(flStructure, fieldsUpdate) as cursorU: for rowU in cursorU: #Section to update the MilePost strMatch = "OBJECTID =" + str(rowU[1]) #print(strMatch) print("Mile post") with arcpy.da.SearchCursor(flMilePost, fieldsM,where_clause=strMatch) as cursorM: for rowM in cursorM: print(u'{0}'.format(rowM[1])) rowU[1] = rowM[1] rowU[2] = rowU[2] * 3.28084 # Section to update the Route print("Route") strMatchRoute = "OBJECTID =" + str(rowU[3]) with arcpy.da.SearchCursor(flRouteLYR, fieldsRoute,where_clause=strMatchRoute) as cursorR: for rowR in cursorR: #print(u'{0}'.format(rowR[0])) rowU[3] = rowR[1] rowU[4] = rowU[4] * 3.28084 ## Update using the intersect Parcels data print("Parcels") strMatchP = "FID_Structures_NAD83_Update ="+str(rowU[0]) with arcpy.da.SearchCursor(flParcels+"int", fieldsParcels,where_clause=strMatchP) as cursorP: for rowP in cursorP: rowU[5] = rowP[1] rowU[6] = rowP[2] ## Update using the intersect County data print("County") strMatchC = "FID_Structures_NAD83_Update =" + str(rowU[0]) with arcpy.da.SearchCursor(flCounty+"int", fieldsCounty,where_clause=strMatchC) as cursorC: for rowC in cursorC: rowU[7] = rowC[1] if rowC[2] == 'SD': rowU[8] = 'South Dakota' elif rowC[2]== 'ND': rowU[8] = 'North Dakota' elif rowC[2]== 'NE': rowU[8] = 'Nebraska' elif rowC[2]== 'MN': rowU[8] = 'Minnesota' elif rowC[2]== 'IA': rowU[8] = 'Iowa' else: rowU[8] = '' cursorU.updateRow(rowU)

‎01-12-2023

That is a nice tool, thanks for sharing. Unfortunately for me, seems like the webhook is triggered between 2 and 4 minutes (did 5 tests) which are consistent with I was getting within Power Automate. I will contact Support tomorrow. Thank you and I will update the post when I get more info. D

‎01-12-2023

I have no Fix Connections next to it, and both of my flows are using the same connection

‎01-12-2023

Hello I have to Power Automate flows that are very similar (one is based on a polygon HFL and the other one is a point HFL). Both layers have a refresh interval set to 0.5 MIN. Both layers have a web hook that has been created while building the flows using he ArcGIS Connector, and the frequency is set at 30 sec So my issue is: When I update a polygon record, the flow is triggered immediately (boom! fast). BUT when I update a point record, it takes 2 minutes for the flow to trigger What am I missing? Thank you!

‎01-11-2023

Well that's what I was thinking at first, but the time run is the same, no additional minutes. Then a friend of mine observed the same behavior on his AGOL starting January 3rd. Like me, he has scheduled Notebooks that have been setup since last November, nothing has changed since then. and his credit usage has ramped up as well. So, it has to be something else...

‎01-11-2023

Hello I have a few Notebooks (4) that are scheduled to run using the Task functionality (some every 15 min, some once a day). They have been setup in 2022 around August. Today I was looking at the Credits Report in AGOL and noticed that my credit usage for Notebooks have increased a lot since January 3rd 2023. Did ESRI changed their Notebook usage policies?

‎12-23-2022

I am experiencing the same issue on IOS 22.4.2 (build954) this functionality used to be working just fine and same as @RichSiko our field crews are relying on those URLs to pull asbuilt, service cards, etc.) it will works if you only have ONE media ... if you have multiple ... not working. I could create Arcade expressions but I would rather have the original functionality back PLEASE ESRI get this fix ASAP

‎12-22-2022

Hello I have a flow in Power Automate that pull data from a Dataverse table, and update a hosted feature layer on AGOL. Everything seems to be working fine EXCEPT for my Date fields. below is what is the payload form Dataverse { "@odata.editLink": "cr3c3_coa_projectses(a85d55b7-1f82-ed11-81ac-000d3a37d89e)", "[email protected]": "12/22/2022 6:00 AM", "[email protected]": "#DateTimeOffset", "cr3c3_coaprjstartdate": "2022-12-22T06:00:00Z", "_cr3c3_coaemployee_value@OData.Community.Display.V1.FormattedValue": "Dominic Roberge", "_cr3c3_coaemployee_value@Microsoft.Dynamics.CRM.associatednavigationproperty": "cr3c3_coaEmployee", "_cr3c3_coaemployee_value@Microsoft.Dynamics.CRM.lookuplogicalname": "cr3c3_coa_stafflist", "[email protected]": "#Guid", "_cr3c3_coaemployee_value": "b302e0c1-2082-ed11-81ac-000d3a37dbf1", "[email protected]": "#Guid", "cr3c3_coa_projectsid": "a85d55b7-1f82-ed11-81ac-000d3a37d89e", "[email protected]": "Active", "statecode": 0, "[email protected]": "Active", "statuscode": 1, "[email protected]": "Dominic Roberge", "[email protected]": "systemuser", "[email protected]": "#Guid", "_createdby_value": "14855649-5267-ed11-9561-000d3a37d89e", "cr3c3_coaprjname": "test revised no staff", "timezoneruleversionnumber@OData.Community.Display.V1.FormattedValue": "4", "timezoneruleversionnumber": 4, "[email protected]": "12/22/2022 5:40 PM", "[email protected]": "#DateTimeOffset", "createdon": "2022-12-22T17:40:26Z", "cr3c3_prjuid": "7", } the 4th line has the data I am looking for to update my date field in AGOL. below is the error I am getting I have tried adding aFormatDateExpression (FormatDateTime(outputs('Get_a_row_by_ID')?['body/cr3c3_coaprjstartdate'],'MM-dd-yyyy')) but still no success. Any help would be much appreciated. Thanks!

‎12-13-2022

hello everyone sorry it took so long, I had open a ticket with ESRI Support regarding this issue and they finally created a BUG as they were able to replicate the issue: Bug Number: BUG-000154427 Synopsis: The Arcade expression configured in a form within a web map does not get honored in Map Viewer Any ideas how I could generate a unique ID automatically? Thanks!

‎11-24-2022

Thanks for the info. However when the expressio is enabled, I can't click the Create Feature button. when I test the expression it seems to be working if I disable the expresssion, then I can Create feature What am I missing? I also tested the process on a different HFL and different web map and same result.

‎11-23-2022

Hello I started playing with the ArcGIS connector as well and kept getting the same error as listed in the original message. I was using a Hosted Feature Layer with a relationship class (was published from a FGDB). Then I tested the same workflow with a HFL published from FGDB but no relationship and it worked. Could it be the problem?

Online Status	Offline
Date Last Visited	3 weeks ago

My Ideas

Latest Contributions by DominicRobergeIADOT

date picker missing in Web Map?

Re: Need help improving an UpdateCursor script

Re: Need help improving an UpdateCursor script

Re: Need help improving an UpdateCursor script

Need help improving an UpdateCursor script

Re: Record Updated in a Feature Layer take a long time to trigger flow

Re: Record Updated in a Feature Layer take a long time to trigger flow

Record Updated in a Feature Layer take a long time to trigger flow

Re: Notebook Credit usage increased in 2023

Notebook Credit usage increased in 2023

Re: URL link within field maps popup not working.

updating Date Field not working

Re: Arcade Generate new Unique ID for new record but not updating existing UID

Re: Arcade Generate new Unique ID for new record but not updating existing UID

Re: Fetch Updates Error - Cannot read property 'headers' of undefined

Re: Category Selector RESET missing?

Category Selector RESET missing?

List widget Arcade expression to return message if...

Re: Record Updated in a Feature Layer take a long ...

AGOL Metadata dropdown list Values

Experience Builder Custom Widgets