Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Data Import Activities into D365

Posted on by 5

Hello,

I'm looking to import activities from Legacy system to D365. I have identified these entities to needs to be updated smmActivitiesEntity and smmActivityParentLinkTable. I'm able to import activites into smmActivitiesEntity and i see new activity number generated for each activity imported. Next step i need to add record to link to parent customer into smmActivityParentLinkTable. I'm not able to figure out how to import to smmActivitiyParentLinkTable after creating records smmActivitiesEntity from the same date import job. Let me know if you have any suggestions. 

Thanks

Banuprasad

  • Banuprasad Profile Picture
    Banuprasad 10 on at
    RE: Data Import Activities into D365

    Thanks for reply. So I was able load activities into smmActivitiesEntity  but for each record I need to also insert record into smmactivitparentlinktable. Can we load data into other entity smmActivityParentLinkTable as records are insrted into smmActivitesEntity? Im not sure how this can be done using data import. Any help or ideas?

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,323 Most Valuable Professional on at
    RE: Data Import Activities into D365

    You can import anything but... as you mentioned there are issues with lookups. So as I mentioned to make your life easier you should use other tools to import data.

  • Banuprasad Profile Picture
    Banuprasad 10 on at
    RE: Data Import Activities into D365

    So does that mean we cannot import activities using D365 data management import.

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,323 Most Valuable Professional on at
    RE: Data Import Activities into D365

    Hello,

    My recommendation - stop using OOB Import tools and switch to SSIS+KingswaySoft adapter. Using this tool you can preserve ids that you use in legacy system and you will have no headache on how to backlink the data - ids will be the same in both source and destination.

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans