Namespace actionETL.FileHelper

Provides delimited (e.g. CSV) and fixed format dataflow import and export. Also see CSV Delimited and Fixed Format.

It uses the FileHelpers library internally.

Classes

FileHelperFileSource<TOutput>

A dataflow worker that reads delimited (e.g. CSV) or fixed format data rows from one or more files, and sends them to a downstream worker.

Please see CSV Delimited and Fixed Format for how to specify the data format. Internally, this worker uses the http://www.filehelpers.net/ library to read the data, specifically the FileHelperAsyncEngine class.

FileHelperFileTarget<TInput>

A dataflow worker with one Input port, for writing incoming data rows as delimited (e.g. CSV) or fixed format records to a file.

Note: Use the factory methods in FileHelperFileTargetFactory to create instances of this class.

Please see CSV Delimited and Fixed Format for how to specify the data format. Internally, this worker uses the http://www.filehelpers.net/ library to read the data, specifically the FileHelperAsyncEngine class.

FileHelperFileTargetFactory

Factory methods that create a FileHelperFileTarget<TInput> dataflow worker, which consumes incoming rows and writes them to a delimited (e.g. CSV) or fixed format file.

Please see CSV Delimited and Fixed Format for how to specify the data format. Internally, this worker uses the http://www.filehelpers.net/ library to read the data, specifically the FileHelperAsyncEngine class.

The Input port is linked to (if available) the upstream output or error output port specified by the factory.

Get the factory from Link when the upstream port is known ahead of time (which is usually the case). Otherwise get it from GetDownstreamFactory<TInput>(), and link the transform or target explicitly using LinkTo(InputPort<TOutput>) or LinkFrom(OutputPortBase<TInput>).

FileHelperStreamSource<TOutput>

A dataflow worker that reads delimited (e.g. CSV) or fixed format data rows from one or more streams, and sends them to a downstream worker.

Please see CSV Delimited and Fixed Format for how to specify the data format. Internally, this worker uses the http://www.filehelpers.net/ library to read the data, specifically the FileHelperAsyncEngine class.

FileHelperStreamTarget<TInput>

A dataflow worker with one Input port, for writing incoming data rows as delimited (e.g. CSV) or fixed format records to a Stream.

Note: Use the factory methods in FileHelperStreamTargetFactory to create instances of this class.

Please see CSV Delimited and Fixed Format for how to specify the data format. Internally, this worker uses the http://www.filehelpers.net/ library to read the data, specifically the FileHelperAsyncEngine class.

FileHelperStreamTargetFactory

Factory methods that create a FileHelperStreamTarget<TInput> dataflow worker, which consumes incoming rows and writes them as delimited (e.g. CSV) or fixed format records to a Stream.

Please see CSV Delimited and Fixed Format for how to specify the data format. Internally, this worker uses the http://www.filehelpers.net/ library to read the data, specifically the FileHelperAsyncEngine class.

The Input port is linked to (if available) the upstream output or error output port specified by the factory.

Get the factory from Link when the upstream port is known ahead of time (which is usually the case). Otherwise get it from GetDownstreamFactory<TInput>(), and link the transform or target explicitly using LinkTo(InputPort<TOutput>) or LinkFrom(OutputPortBase<TInput>).

FileHelperStringSource<TOutput>

A dataflow worker that reads delimited (e.g. CSV) or fixed format data rows from one or more strings, and sends them to a downstream worker.

Please see CSV Delimited and Fixed Format for how to specify the data format. Internally, this worker uses the http://www.filehelpers.net/ library to read the data, specifically the FileHelperAsyncEngine class.