Skip to main content
Version: Classic

Excel/CSV

Configuration​

<!-- AddressService -->
<AddressProvider id="E10A8313-A92D-4CB2-A12B-9AEB58F39207" order="1" active="true">
  <!-- serverside Excel/CSV address provider -->
  <AddressProvider id="62C19ADA-826B-4EBC-848D-B32E957D78C6" Title="myCSVFile.csv">
    <SearchParameters>
      <SearchParameter Name="firstName" Label="Vorname/Name" Type="String" Length="100" Sort="1" />
    </SearchParameters>
    <FilePath>myCSVFile.csv</FilePath>
    <Provider Name="CSV"></Provider>
    <Icon></Icon>
    <Mapping>
      <!-- Insert mapping here -->
    </Mapping>
  </AddressProvider>
</AddressProvider>

Parameters​

  • id 62C19ADA-826B-4EBC-848D-B32E957D78C6
  • SearchParameter List of all possible inputs.
    • Name Unique id for the parameter. Corresponds to the column headers for CSV or for Excel files in which to search.
    • Label Displayed text in front of the input field. Type Input type: String (text), Long (number), Boolean (Yes/No) or Date. Length Maximum length for strings
    • Sort Sort value against the other parameters
  • Mapping Mapping to OneOffixx contact fields. See default contact mapping.
  • Provider Provider, either CSV or EXCEL. Specified in the Name attribute.
  • Title The title that will be displayed to the user.
  • Icon Base64 icon that will be displayed to the user in the recipient dialog.

File: CSV Provider​

Configuration​

<Provider Name="CSV">
  <HasHeaders>True</HasHeaders>
  <Delimiter>,</Delimiter>
</Provider>
  • HasHeaders Default value: True if the CSV file has headers. Otherwise False. If there are no headers, the columns will be numbered (adjust SearchParameters and mapping accordingly).
  • Delimeter Separator. Default value: ";".

File: Excel Provider​

Configuration​

<Provider Name="EXCEL">
  <HasHeaders>True</HasHeaders>
  <Sheet>Sheet 2</Sheet>
</Provider>
  • HasHeaders Default value: True, if the Excel file has headers. Otherwise False. If there are no headers, the columns will be numbered as in Excel (A, B...) (adjust SearchParameter and Mapping accordingly).
  • Sheet The Excel sheet to use. If no value is specified, the first sheet will be used.