When importing a .csv file from the Data tool->new tab -> import data, the following occurs:
if .csv file contains all floats but one number/row has integers due to how file was exported by another program, import fails silently, no error message etc. at least error message would be nice, but perhaps float should be assumed if other values are float? or ask user?
this data fails: distance,field 0.2,4051.641492 0.4,822.7388777 0.6,323.7815696 0.8,167.0679062 1,100 1.2,65.74808896
this data works distance,field 0.2,4051.641492 0.4,822.7388777 0.6,323.7815696 0.8,167.0679062 1.0,100.0 1.2,65.74808896
Thanks for identifying this bug. I was able to reproduce it and it will be fixed in the next release version 6.0.9 which will come out very soon. Doug
> When importing a .csv file from the Data tool->new > tab -> import data, the following occurs: > > if .csv > file contains all floats but one number/row has integers > due to how file was exported by another program, import > fails silently, no error message etc. at least error > message would be nice, but perhaps float should be > assumed if other values are float? or ask user? > > > this data fails: > distance,field > 0.2,4051.641492 > 0.4,822.7388777 > 0.6,323.7815696 > 0.8,167.0679062 > 1,100 > 1.2,65.74808896 > > this > data works > distance,field > 0.2,4051.641492 > 0.4,822.738877 > > 0.6,323.7815696 > 0.8,167.0679062 > 1.0,100.0 > 1.2,65.74808896