I recently came across a query where a customer was having trouble in using the import SDK APIs to import attachment records in CRM. So I thought of writing this blog which explains the steps required to import attachment files in CRM using auto mapping feature of CRM import SDK and its APIs along with some sample code. One can also specify an import map but in this blog I’ll cover auto map feature only to keep things simple.
STEP BY STEP EXPLANATION WITH SAMPLE CODE
On a high level the steps are as follows:
- Create a CSV file containing the details of attachments that you want to import.
- Create the root import record
- Create import file record for attachments which contains actual attachment file contents.
- Create import file record which contains mapping for attachments records.
- Call import SDK APIs.
Let’s go through these steps one by one with sample code.
1. Create a CSV file containing the details of attachments that you want to import.
First create an in memory csv file which contains the details of attachments that you want to import. You can also use an already created csv file and read its contents from the disk but to keep things simple I am creating it in memory. In order to
use the auto mapping feature of import the first row of csv should contain the display names of the attributes from target import entity. The rows that will follow the first row will contain actual data which should be imported in those attributes of the target entity.
In the following code sample the first row contains the comma separated display names of attributes from annotation entity followed by the data which should be there in those columns. The annotation is a special case in import hence the data for “Document” columns contains
the file name instead of actual content. I’ll show in next steps where the actual content needs to be specified.
2. Create the root import record.
This is the root import record which binds the different import files which need to be imported together. You can see this record in the “Imports” navigation area in the mail application.
3. Create import file record for attachments which contains actual file contents.
Now you need to create an import file record where actual contents on the attachment are saved. This can be done using following code.
4. Create import file record which contains mapping for attachments.
Now create another import file record which contains the data that we created in step to import annotations in CRM.
5. Call actual import SDK APIs
Once all record are in place we are ready to actually do the import work. Import SDK provides the Parse, transform and Import SDK APIs for this work. Note that these APIs submits asynchronous jobs to do the actual import work.
The unique id of asynchronous job is returned by these APIs. You can monitor the status of these jobs using the ids which are returned by these APIS.
Once all three jobs are completed your data should get imported into the system. You can check it in the opening the import job record in the application.
Following code shows how these APIs can be called.
COMPLETE SAMPLE CODE
For more information, see:
Import Data in Microsoft Dynamics CRM
Sample: Import Data Using Complex Data Map