topic Not able to pull data from csv file into the survey drop down question in ArcGIS Survey123 Questions

Not able to pull data from csv file into the survey drop down question

Shubhreet1 — Sat, 15 Oct 2022 20:37:55 GMT

I am new to survey 123. I am trying to pull data using pulldata() function from a csv file into my survey but after adding the pulldata() functions and saving the form , I do not see any corresponding changes in my form.

I receive the following error on updating the form: b'ODK Validate errors:\n>> XForm is invalid. See above for the errors.\norg.javarosa.xform.parse.XFormParseException: Invalid Calculate for the bind attached

Please see the following pictures for reference. On selecting the option for 'Name of the Personal Care...', I do not see the information for region, prime contact and email. Could anyone please assist me.

Thank you in advance.

Re: Not able to pull data from csv file into the survey drop down question

ChristopherCounsell — Mon, 17 Oct 2022 03:27:21 GMT

For calculations, fields (name column) should be referred to as ${fieldname} not ${fieldname)

Try changing the calculation to refer to the field as ${name_of_the_personal_care_home}

Re: Not able to pull data from csv file into the survey drop down question

CarissaPhantom — Mon, 17 Oct 2022 15:20:17 GMT

You mentioned you are new to Survey123, and I'd like to share the best beginner hack out there.

Build your survey incrementally.

Add your notes, then the select_one and PUBLISH to make sure those work first.

Now play with the Pull() code, until you get it to work, and the PUBLISH.

Now copy and paste the working code to the next fields and change the pieces that need to be changed.

Re: Not able to pull data from csv file into the survey drop down question

Shubhreet1 — Thu, 20 Oct 2022 17:54:41 GMT

Thank you Magisian. The error you detected did help me sort the things out.

Re: Not able to pull data from csv file into the survey drop down question

CarissaPhantom — Wed, 23 Nov 2022 20:12:17 GMT

@MichelleWilliamsERM