You’re offline. This is a read only version of the page.
2,140
Hi all,
I have some temp tables in database
And want to create records in Dynamics CRM using these data
I am thinking of a Plugin
Could you point me to some directions on how to manipulate data in C# and Plugins ?
Best Regards
Chris
Hi Chris Mavroudis,
You can create a C# console application to create an update records by calling create and update operations but I do not recommend this approach. It is a much better idea to use an ETL tool such as SQL Server Integration Services (SSIS) for this task.
Hi Chris,
If you have some data outside CRM, a plugin is not the way to go here. A plugin triggers when data is changed/created in CRM only.
What I suggest is the following:
1) Either export your temp tables in a nicely formatted excel sheet. Use the import wizard in Dynamics to map the columns in the excel sheet to your entities in Dynamics. For example, if the table consists of Employees, then it is good to map it o Contact entity in CRM. If your data is custom, then create a custom entity in CRM that has fields matching your excel sheet and then import the sheet.
2) You can create a C# utility that uses Dynamics SDK, reads from your database and create records in CRM. Again, you would need an entity(s) in CRM to hold this data.
thanks
Omar
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (