AnsweredAssumed Answered

How to stop Survey123 adding .0 to numbers when it creates itemsets.csv

Question asked by mggeagle-co-nz-esridist Employee on Jan 9, 2018
Latest reply on Sep 28, 2020 by data.officer

Hi all,

I am creating a survey with a large number of records using multiple dependent cascading selects and an external choices tab.  When I save the excel and Survey123 creates the itemsets.csv file, it adds .0 to the end of some of the values as they are integers.  However I have stored them in the excel spreadsheet as type "text", and have added esriFieldTypeString to the survey tab, so I would not expect this.


In the survey tab:


in the external_choices tab:


in the itemsets.csv file:


in the survey:


This is casuing me issues when I try and use pulldata to automatically populate other fieilds from an external csv based on the results of this field, as it does not expect the .0 and so the lookup fails.


If I manually find and replace .0" for " using notepad++ in itemsets.csv then everything works ok.  This is not an acceptable solution for the client however.


Is there a way to prevent this from happening?





Ismael Chivite James Tedrick