Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Data Import shows no records imported?

(0) ShareShare
ReportReport
Posted on by

So I exported a view from a dev environment and imported it into our QA environment.  Even though the file has 200 records and there's no errors indicated on the import, it shows that 0 records import....  Does anyone have any idea what could be wrong?  I even tried exporting a blank template from the QA environment and populating that with the data to re-import.  It still shows 0 records being imported :(

*This post is locked for comments

  • Eduardo Starks Profile Picture
    Eduardo Starks 80 on at
    RE: Data Import shows no records imported?

    Import as a CSV File. Then you will see the uploaded data.

  • pavankumar Profile Picture
    pavankumar 95 on at
    RE: Data Import shows no records imported?

    Import the file in .csv format.

  • Eduardo Starks Profile Picture
    Eduardo Starks 80 on at
    RE: Data Import shows no records imported?

    Hi CRM Learner 8,

    Can you please confirm if the file that you attempted to upload was in CSV format?

    Also, have you tried clearing your browser cache and reloading the browser?

    Please confirm which one worked for you.

    Thanks!

  • Suggested answer
    cristina_b Profile Picture
    cristina_b 57 on at
    RE: Data Import shows no records imported?

    Thanks, converting it to .cvs made it work after spending more than 1 hour trying to figure it out on my own :)

  • billybonkers Profile Picture
    billybonkers 75 on at
    RE: Data Import shows no records imported?

    I had the same problem with exporting from one Dynamics 365 instance to another.  I exported data into an xlsx file from one instance, and then imported it to another, but although it gave a status reason of Completed, the import says there was 0 Successes, 0 partial failures, 0 errors, 0 total processed (despite there definitely being rows in the Excel spreadsheet).

    When I performed the import of the xlsx (via Data Management> Import) it didn't take me through the mapping wizard as I would have expected, it just took me straight to a "Submit" button.

    However when I save the xlsx file as a csv I found it worked ok and imported the data file.  Also when I zipped the xlsx and imported that it also imported the data fine.

    Is this a bug in CRM?

  • Suggested answer
    NatrajY Profile Picture
    NatrajY 3,040 on at
    RE: Data Import shows no records imported?

    Zip up the file and import the zip file.

  • Inogic Profile Picture
    Inogic 438 on at
    RE: Data Import shows no records imported?

    Hi,

    Go To Settings -> Data management -> Imports. There you can find the job created for your Import. Double-Click and open that job and go to failures tab. There you can find the log for error for each column/row for why that data import failed. You can check out the reason from there and correct your data and try importing again.

    Hope this helps !

    Thanks,

    Sam

  • RE: Data Import shows no records imported?

    Unfortunately both of these didn't work :(

  • Suggested answer
    Alagunellaikumar Profile Picture
    Alagunellaikumar 6,210 on at
    RE: Data Import shows no records imported?

    Reset iisreset or asynch service or uncheck the duplicate detection rule in import wizard

  • Suggested answer
    Mahendar Pal Profile Picture
    Mahendar Pal 45,095 on at
    RE: Data Import shows no records imported?

    Hi,

    Assuming you are using on premise, did you try to run IISRESET ?? you can also try to restart asyn service.

    Thanks

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans