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

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Data Import Wizard shows data files successfully mapped, then complains that all files have been ignored

(0) ShareShare
ReportReport
Posted on by

I'm trying to import data from Salesforce into Dynamics CRM 2016.   This is a fresh install, I'm not a Salesforce user and I'm new to Dynamics.

I've trimmed my import down to 14 files, dropped all of the attachments, etc., to get it down to a size that the import wizard will accept.

When I attempt to import the data as a ZIP, using the Salesforce Full Data Export mapping, I see:

  • A screen showing a listing of the 14 included files with their sizes
  • (clicking Next) - A screen listing data import maps.
  • (choosing Salesforce - For Full Data Export) - A pop-up saying: "All Files have been ignored. Please map at least one file to continue".  
  • (clicking OK) - A screen titled "Map Record Types" showing my 14 files, showing each one mapped to a CRM Entity with a green check-mark on each row.
  • (clicking Next) - A new pop-up with the same "all files have been ignored" message.
  • (clicking OK) - back to the previous screen.

What am I missing here?  It's telling me that all files are mapped and that all files are ignored and I cannot proceed.

*This post is locked for comments

I have the same question (0)
  • Syed Ibrahim Profile Picture
    6,257 on at
    RE: Data Import Wizard shows data files successfully mapped, then complains that all files have been ignored

    Please take convert each file as csv and try to import one by one on each entity .dnt compress the file as zip

  • Community Member Profile Picture
    on at
    RE: Data Import Wizard shows data files successfully mapped, then complains that all files have been ignored

    So, you're telling me that the data import wizard, which exists precisely to bring in a collection of related files and rebuild the relationships between those entities is utterly broken and cannot be used for this purpose?  I will of course try individual files, but that's not a viable path to migrating from Salesforce since relationships will be lost.

  • Suggested answer
    Syed Ibrahim Profile Picture
    6,257 on at
    RE: Data Import Wizard shows data files successfully mapped, then complains that all files have been ignored

    Unfortunately no OOB feature to do .Alternatively there are couple of options available.

    1.Kingswaysoft SSIS tool to migrate

    2.Scribe Integration tool

    Reference:

    www.kingswaysoft.com/.../ssis-integration-toolkit-for-salesforce

    www.scribesoft.com/.../salesforce-to-microsoft-dynamics-crm-2013-on-premisecrm-on-line-migration

    andz88.wordpress.com/.../data-migrationsystem-integration-using-ssis-salesforce-to-dynamics-crm-example

    flow.microsoft.com/.../connectors;category=all

    Hope this helps. Pls mark it as verified to close the thread if suggestion resolved your query

  • Verified answer
    Community Member Profile Picture
    on at
    RE: Data Import Wizard shows data files successfully mapped, then complains that all files have been ignored

    The solution was to go into Data Management - My Imports and delete all of the (failed) import records.  This allowed the wizard to continue on through the mapping process and successfully import the data.  For this first import I had to ignore many fields - will work on figuring out which of those to map to what in the coming weeks.

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
HR-09070029-0 Profile Picture

HR-09070029-0 2

#2
ED-30091530-0 Profile Picture

ED-30091530-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans