Pulldata with more decimal places from a CSV File

I am designing a form for a survey which requires referencing some
variables from a CSV file. The problem i have is that the decimals are
being rounded to 1 decimal place (e.g. 3.4) instead of showing all the
decimals(e.g. up to 10 decimals or more i.e. 3.487698325487623). I dont
want the values to be rounded when pulling this data from a CSV file.here
is my code:" pulldata ('reference', 'nutrition_index', 'age_r',
'${age_in_days}' ). Please help

Hi Vincent,

The data is pulled into a calculate, right? What happens if you output
that calculate? Do you get all the numbers?

Yaw

ยทยทยท On Fri, Oct 21, 2016 at 2:29 PM, Vincent Mkandawire wrote: > I am designing a form for a survey which requires referencing some variables > from a CSV file. The problem i have is that the decimals are being rounded > to 1 decimal place (e.g. 3.4) instead of showing all the decimals(e.g. up to > 10 decimals or more i.e. 3.487698325487623). I dont want the values to be > rounded when pulling this data from a CSV file.here is my code:" pulldata > ('reference', 'nutrition_index', 'age_r', '${age_in_days}' ). Please help > > -- > -- > Post: opendatakit@googlegroups.com > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > Options: http://groups.google.com/group/opendatakit?hl=en > > --- > You received this message because you are subscribed to the Google Groups > "ODK Community" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to opendatakit+unsubscribe@googlegroups.com. > For more options, visit https://groups.google.com/d/optout.

yes data is pulled into a calculate. But the output is rounded to 1 decimal
place. I am not getting all the decimals.

ยทยทยท On Monday, October 24, 2016 at 5:08:05 PM UTC+2, Yaw Anokwa wrote: > > Hi Vincent, > > The data is pulled into a calculate, right? What happens if you output > that calculate? Do you get all the numbers? > > Yaw > > On Fri, Oct 21, 2016 at 2:29 PM, Vincent Mkandawire <yelu...@gmail.com > wrote: > > I am designing a form for a survey which requires referencing some > variables > > from a CSV file. The problem i have is that the decimals are being > rounded > > to 1 decimal place (e.g. 3.4) instead of showing all the decimals(e.g. > up to > > 10 decimals or more i.e. 3.487698325487623). I dont want the values to > be > > rounded when pulling this data from a CSV file.here is my code:" > pulldata > > ('reference', 'nutrition_index', 'age_r', '${age_in_days}' ). Please > help > > > > -- > > -- > > Post: opend...@googlegroups.com > > Unsubscribe: opendatakit...@googlegroups.com > > Options: http://groups.google.com/group/opendatakit?hl=en > > > > --- > > You received this message because you are subscribed to the Google > Groups > > "ODK Community" group. > > To unsubscribe from this group and stop receiving emails from it, send > an > > email to opendatakit...@googlegroups.com . > > For more options, visit https://groups.google.com/d/optout. >

Hi Vincent,

There is likely a bug in your form, your CSV, or in the version of
Collect you are using.

Attached is an example using ODK Collect 1.4.11 where I enter a key (a
or b) and get a value with decimals from a lookup CSV.

Yaw

numbers.xlsx (23.8 KB)

lookup.csv (56 Bytes)

ยทยทยท On Fri, Oct 28, 2016 at 8:24 AM, Vincent Mkandawire wrote: > yes data is pulled into a calculate. But the output is rounded to 1 decimal > place. I am not getting all the decimals. > > On Monday, October 24, 2016 at 5:08:05 PM UTC+2, Yaw Anokwa wrote: >> >> Hi Vincent, >> >> The data is pulled into a calculate, right? What happens if you output >> that calculate? Do you get all the numbers? >> >> Yaw >> >> On Fri, Oct 21, 2016 at 2:29 PM, Vincent Mkandawire wrote: >> > I am designing a form for a survey which requires referencing some >> > variables >> > from a CSV file. The problem i have is that the decimals are being >> > rounded >> > to 1 decimal place (e.g. 3.4) instead of showing all the decimals(e.g. >> > up to >> > 10 decimals or more i.e. 3.487698325487623). I dont want the values to >> > be >> > rounded when pulling this data from a CSV file.here is my code:" >> > pulldata >> > ('reference', 'nutrition_index', 'age_r', '${age_in_days}' ). Please >> > help >> > >> > -- >> > -- >> > Post: opend...@googlegroups.com >> > Unsubscribe: opendatakit...@googlegroups.com >> > Options: http://groups.google.com/group/opendatakit?hl=en >> > >> > --- >> > You received this message because you are subscribed to the Google >> > Groups >> > "ODK Community" group. >> > To unsubscribe from this group and stop receiving emails from it, send >> > an >> > email to opendatakit...@googlegroups.com. >> > For more options, visit https://groups.google.com/d/optout. > > -- > -- > Post: opendatakit@googlegroups.com > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > Options: http://groups.google.com/group/opendatakit?hl=en > > --- > You received this message because you are subscribed to the Google Groups > "ODK Community" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to opendatakit+unsubscribe@googlegroups.com. > For more options, visit https://groups.google.com/d/optout.
1 Like

Thank you Yaw Anokwa for the help. I figured out that there is a problem
with Microsoft Excel in Exporting data with decimals to an CSV file. so i
converted the number format in excel to text format using this formula:
TEXT(A1,"#.######################") then save as CSV. Then all things are
working now. Thanks again Yaw Anokwa for your help.

ยทยทยท On Friday, November 4, 2016 at 4:42:08 PM UTC+2, Yaw Anokwa wrote: > > Hi Vincent, > > There is likely a bug in your form, your CSV, or in the version of > Collect you are using. > > Attached is an example using ODK Collect 1.4.11 where I enter a key (a > or b) and get a value with decimals from a lookup CSV. > > Yaw > > On Fri, Oct 28, 2016 at 8:24 AM, Vincent Mkandawire <yelu...@gmail.com > wrote: > > yes data is pulled into a calculate. But the output is rounded to 1 > decimal > > place. I am not getting all the decimals. > > > > On Monday, October 24, 2016 at 5:08:05 PM UTC+2, Yaw Anokwa wrote: > >> > >> Hi Vincent, > >> > >> The data is pulled into a calculate, right? What happens if you output > >> that calculate? Do you get all the numbers? > >> > >> Yaw > >> > >> On Fri, Oct 21, 2016 at 2:29 PM, Vincent Mkandawire wrote: > >> > I am designing a form for a survey which requires referencing some > >> > variables > >> > from a CSV file. The problem i have is that the decimals are being > >> > rounded > >> > to 1 decimal place (e.g. 3.4) instead of showing all the > decimals(e.g. > >> > up to > >> > 10 decimals or more i.e. 3.487698325487623). I dont want the values > to > >> > be > >> > rounded when pulling this data from a CSV file.here is my code:" > >> > pulldata > >> > ('reference', 'nutrition_index', 'age_r', '${age_in_days}' ). Please > >> > help > >> > > >> > -- > >> > -- > >> > Post: opend...@googlegroups.com > >> > Unsubscribe: opendatakit...@googlegroups.com > >> > Options: http://groups.google.com/group/opendatakit?hl=en > >> > > >> > --- > >> > You received this message because you are subscribed to the Google > >> > Groups > >> > "ODK Community" group. > >> > To unsubscribe from this group and stop receiving emails from it, > send > >> > an > >> > email to opendatakit...@googlegroups.com. > >> > For more options, visit https://groups.google.com/d/optout. > > > > -- > > -- > > Post: opend...@googlegroups.com > > Unsubscribe: opendatakit...@googlegroups.com > > Options: http://groups.google.com/group/opendatakit?hl=en > > > > --- > > You received this message because you are subscribed to the Google > Groups > > "ODK Community" group. > > To unsubscribe from this group and stop receiving emails from it, send > an > > email to opendatakit...@googlegroups.com . > > For more options, visit https://groups.google.com/d/optout. >
1 Like