idea S123 online repeat consolidation for excel and shapefile export in ArcGIS Survey123 Ideas

S123 online repeat consolidation for excel and shapefile export

NathanDulfon — Mon, 31 Dec 2018 04:50:14 GMT

It would be great if exported excel and shapefile were cleaner and easier to use... by that I mean in one table or a single shapefile... instead of multiple tabs or multiple shapefiles...

The excel export has many tabs for each repeat... which makes a lot of tail end work consolidating the tabs into one sheet... can a consolidation option be added? The problem is consistent with shapefiles as well.... when using repeats... a shapefile is created for each repeat... I have to process the shapefiles in arcgis using merge... which is an extra step...

Please consider my idea....

Re: S123 online repeat consolidation for excel and shapefile export

JamesTedrick — Tue, 05 Feb 2019 21:10:06 GMT

Hi Nathan,

How would you envision multiple repeat records being present in the excel sheet? With duplicate copies of the parent record data?

Re: S123 online repeat consolidation for excel and shapefile export

NathanDulfon — Tue, 05 Feb 2019 23:16:25 GMT

Hello James,

Consolidating all repeats into one table…. And all repeats into one shapefile would simplify the outputs for analysis in my line of work….

See the attached for an example…

Basically, I collect plant data from frames along transects at a site…

So… being able to calculate cover by species at the site is the end goal….

Currently it takes time and effort to extrapolate the information from multiple tabs (repeats) in the excel output from a S123 visit….

If the data was in one table… and one shapefile…. Life would be much easier…..

It would also be awesome to have an answer repeated from one repeat to the next…. If a box was checked or something….

That way I would not have to enter in plant species names on every frame (repeat)…..

I thank you for taking interest in the matter… and I hope something comes out of the interaction….

If you have any questions… please do not hesitate to ask….

Re: S123 online repeat consolidation for excel and shapefile export

JamesTedrick — Wed, 06 Feb 2019 16:46:34 GMT

Hi Nathan,

Unfortunately, your attachment did not come through (attachments are not supported in ideas.arcgis.com). Survey123 uses ArcGIS Online capabilities for table export; while we cannot directly alter the export capabilities, we can bring feedback to try to improve it.

Re: S123 online repeat consolidation for excel and shapefile export

NathanDulfon — Wed, 06 Feb 2019 17:31:39 GMT

see above... I added a .png of the excel out put that is desirable....

also... you don't have to change the current output.... just add a single tab that would conglomerate the repeat information....

Re: S123 online repeat consolidation for excel and shapefile export

NathanDulfon — Mon, 11 Mar 2019 23:43:13 GMT

James... did you see the above message?

Just checking in... because I did not get a response....

Re: S123 online repeat consolidation for excel and shapefile export

JamesTedrick — Mon, 11 Mar 2019 23:45:52 GMT

Hi Nathan,

Yes, I did see the response- apologies for the delay in responding. Thanks for providing the added detail.

Re: S123 online repeat consolidation for excel and shapefile export

NathanDulfon — Mon, 11 Mar 2019 23:48:17 GMT

You da man!