topic Re: pulldata function not working in survey in ArcGIS Survey123 Questions

pulldata function not working in survey

dwold — Mon, 01 May 2023 16:41:13 GMT

I am trying to pull data from a CSV file in my media folder. However, the survey is blank where that information should appear. Is my pulldata statement not correct?

Form:

CSV lookup table:

Survey:

Re: pulldata function not working in survey

DougBrowning — Mon, 01 May 2023 17:01:54 GMT

I would start by checking your csv in notepad and not excel. You have trailing and leading commas in your data csv which can often cause issues since it messes up the commas used to separate values. In general commas and csv do not mix well. Remove them or make sure your CSV is quoting them properly.

Also you have a field called time but that is a reserved word (see the tab for that) and it should have gave you a green box mark on that one. Looks like you edited the excel sheet formatting and possibly the formulas behind that. I would not edit the excel and make sure to always use Paste Values or all the validation gets messed up.

Oh and filter is a reserved word also so not sure what that will do.

Hope that does it.

Re: pulldata function not working in survey

dwold — Mon, 01 May 2023 18:01:32 GMT

@DougBrowning thanks for those suggestions., I appreciate it. I stripped out all the commas and periods in the csv table. Changed time to time_frame and filter to filt. I've attached my CSV file. Verified column F in CSV table is a value, not an expression. Still getting no info to display on the survey. Do you see anything else that I am doing wrong/missing?

Form:

CSV:

Re: pulldata function not working in survey

DougBrowning — Mon, 01 May 2023 18:06:08 GMT

Can you post the form also? Also why not just use jurisdiction column?

Re: pulldata function not working in survey

dwold — Mon, 01 May 2023 18:41:32 GMT

@DougBrowning

I've attached the form. The CSV table I will be using has 340+ rows not 6. Can I still only use the jurisdiction column with that many rows? I've attached what I intend to use as my final CSV file. The one I previously attached was a dumbed-down version.

Thanks for taking a look.

Re: pulldata function not working in survey

DougBrowning — Mon, 01 May 2023 21:34:18 GMT

Did you test all or just some options. I see in the csv that some values like City of Seattle have an extra space at the end of the value. Emergency Management in the form list has it also. A bunch of agency_type_king list has the extra spaces. core_capability list also. Gotta clean up all of those.
That could be it. Copying from word does this a lot and burns me on the reg.

Re: pulldata function not working in survey

dwold — Tue, 02 May 2023 13:57:36 GMT

Does having special characters in the choice list do any harm? Firefighting/SAR/HazMat or Finance & Administrative Services?

Re: pulldata function not working in survey

DougBrowning — Tue, 02 May 2023 14:19:03 GMT

I do not love it but I have got them to work I think. It is probably the extra spaces that has got me before.

Re: pulldata function not working in survey

dwold — Tue, 02 May 2023 22:49:57 GMT

Removing the extra spaces worked! Thanks again!