I have created a survey which is now being used to collect asset condition data - it's replacing an Excel survey form and has been well received.
I'm now trying to append some historical survey data to the Survey123 Feature Class so that the users can see all survey data in the same place. However I'm struggling to append records to a Repeat table while maintaining the relationship with the parent record - any help in doing this appreciated.
My workflow so far is:
I'm failing at point 6 - although the parentglobalid field name is correct in the csv it is not automatically mapped in the field mappings, and when I manually map it the append operation fails with an 'Error - Unable to append data' message. If I don't manually map the parentglobalid the append works but there is no relationship to the parent record.
Any thoughts on what I'm doing wrong?
If parentglobalid is set to a GlobalID type that is system managed and you cannot change it or append into it. You could try using Pro and set the new Preserve GlobalID option. Not sure if that works on Append but it may.
For me I use my own key fields and my own relationship classes. Then i can edit them all I want.