Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »


Via the CsvData provider .csv files can be accessed.

Configuration

In addition to the Mapping and SearchParameters configuration, which all DataProviders 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 file

  • HasHeader bool, indication whether first row is a header row

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

  • No labels