Coud you attach a small example csv file (or more of them) that causes the
problem?

Created an attachment (id=22935) [details]
See my description above

Here are the files I've prepared.
First, I created a spreadsheet using Kspread.
I then saved the file as a .csv and removed all the commas (using 
the "replace" facility in Kate) because I find that .csv data are read in 
better that way.
Finally I imported the .csv file into Kexi 1.1.3 and created a simple form to 
show the data.
All my comments about Kexi refer to v.1.1.3

There are several observations:

TEST1
1) The dates can only be shown YYYY-MM-DD, whereas I'd prefer to display them 
in European format DD-MM-YYYY
2) For some reason the dates on the 3rd, 5th, 7th and 8th lines have not been 
read in.  This has led to other data being read into wrong columns, or zeros 
resulting instead of numbers.  I know that one or two of the numbers are 
purposely large, and may cause a problem, but I have seen similar things 
happening without unusually large numbers.
3) In the Real Number column, there seems to be no way inside Kexi of setting 
the display to a certain no of significant figures.  So if the real number 
has no figures after the decimal point, Kexi displays it as an integer, 
rather than allowing a prescribed number of zeros (significant figures) to be 
displayed after it.
4) During import, there's no way to specify/force real numbers, so if you have 
a column of integers that you'd still like to set as real you can't.  (See 
the last column).  In Kexi, if you try and modify one of these numbers to be 
real, you can't.
However, in the Real Number column (second column) you'll see I added some 
integers at the end, and these have correctly been read in as real, and can 
be edited as real inside Kexi.

TEST2
I did this to see if the very large numbers were haveing an adverse effect - 
but there are still some numbers being read in wrongly.

Clearly, Kexi does have some good automatic data format setting capability, 
but I think it's a bit short on manual over-rides!
I don't understand why some of the numbers have been read into the wrong 
columns, missed out, or read in as zeros.

I will try to send some attachments alongside.

Created an attachment (id=22936) [details]
This is a test file

Created an attachment (id=22937) [details]
2nd test file of 6

Created an attachment (id=22938) [details]
3rd test file of 3

Created an attachment (id=22939) [details]
4th test file of 6

Created an attachment (id=22940) [details]
5th test file of 6

Created an attachment (id=22941) [details]
6th test file of 6

BTW, similar report: http://bugs.kde.org/show_bug.cgi?id=151478

SVN commit 805884 by staniek:

CSV Import Dialog
- fix setting data types for columns, previously text type was used instead
- fix autodetecting and importing of floating-point values in "E scientificnotation"
- output null values to fields if value coversion failed (e.g. text-to-date); 
  without this subsequent values are written into the wrong columns
- added "Date format" import option with possible values: auto, DMY, YMD, MDY

BUG: 147809
BUG: 151478

   


 M  +36 -14    kexicsvimportdialog.cpp  
 M  +2 -2      kexicsvimportdialog.h  
 M  +76 -21    kexicsvimportoptionsdlg.cpp  
 M  +14 -3     kexicsvimportoptionsdlg.h  


WebSVN link: http://websvn.kde.org/?view=rev&revision=805884

BTW, please read comment http://bugs.kde.org/show_bug.cgi?id=151478#c5 and
below on the importance of being able to compile Kexi. Distros do not keep
maintenance if we're not announcing "official" releases post-1.1.3.

SVN commit 806092 by staniek:

Ported r805884 to Kexi 2.0:

CSV Import Dialog
- fix setting data types for columns, previously text type was used instead
- fix autodetecting and importing of floating-point values in "E scientific notation"
- output null values to fields if value coversion failed (e.g. text-to-date); 
  without this subsequent values are written into the wrong columns
- added "Date format" import option with possible values: auto, DMY, YMD, MDY
CCBUG:147809
CCBUG:151478



 M  +36 -14    kexicsvimportdialog.cpp  
 M  +2 -2      kexicsvimportdialog.h  
 M  +64 -19    kexicsvimportoptionsdlg.cpp  
 M  +14 -3     kexicsvimportoptionsdlg.h  


WebSVN link: http://websvn.kde.org/?view=rev&revision=806092