topic Re: pulldata() and select_one_from_file from linked content CSV in web form in ArcGIS Survey123 Questions

pulldata() and select_one_from_file from linked content CSV in web form

MichaelBrown4 — Thu, 25 Mar 2021 17:21:07 GMT

I'm trying to use a select_one_from_file and pulldata() with a linked content CSV hosted in ArcGIS Enterprise and I'm finding that the web form is not reflecting updates to the CSV file. Is this functionality possible? If so, is there a certain way I need to configure this to work? I am using the latest version of Survey123 (3.12). I can only get the web form to show the changes when I go to connect and choose to download the linked content CSV and then re-publish the survey.

Any help would be greatly appreciated.

Thanks in advance!

Mike

Re: pulldata() and select_one_from_file from linked content CSV in web form

BrettStokes — Fri, 26 Mar 2021 06:24:48 GMT

Hi Mike,

Linked Content CSV is not yet supported in the webapp. We have been working on this and while I can't promise anything, it is looking likely to be supported in the next release (3.13). In the meantime, I will get our documentation updated with a known limitation note. Thanks very much for bringing this to our attention.

Brett

Re: pulldata() and select_one_from_file from linked content CSV in web form

MichaelBrown4 — Fri, 26 Mar 2021 14:32:16 GMT

Thanks for the info on this. In the meantime, I should be able to use the Python code I've seen posted to update the Media folder CSV file correct?

Thanks again,

Mike

Re: pulldata() and select_one_from_file from linked content CSV in web form

IsmaelChivite — Fri, 26 Mar 2021 18:39:12 GMT

@MichaelBrown4 Correct on updating CSV media with Python. If you can wait until the next release (May), you could also consider populating your list using a query to a feature layer as shown here: https://earlyadopter.esri.com/project/article/item.html?cap=e69ef91f45744b98882c651f7b518eb7&arttypeid={5a8e51ed-4a87-43fe-a67d-2b7829af130f}&artid={F91C2CD4-2A42-4CA3-AC7D-755A5C34F811} When working with big lists in the web, select_one_from_file may not be the best option as it forces the web app to download the entire list every time the form loads. The ideal solution is dynamic lists. This is still in the works for the web app, but it is planned for the next update.

Re: pulldata() and select_one_from_file from linked content CSV in web form

MichaelBrown4 — Fri, 26 Mar 2021 19:33:37 GMT

Awesome, thank you for the note on this. I've been eagerly awaiting using the feature layer for dynamic lists. I have many forms that are "identical" across many projects in a program I lead and we have to manually manage the pick lists for each form individually. Many times, the different forms have the same pick list (i.e. people's names) and when a new list item is added/removed/modified, it's a lot of re-publishing and coordination...inherently creating quality issues as things can get missed or incorrectly executed.

My hope is to have a feature layer(s) where we can store all the list values, have a Survey123 form that manages said values, and ultimately have our forms read dynamically from that. Then our users can manage what values show in their choice lists themselves and we can use filters/queries on the feature layer to align to the appropriate project.

Can't wait for May!

Re: pulldata() and select_one_from_file from linked content CSV in web form

JulietK — Mon, 03 May 2021 21:47:54 GMT

Hi Brett, does this mean that pulldata is not supported at all in web forms?

Thank you

Juliet

Re: pulldata() and select_one_from_file from linked content CSV in web form

ahargreaves_FW — Thu, 20 Oct 2022 17:47:37 GMT

Hello @IsmaelChivite and @BrettStokes . Can you tell me when the use of select_one_from_file in the web browser will be supported?

Re: pulldata() and select_one_from_file from linked content CSV in web form

IsmaelChivite — Thu, 20 Oct 2022 18:23:55 GMT

@ahargreaves_FW @MichaelBrown4 select_from_file and linked content is now implemented in the web app. Make sure you publish your survey with Survey123 Connect 3.15 or newer. Thanks!

Re: pulldata() and select_one_from_file from linked content CSV in web form

ahargreaves_FW — Thu, 20 Oct 2022 20:34:44 GMT

Thanks @IsmaelChivite but I published with v3.15.178 and have the same issue....

Re: pulldata() and select_one_from_file from linked content CSV in web form

IsmaelChivite — Thu, 20 Oct 2022 21:42:21 GMT

@ahargreaves_FW Please share XLSForm with the corresponding CSV

Re: pulldata() and select_one_from_file from linked content CSV in web form

ahargreaves_FW — Fri, 21 Oct 2022 14:40:15 GMT

@IsmaelChivite DM sent containing XLS and associated CSV.

However, some more digging into this reveals that using the select_one_from_file was preventing the form opening correctly in the browser and giving me this error. The issue was that the name of my CSV contained a "_". Renaming it to remove the "_" resolved the error and fully populated the select_one_from_file