topic Re: How to view data in repeat fields. in ArcGIS Survey123 Questions

How to view data in repeat fields.

JonathanPendleton — Tue, 17 May 2016 18:14:34 GMT

I have a survey123 form with five repeat groups. The only why I have been able to view the data in the repeat groups is to download the CSV files. However I get five CSV files from the one survey form (One for each repeat group). The data is really cumbersome to work with and understand in this manner. Is there a better way to view this data? If not, will there be a better way to view data in repeated groups in the future? Ideally, I would like to be able to view the data from the repeated fields on the "data" portion of the website (The page with the map and geo-points with the table under it). Would I be better off using some type of excel macro to merge the CSV files?

Re: How to view data in repeat fields.

IsmaelChivite — Wed, 18 May 2016 05:10:18 GMT

Hi Jonathan Pendleton We just added support to view related information in the survey123.arcgis.com web site. Make sure you clear your browser cache before you try:

1- Go into survey123.arcgis.com and login

2- Click on your survey and go to the data tab

3- Click on the row you are interested (in the table) and your related records will show at the bottom

If things do not work for you, please send your XLS file along with an export of your data in file geodatabase format so we can give it a try. If you do not want to attach your data to a comment in GeoNet, please send the XLS file and FileGDB to us at survey123@esri.com referencing this thread (so we can have some context). Thanks a lot.

Re: How to view data in repeat fields.

JonathanPendleton — Wed, 18 May 2016 16:44:10 GMT

Ismael,

This solution did not work for me. I followed all three of your steps including clearing my browser cache. All I get at the bottom of the data page is redundant data from my first repeat group called "secondary". I have attached the files you asked for, along with a screenshot of the type of data I am seeing at the bottom of the page.

Thanks,
Jonathan Pendleton

Re: How to view data in repeat fields.

RogerYoung1 — Wed, 18 May 2016 19:52:58 GMT

Jonathan,

If you have MS Access you can import the tables into an Access DB, set up the relationships and create a form to view the data in about 15 minutes (unless you have additional attachments, then it gets a little ugly). It's a quick way to be able to work with your data.

Re: How to view data in repeat fields.

IsmaelChivite — Wed, 18 May 2016 23:53:24 GMT

Thanks Roger. We will look into this. The screenshot helps a lot understanding the issue, and the data also helps quite a bit.

While we resolve the data duplication in the different repeats, you can try to download the data as Roger suggests above.

If you want to get the images out, you may also want to try the Python script referenced in this blog post: Downloading data captured with Survey123 for ArcGIS

Re: How to view data in repeat fields.

IsmaelChivite — Thu, 19 May 2016 01:21:53 GMT

Jonathan Pendleton It looks like the issue with the duplicates may be due to a badly-formed feature service. Before the 1.4 release, Survey123 Connect for ArcGIS was not uniquely registering related tables. This was not an issue in Surveys with a single repeat, but in cases like yours, where you have multiple, it is an issue. I wanted to ask you to use Survey123 Connect for ArcGIS version 1.4.30 to publish your XLS file again. Then populate a couple of entries with the field app and go back to the web site to check if the data is being duplicated. I did some testing with your own XLS file and I got no duplication of data in the repeats when using 1.4.

Re: How to view data in repeat fields.

JonathanPendleton — Thu, 19 May 2016 16:28:49 GMT

Thank you very much Ismael and Roger! This fixed my issue. The extra info you both provided will definitely prove useful.

Re: How to view data in repeat fields.

Pauline_Low_Pui_Ling — Mon, 02 Mar 2020 07:16:42 GMT

Hi there,

Was wondering if anyone could access the data in repeat fields of survey123 using Python API? I always managed to get the object ID for the repeat fields but could not access the row data for each of the repeat fields...

Hope to hear from anyone who has managed to do it.

Thanks,

Pauline

Re: How to view data in repeat fields.

DougBrowning — Mon, 02 Mar 2020 15:02:02 GMT

Are you calling the {relationship/0/field} items? If so they only give you count, sum, min max, etc of the field. They do not return data just a summary.

I do it with Arcade with a query to the other layers. Does not work offline in Collector yet but in web maps no problem.

https://community.esri.com/thread/246159-any-plans-to-let-collector-see-123-data-while-offline

You could do something similar in the API. Basically do your own lookup query with the Key.

Hope that helps