Hey
I am running into a problem when trying to import users into the 2 tables AccessUser and AccessUserAddress.
The file contains a unique customernumber which I map into both the username and customernumber on a user, but since some users are created outside the import I cannot use this number as the userID in DW, and therefore leave it blank to be autogenerated.
My issue then is that if I try to leave the AccessUserAddressUserId blank for the import of addresses I get "cannot insert the value NULL", I found another (rather old) thread here: https://doc.dynamicweb.com/forum/integration/integration/importing-addresses which stated:
"if it is an integer value – it looks for the AccessUserID with this value
otherwise or if the user is not found by ID it is searching by the columns: "AccessUserUserName", "AccessUserCustomerNumber", "AccessUserEmail"."
So my problem is that if I use the customernumber in the field for AccessUserAddressUserId then it tries to match against the users with the same ID - resulting in the wrong users getting the addresses. Is there anyway to force it to skip straight to looking at AccessUserCustomerNumber? - or ofc. some other field?
