Characters Problem In MDM

[Former Member]

Hello experts,

I have an application built in Portal 7.0 and MDM 5.1

I have a text field for eg. Name which is entered onto the portal input field as for eg" Yogesh Bhatia".

But for some reason or other in MDM it is getting stored with some invalid characters which is diplayed in MDM Data Manager with square values

For eg. "Yogesh Bhatia [] [] [] [] [] [] []"

Again seeing on portal it displays the value as "Yogesh Bhatia ########"

What can be the issue here? How can itb

[Former Member]

Hi Yogesh,

as per you details the problem with source file there is nothing to at MDM side. how you get source file in excel or XML ??

following point may help you

1. if excel file just check field length by using len function because space will also count as character and sometime it get converted to # symbol

2. or if source file coming from SAP or any legacy system in XML or excel make sure space should not include for this field. for e.g. if your field length is 20 and name is "Yogesh Bhatia" so after counting 13 by default system will pass space for that field as length is 20 so name would be "Yogesh Bhatia#######" so if you are using any intermidiate software like XI just tructed this space after name and also you can use use MDM

Thanks,

Jignesh Patel

[Former Member]

Hi Yogesh

Please also check how the record's Name field is getting value. Is is being saved from Portal or there is any interface creating the records first. If records are cretaed by the interface first check the PI mappings too- are they taking care of special characters coming from the source system?

hope this helps-Ravi

Edited by: Ravi Kumar on Sep 3, 2010 7:35 AM

[Former Member]

Hi Yogesh,

Are you entering the value in portal by manual or you copy paste it from a file?

When you copy paste from a file, there may be blanks in the cell which is also get copied which causes the issue

So copy only the contents by pressing Key F2 in the cell of the excel file

Hope it helps if not kindly revert

Regards,

Antony