Best workflow?

[LaurieWilliams]

I'm getting ready to prep a series of Survey123 apps for our upcoming summer field season. I will want to pull the survey data into SDE at some point. What is the best work flow - create the Survey123 forms first (and start collecting data), or create the empty feature classes in SDE? I'm concerned about field types translating correctly - I have a variety of string, integer, long, and date  fields.

[JohnathanHasthorpe]

Hi Laurie 

Can you share a little info on your setup?

Do you have a Portal federated server that points to your SDE. Or are you planning to collect your data in ArcGIS Online and then download it?

Thanks

John

[LaurieWilliams]

Hi john,

We'll be collecting in AGOL and downloading to SDE. I do not believe we have/use Portal.

Thanks!

Laurie

[JohnathanHasthorpe]

In that case you should create your forms in Survey123.

Once your data is collected you can then download the data as File GDB from the Survey123 website (https://survey123.arcgis.com) and import it into your SDE.

If you have concerns over field types, then publish the survey(s) and immediately take a look at the REST end point of the created service. This URL can be accessed by going to the service item in AGOL.

If you are unhappy with the fields types created, you can use the bind::esri:fieldType column in the survey to specify the field type for each question (Esri custom columns—Survey123 for ArcGIS | ArcGIS ). You will then need to republish the survey for these changes to take effect.

I hope this helps.

John