2018.2

l
Test Connection: This will run a test on the current Database Connection settings.
l Restore Defaults. This option restores the preferences to Defaults. This applies to the
current Preferences page only, but not other Preferences.
l
Apply: This option Applies the settings made within the current Preferences page, but
does not close the Preferences dialog.
------------------------------------------------------------------------------------------
DataMapper preferences
DataMapper XML Preferences
l
Display New Line Character as ¶ : Check to show line returns as ¶ in the Data Viewer,
when XML files are shown. If the option is unchecked, you will not see spaces and line
returns after element names in the Data Viewer.
DataMapper Default Format Settings
DataMapper stores user preferences for the Date, Number and Currency formats. By default,
the user preferences are set to the system preferences. These user preferences become the
default format values for any newly created data mapping configuration.
Format settings can also be defined at the data mapping configuration level (Data mapping
configurations) and/or per field in the Data Model. Any format settings specified in an existing
field are always used, regardless of the user preferences or data source settings.
l
Negative Sign Before : A negative sign will be displayed before any negative value.
l
Decimal Separator : Set the decimal separator for a numerical value.
l
Thousand Separator: Set the thousand separator for a numerical value.
l
Currency Sign : Set the currency sign for a currency value.
l
Date Format : Set the date format for a date value.
l
Date Language : Set the date language for a date value (ex: If English is selected, the
term May will be identified as the month of May).
l
Treat empty as 0 : A numerical empty value is treated as a 0 value.
The DataMapper Preferences also provides you with buttons to :
Page 324