Difference between revisions of "Activity:ReadCSVDocument (Activity)"
(→Example) |
|||
| Line 29: | Line 29: | ||
|- align="left" | |- align="left" | ||
| FirstRowIsHeader|| Boolean|| In || Set this to true to ignore the first line (i.e. because it contains header information), to false if the first line should also be processed | | FirstRowIsHeader|| Boolean|| In || Set this to true to ignore the first line (i.e. because it contains header information), to false if the first line should also be processed | ||
| + | |- align="left" | ||
| + | | InputEncoding|| String|| In || The character encoding name (e.g. "iso-8859-15") of the input file ([[CharacterEncodings|List of possible encodings]]);<br/>If not defined, the default encoding "UTF-8" will be used. | ||
|- align="left" | |- align="left" | ||
| RowName|| String || In || The name of the generated XML element for a row; default is ''Row'' | | RowName|| String || In || The name of the generated XML element for a row; default is ''Row'' | ||
Revision as of 17:03, 26 February 2014
| Read CSV Document | |
|---|---|
| Name | ReadCSVDocumnent |
| Purpose | Load a CSV file as XPath document |
| Category | Data Exchange |
| Returns | True if successful |
| Version | 2.1.16+ |
The ReadXPathDocument Activity loads a CSV File into the workflow and transforms it into XML for further processing using XPath expressions. It is the root activity for an import of CSV data into UBIK®.
Contents
Arguments
| Argument | Type | Direction | Purpose |
|---|---|---|---|
| ColumnName | String | In | The name of the generated XML element for a column; default is Column |
| FileName | String | In | The full path to an accessible CSV file |
| FirstRowIsHeader | Boolean | In | Set this to true to ignore the first line (i.e. because it contains header information), to false if the first line should also be processed |
| InputEncoding | String | In | The character encoding name (e.g. "iso-8859-15") of the input file (List of possible encodings); If not defined, the default encoding "UTF-8" will be used. |
| RowName | String | In | The name of the generated XML element for a row; default is Row |
| Separator | Char | In | The char that separates columns in the source file |
| XPathDocument | XPathDocument | Out | The loaded file as XPath document, null if loading failed |
| Result | Boolean | Out | Returns True on success, false on error |
Usage
This activity is typically used to start the import of CSV data by providing the loaded document to subsequent GetXPathResult activities.
Example
Load the CSV file C:\temp\test.CSV with the following content into the workflow:
FIRST NAME;LAST NAME;DATE OF BIRTH
John;Doe;01.01.1970
Jane;Doe;01.02.1971
Jebediah;Springfield;01.03.1774
| Argument | Value |
|---|---|
| FileName | "C:\temp\test.CSV" |
| FirstLineIsHeader | True |
| Separator | ";"C |
