web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Error Importing Users through Data Management or Excel

(1) ShareShare
ReportReport
Posted on by 320

Hey, 

I am trying to import system users using data management after the sandbox environment was refreshed. When I create the data management import job using the excel file and all required fields I am getting an error. I get the same error when I use 'open in excel' and try to publish a new user.

The error says "Cannot create a record in User Information (SysUserInfo). User ID: *******, ******@****.com. The record already exists. 

pastedimage1654704314200v1.png

I tried resetting all the usage data in the environment for all users. 

It does work if I recreate a user by going to the Users screen, clicking New, adding their information, and saving. That will add the user and then when I run the data management package it updates that line fine. 

Any help or suggestions would be appreciated.

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    301,025 Super User 2025 Season 2 on at

    Hi J D,

    Which exact version of Dynamics 365 Finance are you using?

  • 72camaross Profile Picture
    320 on at

    The version is:

    pastedimage1655125615074v1.png

  • Verified answer
    André Arnaud de Calavon Profile Picture
    301,025 Super User 2025 Season 2 on at

    Hi J D,

    I tried to reproduce your error on the same version, but didn't got this error. Can you check if both the tables UserInfo and SysUserInfo don't have existing records for these user(s)? What exact fields did you have in the source file?

  • 72camaross Profile Picture
    320 on at

    I know that SysUserInfo did not have any existing records in it. I checked that with data management and SQL server. I did not however check UserInfo.

    I can't check now because I have manually added all 150 users... it was fun. :)

    Sorry for the width: here's the header

    USERID

    ACCOUNTTYPE ALIAS AUTOLOGOFF AUTOMATICURLUPDATE COMPANY DEFAULTCOUNTRYREGION DENSITY DOCUMENTHANDLINGACTIVE EMAIL EMAILPROVIDERID ENABLED EVENTPOLLFREQUENCY EVENTPOPUPDISPLAYWHEN EVENTPOPUPLINKDESTINATION EVENTPOPUPS EVENTWORKFLOWSHOWPOPUP EXTERNALUSER GLOBALEXCELEXPORTFILEPATH GLOBALEXCELEXPORTMODE GLOBALLISTPAGELINKMODE HELPLANGUAGE HOMEPAGEREFRESHDURATION LANGUAGE MARKEMPTYLINKS NETWORKDOMAIN PERSONNAME PREFERREDCALENDAR PREFERREDLOCALE PreferredTimeZone SENDALERTASEMAILMESSAGE SENDNOTIFICATIONSINEMAIL SHOWATTACHMENTSTATUS SHOWNOTIFICATIONSINTHEMICROSOFTDYNAMICSAX7CLIENT SQMENABLED SQMGUID STARTPAGE THEME USERINFO_DEFAULTPARTITION USERINFO_LANGUAGE USERNAME WORKFLOWLINEITEMNOTIFICATIONFORMAT
  • 72camaross Profile Picture
    320 on at

    that didn't work. Try this:

    USERID
    ACCOUNTTYPE
    ALIAS
    AUTOLOGOFF
    AUTOMATICURLUPDATE
    COMPANY
    DEFAULTCOUNTRYREGION
    DENSITY
    DOCUMENTHANDLINGACTIVE
    EMAIL
    EMAILPROVIDERID
    ENABLED
    EVENTPOLLFREQUENCY
    EVENTPOPUPDISPLAYWHEN
    EVENTPOPUPLINKDESTINATION
    EVENTPOPUPS
    EVENTWORKFLOWSHOWPOPUP
    EXTERNALUSER
    GLOBALEXCELEXPORTFILEPATH
    GLOBALEXCELEXPORTMODE
    GLOBALLISTPAGELINKMODE
    HELPLANGUAGE
    HOMEPAGEREFRESHDURATION
    LANGUAGE
    MARKEMPTYLINKS
    NETWORKDOMAIN
    PERSONNAME
    PREFERREDCALENDAR
    PREFERREDLOCALE
    PreferredTimeZone
    SENDALERTASEMAILMESSAGE
    SENDNOTIFICATIONSINEMAIL
    SHOWATTACHMENTSTATUS
    SHOWNOTIFICATIONSINTHEMICROSOFTDYNAMICSAX7CLIENT
    SQMENABLED
    SQMGUID
    STARTPAGE
    THEME
    USERINFO_DEFAULTPARTITION
    USERINFO_LANGUAGE
    USERNAME
    WORKFLOWLINEITEMNOTIFICATIONFORMAT
  • 72camaross Profile Picture
    320 on at
    Had to clear the tables in SQL behind the scenes. 
  • Verified answer
    Alireza Eshaghzadeh Profile Picture
    14,679 Super User 2025 Season 2 on at
    Hi,
    Does the issue resolved?
    If no, did you received the error message for DMF on staging table? 
    Do you want to create a new user that is already exist in the environment? Ref. to the error message it seems that you want to create a duplicate record.
  • Waed Ayyad Profile Picture
    9,039 Super User 2025 Season 2 on at
    Hi,

    Is your issue resolved?  If yes, mark the answers that helped you as verified.

    Thanks
    Waed Ayyad

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 611 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 529 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans