Kexi/Migration/CSV

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...