Latest Contributions by Trippetoe

@EarlMedina Thanks again for replying. I really appreciate you sharing your time and expertise. I may have stumbled over the problem and solution myself. I have two candidates: I noticed that in the config file i'm using to set various parameters like AGOL itemid, file name, etc, the file name did not include the ".csv" extension. So, i included that info. And, I noticed that i had deleted the original source csv from AGOL. I think i read somewhere in the docs that the source csv file needed to be present for the overwrite to work (or something like that). So i deleted the hosted feature service, reuploaded the original csv file and published that. Since doing those two things, the code is working as expected with the service data being updated. Regardless of what the source of the problem was, I wonder why the overwrite() method returned success = True when the update didn't work. I guess that's a question for another thread. Thanks again for your help.

Hello @EarlMedina . Thanks for replying. Correct, the schema is not changing. What JSON could be the problem - the service's JSON? I'll poke around on community for some truncate/append examples and give those a whirl.

Hi There. I am trying to use the ArcGIS python API to overwrite an AGOL hosted feature table that i own. The process seems to work, i.e. the FeatureLayerCollection.manager.overwrite() method returns {'success': True}, but the data in the AGOL hosted table are not updated. The items detail page of the hosted feature table indicates that it was updated at the same time as my log file indicates that the overwrite() operation completed. So all indications are that the overwrite worked, except for the data. (from Item Details page) (from my log file) If i update the hosted table via the AGOL UI, the process works as expected - the new data are present in the table. The table was originally created by publishing a csv file to AGOL. The csv file i am using to overwrite the existing hosted table has the same name and schema as the original file. my conda environment is using arcgis v2.1.0.2. Any ideas what's going on? files_to_update = json.loads((settings.SURVEY_LOOKUP_TABLES_TO_UPDATE).replace('\n','')) for file in files_to_update: lookup_file = update_survey_lookup_file(settings.SURVEY_LOOKUP_FILES_LOCAL_SOURCE, file) lookup_table = gis.content.get(file['agolItemId']) lookup_collection = FeatureLayerCollection.fromitem(lookup_table) LOGGER.debug("Start to overwrite AGOL table with " + lookup_file) response = lookup_collection.manager.overwrite(lookup_file) LOGGER.debug("the response from the overwrite operation: " + str(response)) LOGGER.debug("Done with overwrite of AGOL table with " + lookup_file) lookup_table.update(item_properties = {"title" : file['agolTitle']})

Setting Tab order seems like basic functionality that really should be present whether the survey is built in Connect or the Web. Here's my use case: Two of the questions in my survey are: Wind Speed (number) and Wind Direction (select_one). The Wind Direction question follows the Wind Speed question. It is 'relevant' and appears if the Wind Speed value > 0 (there's no need for Wind Direction if there's no wind). The Wind Direction question is required when its relevant. The 'problem' i'm having is that the form's Tab Order doesn't seem to include the Wind Direction question. For example, when a user enters a value >0 in the Wind Speed question and hits 'enter' (the blue arrow button on the number pad that appears for numeric questions), the tab skips right over the Wind Direction question. A user has to navigate back to the Wind Direction question. It's not a tragic situation for sure, but it is annoying for the users. Ideally, hitting the blue button on the Wind Speed question would tab to the Wind Direction question and pop open the drop down list of Wind Direction values.

Two of the questions in my survey are: Wind Speed (number) and Wind Direction (select_one). The Wind Direction question follows the Wind Speed question. It is 'relevant' and appears if the Wind Speed value > 0. The Wind Direction question is required when its relevant. The 'problem' i'm having is that the form's Tab Order doesn't seem to include the Wind Direction question. For example, when a user enters a value >0 in the Wind Speed question and hits 'enter' (the blue arrow button on the number pad that appears for numeric questions), the tab skips right over the Wind Direction question. A user has to navigate back to the Wind Direction question. It's not a tragic situation for sure, but it is annoying for the users. Is there a way to force a Tab stop for a relevant question? Ideally, hitting the blue button on the Wind Speed question would tab to the Wind Direction question and pop open the drop down list of Wind Direction values. Thank you

‎03-14-2024

