S123 Extra rows appearing

294
2
Jump to solution
06-29-2021 09:38 PM
CharlotteSmith4
New Contributor II

ArcGIS Survey123 Connect v3.12: xlxs form has a repeat section. Extra ParentGlobalID are being generated. For example 30 observations made, 185 ParentGlobalIDs appear each with unique GlobalID (in Individual download)

0 Kudos
1 Solution

Accepted Solutions
DougBrowning
MVP Notable Contributor

I am getting this with nested repeats.  I get a lot of them.  You are not using nested repeats so it may be the geopoint that is doing it according to the posts.

See https://community.esri.com/t5/arcgis-survey123-questions/blank-rows-in-hidden-repeat/td-p/801750 

Also here is an older one that is not nested repeats https://community.esri.com/t5/arcgis-survey123-questions/nested-repeat-creating-blank-records/td-p/7...

 

View solution in original post

0 Kudos
2 Replies
DougBrowning
MVP Notable Contributor

I am getting this with nested repeats.  I get a lot of them.  You are not using nested repeats so it may be the geopoint that is doing it according to the posts.

See https://community.esri.com/t5/arcgis-survey123-questions/blank-rows-in-hidden-repeat/td-p/801750 

Also here is an older one that is not nested repeats https://community.esri.com/t5/arcgis-survey123-questions/nested-repeat-creating-blank-records/td-p/7...

 

0 Kudos
CharlotteSmith4
New Contributor II

Thank you for the response and links. Actually as it turned out the solution was quite amazing. I thought something was wrong with the data because there were over 3000 observations and I only have 66 students who I thought were collecting 30 observations each. In class today I told them I was trying to figure out why there were so many duplicate observations in our database because I expected less than 2000 and am seeing over 3000. A student said "Professor Smith, you told us 30 was the minimum and we should keep collecting for a full hour. I entered 187 observations." So I asked who collected more than 30 observations and all but 2 students said they did. There is an easy way to check how many surveys were logged into their mobile-App, so we made a quick Google Sheet, and in fact most students collected a lot more than 30.  So I was completely wrong, there's no problem with Survey123, the xlsx form, or the data, the problem was me not realizing that the students were fully committed to the project, and how lucky I am to be teaching UC Berkeley students.