Developer forum

Forum » Integration » User import from EXCEL to UserProvider as Destination

User import from EXCEL to UserProvider as Destination

E-mail notifications
Andrejs Zavorotnijs
Reply
Posted on 25/03/2026 11:08:05

Hello 

I’m not sure whether this is expected behavior or a bug, but we recently had an issue with the UsersImport process.

After importing users from Excel using AccessUserExternalId as the primary key, the import unexpectedly overwrote data for existing users (including administrators) whose External ID field was empty. We later discovered that two rows in the Excel file(which client provided) also had empty External ID values.

Can you confirm if this is the intended behavior?

If so, it would be helpful to highlight this more clearly in the documentation, as it could impact other partners as well.


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 25/03/2026 13:20:29
Reply

Hi Andrejs,
looks like this is a bug. Could you try to add the AccessUserType = 5 Constant column mapping to the column mappings and set it to be the Key Column as a workaround?
BR, Dmitrij

 
Andrejs Zavorotnijs
Posted on 25/03/2026 15:23:19
Reply

Hello Dmitriy,

After recovering the administrator user, we resolved the issue by switching the primary key to the username.

We understand that this was partly our mistake, as we didn’t validate the data properly beforehand. However, from our perspective, if a primary key value is empty, the system should throw an exception or just skip this records rather than proceed with the import.

 

You must be logged in to post in the forum