Opened 7 years ago

Closed 5 years ago

#119 closed enhancement (not needed (anymore))

Generic CSV importer

Reported by: ghorwin Owned by:
Priority: critical Milestone: Future
Version: 2.0.x Keywords:
Cc: Operating System: all

Description

Add a menu option to "File" menu that allows importing of generic CSV/Text importer and works as follows:

  1. read the CSV
  • show dialog similar to Word/LibreOffice import wizard where user can select delimiter or none and use fixed column markers
  • additional parse options: quotes, trimming of values
  • preview of extracted file should be shown in a table preview
  1. User select one time 'index' column, or generates an index column according to some rule ("hourly values")
  1. User selects columns to import and assigns units (defaults to ---)
  1. User selects target directory (empty = default = same as CSV-file)
  1. Import settings for this file are stored in a file "filename.extension.p2import" (and read next time the file is imported)
  1. import is finished; all columns with same unit are grouped and written into a d6o-file (reference type) each. Project name is set to "filename.extension".

Employ fast csv reader library like:

https://github.com/ben-strasser/fast-cpp-csv-parser


and show a preview of the data as it would be interpr

Change History (1)

comment:1 by ghorwin, 5 years ago

Resolution: not needed (anymore)
Status: newclosed

Not needed - documentation shows meaningful ways on how to get from Excel/Calc to tsv... that should be enough.

Note: See TracTickets for help on using tickets.