topic Re: Two CSVs in my media folder for the pull data functionality? in ArcGIS Survey123 Questions

Two CSVs in my media folder for the pull data functionality?

ANRGIS — Wed, 11 Apr 2018 14:00:34 GMT

As soon as I add another pulldata calculation into my survey, using another csv, it stops working. Can I have two csvs in my media folder? I'm using Survey123 Connect.

Re: Two CSVs in my media folder for the pull data functionality?

AldousTsang — Wed, 11 Apr 2018 14:54:45 GMT

Can you post your calculation for your pulldata?

You can have multiple csvs in the media folder.

here's an example of one I use:

if(selected(${agency},'Beaumont'),pulldata('Beaumont','WDID','CI_Key',${Addr}),pulldata('CommInd','WDID','CI_Key',${Addr}))

I have Beaumont.csv and CommInd.csv in my media folder

Re: Two CSVs in my media folder for the pull data functionality?

JamesTedrick — Wed, 11 Apr 2018 15:57:42 GMT

Yes, Survey123 supports multiple CSV files for pulldata operations. That being said, there is a best practice to ensure reliable operation. Pulldata functions work best when they are directly populating a question (without being within a function as in aldoustsang‌'s example); any function/evaluation work should occur in a later question. This is due to how the software that translates the XLSForm file into the XForm file (which is what is actually used by Survey123 field app) identifies and processes the pulldata function.

Re: Two CSVs in my media folder for the pull data functionality?

ANRGIS — Wed, 11 Apr 2018 16:27:25 GMT

I zipped up my survey and CSVs and attached. Must be something else then? I would appreciate you taking a look. I suspect my pull data can't work with a select_one maybe? Thanks.

Re: Two CSVs in my media folder for the pull data functionality?

JamesTedrick — Wed, 11 Apr 2018 18:38:26 GMT

Hi,

The issue is the autocomplete appearance on the select_one - while 2.7 supports calculated values, it does not support it for the autocomplete option yet. Changing the autocomplete to a minimal will resolve the problem.