AnsweredAssumed Answered

How do I make a new Survey123 schema & add existing data while maintaining related table connectivity

Question asked by HelenJohnson on Dec 18, 2019
Latest reply on Dec 19, 2019 by opdcrimeanalysis

I have a survey that has five parts consisting of a parent point layer and its four related items (three related tables and one related feature class).  It is hosted in AGOL.  We have been using this survey for about seven months and have hundreds of data points collected.  I was recently asked to update the survey to add a few questions.  I easily used Survey123 Connect to create a new survey based on the old one, made the required updates, and published.  Now I can find no way to load the existing data into my new blank hosted features classes and tables while maintaining the relationship.  If I append data into the feature classes, it fails with a 99999 error if I select 'preserve globalid' in the environments.  If I don't select 'preserve globalid', then the relationship based on globalid is lost.

 

Is there a trick to pulling old data into a new schema while maintaining the globalids? And if not, is there a way to force the survey123 globalid fields to be GUID instead of globalid, since that is a little more flexible?

 

Thanks!

Outcomes