Define Extra Keys

  1. Select Menu > Data > Extra Keys Setup > Extra Keys Define.
  2. Click New.
    The Extra Key Properties dialog box is displayed.
  3. On the Configuration section, specify this information:
    Name
    Specify the name of the extra key.
  4. On the Import Method section, select the applicable import method if it is New, Update, or Append.
  5. On the Keys section, specify this information:
    Dataset
    Select a dataset from the drop-down list.
    Extra Key
    Select an extra key from the drop-down list.
    Basic Keys
    Select the applicable keys from the list.
  6. On the Data Source section, specify this information:
    Provider
    Select a provider from the drop-down list. Provider is the data source from which an extra key is imported. These are some provider options:
    • ODBC
    • Excel
    • Access
    • SQLServer
    • OleDB
    • File - Select this option for CSV file loading.
    • Active version - Select this option to load the current DMP database. This is useful to select data from attribute and use it for multiple extra key or numeric key import.
    Provider Data
    Specify the provider data. Click the ellipsis icon to browse the selected file.
    User Name
    Specify the user name.
    Password
    Specify the password.
  7. On the File section, specify this information:
    Keys
    Define the Key and File Key.
    List Separator
    Specify a list separator from the drop-down list. If the list separator used in the CSV file you are importing is not available in the options, select other then specify the list separator in the text field .
    Decimal Separator
    Specify a decimal separator from the drop-down list. If the decimal separator used in the CSV file you are importing is not available in the options, select other then specify the decimal separator in the text field .
    Note: List Separator and Decimal Separator are only enabled and visible if a file is selected in Provider. DMP can only support importing of numeric values correctly if the separators defined match the ones in the CSV file. If the correct separators are not defined, this can cause errors or corrupted data import.
  8. Click OK.
    Note:  This functionality is only enabled for administrators.