Send Error: No mapping exists

Marie-AngeFournier-Beck · ‎08-26-2022

Hi there - I'm hoping someone can help! My team and I (so creator and field workers) are getting the same error when trying to send a survey created in Survey123 Connect. From other posts of I've read, this type of error could be from multiple geopoints/geolocations in one survey or feature layer... but this isn't the case here. Permissions for creating and editing exists for all organisation members.
I'm super new to S123 Connect, so I'd appreciate any info if someone out there can spot if I've created the error in the xls form. Please see attached.

Thank you!

LaurenceTait · ‎08-29-2022

Luckily there should be a really simple way to solve this problem.

Since the data in "plot_coords_bcws" is (at best) identical to the data in "plot_coordinates", it is completely redundant and can be discarded with no loss.

That means you can set the [bind::esri:fieldType] column for "plot_coords_bcws" to "null" without losing anything. If you do that, the completed surveys won't even try to send the data in that field, and if they don't send it, they won't check it for validity and so they won't refuse to send because the data doesn't match the field type.

So, in theory, you need to:

1) Set the [bind::esri:fieldType] column to "null"

2) Republish the survey

3) Update the survey on all phones/tablets

4) Resubmit all surveys.

======

PS. When you have uploaded all your existing surveys, change the formula for "plot_coords_bcws" to:

concat(pulldata("@geopoint", ${plot_coordinates},"y")) + ' ,' + (pulldata("@geopoint", ${plot_coordinates},"x"))

I'd still leave the field type set to null, but that formula will produce the result you want in the tablet app.

View solution in original post

IsmaelChivite · ‎08-27-2022

@Marie-AngeFournier-Beck No bad for your first survey! The problem is in question "plot_coords_bcws". Have a look at the screenshot below: Your calculation is copying the value of a geopoint straight into a note question. When the data is submitted, ArcGIS rejects the record because a geopoint object cannot be stored in a text field. The error Survey123 gets back from ArcGIS is not very informative, but that is what is going on.

A couple of suggestions:

Technically, you are not required to set a value to the name column for a note. In fact, you rarely want to do that. See details in this blog. If you leave the name column empty for your plot_coords_bcws question, your form will submit correctly. You may want to do that for the two prior questions as well.
Now, if you really want to display the coordinates as text, I suggest you change the calculation to string(${plot_coordinates})

I am attaching here the updated survey. I also upgraded your XLSForm template to the latest version and added an instance name.

One more thing. I think this survey begs for you to store the horizontal accuracy of the reported location. You can do that easily with a hidden question. See details here.

Again, really nice job. Superb survey for being a newbie!

Marie-AngeFournier-Beck · ‎08-28-2022

Thank you so much @IsmaelChivite for the guidance and work you've done to clean up my form.
Since we have been unsuccessful in uploading/sending the data already collected, I can't quite use your form (all data will be lost). Because the field techs are working away, I don't have access to their tablets. So, for now, I need to keep the form as close to the old one as possible - if possible?

I've tried simply deleting row 69 (plot_coords_bcws) completely as it really isn't necessary. I've also removed the name fields for the additional note type fields I had. However, it still won't send. I get the same error... any more thoughts!?

Thanks again for your help.
Marie

IsmaelChivite · ‎08-29-2022

No more thoughts from my end. The next step should be to get with an Esri Tech Support analyst so this can be looked at through a screen sharing session. I do not think we can do much more via Esri Community.

LaurenceTait · ‎08-29-2022