Developer forum

Forum » Integration » Address duplicates on Import

Address duplicates on Import

E-mail notifications
Justin Sjouw Dynamicweb Employee
Justin Sjouw
Reply
Posted on 08/04/2022 12:10:50

Please see the attached screencast.

A customer in BC has an "Shipping Address" configured. After every import this line get duplicated in the list.

At some point it got even weirder, because then this address ("Kontiki Haarlem, Prinsenbolwerk 60")  shows up in a Totally unrelated customer!

Any idea what is going on here, what should be the Key setting on the Address column?


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 09/04/2022 00:26:33
Reply
This post has been marked as an answer

Hi Justin,
the answer is here: https://doc.dynamicweb.com/forum/integration/integration/user-import-with-addresses and
here: https://doc.dynamicweb.com/forum/integration/integration/insert-update-additional-user-addresses.
BR, Dmitrij

Votes for this answer: 1
 
Justin Sjouw Dynamicweb Employee
Justin Sjouw
Posted on 11/04/2022 10:02:01
Reply

Thanks Dmitriy,

Any idea why AccessUserAddressUId  is not set as the Key by default? Sounds a bit like a bug to me, because for the other tables in my Import the correct keys are set automatically.

Thanks,

Justin

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 11/04/2022 23:24:27
Reply

Hi Justin,
this is working as designed, the AccessUserAddressId is a default PK column for the AccessUserAddress table and AccessUserAddressUId  is only used at the integration,
for example in cases like that, so that is why it is not a default.
BR, Dmitrij

 

You must be logged in to post in the forum