{"id":11,"date":"2013-10-01T06:01:00","date_gmt":"2013-10-01T00:31:00","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=11"},"modified":"2013-10-01T06:01:00","modified_gmt":"2013-10-01T00:31:00","slug":"now-store-images-in-crm-2013","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2013\/10\/now-store-images-in-crm-2013\/","title":{"rendered":"Now Store Images in CRM 2013"},"content":{"rendered":"
We got the first hint of the much awaited data type Image with the introduction of activity feeds where we were allowed to provide a profile image for a user. Though the Activity Feeds had it, it was still not available for other entities OOB or custom.<\/span><\/span><\/p>\n

In CRM 2013, the Dynamics CRM Product team has moved a step further and made this data available to all entities custom and some of the OOB but with a catch. The catch being you can still have only one image associated per record This still serves the purpose in most common cases where you would like to store the contact or product image along with the record.<\/span><\/span><\/p>\n

Let us see how to define this attribute in CRM and later check how to programmatically read\/write the image attribute on the record.<\/span><\/span><\/div>\n
By default CRM now ships with the image attribute added to the following OOB entities<\/span><\/span><\/div>\n


Setting up an entity for Image:<\/u><\/b><\/span><\/span>
<\/span><\/span><\/p>\n

A new setting is now available on the entity form \u201cPrimary Image\u201d. Use this setting to enable the Image attribute. Setting it to none, will not enable this feature i.e the image will not be shown on the entity form.<\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

If the Image feature is enabled, you will find an image container in the record header as can be seen below.<\/span><\/span><\/div>\n
<\/div>\n
<\/a><\/div>\n
<\/div>\n
In the Contact Entity the Image feature is enabled by default. However though the image attribute has been added to the Sales Order entity, it is not enabled by default. You can enable it by customizing the entity and selecting the image attribute.<\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

For Custom entities, you first need to add an image attribute.<\/span><\/span><\/div>\n
<\/div>\n
<\/a><\/div>\n
<\/div>\n
<\/div>\n
Note: The attribute schema name is fixed to \u201centityimage\u201d and cannot be modified.<\/i><\/b><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

Also there can be only one attribute of image data type per entity. Adding another will show the following error<\/span><\/span><\/div>\n
<\/div>\n
<\/a><\/div>\n
<\/div>\n
Once the attribute is added, it is now available for selection on the Primary Image setting on the entity.<\/span><\/span><\/p>\n

To show image on the form follow this steps:<\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

Go to form customization – >> Form Properties ->> Go to Display tab ->> check the Image section ->> Show image in the form option as highlighted below then click ok. Save and publish.<\/span><\/span><\/div>\n
<\/div>\n
<\/a><\/div>\n
Now create a record and check on the top left side as shown in the below screenshot. Click on the image to add\/edit<\/span>and browse new image<\/span><\/span><\/div>\n
<\/div>\n
<\/a><\/div>\n
<\/div>\n
Programmatically Read\/Write the Image to the record:<\/u><\/b><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

Reading entity records using Columns.AllColumns does not return the image attribute. You need to specifically list out the attribute for reading data stored in the image attribute.<\/i><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

Reading Image from a record:<\/b><\/span><\/span><\/div>\n
<\/span><\/span><\/div>\n
<\/div>\n
<\/p>\n
\/\/read the contact<\/span><\/span><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>var<\/span> qry = <\/span>from<\/span> c <\/span>in<\/span> context.CreateQuery(<\/span>“contact”<\/span>)<\/span><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>orderby<\/span> c.GetAttributeValue<<\/span>string<\/span>>(<\/span>“fullname”<\/span>)<\/span><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>select<\/span> <\/span>new<\/span><\/span><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {<\/span><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 name = c.GetAttributeValue<<\/span>string<\/span>>(<\/span>“fullname”<\/span>),<\/span><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 id = c.GetAttributeValue<<\/span>Guid<\/span>>(<\/span>“contactid”<\/span>),<\/span><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 image = c.GetAttributeValue<<\/span>byte<\/span>[]>(<\/span>“entityimage”<\/span>)<\/span><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 };<\/span><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

<\/div>\n

<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>var<\/span> contactid = qry.First().id;<\/span><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>var<\/span> name = qry.First().name;<\/span><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

<\/div>\n

<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>\/\/read the image for the contact<\/span><\/span><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>byte<\/span>[] data = (<\/span>byte<\/span>[]) qry.First().image;<\/span><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

<\/div>\n

<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>\/\/download the image<\/span><\/span><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>using<\/span> (System.IO.<\/span>FileStream<\/span> fileStream = <\/span>new<\/span> <\/span>FileStream<\/span>(name + <\/span>“.png”<\/span>, <\/span>FileMode<\/span>.OpenOrCreate))<\/span><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{<\/span><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 fileStream.Write(data, 0, data.Length);<\/span><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }<\/span><\/span><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

<\/div>\n

<\/span><\/span><\/p>\n

Add\/Update the Image of a record:<\/span><\/b><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

<\/div>\n

<\/span><\/span><\/p>\n

\/\/update the record with a new image<\/span><\/span><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>string<\/span> path = <\/span>@”C:\\test.png”<\/span>;<\/span><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>byte<\/span>[] uploaddata = <\/span>null<\/span>;<\/span><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

<\/div>\n

<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>\/\/download the image<\/span><\/span><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>using<\/span> (System.IO.<\/span>FileStream<\/span> fileStream = <\/span>new<\/span> <\/span>FileStream<\/span>(path, <\/span>FileMode<\/span>.Open))<\/span><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {<\/span><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>int<\/span> size = (<\/span>int<\/span>) fileStream.Length ;<\/span><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0uploaddata = <\/span>new<\/span> <\/span>byte<\/span>[size];<\/span><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 fileStream.Read(uploaddata, 0, size);<\/span><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

<\/div>\n

<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }<\/span><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

<\/div>\n

<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>Entity<\/span> contact = context.CreateQuery(<\/span>“contact”<\/span>).Where(c => c.GetAttributeValue<<\/span>Guid<\/span>>(<\/span>“contactid”<\/span>).Equals(contactid)).First<<\/span>Entity<\/span>>();<\/span><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

<\/div>\n

<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/set the image data<\/span><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 contact.Attributes[<\/span>“entityimage”<\/span>] =\u00a0 uploaddata;<\/span><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

<\/div>\n

<\/span><\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 context.UpdateObject(contact);<\/span><\/span><\/span><\/div>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 context.SaveChanges();<\/span><\/span><\/span> <\/span><\/span><\/p>\n

<\/div>\n<\/div>\n

<\/span><\/span><\/p>\n

Identify if an entity has image enabled:<\/b><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

The EntityMetadata now returns a property PrimaryImageAttribute<\/span>that provides the name of the attribute that stores the image data. <\/span><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

Display the image in an IFRAME:<\/b><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

The image would always be cropped to a square with dimensions of 144×144 or less depending on the size of the image uploaded.<\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

Not sure if this is the supported way, but you can display the image in an IFRAME using the \u201centityimage_url\u201d property. It stores the link to the image. Using a hardcoded link the image could be displayed as shown below<\/span><\/span><\/div>\n
<\/div>\n
<\/a><\/div>\n
<\/div>\n
<\/span><\/div>\n
Conclusion:<\/b><\/span><\/span><\/div>\n

<\/span><\/span><\/p>\n

The next logical step would be to extend this design to allow for multiple image attributes per entity<\/span><\/span><\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n

<\/p>\n

<\/div>\n
<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

We got the first hint of the much awaited data type Image with the introduction of activity feeds where we were allowed to provide a profile image for a user. Though the Activity Feeds had it, it was still not available for other entities OOB or custom. In CRM 2013, the Dynamics CRM Product team\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[19,21,22,24],"tags":[915,916],"class_list":["post-11","post","type-post","status-publish","format-standard","hentry","category-dynamics-crm","category-dynamics-crm-2013","category-dynamics-crm-2015","category-dynamics-crm-2016","tag-image-data-type","tag-images"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/11","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=11"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/11\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=11"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=11"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=11"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}