Opened 12 months ago

Last modified 12 months ago

#1555 closed enhancement

Implement support for INCA data files that are in CSV format — at Version 1

Reported by: Nicklas Nordborg Owned by: Nicklas Nordborg
Priority: critical Milestone: INCA XML to CSV converter 1.5
Component: net.sf.basedb.reggie Keywords:
Cc:

Description (last modified by Nicklas Nordborg)

The current converter implementation only works with INCA source data in XML format. The XML format is being replace with a CSV format, so the converter need to support CSV source files as well. From the test data we have got it seems like the CSV files are formatted as:

  • Comma is used as a separator
  • Text values are quoted.
  • Date values can be both quoted and unquoted.
  • Numeric vales can be both quoted and unquoted (but some may be id-values)
  • NA is used instead of empty values (without quotes)
  • The column header is empty but the values seem to be the PAT_ID values.

Change History (1)

comment:1 by Nicklas Nordborg, 12 months ago

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