ReadCSVDocument (Activity)

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^®.

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 name of the character encoding (e.g. "iso-8859-15") used for reading the input file - List of UBIK character encodings; default is "UTF-8"
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

Using the InputEncoding "ANSI" means that the imported text is read according to the default Windows System Locale Setting (e.g. English-US)!

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

See also

• Workflow Designer
• GetXPathResult (Activity)