Opened 7 years ago

Last modified 7 years ago

#969 closed enhancement

Changes to Frozen tissue date import wizard — at Version 1

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

Description (last modified by Nicklas Nordborg)

  • The import should work with the complete TAB-separated file. The first line is a header line with column names. The SCAN-B ID is found in the "ProvID" column. When converting the XLS file to text it should be saved with TAB as separator, UTF-8 as character encoding, and no text delimiter.
  • SCAN-B ID can appear in different forms that should be supported:
    • 1234567
    • 12-34567
    • 1234567C
    • 12-34567C
    • PAD value (=any other format)
  • The importer should check that consent is acceptable (=Yes or missing). It should not import anything to items with "No" or "Not asked". Entries with non-acceptable consent should be reported when the wizard has finished.
  • Duplicates should be reported when the wizard has finished.
  • Entries with no match in BASE should be reported when the wizard has finished.

Change History (2)

by Nicklas Nordborg, 7 years ago

Attachment: xls2tsv.png added

comment:1 by Nicklas Nordborg, 7 years ago

Description: modified (diff)
Note: See TracTickets for help on using tickets.