Monday 22 April 2013

Thursday 18 April 2013

 A tool For bulk  Importing the N:N related records  (Import/Export N to N for CRM 2011 )

http://crm2011manytomany.codeplex.com/

Exception While associating a record of setting up relationships (N:N) between child and parent records same entity


Code Fix :
associateRequest.Relationship.PrimaryEntityRole = EntityRole.Referenced;


AssociateRequest associateRequest = new AssociateRequest();
            associateRequest.Target = new EntityReference("account", childAccount.AccountId.Value);
            associateRequest.RelatedEntities = new EntityReferenceCollection();
            associateRequest.RelatedEntities.Add(new EntityReference("account", parentAccount.AccountId.Value));
            associateRequest.Relationship = new Relationship("account_parent_account");
associateRequest.Relationship.PrimaryEntityRole = EntityRole.Referenced;
            var associateResponse = xrm.Execute(associateRequest);

Tuesday 16 April 2013

How to update the existing records using Re-import (OOTB Import)Wizard in MSCRM 2011:


If you export a set of Accounts for example and select the option to make available for update, save the file and then open the xml document using Excel, you'll see the format by expanding the first few hidden columns.  You can see that there are some unique values assigned that trigger the Update feature during import.


Step1:
 From Advance find take  the view where the primay key( Account -account name)  and also the required updated column (FAx) should be there.



Step2: Export the view but select the below option (MAKE THIS DATA AVAILABLE FOR RE IMPORT BY INCLUDING REQUIRED COLUMN HEADINGS) :




STEP3: Open the exported file  (open with Xml editor)



Step 4: Update the fax column data in the  above open  excel  with the data you required and save .

Step5: Import the same sheet from importing wizard like normal way.

Add Custom Attributes in the views of Activity Entity:

 Not possible .


The only "true" workaround is to customize each Activity-type record (e.g. Email, Appointment, etc.) individually to include the relationships or attributes you require, and develop custom pages, reports, Workflows, or Plug-in code to support your intended functionality upon each as necessary.
 Ref: