Kexi/Migration/CSV

From KDE Community Wiki
Revision as of 08:13, 3 November 2014 by Jstaniek (talk | contribs)

The Tasks

Note

Pick one task from this list. Mark it with a [assigned to YOURNAME] tag. Create a bugs.kde.org entry especially for non-trivial improvements. See Contributing a Patch.


  1. [DONE] Add support for appending CSV data to an existing table
  2. [unassigned] Add skipEmptyColumns, skipEmptyRows
  3. [unassigned] Add options to parse booleans (default: 0, false, no, "false", "no" -> false; 1, true, yes, "true", "yes" -> true)
  4. [unassigned] Add options to specify accepted false/true boolean values
  5. [unassigned] Add option to specify if missing boolean value should be treat as true or false ( import-globally, also depends on 'required' property)
  6. [W. Kosowicz] Add option to skip comment lines (off by default, if enabled, whitespace is allowed before the character)
  7. [unassigned] Add option to specify commend character (# by default)
  8. [unassigned] Add options to specify date, time, date-time formats (reg exp, mask?)
  9. Add number settings (see also KDE locale tab):
    1. [unassigned] Digit grouping (default from locale, can be space/,/./)
    2. [unassigned] Decimal separator (default from locale, can be space/,/./)
    3. [unassigned] Positive sign (default from locale, propose +)
    4. [unassigned] Negative sign (default from locale, propose -)
    5. [unassigned] Digit set (default from locale)
  10. [unassigned] Add option to specify escape character
  11. [unassigned] Add option to specify if multiline text values are allowed (true by default), if allowed, \n or \r\n can occur inside of text value
  12. [unassigned] Add option to specify 'required' property for given column (true, false, default)
  13. [unassigned] Add import-global option to specify 'required' property for columns
  14. [unassigned] Add option to define behaviour on malformed CSV (unclosed quote, extra quote, missing values) - either stop with error or show warning only
  15. [unassigned] Move options from the main dialog to configuration
  16. [unassigned] Fix it: default extension is txt first, then csv...