Created attachment 177311 [details] test file to reproduce the problem SUMMARY When importing an ASCII file (csv file), the type of the column seems to be based only on the first 11 rows of data. So, if the data is an integer in the 11 first rows, all the data in this colum will be converted in integer, even though they are floating point. Floating point values are then converted to 0. So if in a column we have eleven values of 3 and one of 3.1 at the 12th position, we get some 3 and one 0 after the import STEPS TO REPRODUCE 1. 2. 3. OBSERVED RESULT EXPECTED RESULT SOFTWARE/OS VERSIONS Windows: macOS: (available in the Info Center app, or by running `kinfo` in a terminal window) Linux/KDE Plasma: KDE Plasma Version: KDE Frameworks Version: Qt Version: ADDITIONAL INFORMATION
(In reply to poubellebl33 from comment #0) > Created attachment 177311 [details] > test file to reproduce the problem > > SUMMARY > When importing an ASCII file (csv file), the type of the column seems to be > based only on the first 11 rows of data. So, if the data is an integer in > the 11 first rows, all the data in this colum will be converted in integer, > even though they are floating point. Floating point values are then > converted to 0. > So if in a column we have eleven values of 3 and one of 3.1 at the 12th > position, we get some 3 and one 0 after the import We addressed this problem in the next release 2.12. The logic for the auto-detection of the data types treats integer values as floats (this behavior can be controlled via a new option in the import dialog) and it is also possible to specify the data types explicitly for every column and to overwrite what was detected automatically. I attached a screenshot for how it's going to look like in 2.12. We're finalizing the remaining tasks for 2.12 now and we'll release soon. You can also give the current development version a try, it's available on our homepage in the download section.
Created attachment 177494 [details] Import Dialog in 2.12
*** Bug 498982 has been marked as a duplicate of this bug. ***