AnsweredAssumed Answered

Is there a way to make a schema change such as adding field and not have to create a new Survey and reload all previously collected data?

Question asked by William.Walsh@pseg.com on Apr 25, 2018
Latest reply on Apr 27, 2018 by ichivite-esristaff

I have an existing survey with approximately 10k records, some with attachments, so without.  The challenge I face is to add a field, simple text field no more than 10 characters and republish for our users to continue using.  My understanding is that I cannot make a schema change without losing all previously collected data, thus requiring a rebuild of the survey, download of current data, publish new survey and load data.

 

 

The problem with this workflow is that I have scripts that reference CreationDate which is used as an accountability measure for when the survey is completed.  When I download an republish the current data the original CreationDate is overwritten for the SysDate, which is a major problem for historic reporting.

 

I would appreciate any help!!!

 

Thanks,

Bill

Outcomes