Skip to Content
0
May 05, 2009 at 08:55 PM

Product Long Text for Different Text Types

21 Views

We have requirement to Store long text description associated with the Product for multiple text types such as WEB, PRINT etc.

Text type will be qualifier and depending upon text type, long text will be populated. Both fields Text type and long Text will be multilingual fields. Our Interface transfer Long Text field values in multiple languages with text type ID along with other Product information.

Now Problem is long text field can be more than 333 characters in Source system and we cannot use MDM Field Type u201Ctextu201D to for this field, as this field type has restriction of 333 characters length. If we use u201CText Largeu201D field type for Long text, it is always set as non qualifier and non display field and doesnu2019t allow us to change its properties to Qualifier and display field.

If we make long text field as non qualifier then we are not able populate data in multiple languages for long text field along with other Product Main table Fields. Also as per MDM design, Non qualifiers are always populated first before importing Main table data, which is not possible in our case for Long Text field, as this field value will come along with Product data. Because of these reasons we are not willing to use field type u201CText largeu201D for Long text. Or the only option left is to create multiple fields in Main table for each text types.

Please can you suggest is there any way by what we can achieve this requirement.

Regards,

Shiv