topic Re: Can I bulk upload csv data into existing form on Survey123 in ArcGIS Survey123 Questions

Can I bulk upload csv data into existing form on Survey123

Oliver_Burdekin — Wed, 16 Aug 2017 14:40:04 GMT

I have survey data from an old survey (not created nor collected using Survey123). If I would like to port this survey over to Survey123 I believe I can upload the form itself as it was designed in XLSForm. However, can I bulk upload the survey responses we have already collected? I realise the format is different but can convert it to match the csv output of Survey123 data.

Re: Can I bulk upload csv data into existing form on Survey123

JamesTedrick — Wed, 16 Aug 2017 15:30:17 GMT

Hi Olivier,

This can be done most easily via ArcGIS Pro - that is simply using the Append geoprocessing tool and specifying which field in the original table matches which field in the feature service that is created for Survey123. A script could also be created using Python or other language and working with the REST API directly (the appropriate operation is ApplyEdits - ArcGIS REST API ).

Re: Can I bulk upload csv data into existing form on Survey123

Ness2 — Thu, 01 Mar 2018 01:01:22 GMT

Hi James,

I am attempting this process however the Append tool in Pro is demanding a featureclass, table or raster as the target data set. It is not accepting feature services. Any suggestions?

Thanks,

Re: Can I bulk upload csv data into existing form on Survey123

JamesTedrick — Tue, 27 Mar 2018 21:37:22 GMT

Hi Vanessa,

That's interesting- I know that I've appended to a feature service before in Pro. Could you try using the Append tools in ArcGIS Online - see What’s new with hosted feature layers: Getting to know Append Part 1 (December 2017) | ArcGIS Blog?