Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

how to export all data and activities out of online CRM Dynamics

Posted on by Microsoft Employee

I would like to know how i can export all data and activities such as notes, emails, documents associated with all the entries. I am using online CRM and all i can see is exports using views but this can take forever so what i am asking is if i can export all the related data into an MTI file? My system is hosted by a company who has given me a SQL backup which doesnt help me. I want to export all the information above to a CSV or MTI file so i can imported it into my new system

Please advise if this is possible and how i can go about this!!

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: how to export all data and activities out of online CRM Dynamics

    I suppose Skyvia can solve your issue. It`s a no-coding solution with flexible scheduling and broad mapping features. 

  • RE: how to export all data and activities out of online CRM Dynamics

    Hi Chris,

    If you want to maintain this auto-export flow, from Microsoft Dynamics Online to CSV files, on a recurring basis, you should check out Flatly at flatly.io and see if it meets your needs.  Flatly will store these CSV files in a list of historical copies, or simply refresh the same set of limited files repeatedly, in a cloud storage / drive of your choice.  

    Disclaimer:  I work at Flatly.

  • Suggested answer
    razdynamics Profile Picture
    razdynamics 17,304 User Group Leader on at
    RE: how to export all data and activities out of online CRM Dynamics

    HI Chris, May I ask Which system are you exporting it out to, as there several option for exporting out your data apart from the Entity export function inside of crm,

    -XML Data Package, this is intended for exporting to another dynamics crm instance

    -Use SSIS with a CRM adapter to export your data to CSV (Kingswaysoft and Cozyroc provide free adapters for this)

    -As Giselle Mentioned, use the SDK / API to develop your own Data export function

    The Best approach from the above is to use SSIS with Kingswaysoft / Cozyroc crm adapter to get your data out of CRM into a format that will work into your Target system.

    I hope this helps you? Kindly Verify :)

    Best Wishes, Raz

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: how to export all data and activities out of online CRM Dynamics

    Hello ChrisMcCabe,

    Unfortunately there is no available option to export all the information to a CSV or MTI file through the UI,unless working with views.

    I would suggest you work with SDK to manipulate the data and export.

    More information: Sample code for activity entities (msdn.microsoft.com/.../gg309494.aspx)

    Thank you for using Microsoft Dynamics CRM Communities,

    Dynamics CRM Support Blog

    Giselle Oliveira

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans