Language field Validation

[Former Member]

Hello

Currently we have a DESCRIPTION field in English and French.I have a validation on this field

IS_NOT_NULL(DESCRIPTION)

But this only checks for the English version and not for French,so I tried to include LANGUAGE function like below:

If (Language= English [US] THEN
IS_NOT_NULL(DESCRIPTION)
ELSE if (Language= French [FR] THEN
IS_NOT_NULL(DESCRIPTION)
ELSE
NULL))

Still this does not check the French version.

Any ideas

Regards

Kalyan

[Former Member · Accepted solution]

Hi,

There is nothing wrong in the expression..

If (Language= English [US] THEN

IS_NOT_NULL(DESCRIPTION)

ELSE if (Language= French [FR] THEN

IS_NOT_NULL(DESCRIPTION)

ELSE NULL))

I tried it at my end, It is working fine.

See For French Version, it should validate only if you open your MDM Data Manager with

Language: French(FR) not with English(US). Then try to Run this validation.

This validation will fail if this field DESCRIPTION value is not in Black color(Primary Language). I mean if it is in any other color(RED or Green) Primary inherited or Secondary Inherited. It will fail.

But if this field value is in Black Color, this validation will not fail.

Thats why for English language it is working fine not for French version as you are opening Data Manager with English(US) only every-time.

Try it at your end & let me know if you still face any issue.

Thanks and Regards,

Mandeep Saini

[Former Member · Accepted solution]

I still have the same issue

We are upgrading to SP4 next week..and will try the same there and keep you posted

BTW: what is your version?

Thanks

Kalyan

[Former Member · Accepted solution]

Hi,

I am using MDM 7.1 SP3.

For French validation, Have you tried opening your MDM Data Manager with Language French(FR) not English(US).

After opening your MDM data Manager with Language (FR) try to run this validation, it should work

Thanks and Regards,

Mandeep Saini

[Former Member · Accepted solution]

Thanks for the reply

I have not tried that..and I am sure that will work

My requirement is that for ENGLISH only users we want FRENCH fields to be validated.

Thanks

[Former Member · Accepted solution]

As per my understanding, I don't think opening MDM Data Manager using Language English(US) you can validate this for French(FR), you have to open MDM data Manger with French(FR) to run to validation to validate that this French(FR) field is Primary or not, i mean that field is populated with French value or inherited from English.

If it is in black color then this validation passes else fails if it is inherited from English(US), i mean if it is in different color(Red or Green).

Using English(US) data manager, it will validate only for English language, it won't check for French whether its Primary or inherited.

User who can login to data manager with Language English(US) can also open MDM data Manager with French(FR)

Just check and revert with the result.

Thanks and Regards,

Mandeep Saini

[Former Member · Accepted solution]

Hi

You are correct:)

Multi lingual validations cannot validate the inherited if the data manager is opened in the primary and vice-versa..

Thanks

[Former Member]

Hello Kalyan,

If (Language= English [US] OR French [FR] THEN
IS_NOT_NULL(DESCRIPTION))

Please check if the above code works as a replacement. Hope this solves you.

Regards,

Manish.

[Former Member]

Thanks for that code

But still that doesnt solve the issues.

We have created the French description as Primary inheritance in the repository

Could this make any difference if it is secondary inheritance?

Whats the difference?

Regards