Our support engineers have assembled the top recommended solutions for you.
Microsoft Dynamics AX 2012CRM Connector in Microsoft Dynamics AX 2012Financials Management in Microsoft Dynamics AX 2012Upgrading to Microsoft Dynamics AX 2012
Microsoft Dynamics AX 2009
Application Object Server (AOS)
Enterprise Portal and Role Centers
Inventory Costing in Microsoft Dynamics AX 2009
SSRS and SSAS Integration
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.
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.
Tommy Skaue | Dynamics AX Developer from Norway | http://yetanotherdynamicsaxblog.blogspot.no/ | www.axdata.no
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
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.
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?
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.
"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:
@Eric just check the section "Generate Source Mapping" section in "Create Processing Group" procedure.
May be it would help further.
AX 2012 Techno Consultant
Other Microsoft Sites
I'm a Customer
I'm a Partner
Use the official Twitter tags:
#MSDYNCOMM | #CONV13