#1193 closed enhancement (fixed)

The "Map external data to releases" wizard should have more options

Reported by: Nicklas Nordborg Owned by: Nicklas Nordborg
Priority: major Milestone: Reggie v4.23.2
Component: net.sf.basedb.reggie Keywords:
Cc:

Description

The wizard currently expects that the first column contains personal numbers and translates them to release id values. It should be possible to translate in the other direction as well.

It should also be possible to translate to a personal number if the first column contains a case release id or a specimen release id.

It would also be nice if the wizard could output case release id and specimen release id in separate columns (when translating from personal number to patient release id). Originally, the wizard used to do this and then duplicated lines if a patient had more than one specimen. The new implementation should not do this. Instead, multiple values should be outputted as a comma-separated list in a single column.

Change History (10)

comment:1 Changed 12 months ago by Nicklas Nordborg

Status: newaccepted

comment:2 Changed 12 months ago by Nicklas Nordborg

Milestone: Reggie v4.24Reggie v4.23.2

comment:3 Changed 12 months ago by Nicklas Nordborg

In 5651:

References #1193: The "Map external data to releases" wizard should have more options

Added options for selected the mapping direction to the wizard. It is possible to select that the first columns should be a:

  • Personal number
  • Patient release ID
  • Case release ID
  • Specimen release ID


Depending on the selected input option, output options can be one or more from the same list.

The actual mapping has not yet been implemented.

comment:4 Changed 12 months ago by Nicklas Nordborg

In 5652:

References #1193: The "Map external data to releases" wizard should have more options

Implemented support for using patient release ID in the first column and made some preparations for the other cases.

Output is still only the patient release ID so the feature is not very useful yet.

comment:5 Changed 12 months ago by Nicklas Nordborg

In 5653:

References #1193: The "Map external data to releases" wizard should have more options

Output is now either patient release ID or personal number depending on the input.

comment:6 Changed 12 months ago by Nicklas Nordborg

In 5654:

References #1193: The "Map external data to releases" wizard should have more options

Implemented support for using case id or specimen id in the first column.

comment:7 Changed 12 months ago by Nicklas Nordborg

In 5655:

References #1193: The "Map external data to releases" wizard should have more options

Implemented a pre-parsing step in the browser that tries to detect if the first column contains release id values or not. It will check a few lines in the beginning of the file if they start with a letter 'Q', 'C' or 'S' which is followed by digits. If not, it is assumed that the file contains personal numbers. It will also display a preview of the first 3 lines from the file.

comment:8 Changed 12 months ago by Nicklas Nordborg

In 5656:

References #1193: The "Map external data to releases" wizard should have more options

Implemented support for exporting extra columns with case and specimen release id when the input data contains personal numbers.

comment:9 Changed 12 months ago by Nicklas Nordborg

In 5660:

References #1193: The "Map external data to releases" wizard should have more options

Added help text and minor changes to padding to make the user interface cleaner.

comment:10 Changed 12 months ago by Nicklas Nordborg

Resolution: fixed
Status: acceptedclosed
Note: See TracTickets for help on using tickets.