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 rowDelimiter
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>