summaryrefslogtreecommitdiff
path: root/sc/qa/unit/data/contentCSV
diff options
context:
space:
mode:
authorEike Rathke <erack@redhat.com>2012-04-14 20:22:55 +0200
committerEike Rathke <erack@redhat.com>2012-04-14 20:25:16 +0200
commit1e94b35b3d8d25636a5dc6ad99f81399617ad105 (patch)
tree00f62d63250cecbd7b61ad1ff517c416f4dcd757 /sc/qa/unit/data/contentCSV
parent2d0e58e1fca4d098ecea1a3b0c0fe1447da99855 (diff)
unit test for CSV import fixes related to fdo#48621
Diffstat (limited to 'sc/qa/unit/data/contentCSV')
-rw-r--r--sc/qa/unit/data/contentCSV/fdo48621_broken_quotes_exported.csv90
1 files changed, 90 insertions, 0 deletions
diff --git a/sc/qa/unit/data/contentCSV/fdo48621_broken_quotes_exported.csv b/sc/qa/unit/data/contentCSV/fdo48621_broken_quotes_exported.csv
new file mode 100644
index 000000000000..b1c95af5c689
--- /dev/null
+++ b/sc/qa/unit/data/contentCSV/fdo48621_broken_quotes_exported.csv
@@ -0,0 +1,90 @@
+i80358,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+"abc"" d ""ef",shall be:,"abc"" d ""ef",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+"a""b, ""a",shall be:,"a""b, ""a",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+i78926_input.csv,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+2,5,GR010 015 1001,/image/grimas/015/1001.jpg,/image/grimas/015/1001.jpg,/image/grimas/015/1001.jpg,,,,,,,,,,,,,5.45,0,0000-00-00 00:00:00,0000-00-00 00:00:00,0000-00-00 00:00:00,0.05,1,2,81,4,0,1,0,2000,0,0,0,"0
+"
+3,5,GR010 015 1002,/image/grimas/015/1002.jpg,/image/grimas/015/1002.jpg,/image/grimas/015/1002.jpg,,,,,,,,,,,,,5.45,0,0000-00-00 00:00:00,0000-00-00 00:00:00,0000-00-00 00:00:00,0.05,1,2,81,4,0,0,0,2000,0,0,0,"0
+"
+,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+i78926_input.csv,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+772,3,SPAZZOLA ARIA BABYLISS 32,image/APP.ELET/Varie/Babyliss-Spazzola-Elettrica.jpg,image/APP.ELET/Varie/Babyliss-Spazzola-Elettrica.jpg,image/APP.ELET/Varie/Babyliss-Spazzola-Elettrica.jpg,,,,,,,,,,,,,33,0,2006-11-07 09:26:16,2007-05-24 17:54:24,NULL,1,1,2,86,150,0,0,0,2000,0,,,
+773,1,"BIGODINI RISCALDANTI \""BA",image/APP.ELET/Varie/Bigodini-caldi.jpg,image/APP.ELET/Varie/Bigodini-caldi.jpg,image/APP.ELET/Varie/Bigodini-caldi.jpg,,,,,,,,,,,,,57.91,0,2006-11-07 09:26:16,2006-11-07 09:26:16,0000-00-00 00:00:00,0.7,1,2,86,152,0,1,0,2000,0,0,0,0
+774,3,"PIASTRA \""BABYLISS\"" PRO C",image/APP.ELET/piastre/Piastre-Babyliss-2564E.jpg,image/APP.ELET/piastre/Piastre-Babyliss-2564E.jpg,image/APP.ELET/piastre/Piastre-Babyliss-2564E.jpg,,,,,,,,,,,,,78,0,2006-11-07 09:26:16,2006-12-13 19:18:31,0000-00-00 00:00:00,0.7,1,2,86,148,0,0,0,2000,0,0,0,0
+775,0,PHON ULTRON MAXI 2200W+1,image/APP.ELET/phon/Phon-Ultron-1500W.jpg,image/APP.ELET/phon/Phon-Ultron-1500W.jpg,image/APP.ELET/phon/Phon-Ultron-1500W.jpg,,,,,,,,,,,,,26.66,0,2006-11-07 09:26:16,2006-12-13 18:57:03,0000-00-00 00:00:00,0.7,1,2,101,158,0,0,0,2000,0,0,0,0
+,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+i78926_inconsistent_double_quote_behavior.csv,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+Description,Description,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+The following text breaks everything,"OpenOffice.org calc doesnt "" like quotes embedded in fields.",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+Here is some data,Here is some data,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+Here is some data,Here is some data,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+Here is some data,Here is some data,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+Here is some data,Here is some data,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+This field will fix everything,"Here is the "" fix",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+First fixed record,Here is some data,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+Here is some data,Here is some data,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+This field will break things again,"Mismatched quote "" must be after some quoted text",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+Here is some data,Here is some data,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+Here is some data,Here is some data,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+Here is some data,Here is some data,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+This field will fix everything,"Here is the "" fix",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+First fixed record,Here is some data,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+Here is some data,Here is some data,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+Here is some data,Here is some data,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+Here is some data,Here is some data,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+Here is some data,Here is some data,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+This next field will /not/ break things because /this/ field is not quoted,"Mismatched quote "" must be after some quoted text",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+Here is some data,Here is some data,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+Here is some data,Here is some data,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+Here is some data,Here is some data,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+i80385_test1.csv,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+test,"a""b, ""a"," d""a""c ", m ,j ,d,"b""A""","D""E","f,1","a,b","de""b,a",,,,,,,,,,,,,,,,,,,,,,,,,
+"abcdef"" test ""abc","def""g""h","def""gh""",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+"this is
+a test","yes
+it
+works",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+No it doesn't,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+"yes it,"",""does",no,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+"""""a,cd""e
+""a""b""
+",<- needed to end test file here,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+i80385_test2.csv,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+test,"a""b, ""a"," d""a""c ", m ,j ,d,"b""A""","D""E","f,1","a,b","de""b,a
+""abcdef"" test ""abc","def""g""h","def""gh""",,,,,,,,,,,,,,,,,,,,,,,
+"this is
+a test","yes
+it
+works",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+No it doesn't,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+"yes it,"",""does",no,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+"""""a,cd""e
+""a""b""
+",<- needed to end test file here,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+i80385_test3.csv,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+test,"a""b, ""a"," d""a""c ", m ,j ,d,"b""A""","D""E","f,1","a,b","de""b,a",,,,,,,,,,,,,,,,,,,,,,,,,
+"abcdef"" test ""abc","def""g""h","def""gh""",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+"this is
+a test","yes
+it
+works",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+No it doesn't,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+"yes it,"",""does",no,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+"""""a,cd""e
+""a""b""",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+i80385_test4.csv,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+test,"a""b, ""a"," d""a""c ", m ,j ,d,"b""A""","D""E","f,1","a,b","de""b,a
+""abcdef"" test ""abc","def""g""h","def""gh""",,,,,,,,,,,,,,,,,,,,,,,
+"this is
+a test","yes
+it
+works",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+No it doesn't,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+"yes it,"",""does",no,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
+"""""a,cd""e
+""a""b""",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,