2020.2

Default Format
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" on page197) 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: Any value in a numeric field that has a "-" sign before or after it is
interpreted as a 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 :
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.
Database Connection preferences
Dialog used to change the PlanetPress Connect back-end Database.
This dialog supports the swapping of the back-end database between various vendor
databases. Note, however, that the alternate vendor database(s) must already be installed and
available in order to swap to them.
This is not a migration tool. It is a simple connection tool, that enables shifting to a different
back-end database. Any existing data will not be transferred/ migrated between the databases,
and any existing File Stores will be cleansed by the Clean-up Service after the swap.
Page 830