topic Re: Survey123 PullData function working in Browser, but in not Mobile App in ArcGIS Survey123 Questions

Survey123 PullData function working in Browser, but in not Mobile App

BrianHiller — Wed, 11 Jul 2018 10:49:42 GMT

I have a survey123 form published that's using the pulldata function to select data from a .csv file and calculate the value/fill-in a few fields based on the results of a select one field. The survey works as expected when accessing the survey from a browser, but the pulldata function does not work on a mobile device (I have tested on Windows 10 and iOS).

Has anyone seen this before, I'm surprised this would work in a browser, but not in the survey123 mobile application.

Re: Survey123 PullData function working in Browser, but in not Mobile App

Anonymous User — Fri, 13 Jul 2018 17:03:40 GMT

Hi Brian,

Can you please provide a copy of the xlsx file you are using for your survey so we can take a closer look.

Phil.

Re: Survey123 PullData function working in Browser, but in not Mobile App

BrianHiller — Fri, 13 Jul 2018 20:10:40 GMT

Can you send me your email address so i can send the file via email?

Brian

Re: Survey123 PullData function working in Browser, but in not Mobile App

KimQuach — Mon, 16 Jul 2018 02:21:05 GMT

Hi Brian/Philip,

I also have the same problem using the Survey123 app.

Kim.

Re: Survey123 PullData function working in Browser, but in not Mobile App

BrianHiller — Mon, 16 Jul 2018 13:57:21 GMT

my email is behiller@burnsmcd.com, please send me your email and I'll pass along the .xlsx file.

Brian

Re: Survey123 PullData function working in Browser, but in not Mobile App

Anonymous User — Wed, 18 Jul 2018 06:27:14 GMT

Thanks, have just sent you an email.

Re: Survey123 PullData function working in Browser, but in not Mobile App

Anonymous User — Mon, 23 Jul 2018 02:52:32 GMT

Hi Brian,

I had a look at your survey today and the external csv file being used for pulldata(). The reason pulldata() is not working is because it contains commas (,) in the data in the csv. This will break the pulldata() function as we do not currently support commas in the csv for use with pulldata(). We have an open bug for this issue and plan to fix it in a future release, however no set timeframe yet. In the meantime you need to remove the commas from your csv file for pulldata() to work correctly.

If you open the csv in a text editor you will see what the commas do to the file, extra double quotations are added to the file where commas exist, which are also not detected by the pulldata() function correctly.

Phil.

Re: Survey123 PullData function working in Browser, but in not Mobile App

Anonymous User — Mon, 23 Jul 2018 02:54:07 GMT

Hi Kim,

See my reply to Brian in this thread. Do you have commas in the data in your external CSV file being used for pulldata(), if so you need to remove them.

Phil.

Re: Survey123 PullData function working in Browser, but in not Mobile App

KimQuach — Mon, 23 Jul 2018 03:01:24 GMT

Hi Phil,

No I don't have any commas in my csv. If I open the file in a text editor, the commas only exists as column separators. Did you receive my csv/excel file from Ben?

Kim.

Re: Survey123 PullData function working in Browser, but in not Mobile App

Anonymous User — Mon, 23 Jul 2018 03:45:30 GMT

No, I don't have a copy of your external csv file, can you please send to me? Do you have any other special characters in the csv?

Re: Survey123 PullData function working in Browser, but in not Mobile App

KimQuach — Tue, 14 Aug 2018 00:51:15 GMT

Hi,

Can I have your email address so I can email you the file? Sorry I thought I did, but checked my sent queue and did not have an email address for you.

thanks,

Kim.

Re: Survey123 PullData function working in Browser, but in not Mobile App

BrianHiller — Tue, 14 Aug 2018 02:44:29 GMT

Here you go:

behiller@burnsmd.com<mailto:behiller@burnsmd.com>

Brian

Re: Survey123 PullData function working in Browser, but in not Mobile App

Anonymous User — Tue, 14 Aug 2018 03:01:07 GMT

Hi Kim,

I just sent you a private message with my details.

Phil.

Re: Survey123 PullData function working in Browser, but in not Mobile App

JeffWard — Mon, 15 Oct 2018 20:12:38 GMT

Phil,

I'm running into this problem as well. I have gone through all of my records in the CSV and taken out any that contain commas. I have also taken out any special characters and it still won't auto-fill.

Thanks,

Jeff