Latest Contributions by Trippetoe

@TimJordan1 At this point the best Esri tech support is offering is that we just need to update our servers' operating systems. Would it be that simple. While i agree that is clearly the best long term approach, it's not helpful for the short term. Have you heard anything from Esri or figured out anything helpful to resolve this issue?

Hello. Within the last 36 hours or so from Sept 25, 2025, our AGOL hosted feature services (at least two of them) have started rejecting connections from our Web API. We are using oauth authentication, passing a client id and password to GetToken, then appending the token to subsequent requests to the feature services. The key pieces of the response back from the AGOL hosted service are "The SSL connection could not be established, see inner exception." and the inner exception "Authentication failed because the remote party sent a TLS alert: \u0027HandshakeFailure\u0027." This is true for multiple servers running Windows 2012 R2. However we have a couple of other servers running Windows 2022 and 2025 where the exact same code is able to connect successfully. I have verified that our Windows 2012 servers are using TLS 1.2. Those same servers are able to get Tokens from the GetToken endpoint but cannot connect to the Hosted Services. For at least the past 6 years prior, the API was happily connecting multiple times per day. This is a recent event. Any help is appreciated. Thank you

‎08-22-2025

Hi @Neal_t_k I've wandered pretty far down the 'roll-my-own-report-with-python' path. It's probably too far to back out of that path now 😉 Thanks again for all your help.

‎08-22-2025

Thanks for the link. I've been looking for something like that. There are a couple hundred sites so that may not be an efficient approach for this problem. I'm looking at other programmatic python based pdf report generators now. The Survey123 Report generator just may not be the right tool for this situation.

‎08-22-2025

Hey @Neal_t_k Thanks for your super fast response. Agreed that just storing the label value is the easiest for reporting. The reason it's not my preferred approach is that currently i am storing the 'id' value which can never change whereas the 'label' value can and does change. The data is the 'location' where the work was done - its id value wont/cant change based on company 'business rules'. However the name of the site can change. It doesn't happen often, but it does happen. In those cases, i'd have to go back thru all the previously submitted records and change the location label value. So, it's a classic data maintenance and QA/QC reason for not storing the 'label'

‎08-22-2025

Greetings. In my survey i have a select_one question where the answers are populated via 'autocomplete search()' functionality. The 'name' value, that is the 'id' of the selected answer, is being stored in the survey's feature class as the actual answer to the question. The 'label' value of the selected answer is stored in the Survey as a calculated field but its esri:fieldType is 'null' so i think it's value is not kept when the survey is submitted. Is there a way to get that 'label' value for display in the survey Report template. The 'id' value won't mean anything to Report readers; only the 'label' will. Thank you

‎07-09-2025

Perfect! 'join' is exactly what I was looking for. Thank you. A few 'concat' statements later, i've got the sql query working exactly as needed.

‎07-08-2025

Hello. I'm wondering how to get the all values from a 'select_one' question that exists within a repeat. Ultimately, I'd like to use that list of values in a 'search()' expression to populate the list of values to that select_one in the 'next' repeat. I'm confused just re-reading that last sentence, so here's some background. My survey is used to track 'treatments' of various trees. Each tree has a unique 'tree tag id'. A single survey can be used to track treatments for any number of trees. The 'TreeTagId' is a select_one question within a repeat. I am hoping to create a drop-down list of tree tag ids that does not include any tree tag ids already selected in the survey. To do that, I'm using the approach described here to create a URL query that excludes previously selected tree tags. So, something like where=treetagid NOT IN ('101', '102', '103') . In that example, the user has completed three 'repeats' and selected tree tag ids 101, 102, 103. So in the 4th repeat, none of those TreeTagIds would be in the select_one list. I hope that makes sense.... As a new repeat is added, I am hoping to somehow 'iterate' over the previous repeats, pull out the value of the 'TreeTagId' question and append it on to the 'where' statement to be used in the 'search()' calculation for the TreeTagId select_one of the new repeat. Is such a thing possible? Thank you

‎04-01-2025

@MikeSweeney This is fabulous. Thank you for the example code!

‎03-17-2025

I figured it out. I needed to open / create my notebook after opening a Lake House in my workspace so that the notebook was in the 'context' (i guess) of a lake house. When i got the error, i had started by creating a new notebook as a sort of 'stand alone'. All is working as expected now.

‎03-17-2025

