on 03-22-2013 4:38 PM
Hi community.
I am working on mapping to MDM catalogs import automaically through MDIS , my scenario is ERP ---> MDM
the problem is when contract ID (number) on Source is not exist on destination table Contract Price . I try add new contract ID , contract item ID , Contract item Category , through set MSDIS Unmmaped Value handling. but the add choice is not available to choice is on grey color.
is posible add new register on time automatically execution Process MDIS.
thanks on advance.
Any updates please.
Regards,
Ali
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ali.
an apologie for my delay. I dont Know if it is a Calculation field because is a Look up table on Repositorie the table is Contract Price if that contract ID is not previously load the carge is failed on Import manager manually .
On automatically standard mapping on MDIS when contract Id is not preload on loopk up table that row is create on same time and the catalog is loaded . my doubt is how is possible that.
any suggestion is welcome.
thanks.
Hi Oscar,
Sorry for the delay.
You want add new contract ID, contract item ID, Contract item Category through set MDIS.
1. You can map Contract ID through MDIS. This is possible through the field as shown below.You will need to map contract ID to table Contract price in destination table.
2. For contract item ID: This is text field which will get automatically mapped during the mapping. There is no need for this to add through MDIS as shown below
3. Contract Item category: it is possible to add through MDIS. Please check the source field and destination field as shown below
Thanks
Ravi
Hi Oscar,
The above description is not very clear but what I could get from it is that you wish to add a value,which is not available in destination, from source to destination field.
MDIS unmapped handling can help you in that,do a test run for this.
Retrigger a file with a value which is not present in repository,enable this configuration and let it go through automatic import (through MDIS).
Test and check the results.
Thanks,
Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Oscar,
Field you are referring to may be "Calculated field" with some expression.
In your case, Contract Price field which is under destination table is a Display field with few added expression that is set under console.
Attached is snapshot for your reference. Display fields with calculated expressions won't have MDIS unmapped value handling enabled to "Add". Hope this explains the cause of your issue. Please check & let me know if any queries.
Regards,
Ali
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.