Developer forum

Forum » Integration » User provider - duplicate UserAdress

User provider - duplicate UserAdress

E-mail notifications
Gaëtan Di Caro
Reply
Posted on 08/08/2017 08:34:01

Hello,

I've got a problem with the user provider. I import users as well as their multiple addresses (using the pseudo-table AccessUserAddress). However everytime I run the import the addresses, they are all imported again, in duplicate. And it keeps piling up everytime I run the import.

Is there a way to avoid that ? See a screenshot of my configuration. I use 9.2.17.

Thanks

2017-08-08_08_29_43-Dynamicweb_Admin.png

Replies

 
Jonas Krarup Dam
Posted on 08/08/2017 11:21:34
Reply
This post has been marked as an answer

Hi,

I just tested it locally, and I'm not getting multiple addresses.

Have you defined a key column for the address table? 

If not, the system has no way of knowing which addresses should be updated, and it will create them again on each import, as a new address.

 

/Jonas

Votes for this answer: 1
 
Gaëtan Di Caro
Posted on 08/08/2017 13:19:19
Reply

Ok That was why then. I had to fabricate a unique key because the key to the address table where I get my data from is composite of the user id and an auto-incremented id...

 

You must be logged in to post in the forum