topic Re: Pulldata returning error message in ArcGIS Survey123 Questions

Pulldata returning error message

KendraStraub — Mon, 12 Feb 2018 20:32:20 GMT

I have loaded external data into the media folder in my Survey123 folder.

GRSM_species_list is the exact name of the csv in the media folder.

cover_lookup is another csv in the media folder.

I am not sure how to interpret the error message I am receiving. #

When I publish the form I get the following error message:

Error: Initialing Form...

External instance "GRSM_species_list" is empty.
FormLogicError: instance "cover_lookup" does not exist in model

Re: Pulldata returning error message

JohnathanHasthorpe — Tue, 13 Feb 2018 10:25:58 GMT

Hi Kendra

The form has a couple of issues:

1) You are using + instead of the concat() function. The webform does not support the use of + to create a string

2) The .csv has a column title with spaces in it - try updating it to be: GRSM_Scientific_Name_GRSM_Code_USDA_Code_USDA_Common_Name

Fix those two things and the form will run.

Thanks

John

Re: Pulldata returning error message

KendraStraub — Tue, 13 Feb 2018 19:44:19 GMT

Thanks Jonathan!

I am using + not to concatenate into a strong but as a simple calculation. Is the problem that the results of the calculation can't be displayed in a notes field?

It is odd because this survey, the same way it is, worked last spring but no longer works. Perhaps there have been updates that have affected these behaviors?

Thanks again,

Re: Pulldata returning error message

KendraStraub — Wed, 14 Feb 2018 17:28:29 GMT

Thanks again Jonathan. This solved the follow error:

External instance "GRSM_species_list" is empty.

I am still getting this error:

FormLogicError: instance "cover_lookup" does not exist in model

-No spaces in column headings

-Can't find any issues in the pulldata calculations that are using the cover_up csv

-cover_lookup.csv is in the media folder

Appreciate it!

Re: Pulldata returning error message

JohnathanHasthorpe — Sun, 18 Feb 2018 06:30:39 GMT

Hi Kendra

The thing that is causing this issue is the following:

int(pulldata('cover_lookup','value','cover',${T2_Range})) - note that there are a few examples of this in your survey.

This returns an integer, but you are using it to update a text question.

You should remove the int() statement - or use a integer or decimal question instead.

Please let me know if you need any further assistance with this.

Thanks
John

Re: Pulldata returning error message

KendraStraub — Tue, 20 Feb 2018 20:58:33 GMT

Hi John,

Your point makes sense. I understand that I was using an integer to populate a text field and why that doesn't make sure. Thanks.

I went ahead and tested both

-Changing all fields with int() to integer fields--> same error

-Leaving those fields as text and then removing int() from the calculation-->

I even went ahead and removed all of the fields with those troublesome calculations and then I still got the same error.

Thank you in advance for any help,

Re: Pulldata returning error message

JohnathanHasthorpe — Wed, 21 Feb 2018 07:03:07 GMT

Hi - Attached is the full working survey.

You can just unzip and copy into your my survey designs directory (C:\Users\XXXX\ArcGIS\My Survey Designs)

and publish from connect.

Please let me know how you get on

Thanks

John

Re: Pulldata returning error message

KendraStraub — Wed, 21 Feb 2018 20:04:23 GMT

Hi John,

Thanks for sending the updated form, very helpful. One remaining issue is that concat won't work in this instance. We don't want a concatenated string of values, we want to sum of several integers.

If we use concat we end up with, something like 30 + 40 = 03004000

This zipped version works in that is provides the sum of the values we are looking for. I experience no error in Survey123 Connect when testing, but when I publish, I get the same error: FormLogicError cover_lookup does not exist in your model.

Perhaps this means it will work in the iPad app, just not in the web app?

Re: Pulldata returning error message

JohnathanHasthorpe — Thu, 22 Feb 2018 00:00:09 GMT

Hi Kendra

You are right, we should not use concatenate to add numbers. I have fixed the xls and attached.

Here is the published survey: https://survey123.arcgis.com/share/8e2bc082e19d44beabc0ade8ffb7a13a it does work on the web.

Can you make sure you are using the complete survey (all files not just the xls) as I made edits to all files.

Also can you let me know what version of Connect you are using? As well as the web browser version.

