AnsweredAssumed Answered

Pulldata .csv Leading Zeroes Ignored

Question asked by bowlesgsrcx on Oct 26, 2017
Latest reply on Oct 27, 2017 by JTedrick-esristaff

We are using the Pulldata function with barcode labels for inspection of assets. Our Asset IDs are 5 digit numbers with some that begin with a 0 ie. 02243. Excel ignores these zeroes when reading csv files. I have tried several different methods to create and save the .csv file, but the leading zeroes are not read in Survey123. we require the Asset ID data to be the 5 digit number including any leading zeroes so that we can link it back to our SCADA system. Has anyone else ran into this problem? Suggestions?

 

I have attached the survey, .csv file and a jpg of a barcode for testing.

Thanks,

--gary

Attachments

Outcomes