Importing relationship data

[Former Member]

Hello,

Any one could explain me steps for importing relationship data, pre-requisites, source file structure.

I am very much confused about field mapping. It always give me error Failed to find the aggregation record from its field values.

Any one having document related to this plz send at

abhijeet.more_at_yahoo.co.in

[Former Member]

Hi,

try importing the Relationships with the Data Manager.

Add one Dummy Relationship in the Data Manager and than export the Relationship as TXT file. In the Text file add your relationship data according to the exported file format.

Than import the TXT file also using the Data Manager.

Read in the Data Manger Reference Guide the part "Importing and Exporting Relationship Links" page 444 for more details.

BR,

Mircea

[Former Member]

Hi Mircea,

I tried exporting relationship in TXT format but unable to understand output format.(Also import from 'TXT' option is not available in Data manager MDM5.5 SP4).

I tried Exporting to Excel format & importing same file through Data manager but giving error that those two added relationship column are not in standard format, hence will be neglected.

I created one Test repository having only name & category field.

Could you please explain me field mapping for relationship import in this case.

[Former Member]

Hi abhijeet,

pls read in the Import Manager Reference Guide the part about Importing Relationships.

They explain there the format better and more extensivelly than I can do it on this forum.

As I imported Relationships I also had problems with MDM not recognising the format.

Here is a short guide of how to do it, and it should also work with excel:

1. create a dummy Relationship and export it

2. in the original file exported from MDM add your Relationship data without touching the coloumn names! Don't add new coloums, use the ones that MDM exported!

3. import the file

It worked for me...

Pls tell me if it works

BR,

Mircea

[Former Member]

Hello Mircea,

I manually created relationship entry in data manager (relationship table name Parent\Child ). I exported data in excel file through Data Manager.

Now I deleted the relationship entry i created manually in DM.

I am trying to import data in DM through Import->Import from excel , expecting that it should now create those entry automatically which I created b4 exporting file & deleted there after.

But it pops up err that "The following sheet columns contain data but will be ignored because they do not corresponds to fields or attributes in MDM rep or they are field types that are not supported by import :

Child<Parent>[Rel]

Parent<Child>[Rel]"

[Former Member]

Hi abhijeet,

I haven't worked with SP4, only with SP5 and SP6. So I can't be sure that there isn't a bug there.

How do you export the Relationship?

From Data Manager - "Relationships - Export to File" and import it from "Relationships - Import from File"?

Don't use the Menu "File - Export to Excel"...

BR,

Mircea

[Former Member]

Thanks Mircea,

For taking time for my issue. I was exporting through Menu "File - Export to Excel"...

Now I tried the same thing using Relationship->Import (or Export) option (i.e. creating manually rel entry,exporting to TXT file,deleting that entry,again importing same file). But still it is not working.

giving err:

The import cannot be performed due to one or more of following reason.

*header includes the relationship name that does not exists.

*header includes the field name that does not exists.

*a corresponding field type is not supported for import

[Former Member]

Hi Abhijeet

Please follow the below steps:

1. Create only one Display field in the repository

2. Create the parent child relationship

3. From the Data Manager relate the few records using Relationship table appear along with the Qualified tables

4. Export the relationship from Relationships -> Export to File and dont modify anything let it be text file only

5. Modify the text file accordingly and make a note that it is a tab delimited file

6. Import the modified file from Relationships -> Import from File

Your records will be imported successfully.

Regards,

Jitesh Talreja

[Former Member]

Hi abhijeet,

you must be doing something wrong, but I don't know what. I have just done what you describe you do and it worked fine.

Do you somehow change the exported file? Open it with Excel and save it again?

Try editing the exported file with notepad.

Try to repeat your experiment. This time don't delete your relationship any more. Just try to import the exported relationship. It should be overritten, without error..

I also had the same inexplicable error, but I can't tell you exactly what I did to repair it After some more tries it was over.

Pls tell me if it works

BR,

Mircea

[Former Member]

Hi Mircea,

It worked fine for me when i import Relationship Data of Type Parent/Child either using Data Manager or using Import Manager.

But the Problem is that if i create relationship of Type Sibling say relationship name "Related_Item" then during Import using Import Manager this "Related_Item" relationship is not enabled when i select into Destination Table. So how to enable this as it is enabled for Parent/Child relationship during Import Manager.

So, i m able to import relationships of Type Parent/Child when created into relationship table of MDM Console. But Relationship of Type Sibling Created in MDM console is not imported using MDM Import Manager but sucessfully exported and imported Relationship of Type Sibling using MDM Data Manager.

So, Could you please check and tell how to import this Relationship of Type Sibling when created into Relationship table of MDM Console using MDM Import Manager.

Thanks,

Mandeep Saini

[Former Member]

Hi Mandeep,

the import of sibling relationships only work with the Data Manager.

BR,

Mircea

[Former Member]

Hi Abhijeet,

One suggession from my side is first Export the Relationship from Data manager and use that file only for importing you will get the clear idea about mapping and all.

Display field play the important role in case of relationships.All the display fields will participate in the Relationship output.

Regards,

Jitesh Talreja

[Former Member]

Hello jitesh,

Could you please send any doc related to Relationship Import?

I am unable to get option of Import thorugh TXT file in data manager.

Is this version problem??