[sc-issues] [Issue 78926] Might apply some magic to CSV import with broken non-escaped quotes in f ields
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78926 User gbpacheco changed the following: What|Old value |New value CC|'kohei,mhatheoo,syzygy' |'gbpacheco,kohei,mhatheoo, | |syzygy' - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 78926] Might apply some magic to CSV import with broken non-escaped quotes in f ields
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78926 --- Additional comments from christopher_schu...@openoffice.org Tue Nov 30 19:56:51 + 2010 --- Created an attachment (id=75191) Inconsistent text delimiter behavior (comma field separator, double-quote text delimiter) - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 78926] Might apply some magic to CSV import with broken non-escaped quotes in f ields
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78926 --- Additional comments from christopher_schu...@openoffice.org Tue Nov 30 19:56:14 + 2010 --- Created an attachment (id=75189) Truncates data without warning (comma field separator, double-quote text delimiter) - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 78926] Might apply some magic to CSV import with broken non-escaped quotes in f ields
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78926 --- Additional comments from christopher_schu...@openoffice.org Tue Nov 30 19:57:42 + 2010 --- Created an attachment (id=75192) Confusing "maximum rows exceeded" error (comma field separator, double-quote text delimiter) - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 78926] Might apply some magic to CSV import with broken non-escaped quotes in f ields
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78926 --- Additional comments from christopher_schu...@openoffice.org Tue Nov 30 19:54:36 + 2010 --- I'm observing a bunch of things that I was able to isolate into some sample files, which I'll attach. I'm running OOo 3.2.1 (OOO320m18 Build:9502) on Microsoft Windows 7. I'm using comma (,) as my field separator and double-quote (") as my text delimiter. Here is a summary of the things I discovered: 1. Using an unescaped text delimiter within a field causes the CSV parser to a) include the " in the field b) start searching for second unpaired " later in the file c) include the closing " in the field 2. #1 only occurs if a field before it on the same line was quoted 3. After #1 occurs, it's possible OOo will attempt to read /lots/ of data into a single field which results in the error "the maximum number of rows has been exceeded" - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 78926] Might apply some magic to CSV import with broken non-escaped quotes in f ields
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78926 User syzygy changed the following: What|Old value |New value CC|'kohei,mhatheoo' |'kohei,mhatheoo,syzygy' - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 78926] Might apply some magic to CSV import with broken non-escaped quotes in f ields
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78926 --- Additional comments from e...@openoffice.org Thu Jan 7 15:52:27 + 2010 --- *** Issue 107867 has been marked as a duplicate of this issue. *** - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 78926] Might apply some magic to CSV import with broken non-escaped quotes in f ields
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78926 --- Additional comments from e...@openoffice.org Fri Oct 2 14:28:04 + 2009 --- *** Issue 84048 has been marked as a duplicate of this issue. *** - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 78926] Might apply some magic to CSV import with broken non-escaped quotes in f ields
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78926 User kohei changed the following: What|Old value |New value CC|'mhatheoo'|'kohei,mhatheoo' - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 78926] Might apply some magic to CSV import with broken non-escaped quotes in f ields
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78926 --- Additional comments from n...@openoffice.org Tue Aug 4 16:51:16 + 2009 --- Continuing the discussion from issue 103939: Actually implementing something like the description of the bEmbeddedLineBreak parameter to ReadCsvLine might already be enough. The current implementation is simpler than described. - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 78926] Might apply some magic to CSV import with broken non-escaped quotes in f ields
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78926 --- Additional comments from n...@openoffice.org Tue Aug 4 16:49:49 + 2009 --- *** Issue 103939 has been marked as a duplicate of this issue. *** - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 78926] Might apply some magic to CSV import with broken non-escaped quotes in f ields
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78926 --- Additional comments from [EMAIL PROTECTED] Mon Jul 21 10:30:30 + 2008 --- *** Issue 91825 has been marked as a duplicate of this issue. *** - 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]
[sc-issues] [Issue 78926] Might apply some magic to CSV import with broken non-escaped quotes in f ields
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78926 --- Additional comments from [EMAIL PROTECTED] Sun Sep 23 23:59:56 + 2007 --- @ er I treat dataloss as not acceptable in no way even if "," is rather outdated, you should trust, programs which formed that did know well, how to deal with ' and " If you find new files, it must not be that the new programs work with or even ment to use that behaviour. You need to understand that. one of the ' or " can be the starting/ending delimiter, the other one can be in those braketts in an uncounted number. that is correct. in the example , colon is th only delimiter: ,"abc" d "ef", so for that the result needs to be: ,'"abc" d "ef"', or the delimiter should be substituted be something more reliable like ;"abc" d "ef"; Martin - 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]
[sc-issues] [Issue 78926] Might apply some magic to CSV import with broken non-escaped quotes in f ields
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78926 --- Additional comments from [EMAIL PROTECTED] Wed Aug 15 07:23:46 + 2007 --- *** Issue 80683 has been marked as a duplicate of this issue. *** - 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]
[sc-issues] [Issue 78926] Might apply some magic to CSV import with broken non-escaped quotes in f ields
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78926 --- Additional comments from [EMAIL PROTECTED] Wed Aug 8 19:50:51 + 2007 --- How should this be handled: ...,"abc" d "ef",... IS the FIELD actually: 1. 'abc" d "ef' AND the application forgot to double the QUOTES (valid assumption) I believe, this is indeed the best solution. Only quotes surrounding the full string (i.e. preceded or followed by the FIELD-Delimiter) should be viewed as ESCAPING-Quotes, everything else should be considered as an ordinary string. [Matching all quotes, as discussed in issue 80385 is another consistent way to recover these broken csv-files.] - 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]
[sc-issues] [Issue 78926] Might apply some magic to CSV import with broken non-escaped quotes in f ields
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78926 --- Additional comments from [EMAIL PROTECTED] Wed Aug 8 16:06:17 + 2007 --- Another test case from issue 80385: ,"abc" d "ef", currently results in 'abc d "ef"' To not lose data it should result in 'abc" d "ef' Doing so would also lead to ,"a"b, "a", resulting in _one_ field 'a"b, "a' and not two, 'ab' and ' "a"' like it is currently the case. This would then differ from how Excel treats it, but would be more consistent. See also test case documents attached to issue 80385: http://www.openoffice.org/nonav/issues/showattachment.cgi/47340/test1.csv http://www.openoffice.org/nonav/issues/showattachment.cgi/47341/test2.csv http://www.openoffice.org/nonav/issues/showattachment.cgi/47358/test3.csv http://www.openoffice.org/nonav/issues/showattachment.cgi/47359/test4.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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 78926] Might apply some magic to CSV import with broken non-escaped quotes in f ields
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78926 --- Additional comments from [EMAIL PROTECTED] Wed Aug 8 15:56:00 + 2007 --- *** Issue 80385 has been marked as a duplicate of this issue. *** - 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]
[sc-issues] [Issue 78926] Might apply some magic to CSV import with broken non-escaped quotes in f ields
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78926 --- Additional comments from [EMAIL PROTECTED] Tue Aug 7 12:43:08 + 2007 --- *** Issue 80385 has been marked as a duplicate of this issue. *** - 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]
[sc-issues] [Issue 78926] Might apply some magic to CSV import with broken non-escaped quotes in f ields
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78926 --- Additional comments from [EMAIL PROTECTED] Tue Jul 17 19:27:40 + 2007 --- well er, this is a sort of discussion .. and maybe it is all sort of a misunderstanding. I just learnd, that the CSV-import for my "wrong-build" file is working. The trick/the solution: delete the default text-delimiter from the list-box. In that case the field-delimiter is the ;-semicolon only and all records will be imported. The "-doublequote will not be detected (as expected !) and can be searched and deleted later. So the misunderstanding is, that the behavior changed and that former existing "no Text-delimiter" from the listbox has to be removed manually. Regarding the "start-stop"-function of the text-delimiter ' or " you are right. But that was not the problem. The problem I see is, that the error-handling is not functioning in a proper manner. OO.o should not stop import csv-lines when it sees a logical error (colum-length, delimiter-error) until the file is finished - and than return a error-message. This would help with this issue. to solve my issue 76874 a selection "no delimiter" on the import-dialog would had helped the most. Martin - 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]
[sc-issues] [Issue 78926] Might apply some magic to CSV import with broken non-escaped quotes in f ields
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78926 --- Additional comments from [EMAIL PROTECTED] Mon Jul 16 10:06:51 + 2007 --- > 1. The feature that the textdelimiter is constructed from > quote/doublequote+colon/semicolon as a must, is a new invention to OO.o > That way is ISO- or anythingelse standard? Okay, but it is not very > professional > to invent something against the data, that can be found in the real world, one > has to deal with that. This is simply not true. The behavior regarding quotes is not an invention of OOo, nor is a quote a must if the delimiter or a quote is not present in the field content. However, an embedded quote _must_ be escaped by doubling it. Again, this is not an invention of OOo, this is common CSV handling, and no it's not ISO or any standard, just as CSV is not standardized at all. But there is an RFC 4180 now. You may want to read more about the CSV format at http://www.creativyst.com/Doc/Articles/CSV/CSV01.htm http://tools.ietf.org/html/rfc4180 - 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]
[sc-issues] [Issue 78926] Might apply some magic to CSV import with broken non-escaped quotes in f ields
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78926 User mhatheoo changed the following: What|Old value |New value CC|''|'mhatheoo' --- Additional comments from [EMAIL PROTECTED] Sun Jul 15 19:58:07 + 2007 --- as the reporter to the issue 76874 - which is closed for being a dublicate of this issue (see the number:cool stuff!) - I want to find out, whether it is really the same defect or not 1. The feature that the textdelimiter is constructed from quote/doublequote+colon/semicolon as a must, is a new invention to OO.o That way is ISO- or anythingelse standard? Okay, but it is not very professional to invent something against the data, that can be found in the real world, one has to deal with that. 2. however, that feature is misbehaving anyway. In case of broken import, OO.o should detect the error for the very record/import that is incomplete, and continue after that. But it seem OO.o has not any error-routine for CSV-import. hallo er: right now the main problem is the import-function, and that is defect - I hope you will deal it with not as an academic but as a real problem. Martin - 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]
[sc-issues] [Issue 78926] Might apply some magic to CSV import with broken non-escaped quotes in f ields
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78926 --- Additional comments from [EMAIL PROTECTED] Wed Jul 11 10:59:07 + 2007 --- *** Issue 76874 has been marked as a duplicate of this issue. *** - 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]
[sc-issues] [Issue 78926] Might apply some magic to CSV import with broken non-escaped quotes in f ields
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78926 User er changed the following: What|Old value |New value Assigned to|spreadsheet |er Ever confirmed| |1 Status|UNCONFIRMED |NEW Issue type|DEFECT|TASK Summary|Export to CSV makes empty |Might apply some magic to |columns |CSV import with broken non | |-escaped quotes in fields Subcomponent|save-export |open-import Target milestone|--- |OOo Later --- Additional comments from [EMAIL PROTECTED] Wed Jun 27 18:35:17 + 2007 --- 1. Your input file is broken. If a quoted field contains a quote the software creating the file escaped the quote using a backslash (\"), which is wrong and may result in data fields being misaligned. Contained quotes must be escaped by doubling them (""). 2. In case an odd number of wrongly escaped quotes is contained within a field it depends on the context how the line is read. For example see row 774 where data from line 774 (starting with "773";"1";"BIGODINI RISCALDANTI \"BA";...) is followed by data from line 774 and following lines until a pairing quote is matched, resulting in a long row up to cell IQ774, which upon export results in that many columns. 3. However, this special case should not result in a line concatenation because the preceding fields up to AI774 were recognized and aligned correctly the same as in other lines that contain an even number of broken quotes. [hey, good piece of software, isn't it? Your data is broken and still it is read almost correctly ;-) except that non-doubled quotes are lost in all fields] 4. I take this issue only to investigate what the special case here exactly is and maybe find some magic to apply. 5. Remember, your input file is broken. - 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]