To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72264 Issue #|72264 Summary|Pb import csv file in OOBase (numeric, text, date) Component|Database access Version|OOo 2.0.4 Platform|Opteron/x86_64 URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|fchauvat
------- Additional comments from [EMAIL PROTECTED] Mon Dec 4 13:30:51 -0800 2006 ------- Hi, French 2.0.4 version of OOo with french local settings ( comma as decimal separator). Seems there's some problems with .csv file in Database module ( semi colon separator, text values double quoted - but other parameters like comma separated values and no text delimiter seems to have the same problem). If all the column are text column, ( or consider as text with double quoted) .... is ok. If there's a numeric column (no double quotes), even with integer value, the text column before the numeric one will be consider as numeric, so text values are remplace by O. If there's a date column ( no double quotes), the text value in the column before the date will be empty ( or null I don't know). If all the columns (even numeric or date one's) are double quoted ... all is ok . But if you open the csv file with calc.... you have to reformat numeric column as text otherwise they will be saved again as numeric ..... If the numeric column as a decimal value it seems to be ok ( regardless to decimal separator dot or comma). Really strange behaviour ..... I will send you some little csv files as attachement Also discuss in http://www.oooforum.org/forum/viewtopic.phtml?p=193371 --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
