Content Studio attributes display format

[vervinckt_joyca]

Hi all,

I was wondering if it is possible to change the formatting of some variable attributes in the content studio.

We have for example a Date field, that currently displays as MM/DD/YYYY in the email, but we'd need it to be DD/MM/YYYY.

Also the "Quantity" field of products ordered in a sales order, displays as e.g. 2.00000 blisters currently, we'd like it to be without decimals.

Is that possible?

I already checked in "Configure your solution" the configuration step "2. Check Units of Measurement". I checked and/or added my UOM's in there with decimal places = 0, but that does not change how it is displayed in the email.

PS, my "Quantity" field is within the "Interaction" block, and in the html I can see the following technical field is behind it:

<p>Quantity: <input title="Interaction Product - Quantity" type="button" value="Quantity" data-sap-hpa-ceimo-attrib-pers="|%PI-INTERACTION|C_MKT_CNTNTPLUGININTACTNPROD-INTERACTIONPRODUCTQUANTITY%|" /></p>

[former_member599277]

Hello Joyca,

Please refer document

Specify the Design of a Personalized Email or Email Template - SAP Help Portal

Under the Toolbar Functions table , in Function Insert attribute ,

You can find the below information on how these attributes behaves

The date and time formatting happens according to the recipients country information.

• The way in which the date fields are formatted is dependent on the country of the recipient of the personalized message. The way in which fields with times or time stamps are formatted is dependent on the country of the recipient and the time zone.
• The formatting of fields of the type number, quantity, and currency, which belong to attributes from the contact, product or offer, is performed in the message according to the recipient.

Hope this helps.

Regards,
Saravana.

[vervinckt_joyca]

Thanks for that input saravana92 !

What happens if the country of the recipient is unknown? Is there some way to set a "default" display format for dates?

For the quantity fields, the documentation mentions "formatting is performed according to the recipient". I don't understand what that means. Is there a field on the recipient that decides how many decimals the ordered quantity field should get?

Kr

Joyca

[former_member599277]

Hello Joyca,

The logic checks for the contact country and if it is blank , then it automatically sets a default format and we cant modify the same from our end.

For Number fields as well , the format is defaulted as per the country if I am not wrong , but I can confirm the same.

But we don't have any option to change it manually from our end .

Regards,
Saravana.

[vervinckt_joyca]

Hi Saravana,

I edited my test profile to have country Belgium.

This indeed helps for the Date notation,

but it does not change the Quantity fields, they are still show as "1.00000 PCE" for example.

The configuration for Units of Measurement of PCE is set to 0 decimals, and on the UI on the contact factsheet on the interaction details, this is correctly applied.

The configuration of the country BE only mentions a date format DD.MM.YYYY and a Deciman format 1 234 567,89 and time in 24 hour format, I don't see any setting that determines that quantity fields should have 5 decimals...

So where can I see / check / change that these 5 decimals should be used?

[vervinckt_joyca]

Hi saravana92,

Do you have any more info on the Number/Quantity fields, as you mentioned "For Number fields as well , the format is defaulted as per the country if I am not wrong , but I can confirm the same."? In my test the Country does not seem to impact the display of the quantity in an email. Configuration on UOM level impacts the Mkt Cloud UI, but not the email...

[former_member599277]

Hi Joyca,

I checked at the code level for the logic being Quantity and Currency and I can confirm that its trying to use the Country of the recipient for the format , can you try creating a contact with different country like one with India , etc and try once , If nothing changes as per country , Please raise an Incident to SAP to check on the same.

Regards,
Saravana.

[former_member762721]

Hello Saravanakumar

What if we don't need the system to change the field format automatically?

For example we are getting 92,00 when adding the attribute, but we dont't need decimals and need only the whole number?

Regards,

Oleg