Quotemarks supports importing comma-separated value (CSV) files. Many applications use CSV because it is simple and human-readable. This simplicity is deceiving as there are different variations of CSV which can make working with them more challenging. Fortunately, Quotemarks has a mechanism to help manage these differences.
Quotemarks provides two methods for importing CSV. This article is covers the second method.
The second method is simplest for importing CSV originating from another application such as the legacy app Quotebook. In comparison to the first lossless method, this method is potentially "lossy" as only select columns are supported.
Importing from CSV
By default, Quotemark supports CSV formatted the way Quotebook exports. If you modified your data, or if it comes from another application like a spreadsheet, you can either match your CSV file to the default, or change the import settings by way of the CSV dialect. There's not a foolproof way to detect this so double check your work during and after import.
When importing CSV Quotemarks expects at least one column. At the very least there needs to be quote text. This column needs to be assigned as well as any additional supported columns. Some columns like tag and rating are presently not supported. Supported columns are presently limited to Author, Quote, Note, and Date Added (in date formats dd-MM-yyyy HH:mm:ss and ISO8601 YYYY-MM-DDThh:mm:ssZ).
CSV Dialect and Encoding Requirements
Quotemark addresses the issue of different applications having different encodings by requiring a CSV dialect declaration. Special care should be taken here. For example, if you have modified the CSV with another application the encoding may have changed. See the CSV Dialect specification for more detail.
The default expectation is a UTF-8 file with:
Line Terminator: \r\n (CRLF line endings)
Quote Character: "
Double Quote: false
Escape Character: null
Null Sequence: null
Skip Initial Space: false
Comment Char: Not supported
Case Sensitive Header: Unused
Help, I'm Still Having Trouble
If you are having problems and need assistance with this please email me using the email provided on the Quotemarks website.