Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 general forum
Suggested answer

SSIS import Excel Contact data trigger a Note in time line

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,041 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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,647 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans