Skip to main content

Notifications

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

SSIS import Excel Contact data trigger a Note in time line

(0) ShareShare
ReportReport
Posted on by 135

Hi Expert,

Our system is a Online D365 CE. I want to bulk import Contact records (which stored in an Excel table) into CRM. All the Contacts are exiting in CRM originally. 

Once the specific Contact imported into CRM, in the Contact timeLine, a text Note will be created. 

I selected SSIS + KingswaySoft approach. But the key point is how to trigger the Note directly when import the data. 

Can you contribute your expert guidance?  Thanks in advance.

  • FOR365 Profile Picture
    FOR365 135 on at
    RE: SSIS import Excel Contact data trigger a Note in time line

    Looking forward to hearing from you.  

  • FOR365 Profile Picture
    FOR365 135 on at
    RE: SSIS import Excel Contact data trigger a Note in time line

    Thanks Mahen for you response.

    For the performance concern, I will not select the workflow approach.

    Can you tell me the detail process about create Note after create Contact? Does it need to some script to work on the process?

    Looking forward to hearing from you.  

  • Suggested answer
    Mahendar Pal Profile Picture
    Mahendar Pal 45,095 on at
    RE: SSIS import Excel Contact data trigger a Note in time line

    Hi,

    You can create the note as the next step after creating Contact in SSIS or you can simply setup a workflow to create Note for contact which will trigger on the contact create.

    Let me know if my understanding is not correct.

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

News and Announcements

Announcing Category Subscriptions!

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans