Changes between Version 2 and Version 3 of i2b2 Mapped Importer Data Sources

Timestamp:

05/29/14 11:19:02 (10 years ago)

Author:

Richard Bramley

Comment:

--

i2b2 Mapped Importer Data Sources

@@ -43 +43 @@
 
 * {{{type}}}: {{{uk.org.briccs.i2b2mappedimport.input.csv.CsvDataSourceSet}}}
-* {{{Server}}}: ''The name of the SQL Server''
-* {{{database}}}: ''The name of the SQL Server database''
-* {{{username}}}: ''The username required to log on''
-* {{{password}}}: ''The password for the above user''
-* {{{query}}}: ''The query used to extract the patient data''
-
-The query should return a row for each patient, and contain a patient identifier.
+* {{{filename}}}: ''The filename of the CSV file''
+* {{{field_separator}}}: ''(Optional) The character that separates fields in a record.  The default is a comma. ''
+* {{{quote_character}}}: ''(optional) The character used to surround string values.  Use of the quote character around strings is optional, but strings cannot then include field or row separator characters.  The default is a double quote.''
+* {{{has_headers}}}: ''(optional)  Whether to use the first row of the CSV file as the column headers.  The default if false.''
 
 === Mapping Source
 
-The {{{source}}} attribute list for mappings should contain one item: the name of the field from the query.
+The {{{source}}} attribute list for mappings should contain one item, which identifies the field within the CSV.
+
+If headers are not specified, fields are identified by column number starting from "1".  Column numbers should be specified in the mapping file enclosed within double-quotes.  For example:
+
+{{{
+    source:
+     - "1"
+}}}
+
+
+If headers are specified, fields should be identified by the column header text with leading and trailing spaces removed.
 
 == !OnyxDataSourceSet