CsvDataProvider

---

Via the CsvData provider .csv files can be accessed.

Configuration

In addition to the Mapping configuration and the optional SearchParameters (see Data interface), 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
  If there are no headers, the columns will be numbered (0, 1, ...) (important for SearchParameters and Mapping).
• Delimiter string, indication of the delimiter

Search and file access

• Search: the Id of a SearchParameter is mapped to the column name (with a header row) or the 0-based column index (without a header row). The comparison is a substring (contains) match and is not case-sensitive. Empty search parameters are ignored; multiple search parameters are combined with AND.
• File access: the FilePath is resolved and opened server-side (on the server running the data interface). An absolute path or UNC path is expected; the file must be reachable by the server process.

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>