To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69965
------- Additional comments from [EMAIL PROTECTED] Tue Jan 30 08:19:57 -0800 2007 ------- The error of reading date values not only affects the date fields, also neighbor fields are corrupted. In my test case i send you a csv file, where text fields (inside ") are interpreted as numbers and set to 0. Date fields are recognized sometimes correct, depending which field lead or follows. Attached zip contains 2 csv files with similar content, but the field order varies . In the first one (accounting1) the text field "note" is interpreted as number, but the date fields are correct. In file two (accounting2) the note field is moved to the end of the data row. Not the note is correct, but one of the date fields (date3) is always the same and wrong value. And - last but not least - decimal value of 10,509.00 is interpreted as 10.00. In the database "definition" (attached as account.odb) decimal = "." and thousend delimiter is ",". Omitting the "," in the value so it reads "10509.00" doesn't solve the problem. It seems to me, that using values > 999 with decimal point is wrong interpreted. Solved the problem by exporting the value as 1050900 and divide this by 100 in calc/writer. The workaround for dates and textfields is: arrange the text field as long as you get the right value. In most cases the date and text problem is solved by inserting text "fillers". I now export the file with some dummy fields named all "X" and containing only "X" (with the "). Inserted this on the right place and order i got my file working. But you have to test and unfortunately it is not 100% sure, as sometimes depending on the field value this doesn't work. I know, this are not only related to "ate values from text/csv files improperly read in OOo Base" but there are some other issues around regarding more or less all of this and i didn't want to create a duplicate issue named "csv text files in base completely broken". BTW: In calc i can open and use this csv file WITHOUT any 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]
