Developer forum

Hi Skylar,
there is no direct SQL for the relations update, it works by finding the existing users using different conditions.
In the User destination provider there is an option called "User key field" which is set to "Auto" by default but you can change it to any other column that you are sure can be unique for the users(fx email). This column (if it exists in the mapping and in the "Source" for AccessUser table) will be used for searching of the existing users. The user addresses are imported after the users import. In the AccessUserAddress table mapping you need to specify the mapping for the destination column called: "AccessUserAddressUserID" and set the values from the source AccessUser "User key field" column values. Fx if you are using email as a user key field then you neeed to have in the fields ""AccessUserAddressUserID" values of users emails. At the addresses import the values for "AccessUserAddressUserID"s will be replaced by found users ids, if the user/users will not be found you will see warnings in the log file. When default "Auto" option is used then the search of existing users is made in this order:
"AccessUserID", "AccessUserUserName", "AccessUserCustomerNumber", "AccessUserEmail", "AccessUserExternalId"
BR, Dmitrij