[dba-issues] [Issue 31385] Quoted strings are not han dled in a delimited text database.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=31385 --- Additional comments from [EMAIL PROTECTED] Sun Jan 27 13:22:43 + 2008 --- Created an attachment (id=51185) Bug doc changed to be 2 columns of data - 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 31385] Quoted strings are not han dled in a delimited text database.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=31385 User atjensen changed the following: What|Old value |New value Status|VERIFIED |CLOSED --- Additional comments from [EMAIL PROTECTED] Sun Jan 27 13:21:05 + 2008 --- Tested with 680m4, XP Altered reportData.txt file by adding CR after every pair of data items. Created TEXT type Base file - all data imports to table properly. Closing - 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 31385] Quoted strings are not han dled in a delimited text database.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=31385 User clu changed the following: What|Old value |New value Status|RESOLVED |VERIFIED --- Additional comments from [EMAIL PROTECTED] Wed Dec 12 12:11:03 + 2007 --- verified in cws - 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 31385] Quoted strings are not han dled in a delimited text database.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=31385 User oj changed the following: What|Old value |New value Assigned to|oj|clu --- Additional comments from [EMAIL PROTECTED] Mon Dec 3 08:28:31 + 2007 --- Please verify. Thanks. - 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 31385] Quoted strings are not han dled in a delimited text database.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=31385 User oj changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |FIXED Target milestone|OOo Later |OOo 2.4 --- Additional comments from [EMAIL PROTECTED] Mon Nov 26 07:51:21 + 2007 --- Fixed in cws dba24d - 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 31385] Quoted strings are not han dled in a delimited text database.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=31385 --- Additional comments from [EMAIL PROTECTED] Mon Sep 4 22:37:24 -0700 2006 --- The "normal" CSV handling when using the Text Driver from OOo Base doesn't use the hsql database. So it's a issue I have to fix ;-) - 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 31385] Quoted strings are not han dled in a delimited text database.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=31385 User atjensen changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |38958) test file for embed | |ded cr/lf in text table ex | |port --- Additional comments from [EMAIL PROTECTED] Mon Sep 4 18:07:04 -0700 2006 --- Created an attachment (id=38958) test file for embedded cr/lf in text table export - 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 31385] Quoted strings are not han dled in a delimited text database.
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=31385
--- Additional comments from [EMAIL PROTECTED] Mon Sep 4 18:05:57 -0700
2006 ---
Not sure if this is still the case with HSQLDB.
I am attaching an embedded database file.
Open this file, then open the SQL window.
Copy and paste these commands into it.
CREATE TEXT TABLE "DISCIPLINARY_ACTION_TXT"("ActionID" INTEGER NOT NULL PRIMARY
KEY,"StudentID" INTEGER,"StaffID" INTEGER,"ActionType" VARCHAR(50),"ActionDate"
DATE,"ActionComments" LONGVARCHAR);
SET TABLE DISCIPLINARY_ACTION_TXT SOURCE "DISCIPLINARY_ACTION_TXT.CSV;all_quoted
= true";
INSERT into DISCIPLINARY_ACTION_TXT ( SELECT "ActionID", "StudentID", "StaffID",
"ActionType", "ActionDate", "ActionComments" FROM "DISCIPLINARY_ACTION" AS
"DISCIPLINARY_ACTION" );
Close the database and open the file DISCIPLINARY_ACTION_TXT.CSV with any text
editor.
The second record includes an embedded lineend character.
-
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 31385] Quoted strings are not han dled in a delimited text database.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=31385 --- Additional comments from [EMAIL PROTECTED] Mon Sep 4 08:50:01 -0700 2006 --- It looks like this is a limitation in HSQLDB. I can't find neither specific documentation as to whether newlines are (or are not) allowed in a TEXT table, nor any bug report/feature request, and I'm not going spelunking in the HSQLDB source ;-), but : Q: http://sourceforge.net/forum/message.php?msg_id=2048917 A: http://sourceforge.net/forum/message.php?msg_id=2050639 - 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]
