To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84247 Issue #|84247 Summary|Text / CSV database connection fails when parsing date |s Component|Database access Version|OOo 2.3 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|wcarpenter
------- Additional comments from [EMAIL PROTECTED] Tue Dec 4 21:39:11 +0000 2007 ------- When using a Text file data connection, the field before a date field is empty, the dates are parsed incorrectly as 01/01/00, and the times appear to be correct. To Reproduce: Given a directory (~/db) with a single CSV file (base.csv, attached): 1. File -> New Database 2. Connect to Existing, Type = Text, Next 3. Path to text files ~/db 4. Select 'Comma separated value' files (*.csv) 5. Set Field separator to ',' and delete Thousands separator. 6. Next 7. Select "No, do not register...", Finish 8. Save as ~/db/test.odb 9. View the table 'test:base': +-----------------+----------+-------------+ | syslog_severity | date | time | +-----------------+----------+-------------+ | | 01/01/00 | 12:41:32 PM | | | 01/01/00 | 12:41:32 PM | | | 01/01/00 | 12:41:33 PM | ... 10. Edit the table 'test:base': +-----------------+----------------+ | Field Name | Field Type | +-----------------+----------------+ | syslog_severity | Text [VARCHAR] | | date | Date [DATE] | | time | Time [TIME] | +-----------------+----------------+ Other Info: If I quote the dates, they will be read as Text fields, and then all of the fields will be read, but the dates all appear as '0'. (quoted-dates.csv) If I quote all of the field values, then all of the fields and values will be read properly, but only as Text [VARCHAR] (quoted-all.csv) --------------------------------------------------------------------- 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]