At the Dev Summit this week, all the Survey123 folks were super helpful. For this particular issue Zachary Sutherby ( @ZacharySutherby ) suggested the following which is working exactly as i needed (sorry for the screen shot but that's what i got for now).....

‎03-10-2024

Hey @abureaux . Thank you for your suggestion. That's a clever workaround that i think will get mostly what i was after.

‎03-08-2024

Hello @abureaux . Thank you for sharing your ideas. If i understand your suggestion correctly, in my case it doesn't seem feasible to do a calculate per option. My list of options are coming from an AGOL standalone table via the 'autocomplete search()' function, the options are dynamic with not infrequent changes to the underlying list of options, and there are upwards of 50 or so options. To me the suggested approach doesn't seem practical for the use case. Have you seen any additional documentation from Esri (or from other users) that gives details on how to construct a more complex 'where' clause when doing an 'autocomplete search()'?

‎03-07-2024

Hello. I'm using Survey123 Connect to build a survey where i ask users to select their top 3 preferences from a group of items. Each 'preference' question is a separate question, i.e. 'Choose your top preference', then 'Choose your second preference', etc. The 'group of items' is populated using the `autocomplete search()` functionality to return data from an AGOL hosted table. My goal is to prevent a user from selecting the same item in subsequent preference selections by removing the previously selected value(s) from the 'group of items'. For example, i don't want a user selecting, say Ice Cream as their favorite food in the 3 questions asking for their top 3 food types (although that would be my preferred selections!). So, if they chose Ice Cream in the first question, Ice Cream would not appear in the 'group of items' for the second and third questions. Esri docs say that for a nonspatial table, i can use 'contains' or 'matches' as search types. But, Is there a way to say 'does not match' or 'does not contain'. I tried putting a '!' in front of 'matches' but that didn't work And for the filter option its not clear how the filterText parameter should be formatted for a 'negative' filter. I have the same goal: to filter records so that rows where filterColumn does not equal a particular filterText value. Any suggestions?

‎01-19-2024

Hey @DougBrowning Thank you for your suggestions. When i shortened the field name that is referenced in the choices worksheet, i was able to republish the survey without that error. That approach seems much more simple that expanding the field size in the feature service. we've got many years of data in the service and i don't want to recreate/republish all of that. It seems like maybe the Esri team chould rethink either how the search() functionality is setup/configured within the xls form or reconsider the form validation process when search() is being used. It's reasonable that the length of a field name could be longer than the values going into the field. Or maybe its just me 😉

‎01-19-2024

i think you are on to something. Yes, the question is a select_one. I am using the 'search()' functionality to populate the field based on input from a previous question. And the 'search' column name used that gets set in the choices worksheet is longer than 10 characters. I'm gonna try shortening that to see what happens.

‎01-19-2024

I have a pre-existing survey that I've been using Survey Connect (v3.17.55) for updating . When i attempted to 'Publish' the survey with the update, I got an error message that one field length is too short (see attached screen shot). Because its a dev version of the survey, I opted to republish the survey. This resulted in creation of a new AGOL feature service to support the survey. The very next time I Published the survey, i got the same error message. Again i opted to republish. Again, the next time i tried to publish, i got the same error message. I seem stuck in some dark magic circle. Can you help me get out of that circle?

‎01-18-2024

Using a Calculate as the value of the searchText worked perfectly. I didn't have as much good look changing out the autocomplete appearance for minimal. The app behaved the same regardless of that setting. But I'm calling this a victory for now and moving on to the next hurdle. Thanks again for your help. It is super-appreciated!

‎01-17-2024

Hi @abureaux It has been a fun adventure learning more about the search() functionality. Thank you for pointing me in that direction. Broadly speaking, I think your suggestion will work fine. I am seeing two bits of functionality, though, that are a bit nettlesome. When the survey loads and before any Company is selected, all possible Work Order Numbers are available in the dropdown. Once a company is selected, the list is filtered as expected, but i'm a bit bothered by having all work order numbers present prior to selection. I certainly could hide the Work Order question until a Company is selected, but the question is 'foundational' to the survey and i'm a bit hesitant to hide/display the question depending on the state of the Company selection If i select a company, then make a Work Order Number selection and then clear the Company selection, the selected Work Order Number remains visible. Once i make a new Company selection, the selected work order number is cleared and all is as expected. I would expect the Work Order Number to be cleared if the Company selection is cleared Those two items aren't enough to prevent me from using the Search() functionality, but just troublesome enough to slightly irk me. Do you have any suggestions for making the Work Order Number list blank until, and only if, a company name is selected?

‎01-17-2024

Hey @abureaux Based on your suggestions I'm gonna take a deeper dive into this, but before i got lost in that I wanted to Thank You for your sharing your time and knowledge. I really appreciate it. I'll get back to you later with results from my fiddling around.

Online Status	Offline
Date Last Visited	Wednesday

My Ideas

Latest Contributions by Trippetoe

Re: FeatureLayerCollection manager overwrite() not working as expected

Re: FeatureLayerCollection manager overwrite() not working as expected

FeatureLayerCollection manager overwrite() not working as expected

Re: Add Tab Order to Survey123

Set tab order for relevant select_one questions

Re: Is there a way to do a 'negative' search \ filter with autocomplete search()?

Re: Is there a way to do a 'negative' search \ filter with autocomplete search()?

Re: Is there a way to do a 'negative' search \ filter with autocomplete search()?

Is there a way to do a 'negative' search \ filter with autocomplete search()?

Re: 'Field too short' error even after republishing survey

Re: 'Field too short' error even after republishing survey

'Field too short' error even after republishing survey

Re: Can i display a note based on the number of options in a filtered list?

Re: Can i display a note based on the number of options in a filtered list?

Re: Can i display a note based on the number of options in a filtered list?

Bug with edit Form Titles

Re: Can i display a note based on the number of op...

Search text in Hub pages

Near Me Widget: Option to hide or overwrite 'Close...

Re: Support for Google Analytics 4 Now Available i...