cancel
Showing results for 
Search instead for 
Did you mean: 

ValueX Folder data during Import

Former Member
0 Kudos

All,

I am working on MDM 7.1 SP06. The problem I am facing is as below -

I am trying to import an xml with 2 records in it. The structure of the xml is as below(example shows 1 record) -

<Body>

<CT-AND-SA-Data>

<Designatory-Data>

<Legacy-Business-Partner-ID>CT-1000001</Legacy-Business-Partner-ID>

<Category>Limited Company or PLC</Category>

<Partner-Name>CT Sample Name 1 Changed 1</Partner-Name>

<Partner-Type>CT</Partner-Type>

<Trading-Name>Sample Trading Name changed</Trading-Name>

<Tax-Solvency-Status>I</Tax-Solvency-Status>

<Partner-Status>A</Partner-Status>

<Address-Data>

<Address-Type>Correspondence Address</Address-Type>

<Address-Line1>Address Line 1 - Changed1</Address-Line1>

<Address-Line2>Address Line 2</Address-Line2>

<Address-Line3>Address Line 3</Address-Line3>s

<Address-Line4>Address Line 4</Address-Line4>

<Address-Line5>Address Line 5</Address-Line5>

<Address-Line6>Address Line 6</Address-Line6>

<Name>Address Data Name</Name>

<Postal-Code>HA0 2HR</Postal-Code>

<Country>GB</Country>

<Primary-Number>12345678901234567890</Primary-Number>

<Primary-Name>Primary Name</Primary-Name>

<Secondary-Address>Secondary Address</Secondary-Address>

</Address-Data>

<Address-Data>

<Address-Type>Registered Office Address</Address-Type>

<Address-Line1>Address Line 1-1 - Changed</Address-Line1>

<Address-Line2>Address Line 2-2</Address-Line2>

<Address-Line3>Address Line 3-3</Address-Line3>

<Address-Line4>Address Line 4-4</Address-Line4>

<Address-Line5>Address Line 5-5</Address-Line5>

<Address-Line6>Address Line 6-6</Address-Line6>

<Name>Address Data Name 1</Name>

<Postal-Code>HA0 2HE</Postal-Code>

<Country>GB</Country>

<Primary-Number>12345678901234567890</Primary-Number>

<Primary-Name>Primary Name</Primary-Name>

<Secondary-Address>Secondary Address</Secondary-Address>

</Address-Data>

</Designatory-Data>

</CT-AND-SA-Data>

</Body>

The one of the record in this XML is correct with respect ot structure as well as values however the second record has an invalid value in one of the field though structure is OK

When I am importing this file through MDIS, the record which is correct is getting imported hoever the second record with value mapping problem is not getting imported which is OK.

The file is getting copied to ValueX folder in exception folder. According to me the file in ValueX folder should only contain 1 record which is failed and not the other record which has been succesfully imported.

However in my case the file in ValueX folder contains both the records (successful as well as un-successful one)

Can you please let me know the reason? Am I doing somehting wrong here?

Regards

Pooja

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

All,

thanks for your replies. I got the solution. I was mapping keeping "Body" as the source becuase of which MDM was identifying all records as 1 record. As soon as i changed my map to "Body.CT-SA Data" as my source it started working as required.

Regards

Pooja

Former Member
0 Kudos

Hi Pooja,

What you are saying is absolutely correct as per the SAP documentations. I guess you should raise a message with SAP for this problem and I hope that the people there should be able to comment on this or address, if this is actually an issue, it for future releases.

Best Regards,

Dheeraj

Former Member
0 Kudos

Hello Pooja

Your situation take place if your import dosn't happen.

Load your Import manager with PORT source and check your import map and records creation rules

Regards

Kanstantsin Chernichenka