Skip to Content
avatar image
Former Member

Delimiter in Syndication Maps for Multi-Valued Fields

We are in the process of upgrading to MDM 7.1 from MDM 5.5. In one of our syndication maps we are syndicating a multi-valued hierarchy field with no particular limit as to how many values the field can hold. In the old MDM 5.5 Syndication map the xml output delimits this data with ";" (semi-colon) as in the below example.

<Field>Level 1Level 2Value 1; Level 1Level 2Value 2;Level 1Level2Value 3</Field>

In MDM 7.1 the values are separated by a "," (comma) like in the example below.

<Field>Level 1Level 2Value 1, Level 1Level 2Value 2, Level 1Level2Value 3</Field>

Is there anyway to change the delimiter in MDM 7.1 from a "," (comma) to a ";" (semi-colon) with out splitting the field?

Thanks!

Sincerely,

Courtney

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 07, 2010 at 06:51 PM

    Hi ,

    I think there is some setting missing in map.

    As in most of the cases of upgradation we need to check whether maps settings are same or not.

    Please check whether the map settings are same as before or not.

    first thing i want to know what separator is coming for different records separation as , is used to differenet record separation.

    as you mentioned that

    in one of our syndication maps we are syndicating a multi-valued hierarchy field with no particular limit as to how many values the field can hold.

    Could you please check that the limit property that a field hold values.

    Please check and inform us about the findings.

    Thanks,

    Sudhanshu

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Courtney,

      I am not quite sure but would suggest check if you get MDM Data Manager/syndicator Component build as (7.1.04.142). Try installing Data Manager and syndicator with build(7.1.04.142). As your build is quite close to my build. So I think even if you install only data manager and syndicator with this build(7.1.04.142), it would be compatible with MDM server build(7.1.04.144). Please let me know which delimiter are you getting as i am getting semi-colon ";" at my end. Kindly revert with result.

      Regards,

      Mandeep Saini

  • avatar image
    Former Member
    Sep 08, 2010 at 07:15 AM

    Hi Brewer,

    Is there anyway to change the delimiter in MDM 7.1 from a "," (comma) to a ";" (semi-colon) with out splitting the field?

    Yes, for e.g in in your syndication map at source item lookup field display as follows

    Country

    |___ Code

    |___ Name

    just map country to destination item instead of using Code or Name, multi vaule will display with ; operator

    In one of our syndication maps we are syndicating a multi-valued hierarchy field with no particular limit as to how many values the field can hold.

    if you want to set length of field you require to set properties at destination item as follows :

    Fixed Column Width : the specific with destination item

    Max Item Length : Maximum length allowed for the item

    Hope Above mention point will resolved your problem if not revert back

    Thanks,

    Jignesh Patel

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Brewer,

      it seems problem with MDM Version 7.1.04.144, so i would suggest utilize MDM SP05 latest patch introduce by SAP or try to handle at intermediate software for e.g. SAP PI , Tibco etc

      Hope this will resolve your problem

      Thanks,

      Jignesh Patel