Define Numeric/Text for Keys
- Select Data > Numeric/Text for Keys Setup > Numeric/Text for Keys Define.
-
Click New.
The Numeric/Text for Keys Properties dialog box is displayed.
-
On the Configuration section, specify this information:
- Name
- Specify the name of the numeric/text key.
- On the Import Method section, select the applicable import method if it is New, Update, or Append.
-
On the Keys section, specify this information:
- Dataset
- Select a dataset from the drop-down list.
- Numeric/Text for Keys
- Select a numeric/text key from the drop-down list.
- Basic Keys
- Select the applicable keys from the list.
-
In the Data Source section, specify this information:
- Provider
- Select a provider from the drop-down 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.
-
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. -
Click
OK.
Note: This functionality is only enabled for administrators.