Dates and numbers formatting – MDM standard iViews

July 20, 2009 at 6:33 pm

[] [] [] [] [] [] [] [] [] []

  1. Numbers after decimal point displayed differently- MDM iViewSymptom Formatting of MDM Real, Measurement or Currency field types with 1 or more digits after the decimal point appear to be different when comparing these fields in Item Details Edit mode...
  2. Inability to open images and Pop-up windows – MDM iViewsSymptom There are 3 possible symptoms to this issue: 1. MDM Portal iViews image fields are not displaying image. Instead of the linked image, a red “X” is displayed. In addition, Portal...
  3. MDM Portal iViews does not load large filesSymptom When trying to open large files (PDF, Word, Excel, Video, Music etc.) in MDM Portal iViews (either a Result Set or Item Details iView), the file is not accessisble and instead...
  4. MDM portal iViews – setting logging severitySymptom You would like to increase the logging severity for MDM Portal iViews component, but you can not locate the relevant location in the Visual Admin Log Configurator Other terms MDM, iViews,...
  5. How to upload a MDM Portal iViews custom .PAR fileSymptom You have been requested by SAP support to upload a special customized .PAR file to your Portal environment. Other terms MDM, Portal, PAR, Custom Solution In order to upload the custom...
  6. MDM Change tracker (Web UI) tuple limitations in 7.1 SP00/01Symptom When using MDM 7.1 SP00/SP01, after making changes to the tuple field for a specific record, The permanent ids within the change history table are populated inconsistently. This results in the...
  7. MDM Item Details iView – “Record is protected” messageSymptom When trying to edit a record via MDM Portal Item Details iView you see a message that “Record is protected, record is checked out” and you can not edit it. Trying...
  8. MDM Portal Content deployment fail – MDM 7.1 SP02Symptom You are trying to update your MDM Portal content or the MDM Java API to MDM 7.1 SP02 Patch03 or a higher version and receive the following deployment error: SDM has...

Symptom

Date and numbers format do not match the user regional setting
Other terms

Date, Currency, Real, MDM, Portal, iView
Reason and Prerequisites

MDM Standard Portal iViews formatting of dates and numbers are determined at runtime according to the portal users language property. (If this property is empty, the setting will be set according to the Browser Language Preferences settings).
Note that adjustments to this property also impact the MDM data and MDM metadata language.
Solution

To modify this property in the portal, go to Personalize -> User Profile. In the General Information tab, select the Language property value according to which all formatting will be applied (e.g. If you set the language property to ‘English[US]‘ then the date format will be displayed as 5/27/2008, while if set to ‘German[DE]‘ it will be 27.5.2008).
These settings will affect the following MDM date fields types:
Time Stamp, Create Stamp, Literal Date and GM Time.
The same principle applies to formatting of the following MDM number fields: Currency, Integer, Real, and Measurement fields.
Note: Decimal Symbols, Date Separators and other settings are not customizable and they default to the MDM Java API formatting
setting when in View mode, and for Edit mode, the settings are according to the underlying portal standard UI formatter settings.
As of MDM 7.1 SP02 and MDM 5.5 SP06 Patch04, MDM iViews behave in the
same manner for both View and Edit mode and the formatting is done
according to Java standard.

[Slashdot] [Digg] [Reddit] [del.icio.us] [Facebook] [Technorati] [Google] [StumbleUpon]

Leave a Comment