Hi,
I have setup Integration Batch import for importing users and addresses from NAV. it imports users and addresses correctly but when an addresses is updated in NAV e.g. Phone number or company name then dw creates a new record for it instead of updating the existing record. we cannot set Remove missing address option on data integration job as customers can create new addresses on the website.
Any suggestions on how to prevent duplications?
Best Regards,
Umar
Hi Umar,
you can make a separate job for importing the Addresses. The request is: <GetEcomData ><tables><Addresses type="all"/></tables></GetEcomData>
The settings are like on your image:
The mappings Key columns settings:
Or you can try to make your initial job with manual mappings for users and addresses and make the column AccessUserAddressUId as a Key column in the
AccessUserAddress table mappings settings.
BR, Dmitrij
You must be logged in to post in the forum