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

Announcements

No record found.

News and Announcements icon
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 324

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
    303,365 Super User 2026 Season 1 on at

    Hi J D,

    Which exact version of Dynamics 365 Finance are you using?

  • 72camaross Profile Picture
    324 on at

    The version is:

    pastedimage1655125615074v1.png

  • Verified answer
    André Arnaud de Calavon Profile Picture
    303,365 Super User 2026 Season 1 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
    324 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
    324 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
    324 on at
    Had to clear the tables in SQL behind the scenes. 
  • Verified answer
    Alireza Eshaghzadeh Profile Picture
    14,839 Super User 2026 Season 1 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,066 Super User 2026 Season 1 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 514 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 390

#3
Adis Profile Picture

Adis 266 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans