DMF/DIXF: How to include MCRCustTable in Customer entity

(0) Share

Report

Posted on by Daniel Zook

847

I'm importing customers using DMF (a.k.a. DIXF). I need to include MCRCustTable in the import process, but I have been unsuccessful.

MCRCustTable is related to CustTable by CustTable.RecId == MCRCustTable.CustTable.

I tried creating a custom entity based on the MCRCustTable, with a "generate" method to lookup the CustTable.RecId. The problem I ran into with this method is that it creates the first record, and then updates the target on subsequent source records. For example, when importing two records with customer ID 1 and 2, it creates the record with customer ID 1, then changes the customer ID to 2, and I end up with one record instead of two.

I also tried adding the MCRCustTable to the DMFCustomerTargetEntity (with the default relation). That results in the first record importing with a value of zero in the CustTable field and the rest hitting an error: "Cannot create a record in Customers (MCRCustTable). Reference: 0, lha. The record already exists."

Does anyone have any suggestions on how to make this work?

Thanks in advance.

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

Verified answer

Ajit 8,755 on at

Like (0)

Report

Make sure 'addStagingLink' method of your custom entity also has a reference of your new table.

Was this reply helpful? Yes No
Suggested answer

Khushhal Garg 1,514 on at

Like (0)

Report

In your custom entity, what is the entity key. It should be Customer ID. Also, did you add CustTable column from MCRCustTable in data entity fields?

Was this reply helpful? Yes No
Daniel Zook 847 on at

Like (0)

Report

Thanks for the reply Khushal. Unfortunately, I'm still a newbie and I don't understand what you mean by "entity key". I'm doing some research to see if I can figure it out. If you are referring to the index on the DMFMCRCustTableEntity table (staging), then yes, the AccountNum field is included in the index.

I'm assuming the "data entity fields" you are referring to are in the DMFMCRCustTableTargetEntity query. The CustTable column is included in the query fields.

Was this reply helpful? Yes No
Daniel Zook 847 on at

Like (0)

Report

Thanks for the reply Ajit. I can override that method on the DMFMCRCustTableEntityClass class, but I don't know what to do with it. Since it receives a query and returns a query, I'm assuming it is used to modify the query for the entity. Should I add CustTable to the query with a join to the MCRTable where MCRTable.CustTable == CustTable.RecId?

Was this reply helpful? Yes No
Suggested answer

Ajit 8,755 on at

Like (0)

Report

Yes adding that should work.

Was this reply helpful? Yes No
Suggested answer

Ajit 8,755 on at

Like (0)

Report

Entity Key is nothing but primary index but that is something in D365 not in AX 2012.

Was this reply helpful? Yes No
Daniel Zook 847 on at

Like (0)

Report

Thanks. I'll work on that next week and update this forum post.

Was this reply helpful? Yes No
Daniel Zook 847 on at

Like (0)

Report

I appreciate the advice, but so far I haven't been able to make it work yet.

Here is what I have so far...

1. A custom entity created using the wizard

2. Override of method addStagingLink

3. Stage to target mapping

4. Source to stage mapping

Should I add a method to lookup the CustTable.RecId from the entity AccountNum field?

Was this reply helpful? Yes No
Daniel Zook 847 on at

Like (0)

Report

I forgot to mention what happens when I run the import....

The Execution History shows no errors, 2 records created in staging (which is correct) and 2 records updated in target (which is incorrect). Basically, it is updating existing records (even though they don't match the account number), instead of adding new records to the MCRCustTable table.

Was this reply helpful? Yes No
Suggested answer

Daniel Zook 847 on at

Like (0)

Report

I added the generate method and mapped it from the staging table AccountNum field to the CustTable field in the target, and so far it appears to be working. So it takes a combination of the generate method and the addStagingLink method.

I'll do some more testing to confirm that all is well and update this post to confirm that this is the correct answer.

Thanks again for all your help!

Was this reply helpful? Yes No