Defining Numeric/Text for Keys

  1. From the menu, 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. On Configuration, specify this information:
    Name
    Specify the name of the numeric/text key.
  4. On Import Method, select the applicable option if it is New, Update, or Append.
  5. On Keys, 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. You can select from these 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. If File is selected, the File section is displayed. 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 .
    Note: The default value changes based on the regional settings of the user's machine
    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: The default value changes based on the regional settings of the user's machine
    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. If other providers are selected, the Query section is displayed. Specify this information:
    Expression
    Specify the query to use to retrieve the information in Provider Data.
    UserArg1, UserArg2, UserArg3, UserArg4
    Optionally, specify additional arguments to the query in these fields.
  9. Click OK.
    Note:  This functionality is only enabled for administrators.