CsvDataProvider
Via the CsvData provider .csv files can be accessed.
Configuration
In addition to the Mapping
and SearchParameters
configuration, which all DataProvider
s of the Data interface require, the CsvDataProvider
can be configured via the Option
element:
<CsvDataProvider DisplayName="Customer addresses">
<Options>
<FilePath>\\fileshare\addressdata.csv</FilePath>
<HasHeaders>true</HasHeaders>
<Delimiter>,</Delimiter>
</Options>
...
</CsvDataProvider>
FilePath
string, path to csv fileHasHeader
bool, indication whether first row is a header row
If there are no headers, the columns will be numbered (0, 1, ...) (important forSearchParameters
andMapping
).Delimiter
string, indication of the delimiter
Example
<CsvDataProvider DisplayName="Customer addresses">
<Options>
<FilePath>\\fileshare\addressdata.csv</FilePath>
<HasHeaders>true</HasHeaders>
<Delimiter>,</Delimiter>
</Options>
<SearchParameters>
<Text Id="Firma" Label="Firmenname" />
<Text Id="Ort" Label="Ort" />
</SearchParameters>
<Mapping>
<Map Source="Firma" Target="CompanyName" />
<Map Source="Strasse" Target="Street" />
<Map Source="PLZ" Target="PostalCode" />
<Map Source="Ort" Target="City" />
<Map Source="Land" Target="Country" />
</Mapping>
</CsvDataProvider>
Â
PrimeSoft AG, Bahnhofstrasse 4, 8360 Eschlikon, Switzerland