Hello Community, is there a way to mass upload information for existing users without AW creating new users? I’m looking to add resource ID’s to our existing users in AW but when I import the spreadsheet with the existing names and IDs, it creates completely new users resulting in duplicate users.
Many thanks!
Best answer by Limori
Hi Kayla
I apologize for misleading you with the User Name… it is in fact the External ID that should be used to be referenced with PK as the unique identifier:
As dataloader is going through a 2-step process, it indicates for you whether it is about to Update or to Add a record in the system:
A few tip for dataloader:
+1Hey Kayla, when you are doing the import have you got “PK:” on the user ID or the user email column? That should pick it up as the Primary Key to look up the existing users, and do an Update instead of an Add?
Hi Andy, I tried that but it still added them as new users unfortunately. Thanks for your recommendation!
+4Hi Kayla
Please reference the User Name column with “PK:” - as it’s User Name that is the unique identifier in AdaptiveWork, not the Email address.
That should work.
+1Which object are you importing against? That must have something to do with it? Are you importing a link between existing objects, or the object itself?
+4Hi Kayla
I apologize for misleading you with the User Name… it is in fact the External ID that should be used to be referenced with PK as the unique identifier:
As dataloader is going through a 2-step process, it indicates for you whether it is about to Update or to Add a record in the system:
A few tip for dataloader:
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
