Armanino Blog
Article

Importing Attachments with Notes in Microsoft CRM

August 09, 2013

Have you ever needed to upload a group of attachments to an entity? Perhaps you are doing a data conversion or starting a new account that needs historical documents attached?

Microsoft CRM allows you to import attachments via a zip file in a few easy steps. Any entity in CRM that has Notes & Attachments enabled can have attachments uploaded to it. With that said, there are a couple things to keep in mind:

  • Remember the maximum attachment size defined in the organization settings. Attachments over this size limit will fail during the import.
  • The .csv file still needs to be under 8 MBs. Attachments can be larger if the organization setting allows for larger attachments.

This is not an out-of-the-box import map but here is what you can do to accomplish the task:

1. Create a new .csv with these fields: Title, Owner, File Name, Document (actual name of the file), Description, and the entity the notes/attachments are related to. In this example we are uploading notes/attachments related to accounts. The File Name and Document column need to have the exact file name. File Name

2. Create a directory called "attachments" – note it has to be called this. Place all of the attachments specified in the .csv file into this folder. Attachments Directory

3. CRM is going to look for a zip file that has the csv file and then a folder called attachments that contains the actual files. This is easily done, but selecting the attachments folder, the csv file, then right click and select send to compressed (zipped) folder. You can name the zip file anything you like. Send to compressed foler

4. Import the data in CRM by starting "Import Data" and following these directions.


a. Import data – On the first screen you will select the ZIP file (see screenshot below). Select import file

b. On the second screen, select the default mapping option (first option) as show here: Default mapping option

c. Choose the "Note" entity Choose Note Entity

Here is what will come up by default Default Screen


d. In this example, the column title of my reference entity is called "am_project". Change the am_project to be the lookup to your specified entity and then edit the map. Change Reference Entity
Change am_project
e. This is going to map the project column in the csv to project name, which is what I want. If you need to change that, use the look up to the right of name.

f. Scroll all the way down and hit OK Scroll to bottom OK
Select OK
g. Now click next

h. And next Click Next

i. Click Submit and Finish.

You can see that the files were loaded by opening the project in CRM and clicking on Notes. Click on Notes

Stay In Touch

Sign up to stay up-to-date with the latest accounting regulations, best practices, industry news and technology insights to run your business.

Resources
Related News & Insights
General Contractor Trends to Consider in 2022 Webinar
Webinar
Hear from experts how you can better manage your subcontracts — and more.

December 16, 2021 | 10:00 AM - 11:00 AM PT
Women in Nonprofit Leadership Panel
Webinar
Aspiring nonprofit leaders should hear the insightful stories of these women industry leaders to empower their journeys.

December 14, 2021 | 10:00 AM - 11:00 AM PT
The Evolution of Gaming Companies
Webinar
From seed-funding to acquisition, position your gaming company for success.

December 9, 2021 | 01:00 PM - 02:00 PM PT