2020.1

l
Add : Add a new external library. Use the standard Open dialog to browse and open
the .js file.
l
Delete : Remove the currently selected library from the data mapping configuration.
l
Replace : Open a library and replace it with the contents of a different js file.
l
Reload : Reload the currently selected library and any changes that have been made
to it.
Default Data Format
The Default Data Format settings defined here apply to any new extraction in made in the
current data mapping configuration. Any format already defined for an existing field remains
untouched.
It is also possible to set a default format for dates and currencies in the user preferences
("DataMapper preferences" on page821).
Specific settings for a field that contains extracted data are made via the properties of the
Extract step that the field belongs to (see "Editing fields" on page265).
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.
Note
Default data formats tell the DataMapper how certain types of data are formatted in the
data source. They don't determine how these data are formatted in the Data Model or in
a template. In the Data Model, data are converted to the native data type. Dates, for
example, are converted to a DateTime object in the Data Model, and will always be
shown as "year-month-day" plus the time stamp, for example: 2012-04-11 12.00 AM.
Page 325