Changes between Version 15 and Version 16 of i2b2 Mapped Importer

Timestamp:

05/29/14 15:46:47 (10 years ago)

Author:

Richard Bramley

Comment:

--

i2b2 Mapped Importer

@@ -141 +141 @@
 Date field used for observation start and end dates as well as patient dates of birth, etc.
 
+This field has an optional {{{format}}} mapping parameter.  The processing differs depending on whether this parameter is present and what type of data source is being used.
+
+If the parameter is provided the field will ask the data source for a string and attempt to parse it to a date using the provided date format string. If the parameter is missing, the field will ask the data source for a date value.
+
+If a database data source is asked for a date variable it will expect the column returned by the query to have a type of date.  If a text based data source, such as an XML or CSV file, is asked for a date, it will attempt to parse the text value using the format {{{yyyy-MM-dd'T'HH:mm:ss.SSSZ}}}.
+
 ====== Mapping
 
 * {{{type}}}: {{{uk.org.briccs.onyxmappedexport2pdo.fields.!DataSourceDateField}}}
+* {{{format}}}: (optional) Date format string (see [http://docs.oracle.com/javase/6/docs/api/java/text/SimpleDateFormat.html SimpleDateFormat]).  If missing the field will rely on the data source for date parsing.
 
 ==== !DataSourceEnumerationField