Versions Compared

Old Version 1

changes.mady.by.user Dinah Bolli (Unlicensed)

Saved on

compared with

New Version Current

changes.mady.by.user Samuel Egger

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents

Über den CsvDataProvider kann auf .csv-Dateien zugegriffen werden.

Konfiguration

Neben der Mapping- & SearchParameters-Konfiguration, welche alle DataProvider der Datenschnittstelle benötigen, kann der CsvDataProvider über das Option-Element konfiguriert werden:

...

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:

Code Block
languagexml
<CsvDataProvider DisplayName="KundenadressenCustomer addresses">
    <Options>
      <FilePath>\\fileshare\addressdata.csv</FilePath>
      <HasHeaders>true</HasHeaders>
      <Delimiter>,</Delimiter>
    </Options>
    ...
</CsvDataProvider>

  • FilePath: string, Pfad zur CSV Dateipath to csv file

  • HasHeader: bool, Angabe ob die erste Zeile eine Kopfzeile ist

  • Delimiter: string, Angabe des Trennzeichens.

Beispiel

...

  • 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

Example

Code Block
languagexml
<CsvDataProvider DisplayName="KundenadressenCustomer 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>

...