I have a dataset of 115 rows x 175 columns collected initially with Google Forms. We had one question for the neighborhood of the user.
Then we migrated our form to Survey123, same questions.
Now we need to append to Survey123 the date we collected in Google Forms. For the neighborhood question, we went row by row changing the "neighborhood" to proper coordinates format.
I followed the instructions of the help article "How To: Append data to a Survey123 for ArcGIS survey from an existing survey with related tables", however, I can't apply the update uploading the data in Excel format.
I get this error: "Error. Could not append data to layer."
Before trying to append the data, I verified the schema and both are identical. The Append Data prompt successfully detects that all fields from Survey123 have a match on my local file, however, I get the error all times.
I tried the suggestion from this thread and I disabled the sync option, however, still not working.
I appreciate if you can provide me several workarounds to merge both databases.
¡Thanks in advance!
Unfortunately, I don't have a solution for this issue, but I wanted to say thank you for linking "How to Append data to a Survey123" Esri technical article because it was very helpful to me for appending data between Survey123s in AGO. Good luck!