Developer forum

Forum » Integration » DW9: Import fails for non-existing AccessUserAddresses

DW9: Import fails for non-existing AccessUserAddresses

E-mail notifications
Anders Ebdrup
Anders Ebdrup
Reply
Posted on 27/12/2017 12:21:40

Hi Dynamicweb,

 

We have an issue when importing user addresses for non-existing users, as you have no logic for deleting excess entries as for secondaryrelations:

                updateUserIdSql.Append("delete from AccessUserSecondaryRelationTempTableForBulkImport where AccessUserSecondaryRelationUserID not in (select CONVERT(varchar(max), AccessUserID)from AccessUser);");

Can you do the same for AccessUserAddresses? Then we can prevent errors like this: https://www.screencast.com/t/kpE4BDFN6d1

 

Best regards, Anders

 


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 28/12/2017 09:26:11
Reply

Hi Anders,

yes, it will be added in tfs# 44042. Let me know if you need this in DW8 also, otherwise it will be only in DW9.
Regards, Dmitrij

 
Kristian Kirkholt Dynamicweb Employee
Kristian Kirkholt
Posted on 16/01/2018 15:25:02
Reply

Hi Anders

The problem regarding #44042 "UserProvider: UpdateUserAddresses add delete relations that do not match user ids" has now been resolved in Dynamicweb version 9.3.11

To upgrade please choose this version from backend or download from here:

http://doc.dynamicweb.com/releases-and-downloads/releases

Let me know if you need any more help regarding this

Kind Regards
Dynamicweb Support
Kristian Kirkholt

 

You must be logged in to post in the forum