Data Migration Framework 2.0 Problem with Staging to Taget connections

(0) Share

Report

Posted on by Eric Evander

250

When I try to set up any kind of Entity import I the joins between the Staging and Target tables do not get created or there are only a couple where there should be many more. Am I missing something? There is also no way that I can see to manually join the fields and I cannot find any documentation on this. Any help with this would be greatly appreciated.

Thanks,

Eric

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Community Member on at

Like (0)

Report

Hi Eric,

Is it a standard entity you are using or a custom one you have created. I have written a few blogs on the Data Migration Framework 1.0 where it shows you how to write custom entities, and how to link them. This may help as it shouldn't have changed much between version 1.0 and version 2.0. www.k3technical.com/.../data-migration

Was this reply helpful? Yes No
Eric Evander 250 on at

Like (0)

Report

Rosie,

Thanks for getting back to me on this. I am using standard entities, no customizations needed. The problem is that there are no joins between the staging and target tables.

The basic question is: should there be? And if so, why am I not seeing them.

I started by tying a standard product import that seemed to be successful but after checking further it actually failed because it did not add the itemId field. What it did is added a product with a blank itemId and all other attempts to add a new product had an error to the effect tat it already exitsted. It did as the blank itemId existed. checking the staging to target view I could see that there were many missing joins. I followed another blog's step by step of a standard vendor import. However, unlike what he showed in a screen shot of View Target Mapping with all the connections, mine only showed two.

thanks,

Eric

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I'm not sure why all your joins are not there. If you go to Setup->Target Entities and select the Product entity. Then go to Modify Target Mapping. Switch to the mapping details view and search for staging field ItemID. There are 11 links in mine. How many are in yours? Also, did you preview the data before you loaded into the staging table to make sure the ItemID is being passed in?

Was this reply helpful? Yes No
Verified answer

Tommy Skaue Moderator on at

Like (0)

Report

If you open the Target Entities and change to Details View, you can simply press the "Generate"-button over the grid to regenerate the mappings. The toolbar is only enabled/visible from the details view.

Was this reply helpful? Yes No
Eric Evander 250 on at

Like (0)

Report

Thank you Rosie and Skaue,

This is exactly what I needed. This step was not included in any of the on-line steps/examples that I saw so I could never get anything to import correctly because many of the joins were not there and I could not figure out how to make them show. Clicking "Generate Mapping" restored them all and the imports now run successfully.

Was this reply helpful? Yes No
Mansoor Adeel 840 on at

Like (0)

Report

"Generate Source Mapping" is the very first step after providing the sample file to DMF, its enlisted in all documents may be you overlooked. I have also prepared a blog to share information on DMF after successful bulk data imports, you can see at following link:

dax2012dmfdataimport.blogspot.com

@Eric just check the section "Generate Source Mapping" section in "Create Processing Group" procedure.

May be it would help further.

Mansoor Adeel

Was this reply helpful? Yes No