topic Update csv pulldata file name in ArcGIS Survey123 Questions

Update csv pulldata file name

ZenMasterZeke — Wed, 22 Jun 2022 16:32:14 GMT

I use a csv file in the pulldata function to retrieve address data for a site. In development I named this file address_sample.csv. There are over 80 sites however, with multiple sites possibly being surveyed at any given time, so I'd like the file to be named after them, something like chicago_address.csv, liverpool_address.csv, nairobi_address.csv, etc. This would involve somehow dynamically changing the file name in the pulldata function, as far as I can tell. Is this possible? Thanks.

Re: Update csv pulldata file name

DougBrowning — Wed, 22 Jun 2022 16:45:39 GMT

It works for me if I give it a field. I have the calc for the name in the field then give that to pulldata.

pulldata(${SpeciesListName}, ${WetlandIndicatorStatusColumn}, "name", ${Species})

Maybe you added .csv to it? You should not have it be just the name. And note it IS case sensitive.

Hope that helps

Re: Update csv pulldata file name

ZenMasterZeke — Wed, 22 Jun 2022 19:03:22 GMT

Not using the .csv extension. Will try putting it into a field like you suggest. Would be nice if S123 could read the media folder and select a csv file with 'address' in the file name.

Re: Update csv pulldata file name

DougBrowning — Wed, 22 Jun 2022 19:44:16 GMT

Yes that is what my form does. I pass a state in from Field Maps then it selects the right species list to give them using a calc.

It for sure works. Try and field and make sure the case is correct.