Not being able to delete user records causing mojor problems in CRM Online RRS feed

  • Question

  • Some of our users are having failure’s importing data which references a duplicate system user.

    A user, let’s call him Sam Smith was created in office 365 and given a CRM license.  There was some problem with his office 365 account so the user was deleted from office 365 and a new Sam Smith user was created.  The problem with this is that we now have two Sam Smith users in CRM, one is disabled and one is active and when we try to import data referencing Sam Smith it fails because of the “duplicate” record.

    My question is how can I update the disabled Sam Smith full name to something like “Sam Smith Removed” to prevent data imports from failing?

    I cannot the delete the user from CRM.

    I cannot update the FirstName, LastName of the User in CRM (Online).

    I cannot update FirstName, LastName of the user in office 365 as the user no longer exists.

    (Note: I tried to recreate the user in office 365 portal with the same Username, WindowsLogonId as the disabled Sam Smith account, but this just created a third Sam Smith account, grrr.

    I also tried to Export the user to excel and reimport with updated FirstName, LastName but this did not work).

    Friday, October 3, 2014 10:32 AM

All replies

  • Since you are on CRM online, you will not have access to SQL Server. I suppose you will be better off calling Microsoft support to help you fix this issue.



    Friday, October 3, 2014 11:52 AM
  • Hi,

    I haven't tried it personally, but could you use a workflow or a dialog to update the firstname/lastname of the disabled user?


    MCTS. GAP Consulting Ltd. Microsoft Community Contributor Award 2011 & 2013

    Saturday, November 1, 2014 9:17 PM