Ticket #437 (closed defect: fixed)

Opened 5 years ago

Last modified 5 years ago

Excel importer improvements

Reported by: business@… Owned by: business@…
Priority: major Milestone: 0.8.4
Component: Import wizard Version: 0.8.0
Keywords: Cc:
Hardware: Operating system:
Product: URL:


In the first step:

  • After entering the template editor, choices in the dropdowns are reset
  • In the preview, the count on the bottom line shows 190 instead of 187, caused by the header rows counted as well
  • The dropdown list of studies is not sorted, it should be, with 150+ studies in
  • Recurrent user error: forget to choose the right sheet and header row
  • Change: 'column header starts at' in 'column header is at'

In the second step:

  • Minor detail: The header rows are rendered above the dropdown boxes, however empty cells are not rendered at all, with the result that the dropdowns are not on the same line
  • Still no mouse-over help texts on the Clear, Match, Save... buttons (see a.o. #307)
  • If you choose a mapping that was made with a different header row, the headers are replaced - it should either complain or just rematch the names

In the third step:

  • BIG ERROR in table editor: it applies edits to the cell in the column right of the edited cell

In the fourth step:

  • Change 'The import was succesful' into 'The import preparation was succesful'.

In the fifth step:

  • Add a link to the newly created study

Change History

comment:1 Changed 5 years ago by work@…

  • Milestone changed from 0.8.1 to 0.8.2

comment:2 Changed 5 years ago by business@…

It should also be possible to delete mappings...

And it is OK if mappings only work for the exact same layout (same columns in same order). Otherwise it gets too hard to re-map (e.g. shuffle of 2 columns where one is set to a property and the other to 'don't import' - you cannot know which is which).

comment:3 Changed 5 years ago by work@…

  • Milestone changed from 0.8.2 to 0.8.3

comment:4 Changed 5 years ago by work@…

  • Component changed from Unknown to Import wizard

comment:5 Changed 5 years ago by work@…

  • Milestone changed from 0.8.3 to 0.8.4

comment:6 Changed 5 years ago by t.w.abma@…

  • Owner changed from t.w.abma@… to business@…
  • Status changed from new to assigned

All issues are fixed.

comment:7 Changed 5 years ago by business@…

  • Status changed from assigned to closed
  • Resolution set to fixed
Note: See TracTickets for help on using tickets.