To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110562 Issue #|110562 Summary|Text driver does not obey its own import settings Component|Database access Version|OOO310m19 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|villeroy
------- Additional comments from [email protected] Fri Apr 2 10:05:30 +0000 2010 ------- I think this is related to 70206 I've just read but let me put it this way: Connecting Base to a csv directory, you can specify a decimal delimiter but only the locale delimiter is used. US_Date,text,text,decimal 01/02/09,DIRECTDEP,xxxxxxxxxxxxxxxxxxxxxx, 1167.46 01/02/09,Check 1129,xxxxxxxxx, 30.00 01/05/09,CREDIT,ATM DEPOSIT xxxxxxxxxxxxxxxxxxxx, 1830.35 01/05/09,DEBIT,WIRE INT'L Sxxxxxxxxxxxxx, 148.30 01/05/09,Check 1128,xxxxxxxxxxxx, 350.00 In a German locale it is impossible to import these data for 2 reasons: 1. Base can not handle date locales to import (other issue) 2. Even though I specified the point as decimal separator, I always get text. The second point is a defect I think. --------------------------------------------------------------------- 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]
