[dba-issues] [Issue 72264] Pb import csv file in OOBa se (numeric, text, date)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72264 User laurentgodard changed the following: What|Old value |New value CC|''|'laurentgodard' - 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]
[dba-issues] [Issue 72264] Pb import csv file in OOBa se (numeric, text, date)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72264 --- Additional comments from [EMAIL PROTECTED] Mon Jan 29 08:10:28 -0800 2007 --- Bug always present in version 2.1 french Win XP Oh yes another funny thing The date format -mm-dd seems to be well recognize But always same problem with a varchar column before date colum value is empty. And if the column before date column contains integer value this value is decrease by to 2 unit ( 4 becomes 2, 5 becomes 3 etc). - 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]
[dba-issues] [Issue 72264] Pb import csv file in OOBa se (numeric, text, date)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72264 User allart changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |42493) A simple csv file --- Additional comments from [EMAIL PROTECTED] Fri Jan 26 07:33:20 -0800 2007 --- Created an attachment (id=42493) A simple csv file - 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]
[dba-issues] [Issue 72264] Pb import csv file in OOBa se (numeric, text, date)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72264 --- Additional comments from [EMAIL PROTECTED] Fri Jan 26 07:30:00 -0800 2007 --- Hi, I can confirm with bug. If a numeric column follows a string column, the text of the string column is replaced by 0. But the type of the string column is correctly detected as varchar. If the string column is followed by a date column, the text of the string column is replaced by nothing. It's surprising that this issue is not yet confirmed (?); I attach ou very simple csv file as example. field delimiter: tabs string delimiter: nothing best regards Ph. - 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]
[dba-issues] [Issue 72264] Pb import csv file in OOBa se (numeric, text, date)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72264 --- Additional comments from [EMAIL PROTECTED] Wed Jan 17 13:05:54 -0800 2007 --- Hello, Another strange thing about csv import into Base If in the first line( or second if the first is column header) there is a integer number with 4 digits or more ... the column will be detected as varchar - 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]
[dba-issues] [Issue 72264] Pb import csv file in OOBa se (numeric, text, date)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72264 User fchauvat changed the following: What|Old value |New value Priority|P3|P2 - 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]
[dba-issues] [Issue 72264] Pb import csv file in OOBa se (numeric, text, date)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72264 User fchauvat changed the following: What|Old value |New value Platform|Opteron/x86_64|All - 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]
[dba-issues] [Issue 72264] Pb import csv file in OOBa se (numeric, text, date)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72264 User fchauvat changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |41123) some examples files | | of the problem --- Additional comments from [EMAIL PROTECTED] Mon Dec 4 13:33:12 -0800 2006 --- Created an attachment (id=41123) some examples files of the problem - 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]
[dba-issues] [Issue 72264] Pb import csv file in OOBa se (numeric, text, date)
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]