Defining Numeric/Text for Keys

  1. Select Data > Numeric/Text for Keys Setup > Numeric/Text for Keys Define.
  2. Click New.
    The Numeric/Text for Keys Properties dialog box is displayed.
  3. In the Configuration section, specify this information:
    Name
    Specify the name of the numeric/text key.
  4. In the Import Method section, select the applicable import method if it is New, Update, or Append.
  5. In the Keys section, specify this information:
    Dataset
    Select a dataset from the list.
    Numeric/Text for Keys
    Select a numeric/text key from the list.
    Basic Keys
    Select the applicable keys from the list.
  6. In the Data Source section, specify this information:
    Provider
    Select a provider from the list. Provider is the data source from which an numeric/text 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. In the File section, specify this information:
    Keys
    Define the Key and File Key.
    List Separator
    Specify a list separator from the 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 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.