View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003994 | SymmetricDS | Bug | public | 2019-06-11 16:14 | 2019-06-25 18:06 |
| Reporter | Assigned To | ||||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.10.2 | ||||
| Target Version | 3.10.3 | Fixed in Version | 3.10.3 | ||
| Summary | 0003994: DbExport CSV file should escape quote characters with double quotes | ||||
| Description | The current csv file format standard says to escape a quote character in a string use double quotes ("") not backslash quote (\"). DbExport currently uses \" RFC4180 standards: https://tools.ietf.org/html/rfc4180 | ||||
| Steps To Reproduce | Put value into a database with quotes in value like '"test"', then DbExport. Also if you use a value like '"test,with comma"', then the comma breaks the column into two separate columns because the output into the csv file is "\"test,with comma\"" but this does not actually break the quote so it is parsed incorrectly. | ||||
| Tags | dbimport/dbexport | ||||
|
|
This is only helpful for opening CSV files in Excel or similar software, so I am going to leave the CSV format how it is for SQL importing and exporting and add another format for CSV double quoting |
|
SymmetricDS: 3.10 9e85e2d3 2019-06-11 17:17:41 Details Diff |
0003994: DbExport CSV file should escape quote characters with double quotes |
Affected Issues 0003994 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/DbExportCommand.java | Diff File | ||
| mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/CsvUtils.java | Diff File | ||
| mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/DbExport.java | Diff File | ||
| mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/DbImport.java | Diff File | ||
| add - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/reader/CsvDquoteDataReader.java | Diff File | ||
| mod - symmetric-sqlexplorer/src/main/java/org/jumpmind/vaadin/ui/sqlexplorer/DbExportDialog.java | Diff File | ||
| mod - symmetric-sqlexplorer/src/main/java/org/jumpmind/vaadin/ui/sqlexplorer/DbImportDialog.java | Diff File | ||
|
SymmetricDS: 3.10 63b397e7 2019-06-12 10:15:04 Details Diff |
0003994: DbExport CSV file should escape quote characters with double quotes. Documentation |
Affected Issues 0003994 |
|
| mod - symmetric-assemble/src/asciidoc/appendix/dbexport.ad | Diff File | ||
| mod - symmetric-assemble/src/asciidoc/appendix/dbimport.ad | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2019-06-11 16:14 |
|
New Issue | |
| 2019-06-11 16:14 |
|
Status | new => assigned |
| 2019-06-11 16:14 |
|
Assigned To | => user606 |
| 2019-06-11 16:14 |
|
Tag Attached: dbimport/dbexport | |
| 2019-06-11 20:14 |
|
Note Added: 0001522 | |
| 2019-06-11 20:15 |
|
Project | SymmetricDS Pro => SymmetricDS |
| 2019-06-11 22:00 | jfrees | Changeset attached | => SymmetricDS 3.10 9e85e2d3 |
| 2019-06-12 14:15 |
|
Status | assigned => resolved |
| 2019-06-12 14:15 |
|
Resolution | open => fixed |
| 2019-06-12 14:15 |
|
Fixed in Version | => 3.10.3 |
| 2019-06-12 15:00 | jfrees | Changeset attached | => SymmetricDS 3.10 63b397e7 |
| 2019-06-25 18:06 | admin | Status | resolved => closed |