Relationship Import

[Former Member]

Hi,

I need to impor Relationships using Import Manager with below requirements.

The input file has 3 columns:

MaterialNo | RelatedMaterial | DeleteFlag

123 | abc | N

123 | lmn | Y

The last column, Delete Flag, is used to indicate whether the relationship is currently active or not. How should this scenario be mapped in Import Manager? Using Required Qualiier or a Main Table field for Delete Flag?

I tried mapping DeletFlag to Required qualifier, but getting error as:

Import failed. Illegal value for parameter

Import action: NoneSource record no: 3

There ar only 2 source records in the input text file.

Appreciate your help.

Thanks,

Ketan

[Former Member · Accepted solution]

Hi Ketan,

I am able to successfully import the below file

materialno relatedmaterial required

100 150 1

200 250 0

Steps:

1. Open the Import Manager and select the Parent/Child Relationship Name at the Destination side.

2. Map the Material Number with the Material Number of Parent and map the Related Material with that of Child

3. Map the Required field of source with that of Required Qualifier of the Relationship

4. Perform the Value Mapping for the Required field

5. Execute the Import.

Regards,

Jitesh Talreja

[Former Member · Accepted solution]

Thanks Jitesh

I faced a strange issue that Import Manager created a Relationship with all together seperate Material Number. Also, the additional row file issue got solved when I used excel instead of text.

I also need to syndicate this "DeleteFlag" & as you are aware as we cannot directly syndicate relationship, I'm using Calculated fields to store Related Materials & using that in Syndication Map.

The issue with using "Required" is that I do not see that as a field in Assignments & hence cannot write a calculated expression on it.

Any suggestions on how to Syndicate "Required"

Thanks,

Ketan

[Former Member · Accepted solution]

Hi Ketan,

I tried this from various ways but no luck. Did you get the solution?

Regards,

Jitesh Talreja

[Former Member · Accepted solution]

No success this side as well. Relationships havegot multiple limitations on Import (cannot import Sibling), Syndication, Workflow trigger & even Validations on Relationships do not work as expected.

Jitesh, Can you explain the exact use of "Has Position", "Has required" & "Has Quantity". Console guide just had one liners in it.

Thanks,

Ketan

[Former Member · Accepted solution]

Hi,

Once you define all the relationships into MDM Data Manger. You can export all these relationships out of MDM using MDM Data Manager into tab delimited text file. During export from MDM Data Manger, it will also ask for that qualified fields like Required etc, you have to tick(check) the checkbox. So this delimited text file out of MDM contains all the three required fields in below format

Material | Related Material | Required

123 | abc | No

123 | lmn | Yes

Further, in MDM Syndicator Merge this file using Merge tab.Once it's done you can also get both of these fields (Related Material and Required) in your Source Item side then map both of these fields with target side.

Hope it helps....

Thanks,

Mandeep Saini

[Former Member · Accepted solution]

Hi,

Can I remove a relationship during import via Import Manager?

Eg:

There exists below relationsship

A-B

A-C

A-D

In the import file if I get

A-D

it means, remove the relationship between A & D as its no longer valid. I'm getting this data at runtime from a PLM system & hence need to update the MDM Relationships via Import Manager.

Thanks,

Ketan

[Former Member · Accepted solution]

Hi Ketan,

I tried this and got the desired result.

Set the below mentioned properties in the Configuration of Import Manager

Links update = Update

Existing links (update only) = Delete

Regards,

Jitesh Talreja

[Former Member · Accepted solution]

Ketan,

Have you tried the solution at your end?

Regards,

Jitesh Talreja

[Former Member · Accepted solution]

Jitesh,

I was able to build the import & delet scenario, but still was not able o build the syndication of "Delet Flag" scneario.

Thanks,

Ketan

[Former Member]

Hi Ketan,

As per my knowledge, Relationships are useful when we deal with catalogs and that could be the reason why we cannot syndicate relationships in MDM 5.5 because if you are using SRM-MDM catalog then it is not required to syndicate data out from the system hence they have not provided Syndicator in SRM-MDM Catalog installable.

All relationship qualifiers are used to store additional information about the relationship. You can visualize the actual use of all three qualifiers while dealing with catalog functionality.

Position - describe the sequence of items

Required - when checked means both these items (main and related) are related and should go together

Quantity - quantity of related items i.e. if you may a particular item then this much number of realted items you have to buy.

Regards,

Jitesh Talreja