Developer forum

Forum » Integration » User additional address import incorrect overwrite

User additional address import incorrect overwrite

E-mail notifications
Davy Capiau
Reply
Posted on 08/08/2023 14:58:33

Hi,

I have created users via the user provider. Now I'm trying to add extra addresses via the user providers' AccessUserAddress table. During the first import my 2 additional (not-identical) addresses are imported. But then when reimporting, one of both gets overwritten; resulting in 2 identical addresses. Restarting the import doesn't change the values after that. The values stay the same of address n°2.

Example:

2 additional addresses created during the first import:

When restarting the import the one of the address is overwritten with the other's value:

 

My setup:

- Destination setting User key field: AccessUserExternalid
- Key Column: AccessUserAddressUserId


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 08/08/2023 15:15:33
Reply
This post has been marked as an answer

Hi Davy,
the problem is in the Key Column, it needs to be AccessUserAddressId or a combination of some other columns that can form your unique PK address combination if the AccessUserAddressId does not exist in your source file (fx it can be a combination of AccessUserAddressUserId+ACCESSUSERADDRESSCALLNAME)
BR, Dmitrij

Votes for this answer: 1
 
Davy Capiau
Posted on 08/08/2023 15:33:40
Reply

Hi Dmitrij

Thanks again for the quick an good answer!

 

You must be logged in to post in the forum