Refactoring #2137

Import data assistant minor changes

Added by herck about 2 years ago. Updated almost 2 years ago.

Status:ResolvedStart date:21 Aug 2018
Priority:NormalDue date:
Assignee:juan% Done:

100%

Category:-
Target version:Sprint 39

Description

  • When loading a csv file, the application first shows 'IO problem', while there is no problem.
  • 'File to import' versus 'Export' button
  • Remove headers row in favor of first data row
  • Possibly deduce separator
  • Row number input refers to the original file, while after 'Reload' these numbers are different
  • Ignore blank lines
  • Investigate automatic reload (might not be as user friendly as I first thought)

History

#1 Updated by juan about 2 years ago

  • % Done changed from 0 to 70
  • When loading a csv file, the application first shows 'IO problem', while there is no problem.
    -Done, now the application asks: 'Data format not recognized, do you want to open the Import Assitant?'
  • 'File to import' versus 'Export' button
    -Done, 'Export' button changed to 'Import'.
  • Remove headers row in favor of first data row
    -Done; The GUI is now less cluttered and is not an important parameter.
  • Row number input refers to the original file, while after 'Reload' these numbers are different
    -Done; now the line numbers in the table match the line numbers in the file.
  • Ignore blank lines
    -Only LAST blank line if present --IMO, if there are errors in the middle of files, users should pay more attention to the data they are trying to import.
    Implementation drawback: Ignoring random lines in the middle of the file would mess up the line numbering. If necessary, I'd opt for a more robust solution rather than just ignoring lines.
  • Investigate automatic reload (might not be as user friendly as I first thought)
    -If I were the user, I would be annoyed by the table changing shape whenever I click some field in the dialog boxes, I'd prefer it to reload only when clicking the reload button.
  • Possibly deduce separator
    -Working on it...

#2 Updated by juan about 2 years ago

  • Assignee set to juan
  • % Done changed from 70 to 100
  • Possibly deduce separator
    - Done, it only guesses the most common separators: SPACE, TAB, COMMA, SEMICOLON, and some other weird-but-probable choices: COLON, UNDERSCORE, SLASH, PIPE, BACKSLASH, QUOTE, DOUBLE QUOTE.

#3 Updated by juan almost 2 years ago

  • Target version changed from Sprint 38 to Sprint 39

#4 Updated by pospelov almost 2 years ago

  • Status changed from Sprint to Resolved

Also available in: Atom PDF