You should also clear your browser cache just in case.

We will get this working for you!

Cheers

John

Re: Pulldata returning error message

KendraStraub — Thu, 22 Feb 2018 15:18:30 GMT

Hi John,

Thanks for sticking with me through these issues.

-I have cleared my browser cache

-I am using Google Chrome: Version 64.0.3282.167 (Official Build) (64-bit)

-I was using Survey 123 Connect 2.5.44. But I just updated to 2.6

Everything is looking great and working great in Connect.

I published it and it doesn't work (as we expected) in my browser. We will be testing on iPad soon. Will keep you posted.

Thanks so much!

Kendra

Re: Pulldata returning error message

JohnathanHasthorpe — Sun, 25 Feb 2018 01:55:25 GMT

Hi Kendra - are you able to load and submit to the following: https://survey123.arcgis.com/share/8e2bc082e19d44beabc0ade8ffb7a13a

Re: Pulldata returning error message

KendraStraub — Mon, 26 Feb 2018 15:59:37 GMT

Thank you for all of your help John! Everything works great! Thanks for sticking with me until it was resolved, much appreciated!

Re: Pulldata returning error message

WASHSECTOR — Thu, 31 May 2018 09:45:04 GMT

Hi,

I am having a different problem. It woks for some fields and for other it is not working or retrieving data from different fields !

Any suggestions ?

Mahdi.

Re: Pulldata returning error message

JohnathanHasthorpe — Mon, 04 Jun 2018 06:09:37 GMT

Hi Mahdi - can you share your survey form.xls? - I will publish it and take a look.

Thanks

John

Re: Pulldata returning error message

WASHSECTOR — Tue, 05 Jun 2018 14:19:41 GMT

Thank you Johnathan,

Attached is the xls form and the IAMP file (to be inserted in Media)

Re: Pulldata returning error message

WASHSECTOR — Tue, 05 Jun 2018 14:33:57 GMT

Thank you Johnathan Hasthorpe‌

xls form and the Media file in the link below

https://unicef-my.sharepoint.com/:f:/g/personal/mwehbi_unicef_org/Ep-vGqyow-VAliv-sgoyiH4BZZEwpgj6KV49A6u87A08Ew

Re: Pulldata returning error message

JohnathanHasthorpe — Thu, 07 Jun 2018 02:54:18 GMT

Hi Mahdi

I have taken a look at your survey and the issue looks to be that one of the column names in your external .csv contains both a comma and a question mark. The extra comma is breaking the .csv and the wrong values are being returned by the pulldata function. Updating the .csv should fix things.

Thanks

John

Re: Pulldata returning error message

WASHSECTOR — Fri, 23 Nov 2018 18:09:26 GMT

It works. Thank you

Re: Pulldata returning error message

WASHSECTOR — Fri, 23 Nov 2018 18:19:16 GMT

Hi Can you help me in the below:
It is possible to collect data using survey 123 for only missing fields in hosted feature layer using collect and not inbox.
Example:
I have a hosted feature layer having the fields (pcode1,name,length, width, location) collected using survey 123. (12-654,house,14,25,36.55 33.5) the first 5 fields now are filled.
today, i need to do another data collection for the same site. I added the fields (color,type,size) in the hosted feature layer and submission url in the new survey 123.
now i can go to inbox in the new form of survey 123 and inbox and find the pcode and update the fields already shown (color=black,etc..).
What i am asking is the following:
I need the collector go to the new form survey 123 and collect new data and add the following fields (pcode2, color, type, size) and send.
the survey 123 should look for pcode1 = pcode 2 and fill the missing data.
The new enumerators should not be allowed to see inbox or send items.
Thank you,
waiting your reply.

Johnathan Hasthorpe's Blog‌
Johnathan Hasthorpe

Re: Pulldata returning error message

JohnathanHasthorpe — Mon, 03 Dec 2018 05:23:27 GMT

Hi Mahdi

If you wanted to populate a new survey with existing data you would need to use the pulldata() function. You could do a lookup based on the pcode1 value to return the values that you need and populate the form. The only issue is that you would need to have the existing data available in a .csv file. If there were updates to the underlying data you would need to update .csv and then republish the survey. Please see: Use existing data in your survey - the pulldata( ) function for more information.

Thanks
John