CsvSource<TOutput>

Class CsvSource<TOutput>

Reads data from a csv source. While reading the data from the file, data is also asnychronously posted into the targets. Data is read a as string from the source and dynamically converted into the corresponding data format.

Inherited Members
Namespace: ETLBox.Csv
Assembly: ETLBox.Csv.dll
Syntax
    public class CsvSource<TOutput> : DataFlowStreamSource<TOutput>, IDataFlowStreamSource<TOutput>, IDataFlowExecutableSource<TOutput>, IDataFlowSource<TOutput>, IDataFlowStreamSource, IDataFlowExecutableSource, IDataFlowSource, IDataFlowComponent, ILoggableTask
Type Parameters
NameDescription
TOutput

Type of outgoing data

Examples
CsvSource<CSVData> source = new CsvSource<CSVData>("Demo.csv");
source.Configuration.Delimiter = ";";

Constructors

CsvSource()

Declaration
    public CsvSource()

CsvSource(string)

Declaration
    public CsvSource(string uri)
Parameters
TypeNameDescription
stringuri

The source csv file name or uri

CsvSource(string, ResourceType)

Declaration
    public CsvSource(string uri, ResourceType resourceType)
Parameters
TypeNameDescription
stringuri

The source csv file name or uri

ResourceTyperesourceType

Specifies if data is loaded from a file, a web endpoint or other storage types (e.g. Azure Blob Storage)

Properties

Configuration

The CsvHelper Configuration. E.g. you can change the delimiter or the escape character here.

Declaration
    public CsvConfiguration Configuration { get; set; }
Property Value
TypeDescription
CsvConfiguration

CsvContext

Gives you access to the CsvHelper CsvContext. You can modify the context before data is read.

Declaration
    public Action<CsvContext> CsvContext { get; set; }
Property Value
TypeDescription
Action<CsvContext>

FieldHeaders

The parsed header names from the csv

Declaration
    public string[] FieldHeaders { get; }
Property Value
TypeDescription
string[]

Methods

CheckParameter()

Declaration
    protected override void CheckParameter()
Overrides

CloseReader()

Declaration
    protected override void CloseReader()
Overrides

InitReader()

Declaration
    protected override void InitReader()
Overrides

ReadAllRecords()

Declaration
    protected override void ReadAllRecords()
Overrides

ReadFieldHeaders(string)

Reads the header names using the current configuration.

Declaration
    public string[] ReadFieldHeaders(string uri = null)
Parameters
TypeNameDescription
stringuri

Optionally you can override the current configured Uri

Returns
TypeDescription
string[]

An array with the header names

Implements