2022.2

ManualsBrandsObjectif Lune ManualsApplicationsPlanetPress Connect

781

782

783

784

785

786

787

788

789

790

Table Of Contents

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

Treat empty as 0:Anumericalemptyvalueistreatedasa0value.

l

Date/Time Format:Setthedateformatforadatevalue.

l

Automatic:Selectthisoptiontoparsedatesautomatically,withoutspecifyingaformat.

ThisisthedefaultsettingfornewDatefields.

l

ISO8601:Thissettingallowsfordateswithdifferenttimestampformats,orbelongingtodif-

ferenttimezones,tobeparsedinsideasinglejob.Datesthatdonotincludeaspecifictime

areautomaticallyconsideredtousethecurrentlocale'stimezone.

SelecttheISOtemplatetobeusedwhenparsingthetimestamp.OtherISO8601formats

canbehandledviatheCustomoption.

l

Custom:Setacustomdateformat.ForthemarkersavailableintheDataMappersee

"Date"onpage278.

l

Date Language:Setthelanguageforadatevalue(ex:IfEnglishisselected,thetermMaywill

beidentifiedasthemonthofMay).

l

Use offset from UTC:Selectthedefaulttimezone,whichistobeusedtoextractanytimestamp

thatdoesnotalreadyincludetimezoneinformationwiththetime.

IntheDataModel,time stampscanbe:

l

Displayed in Local Time:Thetimeisformattedinaccordancewiththecurrentoperatingsys-

tem'sregionalsettings.

l

Displayed as UTC/ISO:ThetimeisdisplayedinUTC(CoordinatedUniversalTime)following

ISO8601.

NotethatthissettingonlyimpactshowdatesaredisplayedintheDataModel.Itdoesnotchangehow

datesarestoredintheConnectdatabase,norhowtheyaredisplayedinatemplate.

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,

Page 787