<rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:copyright="http://blogs.law.harvard.edu/tech/rss" xmlns:image="http://purl.org/rss/1.0/modules/image/">
    <channel>
        <title>Olivier Furnémont's blog</title>
        <link>http://furnemont.net/Default.aspx</link>
        <description>Another Subtext Powered Blog</description>
        <language>en-US</language>
        <copyright>Olivier Furnémont</copyright>
        <managingEditor>olivier@furnemont.net</managingEditor>
        <generator>Subtext Version 1.9.5.176</generator>
        <image>
            <title>Olivier Furnémont's blog</title>
            <url>http://furnemont.net/images/RSS2Image.gif</url>
            <link>http://furnemont.net/Default.aspx</link>
            <width>77</width>
            <height>60</height>
        </image>
        <item>
            <title>Microsoft CRM 4.0 CTP3 Preview</title>
            <category>Microsoft CRM</category>
            <link>http://furnemont.net/archive/2007/10/12/microsoft-crm-4.0-ctp3-preview.aspx</link>
            <description>&lt;p&gt;I only found out about it yesterday :-(&lt;/p&gt; &lt;p&gt;It comes as a complete Virtual Machine with the following installed:&lt;/p&gt; &lt;p&gt;- Windows Server 2003 R2 with SP2&lt;/p&gt; &lt;p&gt;- Microsoft SQL Server 2005&lt;/p&gt; &lt;p&gt;- Microsoft Visual Studio 2005&lt;/p&gt; &lt;p&gt;- The complete Microsoft Office 2007 suite (including Outlook 2007)&lt;/p&gt; &lt;p&gt;- Microsoft CRM 4.0 CTP3 (this is a pre-release version of course!)&lt;/p&gt; &lt;p&gt;Here is the link (you need a PartnerSource login to enter):&lt;/p&gt; &lt;p&gt;&lt;a title="https://mbs.microsoft.com/Cms/Templates/document/General.aspx?NRMODE=Published&amp;amp;NRNODEGUID={5E2315DC-AA3E-4726-B69B-9F4B1AFF1F48}&amp;amp;NRORIGINALURL=/partnersource/products/mscrm/newsevents/news/CRM4VirtualPCImageCTP3Beta.htm&amp;amp;NRCACHEHINT=Guest" href="https://mbs.microsoft.com/Cms/Templates/document/General.aspx?NRMODE=Published&amp;amp;NRNODEGUID={5E2315DC-AA3E-4726-B69B-9F4B1AFF1F48}&amp;amp;NRORIGINALURL=/partnersource/products/mscrm/newsevents/news/CRM4VirtualPCImageCTP3Beta.htm&amp;amp;NRCACHEHINT=Guest"&gt;https://mbs.microsoft.com/Cms/Templates/document/General.aspx?NRMODE=Published&amp;amp;NRNODEGUID={5E2315DC-AA3E-4726-B69B-9F4B1AFF1F48}&amp;amp;NRORIGINALURL=/partnersource/products/mscrm/newsevents/news/CRM4VirtualPCImageCTP3Beta.htm&amp;amp;NRCACHEHINT=Guest&lt;/a&gt;&lt;/p&gt; &lt;p&gt;Have fun with it!&lt;/p&gt; &lt;p&gt;PS: Has anyone found out how to customize entities with this version? I can not find the link, even as CRM Admin!&lt;/p&gt; &lt;div class="wlWriterSmartContent" id="0767317B-992E-4b12-91E0-4F059A8CECA8:d139987a-cde3-4d1c-a6d8-0e31ca5066f6" contenteditable="false" style="padding-right: 0px; display: inline; padding-left: 0px; padding-bottom: 0px; margin: 0px; padding-top: 0px"&gt;Technorati Tags: &lt;a href="http://technorati.com/tags/Microsoft%20CRM" rel="tag"&gt;Microsoft CRM&lt;/a&gt;, &lt;a href="http://technorati.com/tags/Titan" rel="tag"&gt;Titan&lt;/a&gt;&lt;/div&gt;&lt;img src="http://furnemont.net/aggbug/32.aspx" width="1" height="1" /&gt;</description>
            <dc:creator>Olivier Furnémont</dc:creator>
            <guid>http://furnemont.net/archive/2007/10/12/microsoft-crm-4.0-ctp3-preview.aspx</guid>
            <pubDate>Fri, 12 Oct 2007 11:52:07 GMT</pubDate>
            <wfw:comment>http://furnemont.net/comments/32.aspx</wfw:comment>
            <comments>http://furnemont.net/archive/2007/10/12/microsoft-crm-4.0-ctp3-preview.aspx#feedback</comments>
            <wfw:commentRss>http://furnemont.net/comments/commentRss/32.aspx</wfw:commentRss>
            <trackback:ping>http://furnemont.net/services/trackbacks/32.aspx</trackback:ping>
        </item>
        <item>
            <title>New Microsoft CRM 3.0 VirtualPC image</title>
            <category>Microsoft CRM</category>
            <link>http://furnemont.net/archive/2007/06/28/new-microsoft-crm-3.0-virtualpc-image.aspx</link>
            <description>&lt;p&gt;Got this in my inbox today:&lt;/p&gt; &lt;p&gt;Microsoft have updated the CRM Virtual PC Demonstration image - &lt;a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=a8edfc7b-01d8-4500-845b-01370d4eed21&amp;amp;DisplayLang=en"&gt;http://www.microsoft.com/downloads/details.aspx?FamilyID=a8edfc7b-01d8-4500-845b-01370d4eed21&amp;amp;DisplayLang=en&lt;/a&gt;&lt;/p&gt; &lt;p&gt;This one is set to expire 30th June 2008. &lt;/p&gt;&lt;p&gt;Happy downloading! &lt;/p&gt;&lt;p&gt;Olivier&lt;/p&gt; &lt;div class="wlWriterSmartContent" id="0767317B-992E-4b12-91E0-4F059A8CECA8:f41c18ba-f88a-4fed-ae6c-daa2bb91921b" contenteditable="false" style="padding-right: 0px; display: inline; padding-left: 0px; padding-bottom: 0px; margin: 0px; padding-top: 0px"&gt;Technorati Tags: &lt;a href="http://technorati.com/tags/Microsoft%20CRM" rel="tag"&gt;Microsoft CRM&lt;/a&gt;, &lt;a href="http://technorati.com/tags/Virtual%20PC" rel="tag"&gt;Virtual PC&lt;/a&gt;&lt;/div&gt;&lt;img src="http://furnemont.net/aggbug/31.aspx" width="1" height="1" /&gt;</description>
            <dc:creator>Olivier Furnémont</dc:creator>
            <guid>http://furnemont.net/archive/2007/06/28/new-microsoft-crm-3.0-virtualpc-image.aspx</guid>
            <pubDate>Thu, 28 Jun 2007 13:15:56 GMT</pubDate>
            <wfw:comment>http://furnemont.net/comments/31.aspx</wfw:comment>
            <comments>http://furnemont.net/archive/2007/06/28/new-microsoft-crm-3.0-virtualpc-image.aspx#feedback</comments>
            <wfw:commentRss>http://furnemont.net/comments/commentRss/31.aspx</wfw:commentRss>
            <trackback:ping>http://furnemont.net/services/trackbacks/31.aspx</trackback:ping>
        </item>
        <item>
            <title>My LinkedIn profile</title>
            <link>http://furnemont.net/archive/2007/06/03/my-linkedin-profile.aspx</link>
            <description>&lt;p&gt;Here is the link to my LinkedIn public profile. Feel free to ask me to be in your connections if you want &lt;img alt="" src="/Providers/BlogEntryEditor/FCKeditor/editor/images/smiley/msn/regular_smile.gif" /&gt;&lt;/p&gt;
&lt;p align="center"&gt;&lt;a href="http://www.linkedin.com/in/olivierfurnemont"&gt;&lt;img height="30" alt="View Olivier Furnémont's profile on LinkedIn" width="120" border="0" src="http://www.linkedin.com/img/webpromo/btn_linkedin_120x30.gif" /&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://furnemont.net/aggbug/26.aspx" width="1" height="1" /&gt;</description>
            <dc:creator>Olivier Furnémont</dc:creator>
            <guid>http://furnemont.net/archive/2007/06/03/my-linkedin-profile.aspx</guid>
            <pubDate>Sun, 03 Jun 2007 13:33:41 GMT</pubDate>
            <wfw:comment>http://furnemont.net/comments/26.aspx</wfw:comment>
            <comments>http://furnemont.net/archive/2007/06/03/my-linkedin-profile.aspx#feedback</comments>
            <wfw:commentRss>http://furnemont.net/comments/commentRss/26.aspx</wfw:commentRss>
            <trackback:ping>http://furnemont.net/services/trackbacks/26.aspx</trackback:ping>
        </item>
        <item>
            <title>First post on new blogging engine!</title>
            <link>http://furnemont.net/archive/2007/06/01/first-post-on-new-blogging-engine.aspx</link>
            <description>&lt;div class="wlWriterSmartContent" id="0767317B-992E-4b12-91E0-4F059A8CECA8:c1af5560-74b8-4cbb-9c1b-e537b4af176b" contenteditable="false" style="padding-right: 0px; display: inline; padding-left: 0px; padding-bottom: 0px; margin: 0px; padding-top: 0px"&gt;Technorati Tags: &lt;a href="http://technorati.com/tags/SubText" rel="tag"&gt;SubText&lt;/a&gt;&lt;/div&gt; &lt;p&gt;Hello everyone,&lt;/p&gt; &lt;p&gt;Well, I know some people around me are gonna hate the fact I removed my old blog (which was not quite old since it worked with DNN 4) because they now have to update their RSS link to point out to the new feed.&lt;/p&gt; &lt;p&gt;Anyway, I managed to find out a new blogging engine (SubText) since I was not happy with the blog module coming in DNN and didn't want to spend money on something that should be free (thanks to the democracy), so I installed it and I am very happy as of now!&lt;/p&gt; &lt;p&gt;So, if you're looking for a cool blogging engine that supports Microsoft Live Writer, be sure to check out this site: &lt;a title="http://www.subtextproject.com/" href="http://www.subtextproject.com/"&gt;http://www.subtextproject.com/&lt;/a&gt;&lt;/p&gt; &lt;p&gt;I should be able to reimport my old blog posts from my (now dead) DNN blog engine in a couple of days (I should maybe try to create a web project in ASP.Net that would do this automatically...oh well, enough is enough for now).&lt;/p&gt; &lt;p&gt; &lt;/p&gt; &lt;p&gt;Stay tuned for more to come!&lt;/p&gt; &lt;p&gt;Olivier&lt;/p&gt;&lt;img src="http://furnemont.net/aggbug/3.aspx" width="1" height="1" /&gt;</description>
            <dc:creator>Olivier Furnémont</dc:creator>
            <guid>http://furnemont.net/archive/2007/06/01/first-post-on-new-blogging-engine.aspx</guid>
            <pubDate>Fri, 01 Jun 2007 14:39:01 GMT</pubDate>
            <wfw:comment>http://furnemont.net/comments/3.aspx</wfw:comment>
            <comments>http://furnemont.net/archive/2007/06/01/first-post-on-new-blogging-engine.aspx#feedback</comments>
            <wfw:commentRss>http://furnemont.net/comments/commentRss/3.aspx</wfw:commentRss>
            <trackback:ping>http://furnemont.net/services/trackbacks/3.aspx</trackback:ping>
        </item>
        <item>
            <title>Customisation 2 : Ajout d&amp;rsquo;attribut &amp;agrave; un formulaire</title>
            <category>Customization</category>
            <category>Microsoft CRM</category>
            <link>http://furnemont.net/archive/2007/05/21/customisation-2--ajout-drsquoattribut-agrave-un-formulaire.aspx</link>
            <description>&lt;p&gt;Maintenant que nous avons compris à quoi correspond la couche des métadonnées, nous pouvons commencer nos customisations par l’ajout d’un attribut sur un formulaire (nous verrons ensuite comment la « &lt;i&gt;metabase&lt;/i&gt; » se met à jour automatiquement avec le nouvel attribut). &lt;/p&gt;&lt;p&gt;Pour commencer, nous allons modifier l’entité, ou l’objet, « contact » de Microsoft CRM et lui ajouter quelques attributs (voir le tableau ci-dessous) ; pour ce faire, il faut se connecter au CRM avec un utilisateur qui a les droits de customisation. &lt;/p&gt;&lt;p&gt;Une fois connecté au CRM : &lt;/p&gt;&lt;p&gt;a) Il faut cliquer sur le lien « Paramètres » &lt;/p&gt;&lt;p&gt;b) Choisir l’option « Personnalisation » dans le menu de gauche de Microsoft CRM pour accéder à la section de personnalisation de l’outil. &lt;/p&gt;&lt;p&gt;c) Une fois dans cette section, il faut sélectionner l’option « Personnaliser les entités » pour accéder à l’écran de personnalisation des entités. &lt;/p&gt;&lt;p&gt;&lt;img alt="personnalisation" src="http://furnemont.net/images/furnemont_net/WindowsLiveWriter/Customisation2Ajoutdattributunformulaire_12143/personnalisation_04c59761-ed07-40c8-9ddc-9a1e7cb50f16.jpg" border="0" /&gt;  &lt;/p&gt;&lt;p&gt;&lt;a&gt;Figure &lt;/a&gt;3 : Personnaliser les entités &lt;/p&gt;&lt;p&gt;  &lt;/p&gt;&lt;p&gt;L’écran de personnalisation des entités donne une liste de toutes les entités pouvant être customisées ; pour ajouter un attribut à l’entité « contact », il suffit de double-cliquer sur la ligne « contact » dans la liste (voir figure 4). &lt;/p&gt;&lt;p&gt;&lt;img alt="liste entités" src="http://furnemont.net/images/furnemont_net/WindowsLiveWriter/Customisation2Ajoutdattributunformulaire_12143/liste%20entit%C3%A9s_8091b077-e006-4c30-8ab8-9089d6d0ee39.jpg" border="0" /&gt;  &lt;/p&gt;&lt;p&gt;&lt;a&gt;Figure &lt;/a&gt;4 : Liste des entités customisables &lt;/p&gt;&lt;p&gt;  &lt;/p&gt;&lt;p&gt;Un nouvel écran apparaît après avoir double-cliqué sur la ligne « contact » ci-dessus (voir figure 5) : &lt;/p&gt;&lt;p&gt;&lt;img alt="entité contact" src="http://furnemont.net/images/furnemont_net/WindowsLiveWriter/Customisation2Ajoutdattributunformulaire_12143/entit%C3%A9%20contact_adf426d9-181e-4529-875e-898e0ecfe546.jpg" border="0" /&gt;  &lt;/p&gt;&lt;p&gt;&lt;a&gt;Figure &lt;/a&gt;5 : Entité contact &lt;/p&gt;&lt;p&gt;  &lt;/p&gt;&lt;p&gt;Sur le côté gauche de ce nouvel écran, on peut apercevoir une série de menus : &lt;/p&gt;&lt;p&gt;· &lt;b&gt;&lt;i&gt;Informations&lt;/i&gt;&lt;/b&gt; : donne des renseignements sur l’entité, tels que le nom de l’entité, son appartenance (utilisateur ou organisation), le nom de l’entité dans le schéma (le nom de la table SQL), etc. ; c’est via ce menu également que l’on peut modifier le nom de l’entité (par exemple : compte peut devenir société, etc.) &lt;/p&gt;&lt;p&gt;· &lt;b&gt;&lt;i&gt;Formulaires et vues&lt;/i&gt;&lt;/b&gt; : permet de modifier ou de créer des vues (des requêtes) ou de modifier les formulaires existants &lt;/p&gt;&lt;p&gt;· &lt;b&gt;&lt;i&gt;Attributs&lt;/i&gt; &lt;/b&gt;: permet de modifier ou de créer des attributs (des champs) &lt;/p&gt;&lt;p&gt;· &lt;b&gt;&lt;i&gt;Relations&lt;/i&gt;&lt;/b&gt; : permet de voir ou de créer des relations entre les entités (existantes ou nouvelles) &lt;/p&gt;&lt;p&gt;· &lt;b&gt;&lt;i&gt;Messages&lt;/i&gt;&lt;/b&gt; : permet de modifier l’aide et tous les messages du système (à utiliser impérativement lorsqu’on renomme une entité, pour éviter d’avoir une désynchronisation entre le nom de l’entité affichée et l’aide aux utilisateurs) &lt;/p&gt;&lt;p&gt;&lt;img alt="liste attributs" src="http://furnemont.net/images/furnemont_net/WindowsLiveWriter/Customisation2Ajoutdattributunformulaire_12143/liste%20attributs_4e5668ad-bf9c-454c-9be0-a4158d1367ae.jpg" border="0" /&gt;  &lt;/p&gt;&lt;p&gt;&lt;a&gt;Figure &lt;/a&gt;6 : Liste des attributs de l'entité &lt;/p&gt;&lt;p&gt;  &lt;/p&gt;&lt;p&gt;Il va de soi que pour la création d’un nouvel attribut, nous devons passer par le menu « attributs » de l’entité ; une fois que l’on a cliqué sur le lien, on se retrouve devant la liste de tous les attributs existants pour l’entité « contact ». &lt;/p&gt;&lt;p&gt;Que retrouve-t-on sur cet écran ? Nous voyons plusieurs colonnes dont les plus importantes sont les 3 premières, à savoir le nom du schéma, le nom complet et le type. &lt;/p&gt;&lt;p&gt;Quelle est la signification de ces 3 colonnes ? &lt;/p&gt;&lt;p&gt;· &lt;b&gt;&lt;i&gt;Nom du schéma&lt;/i&gt;&lt;/b&gt; : c’est littéralement le nom du champ dans la table « contact » &lt;/p&gt;&lt;p&gt;· &lt;b&gt;&lt;i&gt;Nom complet&lt;/i&gt;&lt;/b&gt;&lt;i&gt; &lt;/i&gt;: c’est le libellé de l’attribut qui apparaît à l’écran (celui-ci est toujours modifiable par après) &lt;/p&gt;&lt;p&gt;· &lt;b&gt;&lt;i&gt;Type&lt;/i&gt;&lt;/b&gt;&lt;i&gt; &lt;/i&gt;: c’est le type de l’attribut (identique au type lors de la création d’un champ en SQL) &lt;/p&gt;&lt;p&gt;Voici les différents types possibles d’un attribut dans Microsoft CRM 3.0 :&lt;/p&gt; &lt;table class="MediumShading1-Accent11" style="border-right: medium none; border-top: medium none; border-left: medium none; border-bottom: medium none; border-collapse: collapse; mso-border-alt: solid #7ba0cd 1.0pt; mso-border-themecolor: accent1; mso-border-themetint: 191; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt" cellspacing="0" cellpadding="0" border="1" unselectable="on"&gt; &lt;tbody&gt; &lt;tr style="mso-yfti-irow: -1; mso-yfti-firstrow: yes"&gt; &lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: #7ba0cd 1pt solid; padding-left: 5.4pt; background: #4f81bd; padding-bottom: 0cm; border-left: #7ba0cd 1pt solid; width: 230.3pt; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-border-themecolor: accent1; mso-border-themetint: 191; mso-background-themecolor: accent1" valign="top" width="307"&gt; &lt;p class="MsoListParagraphCxSpFirst" style="margin: 0cm 0cm 0pt; line-height: normal; mso-add-space: auto; mso-yfti-cnfc: 5"&gt;&lt;b&gt;&lt;span lang="FR-BE" style="color: white; mso-themecolor: background1"&gt;Type Microsoft CRM&lt;?xml:namespace prefix = o /?&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;&lt;/td&gt; &lt;td style="border-right: #7ba0cd 1pt solid; padding-right: 5.4pt; border-top: #7ba0cd 1pt solid; padding-left: 5.4pt; background: #4f81bd; padding-bottom: 0cm; border-left: medium none; width: 230.3pt; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-border-themecolor: accent1; mso-border-themetint: 191; mso-background-themecolor: accent1" valign="top" width="307"&gt; &lt;p class="MsoListParagraphCxSpLast" style="margin: 0cm 0cm 0pt; line-height: normal; mso-add-space: auto; mso-yfti-cnfc: 1"&gt;&lt;b&gt;&lt;span lang="FR-BE" style="color: white; mso-themecolor: background1"&gt;Type SQL Server&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;&lt;/td&gt;&lt;/tr&gt; &lt;tr style="mso-yfti-irow: 0"&gt; &lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; background: #d3dfee; padding-bottom: 0cm; border-left: #7ba0cd 1pt solid; width: 230.3pt; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-background-themecolor: accent1; mso-border-left-themecolor: accent1; mso-border-left-themetint: 191; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-background-themetint: 63" valign="top" width="307"&gt; &lt;p class="MsoListParagraphCxSpFirst" style="margin: 0cm 0cm 0pt; line-height: normal; mso-add-space: auto; mso-yfti-cnfc: 68"&gt;&lt;b&gt;&lt;span lang="FR-BE"&gt;primarykey&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;&lt;/td&gt; &lt;td style="border-right: #7ba0cd 1pt solid; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; background: #d3dfee; padding-bottom: 0cm; border-left: medium none; width: 230.3pt; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-background-themecolor: accent1; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-background-themetint: 63; mso-border-right-themecolor: accent1; mso-border-right-themetint: 191" valign="top" width="307"&gt; &lt;p class="MsoListParagraphCxSpLast" style="margin: 0cm 0cm 0pt; line-height: normal; mso-add-space: auto; mso-yfti-cnfc: 64"&gt;&lt;span lang="FR-BE"&gt;uniqueidentifier&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;&lt;/tr&gt; &lt;tr style="mso-yfti-irow: 1"&gt; &lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #7ba0cd 1pt solid; width: 230.3pt; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-border-left-themecolor: accent1; mso-border-left-themetint: 191; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191" valign="top" width="307"&gt; &lt;p class="MsoListParagraphCxSpFirst" style="margin: 0cm 0cm 0pt; line-height: normal; mso-add-space: auto; mso-yfti-cnfc: 132"&gt;&lt;b&gt;&lt;span lang="FR-BE"&gt;lookup&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;&lt;/td&gt; &lt;td style="border-right: #7ba0cd 1pt solid; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: medium none; width: 230.3pt; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-border-right-themecolor: accent1; mso-border-right-themetint: 191" valign="top" width="307"&gt; &lt;p class="MsoListParagraphCxSpLast" style="margin: 0cm 0cm 0pt; line-height: normal; mso-add-space: auto; mso-yfti-cnfc: 128"&gt;&lt;span lang="FR-BE"&gt;uniqueidentifier&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;&lt;/tr&gt; &lt;tr style="mso-yfti-irow: 2"&gt; &lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; background: #d3dfee; padding-bottom: 0cm; border-left: #7ba0cd 1pt solid; width: 230.3pt; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-background-themecolor: accent1; mso-border-left-themecolor: accent1; mso-border-left-themetint: 191; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-background-themetint: 63" valign="top" width="307"&gt; &lt;p class="MsoListParagraphCxSpFirst" style="margin: 0cm 0cm 0pt; line-height: normal; mso-add-space: auto; mso-yfti-cnfc: 68"&gt;&lt;b&gt;&lt;span lang="FR-BE"&gt;nvarchar&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;&lt;/td&gt; &lt;td style="border-right: #7ba0cd 1pt solid; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; background: #d3dfee; padding-bottom: 0cm; border-left: medium none; width: 230.3pt; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-background-themecolor: accent1; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-background-themetint: 63; mso-border-right-themecolor: accent1; mso-border-right-themetint: 191" valign="top" width="307"&gt; &lt;p class="MsoListParagraphCxSpLast" style="margin: 0cm 0cm 0pt; line-height: normal; mso-add-space: auto; mso-yfti-cnfc: 64"&gt;&lt;span lang="FR-BE"&gt;nvarchar&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;&lt;/tr&gt; &lt;tr style="mso-yfti-irow: 3"&gt; &lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #7ba0cd 1pt solid; width: 230.3pt; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-border-left-themecolor: accent1; mso-border-left-themetint: 191; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191" valign="top" width="307"&gt; &lt;p class="MsoListParagraphCxSpFirst" style="margin: 0cm 0cm 0pt; line-height: normal; mso-add-space: auto; mso-yfti-cnfc: 132"&gt;&lt;b&gt;&lt;span lang="FR-BE"&gt;ntext&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;&lt;/td&gt; &lt;td style="border-right: #7ba0cd 1pt solid; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: medium none; width: 230.3pt; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-border-right-themecolor: accent1; mso-border-right-themetint: 191" valign="top" width="307"&gt; &lt;p class="MsoListParagraphCxSpLast" style="margin: 0cm 0cm 0pt; line-height: normal; mso-add-space: auto; mso-yfti-cnfc: 128"&gt;&lt;span lang="FR-BE"&gt;ntext&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;&lt;/tr&gt; &lt;tr style="mso-yfti-irow: 4"&gt; &lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; background: #d3dfee; padding-bottom: 0cm; border-left: #7ba0cd 1pt solid; width: 230.3pt; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-background-themecolor: accent1; mso-border-left-themecolor: accent1; mso-border-left-themetint: 191; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-background-themetint: 63" valign="top" width="307"&gt; &lt;p class="MsoListParagraphCxSpFirst" style="margin: 0cm 0cm 0pt; line-height: normal; mso-add-space: auto; mso-yfti-cnfc: 68"&gt;&lt;b&gt;&lt;span lang="FR-BE"&gt;int&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;&lt;/td&gt; &lt;td style="border-right: #7ba0cd 1pt solid; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; background: #d3dfee; padding-bottom: 0cm; border-left: medium none; width: 230.3pt; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-background-themecolor: accent1; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-background-themetint: 63; mso-border-right-themecolor: accent1; mso-border-right-themetint: 191" valign="top" width="307"&gt; &lt;p class="MsoListParagraphCxSpLast" style="margin: 0cm 0cm 0pt; line-height: normal; mso-add-space: auto; mso-yfti-cnfc: 64"&gt;&lt;span lang="FR-BE"&gt;int&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;&lt;/tr&gt; &lt;tr style="mso-yfti-irow: 5"&gt; &lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #7ba0cd 1pt solid; width: 230.3pt; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-border-left-themecolor: accent1; mso-border-left-themetint: 191; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191" valign="top" width="307"&gt; &lt;p class="MsoListParagraphCxSpFirst" style="margin: 0cm 0cm 0pt; line-height: normal; mso-add-space: auto; mso-yfti-cnfc: 132"&gt;&lt;b&gt;&lt;span lang="FR-BE"&gt;float&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;&lt;/td&gt; &lt;td style="border-right: #7ba0cd 1pt solid; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: medium none; width: 230.3pt; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-border-right-themecolor: accent1; mso-border-right-themetint: 191" valign="top" width="307"&gt; &lt;p class="MsoListParagraphCxSpLast" style="margin: 0cm 0cm 0pt; line-height: normal; mso-add-space: auto; mso-yfti-cnfc: 128"&gt;&lt;span lang="FR-BE"&gt;float&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;&lt;/tr&gt; &lt;tr style="mso-yfti-irow: 6"&gt; &lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; background: #d3dfee; padding-bottom: 0cm; border-left: #7ba0cd 1pt solid; width: 230.3pt; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-background-themecolor: accent1; mso-border-left-themecolor: accent1; mso-border-left-themetint: 191; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-background-themetint: 63" valign="top" width="307"&gt; &lt;p class="MsoListParagraphCxSpFirst" style="margin: 0cm 0cm 0pt; line-height: normal; mso-add-space: auto; mso-yfti-cnfc: 68"&gt;&lt;b&gt;&lt;span lang="FR-BE"&gt;money&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;&lt;/td&gt; &lt;td style="border-right: #7ba0cd 1pt solid; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; background: #d3dfee; padding-bottom: 0cm; border-left: medium none; width: 230.3pt; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-background-themecolor: accent1; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-background-themetint: 63; mso-border-right-themecolor: accent1; mso-border-right-themetint: 191" valign="top" width="307"&gt; &lt;p class="MsoListParagraphCxSpLast" style="margin: 0cm 0cm 0pt; line-height: normal; mso-add-space: auto; mso-yfti-cnfc: 64"&gt;&lt;span lang="FR-BE"&gt;money&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;&lt;/tr&gt; &lt;tr style="mso-yfti-irow: 7"&gt; &lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #7ba0cd 1pt solid; width: 230.3pt; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-border-left-themecolor: accent1; mso-border-left-themetint: 191; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191" valign="top" width="307"&gt; &lt;p class="MsoListParagraphCxSpFirst" style="margin: 0cm 0cm 0pt; line-height: normal; mso-add-space: auto; mso-yfti-cnfc: 132"&gt;&lt;b&gt;&lt;span lang="FR-BE"&gt;datetime&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;&lt;/td&gt; &lt;td style="border-right: #7ba0cd 1pt solid; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: medium none; width: 230.3pt; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-border-right-themecolor: accent1; mso-border-right-themetint: 191" valign="top" width="307"&gt; &lt;p class="MsoListParagraphCxSpLast" style="margin: 0cm 0cm 0pt; line-height: normal; mso-add-space: auto; mso-yfti-cnfc: 128"&gt;&lt;span lang="FR-BE"&gt;datetime&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;&lt;/tr&gt; &lt;tr style="mso-yfti-irow: 8"&gt; &lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; background: #d3dfee; padding-bottom: 0cm; border-left: #7ba0cd 1pt solid; width: 230.3pt; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-background-themecolor: accent1; mso-border-left-themecolor: accent1; mso-border-left-themetint: 191; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-background-themetint: 63" valign="top" width="307"&gt; &lt;p class="MsoListParagraphCxSpFirst" style="margin: 0cm 0cm 0pt; line-height: normal; mso-add-space: auto; mso-yfti-cnfc: 68"&gt;&lt;b&gt;&lt;span lang="FR-BE"&gt;bit&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;&lt;/td&gt; &lt;td style="border-right: #7ba0cd 1pt solid; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; background: #d3dfee; padding-bottom: 0cm; border-left: medium none; width: 230.3pt; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-background-themecolor: accent1; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-background-themetint: 63; mso-border-right-themecolor: accent1; mso-border-right-themetint: 191" valign="top" width="307"&gt; &lt;p class="MsoListParagraphCxSpLast" style="margin: 0cm 0cm 0pt; line-height: normal; mso-add-space: auto; mso-yfti-cnfc: 64"&gt;&lt;span lang="FR-BE"&gt;bit&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;&lt;/tr&gt; &lt;tr style="mso-yfti-irow: 9; mso-yfti-lastrow: yes"&gt; &lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #7ba0cd 1pt solid; width: 230.3pt; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-border-left-themecolor: accent1; mso-border-left-themetint: 191; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191" valign="top" width="307"&gt; &lt;p class="MsoListParagraphCxSpFirst" style="margin: 0cm 0cm 0pt; line-height: normal; mso-add-space: auto; mso-yfti-cnfc: 132"&gt;&lt;b&gt;&lt;span lang="FR-BE"&gt;picklist (boîte de sélection)&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;&lt;/td&gt; &lt;td style="border-right: #7ba0cd 1pt solid; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: medium none; width: 230.3pt; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-border-right-themecolor: accent1; mso-border-right-themetint: 191" valign="top" width="307"&gt; &lt;p class="MsoListParagraphCxSpLast" style="margin: 0cm 0cm 0pt; line-height: normal; mso-add-space: auto; mso-yfti-cnfc: 128"&gt;&lt;span lang="FR-BE"&gt;int&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/tbody&gt;&lt;/table&gt; &lt;p&gt;&lt;a&gt;Tableau &lt;/a&gt;1 : Types d'attribut &lt;/p&gt;&lt;p&gt;  &lt;/p&gt;&lt;p&gt;Il existe d’autres types tels que « &lt;i&gt;owner&lt;/i&gt; », « &lt;i&gt;customer&lt;/i&gt; », etc. qui sont créés automatiquement par le système lors de la création de relations entre entités mais nous n’allons pas nous en occuper dans ce document. &lt;/p&gt;&lt;p&gt;&lt;img alt="nv attribut" src="http://furnemont.net/images/furnemont_net/WindowsLiveWriter/Customisation2Ajoutdattributunformulaire_12143/nv%20attribut_e5f1934f-ce13-40c2-8e6c-add39ded2b50.jpg" border="0" /&gt;  &lt;/p&gt;&lt;p&gt;&lt;a&gt;Figure &lt;/a&gt;7 : Création d'un nouvel attribut &lt;/p&gt;&lt;p&gt;  &lt;/p&gt;&lt;p&gt;Pour ce premier exemple, nous allons créer une série de nouveaux attributs que nous utiliserons tout au long de ce document ; pour créer un attribut, il suffit de cliquer sur le bouton « nouveau » et, au nouvel écran, de remplir les différents champs nécessaires à la création de l’attribut : &lt;/p&gt;&lt;p&gt;&lt;img alt="attribut save" src="http://furnemont.net/images/furnemont_net/WindowsLiveWriter/Customisation2Ajoutdattributunformulaire_12143/attribut%20save_63bd2d63-b8a2-48ec-b51f-0836ce93edf0.jpg" border="0" /&gt;  &lt;/p&gt;&lt;p&gt;&lt;a&gt;Figure &lt;/a&gt;8 : Enregistrement d'un nouvel attribut &lt;/p&gt;&lt;p&gt;  &lt;/p&gt;&lt;p&gt;Une fois chaque champ défini, il suffit de cliquer sur un des boutons de sauvegarde situés sur la barre de menu de l’écran : &lt;/p&gt;&lt;p&gt;Voici les paramètres à utiliser pour notre exemple :&lt;/p&gt; &lt;table class="MediumShading1-Accent11" style="border-right: medium none; border-top: medium none; border-left: medium none; border-bottom: medium none; border-collapse: collapse; mso-border-alt: solid #7ba0cd 1.0pt; mso-border-themecolor: accent1; mso-border-themetint: 191; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-table-layout-alt: fixed" cellspacing="0" cellpadding="0" width="100%" border="1" unselectable="on"&gt; &lt;tbody&gt; &lt;tr style="mso-yfti-irow: -1; mso-yfti-firstrow: yes"&gt; &lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: #7ba0cd 1pt solid; padding-left: 5.4pt; background: #4f81bd; padding-bottom: 0cm; border-left: #7ba0cd 1pt solid; width: 10.32%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-border-themecolor: accent1; mso-border-themetint: 191; mso-background-themecolor: accent1" valign="top" width="10%"&gt; &lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; text-align: center; mso-yfti-cnfc: 5" align="center"&gt;&lt;b&gt;&lt;span lang="FR-BE" style="color: white; mso-themecolor: background1"&gt;Attribut n°&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;&lt;/td&gt; &lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: #7ba0cd 1pt solid; padding-left: 5.4pt; background: #4f81bd; padding-bottom: 0cm; border-left: medium none; width: 19.88%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-background-themecolor: accent1; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191" valign="top" width="19%"&gt; &lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 1"&gt;&lt;b&gt;&lt;span lang="FR-BE" style="color: white; mso-themecolor: background1"&gt;Nom complet&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;&lt;/td&gt; &lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: #7ba0cd 1pt solid; padding-left: 5.4pt; background: #4f81bd; padding-bottom: 0cm; border-left: medium none; width: 25.18%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-background-themecolor: accent1; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191" valign="top" width="25%"&gt; &lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 1"&gt;&lt;b&gt;&lt;span lang="FR-BE" style="color: white; mso-themecolor: background1"&gt;Nom du schéma (automatique)&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;&lt;/td&gt; &lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: #7ba0cd 1pt solid; padding-left: 5.4pt; background: #4f81bd; padding-bottom: 0cm; border-left: medium none; width: 14.76%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-background-themecolor: accent1; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191" valign="top" width="14%"&gt; &lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 1"&gt;&lt;b&gt;&lt;span lang="FR-BE" style="color: white; mso-themecolor: background1"&gt;Niveau requis&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;&lt;/td&gt; &lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: #7ba0cd 1pt solid; padding-left: 5.4pt; background: #4f81bd; padding-bottom: 0cm; border-left: medium none; width: 8.36%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-background-themecolor: accent1; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191" valign="top" width="8%"&gt; &lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 1"&gt;&lt;b&gt;&lt;span lang="FR-BE" style="color: white; mso-themecolor: background1"&gt;Type&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;&lt;/td&gt; &lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: #7ba0cd 1pt solid; padding-left: 5.4pt; background: #4f81bd; padding-bottom: 0cm; border-left: medium none; width: 11.34%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-background-themecolor: accent1; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191" valign="top" width="11%"&gt; &lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 1"&gt;&lt;b&gt;&lt;span lang="FR-BE" style="color: white; mso-themecolor: background1"&gt;Valeurs possibles&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;&lt;/td&gt; &lt;td style="border-right: #7ba0cd 1pt solid; padding-right: 5.4pt; border-top: #7ba0cd 1pt solid; padding-left: 5.4pt; background: #4f81bd; padding-bottom: 0cm; border-left: medium none; width: 10.16%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-border-themecolor: accent1; mso-border-themetint: 191; mso-background-themecolor: accent1" valign="top" width="10%"&gt; &lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 1"&gt;&lt;b&gt;&lt;span lang="FR-BE" style="color: white; mso-themecolor: background1"&gt;Valeur par défaut&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;&lt;/td&gt;&lt;/tr&gt; &lt;tr style="mso-yfti-irow: 0"&gt; &lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; background: #d3dfee; padding-bottom: 0cm; border-left: #7ba0cd 1pt solid; width: 10.32%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-background-themecolor: accent1; mso-border-left-themecolor: accent1; mso-border-left-themetint: 191; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-background-themetint: 63" valign="top" width="10%"&gt; &lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; text-align: center; mso-yfti-cnfc: 68" align="center"&gt;&lt;b&gt;&lt;span lang="FR-BE"&gt;1&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;&lt;/td&gt; &lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; background: #d3dfee; padding-bottom: 0cm; border-left: medium none; width: 19.88%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-background-themecolor: accent1; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-background-themetint: 63" valign="top" width="19%"&gt; &lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 64"&gt;&lt;span lang="FR-BE"&gt;Adresse du compte&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt; &lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; background: #d3dfee; padding-bottom: 0cm; border-left: medium none; width: 25.18%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-background-themecolor: accent1; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-background-themetint: 63" valign="top" width="25%"&gt; &lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 64"&gt;&lt;span lang="FR-BE"&gt;New_adresseducompte&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt; &lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; background: #d3dfee; padding-bottom: 0cm; border-left: medium none; width: 14.76%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-background-themecolor: accent1; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-background-themetint: 63" valign="top" width="14%"&gt; &lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 64"&gt;&lt;span lang="FR-BE"&gt;Aucune contrainte&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt; &lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; background: #d3dfee; padding-bottom: 0cm; border-left: medium none; width: 8.36%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-background-themecolor: accent1; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-background-themetint: 63" valign="top" width="8%"&gt; &lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 64"&gt;&lt;span lang="FR-BE"&gt;Bit&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt; &lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; background: #d3dfee; padding-bottom: 0cm; border-left: medium none; width: 11.34%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-background-themecolor: accent1; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-background-themetint: 63" valign="top" width="11%"&gt; &lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 64"&gt;&lt;span lang="FR-BE"&gt;Non/Oui&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt; &lt;td style="border-right: #7ba0cd 1pt solid; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; background: #d3dfee; padding-bottom: 0cm; border-left: medium none; width: 10.16%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-background-themecolor: accent1; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-background-themetint: 63; mso-border-right-themecolor: accent1; mso-border-right-themetint: 191" valign="top" width="10%"&gt; &lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 64"&gt;&lt;span lang="FR-BE"&gt;Oui&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;&lt;/tr&gt; &lt;tr style="mso-yfti-irow: 1; mso-yfti-lastrow: yes"&gt; &lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #7ba0cd 1pt solid; width: 10.32%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-border-left-themecolor: accent1; mso-border-left-themetint: 191; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191" valign="top" width="10%"&gt; &lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; text-align: center; mso-yfti-cnfc: 132" align="center"&gt;&lt;b&gt;&lt;span lang="FR-BE"&gt;2&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;&lt;/td&gt; &lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: medium none; width: 19.88%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191" valign="top" width="19%"&gt; &lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 128"&gt;&lt;span lang="FR-BE"&gt;A jour&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt; &lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: medium none; width: 25.18%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191" valign="top" width="25%"&gt; &lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 128"&gt;&lt;span lang="FR-BE"&gt;New_ajour&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt; &lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: medium none; width: 14.76%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191" valign="top" width="14%"&gt; &lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 128"&gt;&lt;span lang="FR-BE"&gt;Aucune contrainte&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt; &lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: medium none; width: 8.36%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191" valign="top" width="8%"&gt; &lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 128"&gt;&lt;span lang="FR-BE"&gt;Bit&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt; &lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: medium none; width: 11.34%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191" valign="top" width="11%"&gt; &lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 128"&gt;&lt;span lang="FR-BE"&gt;Non/Oui&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt; &lt;td style="border-right: #7ba0cd 1pt solid; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: medium none; width: 10.16%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-border-right-themecolor: accent1; mso-border-right-themetint: 191" valign="top" width="10%"&gt; &lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 128"&gt;&lt;span lang="FR-BE"&gt;Non&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/tbody&gt;&lt;/table&gt; &lt;p&gt;&lt;a&gt;Tableau &lt;/a&gt;2 : Attributs de l'exemple 1 &lt;/p&gt;&lt;p&gt;  &lt;/p&gt;&lt;p&gt;A quoi vont-nous servir ces nouveaux attributs ? Voici une petite explication. &lt;/p&gt;&lt;p&gt;Tout le monde sait, après avoir utilisé Microsoft CRM, que lorsqu’on crée un contact &lt;u&gt;à partir d’un compte client&lt;/u&gt;, l’adresse principale du contact est héritée du compte, et ceci grâce à la relation système qui existe entre ces 2 entités (ce point n’est pas abordé dans ce document) ; mais que se passe-t-il si on crée un contact et puis qu’on le relie à compte client existant ? L’adresse principale n’est tout simplement pas reprise automatiquement. De plus, si on modifie l’adresse du compte, aucune des adresses des contacts liés n’est mise à jour ! &lt;/p&gt;&lt;p&gt;Les attributs que nous venons de rajouter vont dès lors nous permettre de pallier à ces 2 problèmes (beaucoup de clients me demandent ces customisations, qui sont, pour eux, une aide précieuse à l’encodage), et ils seront utilisés dans un « &lt;i&gt;callout&lt;/i&gt; » et dans une règle de « &lt;i&gt;workflow&lt;/i&gt; » (le déploiement de celui-ci sera expliqué pas à pas). &lt;/p&gt;&lt;p&gt;Revenons à notre base de données « &lt;i&gt;metabase &lt;/i&gt;» et voyons les modifications qui y ont été apportée : pour ce faire, il suffit de faire tourner la requête suivante sur la base de données XX_METABASE : &lt;/p&gt;&lt;blockquote&gt;&lt;pre&gt;&lt;a style="color: #0000ff" href="http://search.microsoft.com/default.asp?so=RECCNT&amp;amp;siteid=us%2Fdev&amp;amp;p=1&amp;amp;nq=NEW&amp;amp;qu=select&amp;amp;IntlSearch=&amp;amp;boolean=PHRASE&amp;amp;ig=01&amp;amp;i=09&amp;amp;i=99"&gt;select&lt;/a&gt; a.*, '&lt;span style="color: #8b0000"&gt;typename&lt;/span&gt;' = &lt;a style="color: #0000ff" href="http://search.microsoft.com/default.asp?so=RECCNT&amp;amp;siteid=us%2Fdev&amp;amp;p=1&amp;amp;nq=NEW&amp;amp;qu=at&amp;amp;IntlSearch=&amp;amp;boolean=PHRASE&amp;amp;ig=01&amp;amp;i=09&amp;amp;i=99"&gt;at&lt;/a&gt;.Description, '&lt;span style="color: #8b0000"&gt;isquoted&lt;/span&gt;' = &lt;a style="color: #0000ff" href="http://search.microsoft.com/default.asp?so=RECCNT&amp;amp;siteid=us%2Fdev&amp;amp;p=1&amp;amp;nq=NEW&amp;amp;qu=at&amp;amp;IntlSearch=&amp;amp;boolean=PHRASE&amp;amp;ig=01&amp;amp;i=09&amp;amp;i=99"&gt;at&lt;/a&gt;.Quoted 
&lt;a style="color: #0000ff" href="http://search.microsoft.com/default.asp?so=RECCNT&amp;amp;siteid=us%2Fdev&amp;amp;p=1&amp;amp;nq=NEW&amp;amp;qu=from&amp;amp;IntlSearch=&amp;amp;boolean=PHRASE&amp;amp;ig=01&amp;amp;i=09&amp;amp;i=99"&gt;from&lt;/a&gt; Entity e 
&lt;a style="color: #0000ff" href="http://search.microsoft.com/default.asp?so=RECCNT&amp;amp;siteid=us%2Fdev&amp;amp;p=1&amp;amp;nq=NEW&amp;amp;qu=join&amp;amp;IntlSearch=&amp;amp;boolean=PHRASE&amp;amp;ig=01&amp;amp;i=09&amp;amp;i=99"&gt;join&lt;/a&gt; Attribute a &lt;a style="color: #0000ff" href="http://search.microsoft.com/default.asp?so=RECCNT&amp;amp;siteid=us%2Fdev&amp;amp;p=1&amp;amp;nq=NEW&amp;amp;qu=on&amp;amp;IntlSearch=&amp;amp;boolean=PHRASE&amp;amp;ig=01&amp;amp;i=09&amp;amp;i=99"&gt;on&lt;/a&gt; (e.EntityId = a.EntityId) 
&lt;a style="color: #0000ff" href="http://search.microsoft.com/default.asp?so=RECCNT&amp;amp;siteid=us%2Fdev&amp;amp;p=1&amp;amp;nq=NEW&amp;amp;qu=join&amp;amp;IntlSearch=&amp;amp;boolean=PHRASE&amp;amp;ig=01&amp;amp;i=09&amp;amp;i=99"&gt;join&lt;/a&gt; AttributeTypes &lt;a style="color: #0000ff" href="http://search.microsoft.com/default.asp?so=RECCNT&amp;amp;siteid=us%2Fdev&amp;amp;p=1&amp;amp;nq=NEW&amp;amp;qu=at&amp;amp;IntlSearch=&amp;amp;boolean=PHRASE&amp;amp;ig=01&amp;amp;i=09&amp;amp;i=99"&gt;at&lt;/a&gt; &lt;a style="color: #0000ff" href="http://search.microsoft.com/default.asp?so=RECCNT&amp;amp;siteid=us%2Fdev&amp;amp;p=1&amp;amp;nq=NEW&amp;amp;qu=on&amp;amp;IntlSearch=&amp;amp;boolean=PHRASE&amp;amp;ig=01&amp;amp;i=09&amp;amp;i=99"&gt;on&lt;/a&gt; (a.AttributeTypeId = &lt;a style="color: #0000ff" href="http://search.microsoft.com/default.asp?so=RECCNT&amp;amp;siteid=us%2Fdev&amp;amp;p=1&amp;amp;nq=NEW&amp;amp;qu=at&amp;amp;IntlSearch=&amp;amp;boolean=PHRASE&amp;amp;ig=01&amp;amp;i=09&amp;amp;i=99"&gt;at&lt;/a&gt;.AttributeTypeId) 
&lt;a style="color: #0000ff" href="http://search.microsoft.com/default.asp?so=RECCNT&amp;amp;siteid=us%2Fdev&amp;amp;p=1&amp;amp;nq=NEW&amp;amp;qu=where&amp;amp;IntlSearch=&amp;amp;boolean=PHRASE&amp;amp;ig=01&amp;amp;i=09&amp;amp;i=99"&gt;where&lt;/a&gt; e.Name = '&lt;span style="color: #8b0000"&gt;contact &lt;/span&gt;
&lt;a style="color: #0000ff" href="http://search.microsoft.com/default.asp?so=RECCNT&amp;amp;siteid=us%2Fdev&amp;amp;p=1&amp;amp;nq=NEW&amp;amp;qu=and&amp;amp;IntlSearch=&amp;amp;boolean=PHRASE&amp;amp;ig=01&amp;amp;i=09&amp;amp;i=99"&gt;and&lt;/a&gt; a.VisibleToPlatform = 1 
&lt;a style="color: #0000ff" href="http://search.microsoft.com/default.asp?so=RECCNT&amp;amp;siteid=us%2Fdev&amp;amp;p=1&amp;amp;nq=NEW&amp;amp;qu=order&amp;amp;IntlSearch=&amp;amp;boolean=PHRASE&amp;amp;ig=01&amp;amp;i=09&amp;amp;i=99"&gt;order&lt;/a&gt; &lt;a style="color: #0000ff" href="http://search.microsoft.com/default.asp?so=RECCNT&amp;amp;siteid=us%2Fdev&amp;amp;p=1&amp;amp;nq=NEW&amp;amp;qu=by&amp;amp;IntlSearch=&amp;amp;boolean=PHRASE&amp;amp;ig=01&amp;amp;i=09&amp;amp;i=99"&gt;by&lt;/a&gt; a.ColumnNumber&lt;/pre&gt;&lt;/blockquote&gt;
&lt;p&gt; 
&lt;/p&gt;&lt;p&gt;Voici, en partie, le résultat de cette requête (certaines colonnes et lignes ont été retirées pour plus de lisibilité) :&lt;/p&gt;
&lt;table class="MediumShading1-Accent11" style="border-right: medium none; border-top: medium none; border-left: medium none; border-bottom: medium none; border-collapse: collapse; mso-border-alt: solid #7ba0cd 1.0pt; mso-border-themecolor: accent1; mso-border-themetint: 191; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-table-layout-alt: fixed" cellspacing="0" cellpadding="0" width="100%" border="1" unselectable="on"&gt;
&lt;tbody&gt;
&lt;tr style="height: 15pt; mso-yfti-irow: -1; mso-yfti-firstrow: yes"&gt;
&lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: #7ba0cd 1pt solid; padding-left: 5.4pt; background: #4f81bd; padding-bottom: 0cm; border-left: #7ba0cd 1pt solid; width: 25.62%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; height: 15pt; mso-border-themecolor: accent1; mso-border-themetint: 191; mso-background-themecolor: accent1" valign="top" nowrap="" width="25%"&gt;
&lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 5"&gt;&lt;b&gt;&lt;span lang="FR-BE" style="color: black; mso-ascii-font-family: calibri; mso-fareast-font-family: 'Times New Roman'; mso-hansi-font-family: calibri; mso-bidi-font-family: 'Times New Roman'; mso-fareast-language: fr-be"&gt;AttributeID&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;&lt;/td&gt;
&lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: #7ba0cd 1pt solid; padding-left: 5.4pt; background: #4f81bd; padding-bottom: 0cm; border-left: medium none; width: 25.92%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; height: 15pt; mso-background-themecolor: accent1; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191" valign="top" nowrap="" width="25%"&gt;
&lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 1"&gt;&lt;b&gt;&lt;span lang="FR-BE" style="color: black; mso-ascii-font-family: calibri; mso-fareast-font-family: 'Times New Roman'; mso-hansi-font-family: calibri; mso-bidi-font-family: 'Times New Roman'; mso-fareast-language: fr-be"&gt;Name&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;&lt;/td&gt;
&lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: #7ba0cd 1pt solid; padding-left: 5.4pt; background: #4f81bd; padding-bottom: 0cm; border-left: medium none; width: 22.88%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; height: 15pt; mso-background-themecolor: accent1; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191" valign="top" nowrap="" width="22%"&gt;
&lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 1"&gt;&lt;b&gt;&lt;span lang="FR-BE" style="color: black; mso-ascii-font-family: calibri; mso-fareast-font-family: 'Times New Roman'; mso-hansi-font-family: calibri; mso-bidi-font-family: 'Times New Roman'; mso-fareast-language: fr-be"&gt;PhysicalName&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;&lt;/td&gt;
&lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: #7ba0cd 1pt solid; padding-left: 5.4pt; background: #4f81bd; padding-bottom: 0cm; border-left: medium none; width: 12.2%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; height: 15pt; mso-background-themecolor: accent1; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191" valign="top" nowrap="" width="12%"&gt;
&lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; text-align: center; mso-yfti-cnfc: 1" align="center"&gt;&lt;b&gt;&lt;span lang="FR-BE" style="color: black; mso-ascii-font-family: calibri; mso-fareast-font-family: 'Times New Roman'; mso-hansi-font-family: calibri; mso-bidi-font-family: 'Times New Roman'; mso-fareast-language: fr-be"&gt;IsCustomField&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;&lt;/td&gt;
&lt;td style="border-right: #7ba0cd 1pt solid; padding-right: 5.4pt; border-top: #7ba0cd 1pt solid; padding-left: 5.4pt; background: #4f81bd; padding-bottom: 0cm; border-left: medium none; width: 13.38%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; height: 15pt; mso-border-themecolor: accent1; mso-border-themetint: 191; mso-background-themecolor: accent1" valign="top" nowrap="" width="13%"&gt;
&lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 1"&gt;&lt;b&gt;&lt;span lang="FR-BE" style="color: black; mso-ascii-font-family: calibri; mso-fareast-font-family: 'Times New Roman'; mso-hansi-font-family: calibri; mso-bidi-font-family: 'Times New Roman'; mso-fareast-language: fr-be"&gt;typename&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr style="height: 15pt; mso-yfti-irow: 0"&gt;
&lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; background: #d3dfee; padding-bottom: 0cm; border-left: #7ba0cd 1pt solid; width: 25.62%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; height: 15pt; mso-background-themecolor: accent1; mso-border-left-themecolor: accent1; mso-border-left-themetint: 191; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-background-themetint: 63" valign="top" nowrap="" width="25%"&gt;
&lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 68"&gt;&lt;b&gt;&lt;span lang="FR-BE" style="color: black; mso-ascii-font-family: calibri; mso-fareast-font-family: 'Times New Roman'; mso-hansi-font-family: calibri; mso-bidi-font-family: 'Times New Roman'; mso-fareast-language: fr-be"&gt;1B888D39-C537-47DC-80DB-55A6D3281863&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;&lt;/td&gt;
&lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; background: #d3dfee; padding-bottom: 0cm; border-left: medium none; width: 25.92%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; height: 15pt; mso-background-themecolor: accent1; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-background-themetint: 63" valign="top" nowrap="" width="25%"&gt;
&lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 64"&gt;&lt;span lang="FR-BE" style="color: black; mso-ascii-font-family: calibri; mso-fareast-font-family: 'Times New Roman'; mso-hansi-font-family: calibri; mso-bidi-font-family: 'Times New Roman'; mso-fareast-language: fr-be"&gt;contactid&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;
&lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; background: #d3dfee; padding-bottom: 0cm; border-left: medium none; width: 22.88%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; height: 15pt; mso-background-themecolor: accent1; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-background-themetint: 63" valign="top" nowrap="" width="22%"&gt;
&lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 64"&gt;&lt;span lang="FR-BE" style="color: black; mso-ascii-font-family: calibri; mso-fareast-font-family: 'Times New Roman'; mso-hansi-font-family: calibri; mso-bidi-font-family: 'Times New Roman'; mso-fareast-language: fr-be"&gt;ContactId&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;
&lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; background: #d3dfee; padding-bottom: 0cm; border-left: medium none; width: 12.2%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; height: 15pt; mso-background-themecolor: accent1; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-background-themetint: 63" valign="top" nowrap="" width="12%"&gt;
&lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; text-align: center; mso-yfti-cnfc: 64" align="center"&gt;&lt;span lang="FR-BE" style="color: black; mso-ascii-font-family: calibri; mso-fareast-font-family: 'Times New Roman'; mso-hansi-font-family: calibri; mso-bidi-font-family: 'Times New Roman'; mso-fareast-language: fr-be"&gt;0&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;
&lt;td style="border-right: #7ba0cd 1pt solid; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; background: #d3dfee; padding-bottom: 0cm; border-left: medium none; width: 13.38%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; height: 15pt; mso-background-themecolor: accent1; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-background-themetint: 63; mso-border-right-themecolor: accent1; mso-border-right-themetint: 191" valign="top" nowrap="" width="13%"&gt;
&lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 64"&gt;&lt;span lang="FR-BE" style="color: black; mso-ascii-font-family: calibri; mso-fareast-font-family: 'Times New Roman'; mso-hansi-font-family: calibri; mso-bidi-font-family: 'Times New Roman'; mso-fareast-language: fr-be"&gt;primarykey&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr style="height: 15pt; mso-yfti-irow: 1"&gt;
&lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #7ba0cd 1pt solid; width: 25.62%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; height: 15pt; mso-border-left-themecolor: accent1; mso-border-left-themetint: 191; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191" valign="top" nowrap="" width="25%"&gt;
&lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 132"&gt;&lt;b&gt;&lt;span lang="FR-BE" style="color: black; mso-ascii-font-family: calibri; mso-hansi-font-family: calibri"&gt;[…]&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;&lt;/td&gt;
&lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: medium none; width: 25.92%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; height: 15pt; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191" valign="top" nowrap="" width="25%"&gt;
&lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 128"&gt;&lt;span lang="FR-BE" style="color: black; mso-ascii-font-family: calibri; mso-hansi-font-family: calibri"&gt;[…]&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;
&lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: medium none; width: 22.88%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; height: 15pt; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191" valign="top" nowrap="" width="22%"&gt;
&lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 128"&gt;&lt;span lang="FR-BE" style="color: black; mso-ascii-font-family: calibri; mso-hansi-font-family: calibri"&gt;[…]&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;
&lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: medium none; width: 12.2%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; height: 15pt; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191" valign="top" nowrap="" width="12%"&gt;
&lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; text-align: center; mso-yfti-cnfc: 128" align="center"&gt;&lt;span lang="FR-BE" style="color: black; mso-ascii-font-family: calibri; mso-hansi-font-family: calibri"&gt;[…]&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;
&lt;td style="border-right: #7ba0cd 1pt solid; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: medium none; width: 13.38%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; height: 15pt; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-border-right-themecolor: accent1; mso-border-right-themetint: 191" valign="top" nowrap="" width="13%"&gt;
&lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 128"&gt;&lt;span lang="FR-BE" style="color: black; mso-ascii-font-family: calibri; mso-hansi-font-family: calibri"&gt;[…]&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr style="height: 15pt; mso-yfti-irow: 2"&gt;
&lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; background: #d3dfee; padding-bottom: 0cm; border-left: #7ba0cd 1pt solid; width: 25.62%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; height: 15pt; mso-background-themecolor: accent1; mso-border-left-themecolor: accent1; mso-border-left-themetint: 191; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-background-themetint: 63" valign="top" nowrap="" width="25%"&gt;
&lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 68"&gt;&lt;b&gt;&lt;span lang="FR-BE" style="color: black; mso-ascii-font-family: calibri; mso-hansi-font-family: calibri"&gt;AC6D7AAE-F250-4523-B83D-078530259EA1&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;&lt;/td&gt;
&lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; background: #d3dfee; padding-bottom: 0cm; border-left: medium none; width: 25.92%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; height: 15pt; mso-background-themecolor: accent1; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-background-themetint: 63" valign="top" nowrap="" width="25%"&gt;
&lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 64"&gt;&lt;span lang="FR-BE" style="color: black; mso-ascii-font-family: calibri; mso-hansi-font-family: calibri"&gt;new_adresseducompte&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;
&lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; background: #d3dfee; padding-bottom: 0cm; border-left: medium none; width: 22.88%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; height: 15pt; mso-background-themecolor: accent1; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-background-themetint: 63" valign="top" nowrap="" width="22%"&gt;
&lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 64"&gt;&lt;span lang="FR-BE" style="color: black; mso-ascii-font-family: calibri; mso-hansi-font-family: calibri"&gt;New_Adresseducompte&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;
&lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; background: #d3dfee; padding-bottom: 0cm; border-left: medium none; width: 12.2%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; height: 15pt; mso-background-themecolor: accent1; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-background-themetint: 63" valign="top" nowrap="" width="12%"&gt;
&lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; text-align: center; mso-yfti-cnfc: 64" align="center"&gt;&lt;span lang="FR-BE" style="color: black; mso-ascii-font-family: calibri; mso-hansi-font-family: calibri"&gt;1&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;
&lt;td style="border-right: #7ba0cd 1pt solid; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; background: #d3dfee; padding-bottom: 0cm; border-left: medium none; width: 13.38%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; height: 15pt; mso-background-themecolor: accent1; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-background-themetint: 63; mso-border-right-themecolor: accent1; mso-border-right-themetint: 191" valign="top" nowrap="" width="13%"&gt;
&lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 64"&gt;&lt;span lang="FR-BE" style="color: black; mso-ascii-font-family: calibri; mso-hansi-font-family: calibri"&gt;bit&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr style="height: 15pt; mso-yfti-irow: 3"&gt;
&lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #7ba0cd 1pt solid; width: 25.62%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; height: 15pt; mso-border-left-themecolor: accent1; mso-border-left-themetint: 191; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191" valign="top" nowrap="" width="25%"&gt;
&lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 132"&gt;&lt;b&gt;&lt;span lang="FR-BE" style="color: black; mso-ascii-font-family: calibri; mso-hansi-font-family: calibri"&gt;C58E0DC4-C41D-4026-ACB2-4ECD6EE9CF02&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;&lt;/td&gt;
&lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: medium none; width: 25.92%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; height: 15pt; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191" valign="top" nowrap="" width="25%"&gt;
&lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 128"&gt;&lt;span lang="FR-BE" style="color: black; mso-ascii-font-family: calibri; mso-hansi-font-family: calibri"&gt;new_adresseducomptename&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;
&lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: medium none; width: 22.88%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; height: 15pt; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191" valign="top" nowrap="" width="22%"&gt;
&lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 128"&gt;&lt;span lang="FR-BE" style="color: black; mso-ascii-font-family: calibri; mso-hansi-font-family: calibri"&gt;new_adresseducompteName&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;
&lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: medium none; width: 12.2%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; height: 15pt; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191" valign="top" nowrap="" width="12%"&gt;
&lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; text-align: center; mso-yfti-cnfc: 128" align="center"&gt;&lt;span lang="FR-BE" style="color: black; mso-ascii-font-family: calibri; mso-hansi-font-family: calibri"&gt;1&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;
&lt;td style="border-right: #7ba0cd 1pt solid; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: medium none; width: 13.38%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; height: 15pt; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-border-right-themecolor: accent1; mso-border-right-themetint: 191" valign="top" nowrap="" width="13%"&gt;
&lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 128"&gt;&lt;span lang="FR-BE" style="color: black; mso-ascii-font-family: calibri; mso-hansi-font-family: calibri"&gt;virtual&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr style="height: 15pt; mso-yfti-irow: 4"&gt;
&lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; background: #d3dfee; padding-bottom: 0cm; border-left: #7ba0cd 1pt solid; width: 25.62%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; height: 15pt; mso-background-themecolor: accent1; mso-border-left-themecolor: accent1; mso-border-left-themetint: 191; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-background-themetint: 63" valign="top" nowrap="" width="25%"&gt;
&lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 68"&gt;&lt;b&gt;&lt;span lang="FR-BE" style="color: black; mso-ascii-font-family: calibri; mso-hansi-font-family: calibri"&gt;0364F190-6641-4D5D-8B47-772B916CAAEE&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;&lt;/td&gt;
&lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; background: #d3dfee; padding-bottom: 0cm; border-left: medium none; width: 25.92%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; height: 15pt; mso-background-themecolor: accent1; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-background-themetint: 63" valign="top" nowrap="" width="25%"&gt;
&lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 64"&gt;&lt;span lang="FR-BE" style="color: black; mso-ascii-font-family: calibri; mso-hansi-font-family: calibri"&gt;new_ajour&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;
&lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; background: #d3dfee; padding-bottom: 0cm; border-left: medium none; width: 22.88%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; height: 15pt; mso-background-themecolor: accent1; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-background-themetint: 63" valign="top" nowrap="" width="22%"&gt;
&lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 64"&gt;&lt;span lang="FR-BE" style="color: black; mso-ascii-font-family: calibri; mso-hansi-font-family: calibri"&gt;New_AJour&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;
&lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; background: #d3dfee; padding-bottom: 0cm; border-left: medium none; width: 12.2%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; height: 15pt; mso-background-themecolor: accent1; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-background-themetint: 63" valign="top" nowrap="" width="12%"&gt;
&lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; text-align: center; mso-yfti-cnfc: 64" align="center"&gt;&lt;span lang="FR-BE" style="color: black; mso-ascii-font-family: calibri; mso-hansi-font-family: calibri"&gt;1&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;
&lt;td style="border-right: #7ba0cd 1pt solid; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; background: #d3dfee; padding-bottom: 0cm; border-left: medium none; width: 13.38%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; height: 15pt; mso-background-themecolor: accent1; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-background-themetint: 63; mso-border-right-themecolor: accent1; mso-border-right-themetint: 191" valign="top" nowrap="" width="13%"&gt;
&lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 64"&gt;&lt;span lang="FR-BE" style="color: black; mso-ascii-font-family: calibri; mso-hansi-font-family: calibri"&gt;bit&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr style="height: 15pt; mso-yfti-irow: 5; mso-yfti-lastrow: yes"&gt;
&lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: #7ba0cd 1pt solid; width: 25.62%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; height: 15pt; mso-border-left-themecolor: accent1; mso-border-left-themetint: 191; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191" valign="top" nowrap="" width="25%"&gt;
&lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 132"&gt;&lt;b&gt;&lt;span lang="FR-BE" style="color: black; mso-ascii-font-family: calibri; mso-hansi-font-family: calibri"&gt;272DEB2F-3379-4127-A7CA-D8693CA7555E&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;&lt;/td&gt;
&lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: medium none; width: 25.92%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; height: 15pt; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191" valign="top" nowrap="" width="25%"&gt;
&lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 128"&gt;&lt;span lang="FR-BE" style="color: black; mso-ascii-font-family: calibri; mso-hansi-font-family: calibri"&gt;new_ajourname&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;
&lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: medium none; width: 22.88%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; height: 15pt; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191" valign="top" nowrap="" width="22%"&gt;
&lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 128"&gt;&lt;span lang="FR-BE" style="color: black; mso-ascii-font-family: calibri; mso-hansi-font-family: calibri"&gt;new_ajourName&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;
&lt;td style="border-right: medium none; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: medium none; width: 12.2%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; height: 15pt; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191" valign="top" nowrap="" width="12%"&gt;
&lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; text-align: center; mso-yfti-cnfc: 128" align="center"&gt;&lt;span lang="FR-BE" style="color: black; mso-ascii-font-family: calibri; mso-hansi-font-family: calibri"&gt;1&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;
&lt;td style="border-right: #7ba0cd 1pt solid; padding-right: 5.4pt; border-top: medium none; padding-left: 5.4pt; padding-bottom: 0cm; border-left: medium none; width: 13.38%; padding-top: 0cm; border-bottom: #7ba0cd 1pt solid; height: 15pt; mso-border-bottom-themecolor: accent1; mso-border-bottom-themetint: 191; mso-border-top-alt: solid #7ba0cd 1.0pt; mso-border-top-themecolor: accent1; mso-border-top-themetint: 191; mso-border-right-themecolor: accent1; mso-border-right-themetint: 191" valign="top" nowrap="" width="13%"&gt;
&lt;p class="MsoNormal" style="margin-bottom: 0pt; line-height: normal; mso-yfti-cnfc: 128"&gt;&lt;span lang="FR-BE" style="color: black; mso-ascii-font-family: calibri; mso-hansi-font-family: calibri"&gt;virtual&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/p&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/tbody&gt;&lt;/table&gt;
&lt;p&gt;&lt;a&gt;Tableau &lt;/a&gt;3 : Résultat de la requête sur la metabase
&lt;/p&gt;&lt;p&gt; 
&lt;/p&gt;&lt;p&gt;On constate d’après le résultat ci-dessus que la « &lt;i&gt;metabase&lt;/i&gt; » n’a pas changé, elle reflète simplement le changement qui a été effectué dans la couche de données (donc dans la base de données XX_MSCRM). Ainsi, quelque soit le nombre d’attributs ajoutés et/ou supprimés, la « &lt;i&gt;metabase&lt;/i&gt; » assure la synchronisation (et par la même la stabilité complète) entre la couche présentation et la couche de données : la plateforme Microsoft CRM sera ainsi toujours à jour !
&lt;/p&gt;&lt;p&gt;&lt;img alt="entité contact 2" src="http://furnemont.net/images/furnemont_net/WindowsLiveWriter/Customisation2Ajoutdattributunformulaire_12143/entit%C3%A9%20contact%202_7c994589-d7e6-4b12-bd4b-87b3f3cf5b35.jpg" border="0" /&gt; 
&lt;/p&gt;&lt;p&gt;&lt;a&gt;Figure &lt;/a&gt;9 : Accès aux formulaires et vues
&lt;/p&gt;&lt;p&gt; 
&lt;/p&gt;&lt;p&gt;Maintenant que nos attributs ont été créés, il nous reste à les ajouter sur le formulaire ; ceci se fait via le menu « Formulaires et vues » de l’entité (voir figure 9).
&lt;/p&gt;&lt;p&gt;Dans la partie de droite de la figure 9, on peut apercevoir toutes les vues créées par le système (dont la vue par défaut) ainsi que tous les formulaires existants (par défaut, il n’y a qu’un seul formulaire pour chaque entité).
&lt;/p&gt;&lt;p&gt;Pour modifier le formulaire de l’entité « contact », il suffit de &lt;u&gt;double-cliquer sur la ligne « Formulaire »&lt;/u&gt; dans l’écran de droite pour accéder au formulaire en mode « &lt;i&gt;design&lt;/i&gt; » (comme dans Access).
&lt;/p&gt;&lt;p&gt;Une fois dans le mode « &lt;i&gt;design&lt;/i&gt; » du formulaire, on a la possibilité de créer ou de supprimer des champs via le menu de droite (voir figure 10) :
&lt;/p&gt;&lt;p&gt;&lt;img alt="form design" src="http://furnemont.net/images/furnemont_net/WindowsLiveWriter/Customisation2Ajoutdattributunformulaire_12143/form%20design_49ae98b5-4b1c-4a84-a6a3-5c188f107cb4.jpg" border="0" /&gt; 
&lt;/p&gt;&lt;p&gt;&lt;a&gt;Figure &lt;/a&gt;10 : Formulaire en mode design
&lt;/p&gt;&lt;p&gt;&lt;img alt="liste attributs entité" src="http://furnemont.net/images/furnemont_net/WindowsLiveWriter/Customisation2Ajoutdattributunformulaire_12143/liste%20attributs%20entit%C3%A9_18132c29-8c48-44ec-b24f-ce37525b9ddb.jpg" border="0" /&gt; 
&lt;/p&gt;&lt;p&gt;&lt;a&gt;Figure &lt;/a&gt;11 : Liste des attributs pour l'entité contact
&lt;/p&gt;&lt;p&gt; 
&lt;/p&gt;&lt;p&gt;Pour ajouter un champ existant, il suffit de cliquer sur le lien « Ajouter des champs » dans le menu de droite, pour voir apparaître la liste de tous les attributs du système (dont ceux que nous avons créés, voir figure 11).
&lt;/p&gt;&lt;p&gt;On voit qu’un de nos 2 attributs (« A jour ») est disponible dans la liste de tous les attributs de l’entité ; ainsi, pour l’ajouter au formulaire, il suffit de le sélectionner (le cocher, plusieurs attributs pouvant être cochés), de lui spécifier l’onglet sur lequel il doit apparaître (l’onglet « Général » étant le premier onglet du formulaire, voir figure 10) et la section à laquelle le champ choisi appartiendra (choisir la section « Adresse » pour nos 2 attributs). Une fois les attributs sélectionnés et attribués au bon onglet et à la bonne section, il suffit de cliquer sur le bouton OK pour revenir à l’écran précédent.
&lt;/p&gt;&lt;p&gt;Voici à quoi ressemble notre formulaire suite à l’ajout des 2 attributs « A jour » et « Adresse du compte » et après la suppression de quelques attributs non désirés :
&lt;/p&gt;&lt;p&gt;&lt;img alt="form cleaning" src="http://furnemont.net/images/furnemont_net/WindowsLiveWriter/Customisation2Ajoutdattributunformulaire_12143/form%20cleaning_76a26154-6849-40bf-b74e-8aac742aa006.jpg" border="0" /&gt; 
&lt;/p&gt;&lt;p&gt;&lt;a&gt;Figure &lt;/a&gt;12 : Ajout des 2 attributs au formulaire contact
&lt;/p&gt;&lt;p&gt; 
&lt;/p&gt;&lt;p&gt;L’écran est OK, il suffit de cliquer sur un des boutons d’enregistrement situés dans la barre de menu du haut pour enregistrer les changements (voir figure 10) ; ensuite, à l’écran des vues disponibles, cliquer également sur le bouton d’enregistrement pour fermer la fenêtre de modification de l’entité « contact » et revenir à la liste des entités modifiables (voir figure 4).
&lt;/p&gt;&lt;p&gt;Maintenant que notre formulaire a été modifié, il faut encore « publier » les changements pour que la couche présentation soit synchronisée avec la metabase ; pour ce faire, il suffit de sélectionner l’entité « contact » dans la liste des entités (voir figure 4) et de cliquer sur le bouton « publier » situé dans la barre de menu, juste au-dessus de la liste des entités :
&lt;/p&gt;&lt;p&gt;&lt;img alt="publication" src="http://furnemont.net/images/furnemont_net/WindowsLiveWriter/Customisation2Ajoutdattributunformulaire_12143/publication_3c42a9b7-2a00-4ad1-8033-227cb0b4a01e.jpg" border="0" /&gt; 
&lt;/p&gt;&lt;p&gt;&lt;a&gt;Figure &lt;/a&gt;13 : Bouton de publication
&lt;/p&gt;&lt;p&gt; 
&lt;/p&gt;&lt;p&gt;Lorsque l’utilisateur clique sur ce bouton, le processus de synchronisation se met en marche et le site Web est coupé pendant quelques secondes (équivalent à la commande « &lt;i&gt;iisreset&lt;/i&gt; »).
&lt;/p&gt;&lt;p&gt;&lt;img alt="publication en cours" src="http://furnemont.net/images/furnemont_net/WindowsLiveWriter/Customisation2Ajoutdattributunformulaire_12143/publication%20en%20cours_ffb969be-04cb-4dbe-96f1-bf5f1549bc64.jpg" border="0" /&gt; 
&lt;/p&gt;&lt;p&gt;&lt;a&gt;Figure &lt;/a&gt;14 : Publications des customisations en cours
&lt;/p&gt;&lt;p&gt; 
&lt;/p&gt;&lt;p&gt;Une fois la publication terminée, on peut apercevoir le résultat directement en ouvrant un contact existant, ou en créant un nouveau contact :
&lt;/p&gt;&lt;p&gt;&lt;img alt="contact modifié" src="http://furnemont.net/images/furnemont_net/WindowsLiveWriter/Customisation2Ajoutdattributunformulaire_12143/contact%20modifi%C3%A9_85a8c7dc-4bf1-495a-bd6c-ea80c4c8ba0d.jpg" border="0" /&gt; 
&lt;/p&gt;&lt;p&gt;&lt;a&gt;Figure &lt;/a&gt;15 : Formulaire contact après publication des customisations
&lt;/p&gt;&lt;p&gt; 
&lt;/p&gt;&lt;p&gt;Et voilà !
&lt;/p&gt;&lt;p&gt;Olivier&lt;/p&gt;
&lt;div class="wlWriterSmartContent" id="0767317B-992E-4b12-91E0-4F059A8CECA8:1e7ede3e-9a88-4247-8226-638f5d623787" contenteditable="false" style="padding-right: 0px; display: inline; padding-left: 0px; padding-bottom: 0px; margin: 0px; padding-top: 0px"&gt;Technorati Tags: &lt;a href="http://technorati.com/tags/Microsoft%20CRM" rel="tag"&gt;Microsoft CRM&lt;/a&gt;, &lt;a href="http://technorati.com/tags/Customisation" rel="tag"&gt;Customisation&lt;/a&gt;, &lt;a href="http://technorati.com/tags/Entit%c3%a9%20contact" rel="tag"&gt;Entité contact&lt;/a&gt;&lt;/div&gt;&lt;img src="http://furnemont.net/aggbug/30.aspx" width="1" height="1" /&gt;</description>
            <dc:creator>Olivier Furnémont</dc:creator>
            <guid>http://furnemont.net/archive/2007/05/21/customisation-2--ajout-drsquoattribut-agrave-un-formulaire.aspx</guid>
            <pubDate>Mon, 21 May 2007 11:30:55 GMT</pubDate>
            <wfw:comment>http://furnemont.net/comments/30.aspx</wfw:comment>
            <comments>http://furnemont.net/archive/2007/05/21/customisation-2--ajout-drsquoattribut-agrave-un-formulaire.aspx#feedback</comments>
            <wfw:commentRss>http://furnemont.net/comments/commentRss/30.aspx</wfw:commentRss>
            <trackback:ping>http://furnemont.net/services/trackbacks/30.aspx</trackback:ping>
        </item>
        <item>
            <title>Customisation 1 : Petits rappels</title>
            <category>Customization</category>
            <category>Microsoft CRM</category>
            <link>http://furnemont.net/archive/2007/05/11/customisation-1--petits-rappels.aspx</link>
            <description>&lt;p&gt;Qu’est-ce qu’un attribut ? Un attribut dans Microsoft CRM peut être vu comme un champ (« &lt;i&gt;field&lt;/i&gt; ») dans Microsoft Access ou SQL Server.&lt;/p&gt; &lt;p&gt;&lt;img height="293" alt="image" src="http://furnemont.net/images/furnemont_net/WindowsLiveWriter/Customisation1Petitsrappels_DCB9/image_d36a58b7-48b5-405d-a714-d07c3a84308b.png" width="350" border="0" /&gt; &lt;/p&gt; &lt;p&gt;&lt;a&gt;Figure &lt;/a&gt;1 : Bases de données de Microsoft CRM&lt;/p&gt; &lt;p&gt; &lt;/p&gt; &lt;p&gt;En effet, lors de la création d’un nouvel attribut, Microsoft CRM va &lt;u&gt;réellement créer&lt;/u&gt; un nouveau champ dans la table correspondante à l’entité modifiée (une entité = un objet au sens POO ou une table au sens base de données).&lt;/p&gt; &lt;p&gt;Voyons de plus près comment cela se présente dans SQL Server : lors de l’installation de Microsoft CRM, le programme d’installation vous demande le nom de la société (de l’organisation) ; ce nom est utilisé lors de la création des 2 bases de données utilisées par Microsoft CRM (il est utilisé comme préfixe dans le nom complet de chacune des bases de données) comme on peut le voir sur la figure 1 (dans notre exemple, l’organisation s’appelle TEST).&lt;/p&gt; &lt;p&gt;A quoi correspondent ces 2 bases de données et quels sont leur rôle respectif ?&lt;/p&gt; &lt;p&gt;Il faut savoir que Microsoft CRM 3.0 est une plateforme autant qu’un produit ; ainsi, étant donné que chaque société a son propre mode de fonctionnement, Microsoft a décidé de créer une plateforme pouvant être « customisable » afin de s’adapter aux besoins de chaque société, quel que soit son business.&lt;/p&gt; &lt;p&gt;Dès lors, Microsoft a du, très tôt (dès la version 1.0), réfléchir à l’architecture de cette plateforme afin de garantir une grande souplesse de customisation : c’est le rôle de la « &lt;i&gt;metabase&lt;/i&gt; » (Microsoft CRM est donc, fort logiquement, appelé &lt;u&gt;application de métadonnées&lt;/u&gt; (« &lt;i&gt;metadata&lt;/i&gt; »).&lt;/p&gt; &lt;p&gt;La metabase est une couche logicielle placée entre la couche présentation (les écrans) et la couche de données (les données encodées se trouvant dans la base de données XX_MSCRM).&lt;/p&gt; &lt;p&gt;&lt;img alt="image" src="http://furnemont.net/images/furnemont_net/WindowsLiveWriter/Customisation1Petitsrappels_DCB9/image_b822475f-03a4-4600-b6bf-d5aec4502590.png" /&gt; &lt;/p&gt; &lt;p&gt;&lt;a&gt;Figure &lt;/a&gt;2 : Architecture en couches&lt;/p&gt; &lt;p&gt; &lt;/p&gt; &lt;p&gt;&lt;/p&gt; &lt;p&gt;Prenons un schéma pour mieux comprendre cette architecture en couches :&lt;/p&gt; &lt;p&gt;A quoi sert une couche de métadonnées ? Cette couche sert essentiellement de s’affranchir de toute modification faite à la couche des données. Ainsi, si on ajoute un nouveau champ à une des tables dans la couche des données (représentée par la base de données XX_MSCRM), l’application continuera à fonctionner sans problèmes grâce à la couche des métadonnées (c’est elle qui « guide » l’affichage dans la couche présentation).&lt;/p&gt; &lt;p&gt;Définition : métadonnée = description de la structure des données.&lt;/p&gt; &lt;p&gt;A bientôt pour plus de choses !&lt;/p&gt; &lt;p&gt;Olivier&lt;/p&gt; &lt;div class="wlWriterSmartContent" id="0767317B-992E-4b12-91E0-4F059A8CECA8:db840751-eef5-42c3-8a0f-bdf16ddbbc96" contenteditable="false" style="padding-right: 0px; display: inline; padding-left: 0px; padding-bottom: 0px; margin: 0px; padding-top: 0px"&gt;Technorati Tags: &lt;a href="http://technorati.com/tags/Microsoft%20CRM" rel="tag"&gt;Microsoft CRM&lt;/a&gt;, &lt;a href="http://technorati.com/tags/Customisation" rel="tag"&gt;Customisation&lt;/a&gt;, &lt;a href="http://technorati.com/tags/Architecture%20en%20couches" rel="tag"&gt;Architecture en couches&lt;/a&gt;, &lt;a href="http://technorati.com/tags/Metabase" rel="tag"&gt;Metabase&lt;/a&gt;&lt;/div&gt;&lt;img src="http://furnemont.net/aggbug/29.aspx" width="1" height="1" /&gt;</description>
            <dc:creator>Olivier Furnémont</dc:creator>
            <guid>http://furnemont.net/archive/2007/05/11/customisation-1--petits-rappels.aspx</guid>
            <pubDate>Fri, 11 May 2007 11:30:55 GMT</pubDate>
            <wfw:comment>http://furnemont.net/comments/29.aspx</wfw:comment>
            <comments>http://furnemont.net/archive/2007/05/11/customisation-1--petits-rappels.aspx#feedback</comments>
            <wfw:commentRss>http://furnemont.net/comments/commentRss/29.aspx</wfw:commentRss>
            <trackback:ping>http://furnemont.net/services/trackbacks/29.aspx</trackback:ping>
        </item>
        <item>
            <title>Quelques exemples de customisations</title>
            <category>Customization</category>
            <category>Microsoft CRM</category>
            <link>http://furnemont.net/archive/2007/05/10/quelques-exemples-de-customisations.aspx</link>
            <description>&lt;p&gt;Les différents posts qui vont suivre porteront sur des exemples concrets de customisations, extrêmement faciles à mettre en oeuvre et directement utilisables chez vos clients.&lt;/p&gt; &lt;p&gt;Ce sont des customisations qui ont été développées par moi-même dans le cadre de l'implémentation de plusieurs solutions Microsoft CRM chez quelques-uns de nos clients.&lt;/p&gt; &lt;p&gt;Les outils nécessaires sont :&lt;/p&gt; &lt;ul&gt; &lt;li&gt;Visual Studio 2003 avec Reporting Services 2000 ou 2005&lt;/li&gt; &lt;li&gt;Un environnement de développement et/ou de test complet et configuré avec Windows Server 2003 et Microsoft CRM 3.0 (moi j'utilise une VM installée par mes soins, mais vous pouvez utiliser la VM gratuite de démo de Microsoft [Mai 2006?])&lt;/li&gt; &lt;li&gt;Une machine cliente permettant de tester les customisations à distance (c'est toujours mieux que directement sur le serveur) avec Windows XP et si possible Outlook 2003 ou supérieur (j'utilise également une autre VM faite par mes soins)&lt;/li&gt;&lt;/ul&gt; &lt;p&gt;Un fichier Word complet sera fourni une fois tous les posts publiés pour ceux qui veulent les lire en off-line.&lt;/p&gt; &lt;p&gt;A bientôt,&lt;/p&gt; &lt;p&gt;Olivier&lt;/p&gt; &lt;div class="wlWriterSmartContent" id="0767317B-992E-4b12-91E0-4F059A8CECA8:89f38720-04e8-4dbe-ae86-2448b55d59f6" contenteditable="false" style="padding-right: 0px; display: inline; padding-left: 0px; padding-bottom: 0px; margin: 0px; padding-top: 0px"&gt;Technorati Tags: &lt;a href="http://technorati.com/tags/Microsoft%20CRM" rel="tag"&gt;Microsoft CRM&lt;/a&gt;, &lt;a href="http://technorati.com/tags/Customization" rel="tag"&gt;Customization&lt;/a&gt;&lt;/div&gt;&lt;img src="http://furnemont.net/aggbug/28.aspx" width="1" height="1" /&gt;</description>
            <dc:creator>Olivier Furnémont</dc:creator>
            <guid>http://furnemont.net/archive/2007/05/10/quelques-exemples-de-customisations.aspx</guid>
            <pubDate>Thu, 10 May 2007 11:30:55 GMT</pubDate>
            <wfw:comment>http://furnemont.net/comments/28.aspx</wfw:comment>
            <comments>http://furnemont.net/archive/2007/05/10/quelques-exemples-de-customisations.aspx#feedback</comments>
            <wfw:commentRss>http://furnemont.net/comments/commentRss/28.aspx</wfw:commentRss>
            <trackback:ping>http://furnemont.net/services/trackbacks/28.aspx</trackback:ping>
        </item>
        <item>
            <title>Update Rollup 2 is on the way</title>
            <category>Microsoft CRM</category>
            <link>http://furnemont.net/archive/2007/05/10/update-rollup-2-is-on-the-way.aspx</link>
            <description>&lt;p&gt;As a registered "beta" tester of Microsoft CRM products, I've had the chance to test the pre-release version of the Update Rollup 2 for Microsoft CRM 3.0 (I've had the chance to test the previous UR1, back in 2006).&lt;/p&gt; &lt;p&gt;What can I say about this pre-release version? Not much since it is still in beta and since this version is not intented to be tested by our clients! &lt;img alt="smile_thinking" src="http://spaces.live.com/rte/emoticons/smile_thinking.gif" /&gt;&lt;/p&gt; &lt;p&gt;Anyway, what I can already say after my first tests, is that the performance have &lt;strong&gt;highly&lt;/strong&gt; improved over the previous UR1 (in terms of accessing the pages and so on). And this is a well-known feature of this update rollup pack (aka "service pack" for other Microsoft products, since it includes the KB927854:&lt;/p&gt; &lt;p&gt;&lt;a href="http://support.microsoft.com/kb/927854/en-us" target="_blank"&gt;KB927854&lt;/a&gt;&lt;/p&gt; &lt;p&gt;So stay tuned for more updates on this update!&lt;/p&gt; &lt;p&gt;&lt;em&gt;PS: I'll like to compliment and thank Greg Nichols for providing such a great opportunity in testing all these pre-releases updates! Many thanks to you and the Microsoft CRM Update Team!&lt;/em&gt;&lt;/p&gt; &lt;p&gt;Oliver&lt;/p&gt; &lt;div class="wlWriterSmartContent" id="0767317B-992E-4b12-91E0-4F059A8CECA8:8648ac0b-533f-4337-afae-382602f82779" contenteditable="false" style="padding-right: 0px; display: inline; padding-left: 0px; padding-bottom: 0px; margin: 0px; padding-top: 0px"&gt;Technorati Tags: &lt;a href="http://technorati.com/tags/Microsoft%20CRM" rel="tag"&gt;Microsoft CRM&lt;/a&gt;, &lt;a href="http://technorati.com/tags/Update%20Rollup%202" rel="tag"&gt;Update Rollup 2&lt;/a&gt;, &lt;a href="http://technorati.com/tags/KB927854" rel="tag"&gt;KB927854&lt;/a&gt;&lt;/div&gt;&lt;img src="http://furnemont.net/aggbug/27.aspx" width="1" height="1" /&gt;</description>
            <dc:creator>Olivier Furnémont</dc:creator>
            <guid>http://furnemont.net/archive/2007/05/10/update-rollup-2-is-on-the-way.aspx</guid>
            <pubDate>Thu, 10 May 2007 11:27:55 GMT</pubDate>
            <wfw:comment>http://furnemont.net/comments/27.aspx</wfw:comment>
            <comments>http://furnemont.net/archive/2007/05/10/update-rollup-2-is-on-the-way.aspx#feedback</comments>
            <wfw:commentRss>http://furnemont.net/comments/commentRss/27.aspx</wfw:commentRss>
            <trackback:ping>http://furnemont.net/services/trackbacks/27.aspx</trackback:ping>
        </item>
        <item>
            <title>Authentication over HTTP in ISA Server 2006</title>
            <category>Infrastructure</category>
            <link>http://furnemont.net/archive/2007/04/26/authentication-over-http-in-isa-server-2006.aspx</link>
            <description>&lt;p&gt;As I'm configuring our company's internal ISA Server 2006 (front-end server), I encountered the following error while trying to access our internal web site from a remote connection: &lt;a href="http://support.microsoft.com/kb/924374/en-us" target="_blank"&gt;KB924374&lt;/a&gt;&lt;/p&gt; &lt;p&gt;After some research, I found the following article describing how to enable users' authentication over HTTP in ISA Server 2006: &lt;a href="http://www.stealthpuppy.com/blogs/travelling/archive/2006/09/28/ISA-Server-2004-to-2006-Upgrade.aspx" target="_blank"&gt;Link&lt;/a&gt;&lt;/p&gt; &lt;p&gt;Oliver&lt;/p&gt; &lt;div class="wlWriterSmartContent" id="0767317B-992E-4b12-91E0-4F059A8CECA8:e08070b8-a2d1-4a03-aeef-b31734884757" contenteditable="false" style="padding-right: 0px; display: inline; padding-left: 0px; padding-bottom: 0px; margin: 0px; padding-top: 0px"&gt;Technorati Tags: &lt;a href="http://technorati.com/tags/ISA%20Server%202006" rel="tag"&gt;ISA Server 2006&lt;/a&gt;, &lt;a href="http://technorati.com/tags/HTTP" rel="tag"&gt;HTTP&lt;/a&gt;, &lt;a href="http://technorati.com/tags/Authentication" rel="tag"&gt;Authentication&lt;/a&gt;, &lt;a href="http://technorati.com/tags/KB924374" rel="tag"&gt;KB924374&lt;/a&gt;&lt;/div&gt;&lt;img src="http://furnemont.net/aggbug/25.aspx" width="1" height="1" /&gt;</description>
            <dc:creator>Olivier Furnémont</dc:creator>
            <guid>http://furnemont.net/archive/2007/04/26/authentication-over-http-in-isa-server-2006.aspx</guid>
            <pubDate>Thu, 26 Apr 2007 11:00:59 GMT</pubDate>
            <wfw:comment>http://furnemont.net/comments/25.aspx</wfw:comment>
            <comments>http://furnemont.net/archive/2007/04/26/authentication-over-http-in-isa-server-2006.aspx#feedback</comments>
            <wfw:commentRss>http://furnemont.net/comments/commentRss/25.aspx</wfw:commentRss>
            <trackback:ping>http://furnemont.net/services/trackbacks/25.aspx</trackback:ping>
        </item>
        <item>
            <title>KB: 916566</title>
            <category>Infrastructure</category>
            <category>Microsoft CRM</category>
            <link>http://furnemont.net/archive/2007/02/21/kb-916566.aspx</link>
            <description>&lt;p&gt;Hello everyone, &lt;/p&gt; &lt;p&gt;Today I've received a call from one of our client's main office in Luxemburg, telling me that the 4000 people using Microsoft Outlook were having some 'difficulties' working with it!&lt;/p&gt; &lt;p&gt;It happens that, after some analysis, most of the MSCRM users Outlook clients were making 20000 requests in one second (yes: 20000rq/s &lt;img alt="smile_omg" src="http://spaces.live.com/rte/emoticons/smile_omg.gif" /&gt;) on the Exchange servers (which are in cluster!)... and the Exchange servers could not cope anymore with the additional workload.&lt;/p&gt; &lt;p&gt;Anyway, they called Microsoft and an engineer worked out the solution for them: the KB #916566&lt;/p&gt; &lt;p&gt;&lt;a href="http://support.microsoft.com/kb/916566/en-us" target="_blank"&gt;KB916566&lt;/a&gt;&lt;/p&gt; &lt;p&gt;I recommend using either method 1 since I think that auto-tagging is a useful feature (but method 2 might be helpful as well... anyone having to say something about it?).&lt;/p&gt; &lt;p&gt;A test on the 4 'out of the top 10 most request makers' users with method 3 proved to be efficient (they were not in the 'top 10' anymore &lt;img alt="smile_teeth" src="http://spaces.live.com/rte/emoticons/smile_teeth.gif" /&gt;) so it's up to your infrastructure team to test on a small group of users &lt;u&gt;before&lt;/u&gt; going into production!&lt;/p&gt; &lt;p&gt;Olivier&lt;/p&gt; &lt;div class="wlWriterSmartContent" id="0767317B-992E-4b12-91E0-4F059A8CECA8:13617ca4-2c98-4ab5-8a63-5e0ecca755eb" contenteditable="false" style="padding-right: 0px; display: inline; padding-left: 0px; padding-bottom: 0px; margin: 0px; padding-top: 0px"&gt;Technorati Tags: &lt;a href="http://technorati.com/tags/Microsoft%20CRM" rel="tag"&gt;Microsoft CRM&lt;/a&gt;, &lt;a href="http://technorati.com/tags/Exchange" rel="tag"&gt;Exchange&lt;/a&gt;, &lt;a href="http://technorati.com/tags/KB916566" rel="tag"&gt;KB916566&lt;/a&gt;&lt;/div&gt;&lt;img src="http://furnemont.net/aggbug/24.aspx" width="1" height="1" /&gt;</description>
            <dc:creator>Olivier Furnémont</dc:creator>
            <guid>http://furnemont.net/archive/2007/02/21/kb-916566.aspx</guid>
            <pubDate>Wed, 21 Feb 2007 12:00:59 GMT</pubDate>
            <wfw:comment>http://furnemont.net/comments/24.aspx</wfw:comment>
            <comments>http://furnemont.net/archive/2007/02/21/kb-916566.aspx#feedback</comments>
            <wfw:commentRss>http://furnemont.net/comments/commentRss/24.aspx</wfw:commentRss>
            <trackback:ping>http://furnemont.net/services/trackbacks/24.aspx</trackback:ping>
        </item>
        <item>
            <title>Merry Christmas to you all!</title>
            <category>General</category>
            <link>http://furnemont.net/archive/2006/12/23/merry-christmas-to-you-all.aspx</link>
            <description>&lt;p&gt;Since I still work next week, I won't shout 'a Happy New Year' yet &lt;img alt="smile_party" src="http://spaces.live.com/rte/emoticons/smile_party.gif" /&gt; &lt;/p&gt;&lt;p&gt;Mister O.&lt;/p&gt;&lt;img src="http://furnemont.net/aggbug/23.aspx" width="1" height="1" /&gt;</description>
            <dc:creator>Olivier Furnémont</dc:creator>
            <guid>http://furnemont.net/archive/2006/12/23/merry-christmas-to-you-all.aspx</guid>
            <pubDate>Sat, 23 Dec 2006 17:00:59 GMT</pubDate>
            <wfw:comment>http://furnemont.net/comments/23.aspx</wfw:comment>
            <comments>http://furnemont.net/archive/2006/12/23/merry-christmas-to-you-all.aspx#feedback</comments>
            <wfw:commentRss>http://furnemont.net/comments/commentRss/23.aspx</wfw:commentRss>
            <trackback:ping>http://furnemont.net/services/trackbacks/23.aspx</trackback:ping>
        </item>
        <item>
            <title>Update: V3C Has Been Released!</title>
            <category>Microsoft CRM</category>
            <link>http://furnemont.net/archive/2006/12/23/update-v3c-has-been-released.aspx</link>
            <description>&lt;p&gt;Microsoft has recently announced the availability of the new Microsoft CRM Outlook module: the 3.0C version! &lt;img alt="smile_teeth" src="http://spaces.live.com/rte/emoticons/smile_teeth.gif" /&gt;&lt;/p&gt; &lt;p&gt;More information here: &lt;a href="http://blogs.msdn.com/crm/archive/2006/12/20/v3c-has-been-released.aspx" target="_blank"&gt;Link&lt;/a&gt;&lt;/p&gt; &lt;p&gt;O.&lt;/p&gt; &lt;div class="wlWriterSmartContent" id="0767317B-992E-4b12-91E0-4F059A8CECA8:43d4b1bd-5118-431a-bd0f-37936d155f87" contenteditable="false" style="padding-right: 0px; display: inline; padding-left: 0px; padding-bottom: 0px; margin: 0px; padding-top: 0px"&gt;Technorati Tags: &lt;a href="http://technorati.com/tags/Microsoft%20CRM" rel="tag"&gt;Microsoft CRM&lt;/a&gt;, &lt;a href="http://technorati.com/tags/V3C" rel="tag"&gt;V3C&lt;/a&gt;&lt;/div&gt;&lt;img src="http://furnemont.net/aggbug/22.aspx" width="1" height="1" /&gt;</description>
            <dc:creator>Olivier Furnémont</dc:creator>
            <guid>http://furnemont.net/archive/2006/12/23/update-v3c-has-been-released.aspx</guid>
            <pubDate>Sat, 23 Dec 2006 15:00:59 GMT</pubDate>
            <wfw:comment>http://furnemont.net/comments/22.aspx</wfw:comment>
            <comments>http://furnemont.net/archive/2006/12/23/update-v3c-has-been-released.aspx#feedback</comments>
            <wfw:commentRss>http://furnemont.net/comments/commentRss/22.aspx</wfw:commentRss>
            <trackback:ping>http://furnemont.net/services/trackbacks/22.aspx</trackback:ping>
        </item>
        <item>
            <title>How-to: Play nice with Outlook and Web access</title>
            <link>http://furnemont.net/archive/2006/12/18/how-to-play-nice-with-outlook-and-web-access.aspx</link>
            <description>&lt;p&gt;Hello all,&lt;/p&gt; &lt;p&gt;As I have already said so to one of my client, the fact that the Settings tab &amp;amp; Calendar menu are disappearing from the CRM Web Access when Microsoft Outlook is running (with the CRM module installed) is 'by design'!&lt;/p&gt; &lt;p&gt;Of course, this is not quite obvious for everyone! And I don't see why it has been made like this &lt;img alt="smile_sarcastic" src="http://spaces.live.com/rte/emoticons/smile_sarcastic.gif" /&gt;&lt;/p&gt; &lt;p&gt;Anyway, I've always used the SiteMap 'hack' to display the Settings tab when Outlook is running (remove the &lt;strong&gt;Client=”Web”&lt;/strong&gt; setting for the Settings area in the SiteMap.xml file) but now, I've found an interesting post on the Microsoft Dynamics CRM Team blog that deals with this 'problem'.&lt;/p&gt; &lt;p&gt;You can find it here: &lt;a href="http://blogs.msdn.com/crm/archive/2006/12/11/why-the-crm-web-client-and-outlook-client-don-t-play-nicely-together.aspx" target="_blank"&gt;Link&lt;/a&gt;&lt;/p&gt; &lt;p&gt;Happy 'hacking' &lt;img alt="smile_regular" src="http://spaces.live.com/rte/emoticons/smile_regular.gif" /&gt;&lt;/p&gt; &lt;p&gt;Mister O.&lt;/p&gt; &lt;div class="wlWriterSmartContent" id="0767317B-992E-4b12-91E0-4F059A8CECA8:addfddca-4bc7-40c0-b9be-23d0b3f43e62" contenteditable="false" style="padding-right: 0px; display: inline; padding-left: 0px; padding-bottom: 0px; margin: 0px; padding-top: 0px"&gt;Technorati Tags: &lt;a href="http://technorati.com/tags/Microsoft%20CRM" rel="tag"&gt;Microsoft CRM&lt;/a&gt;, &lt;a href="http://technorati.com/tags/Outlook" rel="tag"&gt;Outlook&lt;/a&gt;, &lt;a href="http://technorati.com/tags/Web%20access" rel="tag"&gt;Web access&lt;/a&gt;&lt;/div&gt;&lt;img src="http://furnemont.net/aggbug/21.aspx" width="1" height="1" /&gt;</description>
            <dc:creator>Olivier Furnémont</dc:creator>
            <guid>http://furnemont.net/archive/2006/12/18/how-to-play-nice-with-outlook-and-web-access.aspx</guid>
            <pubDate>Mon, 18 Dec 2006 15:00:59 GMT</pubDate>
            <wfw:comment>http://furnemont.net/comments/21.aspx</wfw:comment>
            <comments>http://furnemont.net/archive/2006/12/18/how-to-play-nice-with-outlook-and-web-access.aspx#feedback</comments>
            <wfw:commentRss>http://furnemont.net/comments/commentRss/21.aspx</wfw:commentRss>
            <trackback:ping>http://furnemont.net/services/trackbacks/21.aspx</trackback:ping>
        </item>
        <item>
            <title>Update: Update Rollup 1 available!</title>
            <link>http://furnemont.net/archive/2006/12/03/update-update-rollup-1-available.aspx</link>
            <description>&lt;p&gt;Hey buddies!&lt;/p&gt; &lt;p&gt;Friday (the 1st of December) I received an email from Greg Nichols about the final version of Update Rollup 1, which is now available publicly on Microsoft Downloads site!&lt;/p&gt; &lt;p&gt;To download the latest UR1, follow this link:&lt;/p&gt; &lt;p&gt;&lt;a href="http://www.microsoft.com/downloads/details.aspx?FamilyId=08BADB01-4984-458E-96E6-4F08622CFE63&amp;amp;amp;displaylang=en" target="_blank"&gt;Update Rollup 1 for Microsoft CRM 3.0&lt;/a&gt;&lt;/p&gt; &lt;p&gt;And for the KB article, follow this one:&lt;/p&gt; &lt;p&gt;&lt;a href="http://support.microsoft.com/?kbid=922815" target="_blank"&gt;KB922815&lt;/a&gt;&lt;/p&gt; &lt;p&gt;Thanks Greg &amp;amp; the whole development team at Microsoft!&lt;/p&gt; &lt;p&gt;Oliver&lt;/p&gt; &lt;div class="wlWriterSmartContent" id="0767317B-992E-4b12-91E0-4F059A8CECA8:c4ef2d6b-14e2-4685-a085-d4766034f720" contenteditable="false" style="padding-right: 0px; display: inline; padding-left: 0px; padding-bottom: 0px; margin: 0px; padding-top: 0px"&gt;Technorati Tags: &lt;a href="http://technorati.com/tags/Microsoft%20CRM" rel="tag"&gt;Microsoft CRM&lt;/a&gt;, &lt;a href="http://technorati.com/tags/Update%20Rollup%201" rel="tag"&gt;Update Rollup 1&lt;/a&gt;, &lt;a href="http://technorati.com/tags/KB922815" rel="tag"&gt;KB922815&lt;/a&gt;&lt;/div&gt;&lt;img src="http://furnemont.net/aggbug/20.aspx" width="1" height="1" /&gt;</description>
            <dc:creator>Olivier Furnémont</dc:creator>
            <guid>http://furnemont.net/archive/2006/12/03/update-update-rollup-1-available.aspx</guid>
            <pubDate>Sun, 03 Dec 2006 15:00:59 GMT</pubDate>
            <wfw:comment>http://furnemont.net/comments/20.aspx</wfw:comment>
            <comments>http://furnemont.net/archive/2006/12/03/update-update-rollup-1-available.aspx#feedback</comments>
            <wfw:commentRss>http://furnemont.net/comments/commentRss/20.aspx</wfw:commentRss>
            <trackback:ping>http://furnemont.net/services/trackbacks/20.aspx</trackback:ping>
        </item>
        <item>
            <title>Update: Microsoft CRM version 3.0C</title>
            <link>http://furnemont.net/archive/2006/12/01/update-microsoft-crm-version-3.0c.aspx</link>
            <description>&lt;p&gt;As some blogs as already said it, the new version of Microsoft CRM (the 3.0C version, don't know why 'C'?) which is compatible with Microsoft Office 2007 &amp;amp; Microsoft Vista will be released around the end of December (22nd seems to be the 'official' date).&lt;/p&gt; &lt;p&gt;You can read more about it here: &lt;a href="http://blogs.msdn.com/mscrmfreak/archive/2006/11/30/microsoft-dynamics-crm-v3c-to-be-released-on.aspx" target="_blank"&gt;Next to be released&lt;/a&gt;&amp;lt;&lt;/p&gt; &lt;p&gt;Or here (in French): &lt;a href="http://www.clubmscrm.net/Microsoft-annonce-une-nouvelle-version-de-Microsoft-Dynamics-CRM-pour-Microsoft-Office-2007-et-Windows-Vista_a181.html" target="_blank"&gt;Club MSCRM&lt;/a&gt;&lt;/p&gt; &lt;p&gt;Mr. O&lt;/p&gt; &lt;div class="wlWriterSmartContent" id="0767317B-992E-4b12-91E0-4F059A8CECA8:627c4d24-bd75-47ed-9b19-70527a2d8d03" contenteditable="false" style="padding-right: 0px; display: inline; padding-left: 0px; padding-bottom: 0px; margin: 0px; padding-top: 0px"&gt;Technorati Tags: &lt;a href="http://technorati.com/tags/Microsoft%20CRM" rel="tag"&gt;Microsoft CRM&lt;/a&gt;, &lt;a href="http://technorati.com/tags/Office%202007" rel="tag"&gt;Office 2007&lt;/a&gt;, &lt;a href="http://technorati.com/tags/Vista" rel="tag"&gt;Vista&lt;/a&gt;&lt;/div&gt;&lt;img src="http://furnemont.net/aggbug/19.aspx" width="1" height="1" /&gt;</description>
            <dc:creator>Olivier Furnémont</dc:creator>
            <guid>http://furnemont.net/archive/2006/12/01/update-microsoft-crm-version-3.0c.aspx</guid>
            <pubDate>Fri, 01 Dec 2006 15:00:59 GMT</pubDate>
            <wfw:comment>http://furnemont.net/comments/19.aspx</wfw:comment>
            <comments>http://furnemont.net/archive/2006/12/01/update-microsoft-crm-version-3.0c.aspx#feedback</comments>
            <wfw:commentRss>http://furnemont.net/comments/commentRss/19.aspx</wfw:commentRss>
            <trackback:ping>http://furnemont.net/services/trackbacks/19.aspx</trackback:ping>
        </item>
        <item>
            <title>How-to: Swap the 'To' &amp;amp; 'From' fields in phone calls</title>
            <link>http://furnemont.net/archive/2006/11/23/how-to-swap-the-to-amp-from-fields-in-phone-calls.aspx</link>
            <description>&lt;p&gt;Hello everyone,&lt;/p&gt; &lt;p&gt;Today, we'll see how to swap automatically the 'To' &amp;amp; 'From' fields when one is creating a new phone call in Microsoft CRM 3.0.&lt;/p&gt; &lt;p&gt;What is the reason to do this? Well, consider a HR service using Microsoft CRM internally, for phone call reception purposes; suppose 15 people are in the service to receive all the phone calls and to create all these calls in Microsoft CRM as soon as they answer them...&lt;/p&gt; &lt;p&gt;You see now where you can gain some time&amp;amp;nbsp;by automatically switching the phone call direction from 'Outgoing' to 'Incoming', as well as the 'To' &amp;amp; 'From' lookups; here is the default phone call creation form, with the direction set to 'Outgoing' (default):&lt;/p&gt; &lt;p&gt;&lt;img alt="PhoneCall_old" src="http://furnemont.net/images/furnemont_net/WindowsLiveWriter/HowtoSwaptheToFromfieldsinphonecalls_119BB/PhoneCall_old_62702cd3-06af-4840-93f8-f3155979350a.jpg" border="0" /&gt; &lt;/p&gt; &lt;p&gt;Some people might say that you just need to switch the direction attribute through the customization screen, but this &lt;u&gt;will not automatically switch&lt;/u&gt; the 'To' &amp;amp; 'From' fields!&lt;/p&gt; &lt;p&gt;&lt;img alt="phonecall_direction" src="http://furnemont.net/images/furnemont_net/WindowsLiveWriter/HowtoSwaptheToFromfieldsinphonecalls_119BB/phonecall_direction_f0511c44-cca7-43fa-ba76-3bf8a088c063.jpg" border="0" /&gt; &lt;/p&gt; &lt;p&gt;To swith these 2 fields, you have to use the SwapLookups() function used within Microsoft CRM 3.0 (this function is not publicly available or described but you can find it in the following file: &lt;strong&gt;CRM_web_folder\Activities\Activity.js&lt;/strong&gt;):&lt;/p&gt;&lt;pre&gt;&lt;span style="color: #0000ff"&gt;function&lt;/span&gt; SwapLookups( oLookupA, oLookupB )
{
	&lt;span style="color: #0000ff"&gt;var&lt;/span&gt; swapStyle = "&lt;span style="color: #8b0000"&gt;single&lt;/span&gt;
	&lt;span style="color: #0000ff"&gt;if&lt;/span&gt; ( oLookupA.lookupstyle.toLowerCase() == "&lt;span style="color: #8b0000"&gt;multi&lt;/span&gt;" &amp;amp;&amp;amp; oLookupB.lookupstyle.toLowerCase() == "&lt;span style="color: #8b0000"&gt;multi&lt;/span&gt;" )
	{
		swapStyle = "&lt;span style="color: #8b0000"&gt;multi&lt;/span&gt;";
	}
	&lt;span style="color: #0000ff"&gt;var&lt;/span&gt; aoLookupAItems = oLookupA.Items();
	&lt;span style="color: #0000ff"&gt;var&lt;/span&gt; aoLookupBItems = oLookupB.Items();
	&lt;span style="color: #0000ff"&gt;if&lt;/span&gt; ( swapStyle == "&lt;span style="color: #8b0000"&gt;single&lt;/span&gt;" &amp;amp;&amp;amp; ( aoLookupAItems.&lt;span style="color: #0000ff"&gt;length&lt;/span&gt; &amp;gt; 1 || aoLookupBItems.&lt;span style="color: #0000ff"&gt;length&lt;/span&gt; &amp;gt; 1 ) )
	{
		&lt;span style="color: #0000ff"&gt;if&lt;/span&gt;( !openStdDlg( "&lt;span style="color: #8b0000"&gt;/Activities/dlg_confirm_swap.aspx&lt;/span&gt;", &lt;span style="color: #0000ff"&gt;null&lt;/span&gt;, 350, 250) )
		{
			&lt;span style="color: #0000ff"&gt;return&lt;/span&gt; &lt;span style="color: #0000ff"&gt;false&lt;/span&gt;;
		}
		aoLookupAItems = TrimLookup( aoLookupAItems );
		aoLookupBItems = TrimLookup( aoLookupBItems );
	}
	oLookupA.Clear();
	oLookupA.AddItems( aoLookupBItems );
	oLookupB.Clear();
	oLookupB.AddItems( aoLookupAItems );

	&lt;span style="color: #0000ff"&gt;return&lt;/span&gt; &lt;span style="color: #0000ff"&gt;true&lt;/span&gt;;
}&lt;/pre&gt;
&lt;p&gt;Here is the code to copy/paste in your form's &lt;strong&gt;OnLoad()&lt;/strong&gt; event:&lt;/p&gt;&lt;pre&gt;&lt;span style="color: #008000"&gt;/* FormType = 1 is a creation form */&lt;/span&gt;
&lt;span style="color: #0000ff"&gt;if&lt;/span&gt; (crmForm.FormType == 1)
{
	&lt;span style="color: #0000ff"&gt;try&lt;/span&gt;
	{
		&lt;span style="color: #008000"&gt;/* Swap the two fields using Microsoft SwapLookups method */&lt;/span&gt;
		&lt;span style="color: #0000ff"&gt;if&lt;/span&gt; (!SwapLookups( crmForm.all.from, crmForm.all.to ))
		{
			&lt;span style="color: #008000"&gt;/* Unsuccessful swap-- restore the original incoming/outgoing direction. */&lt;/span&gt;
			crmForm.all.directioncode.DataValue = !crmForm.all.directioncode.DataValue;
		}
	}
	&lt;span style="color: #0000ff"&gt;catch&lt;/span&gt;(e)
	{
		&lt;span style="color: #0000ff"&gt;alert&lt;/span&gt; ("&lt;span style="color: #8b0000"&gt;Field\u003a directioncode-Error\u003a &lt;/span&gt;" + e.description);
	}
}&lt;/pre&gt;
&lt;p&gt;And here is the result after saving &amp;amp; publishing the changes:&lt;/p&gt;
&lt;p&gt;&lt;img alt="phoneCall_new" src="http://furnemont.net/images/furnemont_net/WindowsLiveWriter/HowtoSwaptheToFromfieldsinphonecalls_119BB/phoneCall_new_98f36321-38aa-470f-a8d3-62abb15f7be6.jpg" border="0" /&gt; &lt;/p&gt;
&lt;p&gt;Of course, make use of this code at your own risk and I will not be responsible for the damages that can occur on your systems &lt;img alt="smile_regular" src="http://spaces.live.com/rte/emoticons/smile_regular.gif" /&gt;&lt;/p&gt;
&lt;p&gt;Next "how-to" in the pipe is: &lt;strong&gt;How-to clone a phone call&lt;/strong&gt; (scheduled for ?????? &lt;img alt="smile_embaressed" src="http://spaces.live.com/rte/emoticons/smile_embaressed.gif" /&gt;) so stay tuned...&lt;/p&gt;
&lt;p&gt;Olivier&lt;/p&gt;
&lt;div class="wlWriterSmartContent" id="0767317B-992E-4b12-91E0-4F059A8CECA8:7bed3f60-70e5-487d-8cb7-67cde86ad43e" contenteditable="false" style="padding-right: 0px; display: inline; padding-left: 0px; padding-bottom: 0px; margin: 0px; padding-top: 0px"&gt;Technorati Tags: &lt;a href="http://technorati.com/tags/Microsoft%20CRM" rel="tag"&gt;Microsoft CRM&lt;/a&gt;, &lt;a href="http://technorati.com/tags/Customization" rel="tag"&gt;Customization&lt;/a&gt;, &lt;a href="http://technorati.com/tags/Phone%20Call" rel="tag"&gt;Phone Call&lt;/a&gt;&lt;/div&gt;&lt;img src="http://furnemont.net/aggbug/18.aspx" width="1" height="1" /&gt;</description>
            <dc:creator>Olivier Furnémont</dc:creator>
            <guid>http://furnemont.net/archive/2006/11/23/how-to-swap-the-to-amp-from-fields-in-phone-calls.aspx</guid>
            <pubDate>Thu, 23 Nov 2006 15:00:59 GMT</pubDate>
            <wfw:comment>http://furnemont.net/comments/18.aspx</wfw:comment>
            <comments>http://furnemont.net/archive/2006/11/23/how-to-swap-the-to-amp-from-fields-in-phone-calls.aspx#feedback</comments>
            <wfw:commentRss>http://furnemont.net/comments/commentRss/18.aspx</wfw:commentRss>
            <trackback:ping>http://furnemont.net/services/trackbacks/18.aspx</trackback:ping>
        </item>
        <item>
            <title>How-to: Force the email body size</title>
            <link>http://furnemont.net/archive/2006/11/18/how-to-force-the-email-body-size.aspx</link>
            <description>&lt;p&gt;&lt;strong&gt;BE AWARE, THIS CUSTOMIZATION IS NOT SUPPORTED BY MICROSOFT&lt;/strong&gt; &lt;img alt="smile_embaressed" src="http://spaces.live.com/rte/emoticons/smile_embaressed.gif" /&gt;&lt;/p&gt; &lt;p&gt;Sometimes, customers don't want to maximize the email screen to full screen... but the problem of not maximizing the email message is that the email body is very small:&lt;/p&gt; &lt;p&gt;&lt;img height="410" alt="email_old" src="http://furnemont.net/images/furnemont_net/WindowsLiveWriter/HowtoForcetheemailbodysize_11847/email_old_f9f4a633-e950-4b44-8b7b-2ce285178d60.jpg" width="805" border="0" /&gt; &lt;/p&gt; &lt;p&gt;Since then, one of my customer wanted me to resize the email body to a specific size (expressed in pixels) so they do not have to resize the email message to full screen; this was accomplished by modifying the &lt;strong&gt;controls.css&lt;/strong&gt; file located under the &lt;strong&gt;_forms\controls&lt;/strong&gt; directory (put any size in front of the &lt;strong&gt;height&lt;/strong&gt; property, such as 500px [DO NOT FORGET THE 'px' AT THE END!]):&lt;/p&gt; &lt;p&gt;&lt;img alt="ControlCss" src="http://furnemont.net/images/furnemont_net/WindowsLiveWriter/HowtoForcetheemailbodysize_11847/ControlCss_a073e190-0b8d-4f73-a097-d301a833c0ee.jpg" border="0" /&gt; &lt;/p&gt; &lt;p&gt;But there is a drawback to this approach: a new vertical scroll bar appears in the screen, so it is up to your customer to decide whether it prefers a scroll bar to a click on the maximize button!&lt;/p&gt; &lt;p&gt;&lt;img alt="Email_new" src="http://furnemont.net/images/furnemont_net/WindowsLiveWriter/HowtoForcetheemailbodysize_11847/Email_new_70bb850d-7082-4f37-9090-7def7880851d.jpg" border="0" /&gt; &lt;/p&gt; &lt;p&gt;Olivier&lt;/p&gt; &lt;div class="wlWriterSmartContent" id="0767317B-992E-4b12-91E0-4F059A8CECA8:01d3c82b-4dda-4f74-961b-4ec55fd88f94" contenteditable="false" style="padding-right: 0px; display: inline; padding-left: 0px; padding-bottom: 0px; margin: 0px; padding-top: 0px"&gt;Technorati Tags: &lt;a href="http://technorati.com/tags/Microsoft%20CRM" rel="tag"&gt;Microsoft CRM&lt;/a&gt;, &lt;a href="http://technorati.com/tags/Customization" rel="tag"&gt;Customization&lt;/a&gt;, &lt;a href="http://technorati.com/tags/Email" rel="tag"&gt;Email&lt;/a&gt;&lt;/div&gt;&lt;img src="http://furnemont.net/aggbug/17.aspx" width="1" height="1" /&gt;</description>
            <dc:creator>Olivier Furnémont</dc:creator>
            <guid>http://furnemont.net/archive/2006/11/18/how-to-force-the-email-body-size.aspx</guid>
            <pubDate>Sat, 18 Nov 2006 15:00:59 GMT</pubDate>
            <wfw:comment>http://furnemont.net/comments/17.aspx</wfw:comment>
            <comments>http://furnemont.net/archive/2006/11/18/how-to-force-the-email-body-size.aspx#feedback</comments>
            <wfw:commentRss>http://furnemont.net/comments/commentRss/17.aspx</wfw:commentRss>
            <trackback:ping>http://furnemont.net/services/trackbacks/17.aspx</trackback:ping>
        </item>
        <item>
            <title>Deploy: Outlook 2007 client</title>
            <link>http://furnemont.net/archive/2006/11/08/deploy-outlook-2007-client.aspx</link>
            <description>&lt;p&gt;After having read that Microsoft Office 2007 was going RTM, I can't wait to test the new Microsoft CRM Outlook client with its redesigned toolbox (one which integrates truly in the totally cool ribbon &lt;img alt="smile_tongue" src="http://spaces.live.com/rte/emoticons/smile_tongue.gif" /&gt;)&lt;/p&gt; &lt;p&gt;Here is the Frenc