Hello. At the Dev Summit i had a great conversation with someone (Noah maybe) at the GeoAnalytics booth about getting AGOL data into Fabric. He pointed me towards the 'GeoAnalytics in Fabric' blog. This first morning after the Dev Summit i was excited to get started testing some of the functionality. I had our Fabric Admin enable the required tenet setting, and fired up my first notebook. I copy/pasted the first bit of example code, and ran into an error. import geoanalytics_fabric from geoanalytics_fabric.sql import functions as ST spark.sql("show user functions like 'ST_*'").show() There was a much longer exception message, but this part seems to be the summary, maybe AnalysisException: org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(message:Spark SQL queries are only possible in the context of a lakehouse. Please attach a lakehouse to proceed.) The next section of code (creating a data frame and echoing out the schema) worked fine. I'm gonna keep on plugging thru the tutorials, but is there something i need to do, like creating a lakehouse, before i can run that first bit of code (and maybe other sections as well)?

‎02-20-2025

Hello. We have several older data processing scripts that manually sync data from AGOL to our enterprise spatial databases (in older person's vernacular - SDE databases). Generally speaking, the scripts - find the last date the script ran successfully - find data in a hosted feature service that have a last edit date more recent than the last date the script ran successfully - export that data as a file geodatabase (fgdb) - inserts/updates data in SDE based on fgdb I am starting a new project that needs to do the same basic process - one-way sync of data from AGOL to an SDE database, but before i follow the tried-and-true well-worn path, i am reconsidering the approach to see if there are other, better ways of completing the task. I've spent some time reading the REST API docs about sync functionality, but i haven't seen anything that specifies a sync client that's an SDE data table(s). Or any workflow examples that match what i'd like to do. I'm wondering if there are better / alternative ways of performing the sync from AGOL to SDE than the manual approach we're using now. Thank you

‎01-17-2025

It's looking like this is a bug. Interestingly, if you use the "Inbox" to open the survey, the cascade works as expected - for example, clearing out Q1 clears out Q2. However, if you use the "Sent" folder, the cascade does not work as expected - clearing out Q1 has no effect on Q2. In fact, I can't change the value of Q2 at all.

‎01-14-2025

Thanks for your suggested workaround. I'll give it a try. There's already a complicated relevant statement on the field. Might as well add some additional complexity 😉 I've filed a bug report with Esri about this behavior, and i'm working with the Esri technician to identify what's going on. I'll let you know what i learn about this.

‎01-13-2025

Hello. I have a survey that has a standard cascading select so that selecting a value in Question 1 (let's say "State" is the question) impacts the possible options in Question 2 ( and "State capital" is the question). When a survey response is first created, I am seeing the expected behavior when selecting and clearing the value in Question 1. For example, if I've selected, say "Oregon", in Question 1, and then "Salem" is selected in Question 2. If i then clear "Oregon" from Question 1 answer, "Salem" is cleared from Question 2. However, if the survey has already been submitted and the user is coming back to edit their responses, the expected 'auto-clearing' of Question 2 does not happen when Question 1 is cleared. And worse, when selecting a new value in Question 1, the value in Question 2 does not update. So, its possible to have the value "Alabama" in Question 1 and "Salem" in Question 2. This seems like a bug to me. Has anyone else seen this behavior? I am using Survey123 Connect 3.19.116 and viewing the survey in Survey123 Android 3.19.121 Thank you

Online Status	Offline
Date Last Visited	Tuesday

My Ideas

Latest Contributions by Trippetoe

Re: AGOL hosted feature service just started refusing connections from Windows 2012 R2 server

AGOL hosted feature service just started refusing connections from Windows 2012 R2 server

Re: Display a select_one label in a Report template

Re: Display a select_one label in a Report template

Re: Display a select_one label in a Report template

Display a select_one label in a Report template

Re: How can i access answers to a specific question in a collection of repeats

How can i access answers to a specific question in a collection of repeats

Re: Can arcade return the coordinates of a map click?

Re: Problem with getting started with GeoAnalytics in Fabric

Problem with getting started with GeoAnalytics in Fabric

How to do a one-way sync from AGOL to enterprise spatial geodatabase?

Re: Clearing a cascading Select not working in Edit mode

Re: Clearing a cascading Select not working in Edit mode

Clearing a cascading Select not working in Edit mode

Re: AGOL hosted feature service just started refus...

AGOL hosted feature service just started refusing ...

Re: Problem with getting started with GeoAnalytics...

Apply sensitivity labels to AGOL items, particular...

Re: Repeat Always Creating Record