Search This Blog

Friday, May 20, 2016

Dynamics CRM 2011 feature

The below items were introduced in CRM 2011 as compared to previous version 4.0

  • Assigning records to teams
  • Adding related items grids to forms(now it is configuration)
  • Lookup fields(easy creation)
  • Dashboards(Wizard based erport creation is available)
  • Share-point 2010 integration
  • Auditing(configure auditing for an entity down to the attribute level)
  • Role based forms
  • Global optionsets are available we can use more than one form

Thursday, May 12, 2016

Customize CRM Charts-Part2


There are  two axes: 
  • horizontal (x) and 
  • vertical (y).
x axis is called the "category axis" (can display numeric as well as non-numeric values)
y axis is called the "series axis".(can display numeric as well as non-numeric values).

Series 

  • Single-series charts: Charts that display data with a series (y) value mapped to a category (x) value.
  • Multi-series charts: Charts that display data with multiple series values mapped to a single category value. Multi-series charts include stacked column charts, which vertically display the contribution of each series to a total across categories, and 100% stacked column charts, which compare the percentage that each series contributes to a total across categories. You can combine different compatible chart types in multi-series charts, for example, column and line, bar and line, and so on.
Category

1) Data about general information regarding the chart: the GUID of the chart, the name of the chart and the entity it is related to
2) The determines which fields will be used in the chart. Use this section pull information from related entities. Use this section change how the information is being aggregated
3) The determines the category and series information.

4) contains data about how each data series is being displayed. Customize the type of chart (see Additional Information for list of chart types) i. Make sure that your chart type is supported by the data ii. Each chart type has specific attributes that should be followed. Customize how the chart is displayed: color, font, size . . .
5) controls how the x-axis and y-axis are displayed a. The syntax for this section will change based on the chart type
6) determines how the relevant information about the chart will be displayed By understanding the key areas of the XML for charts, it allows you to create charts that managers and executives can more easily consume.

Create Email Activity in CRM Plugin


public void Execute(IServiceProvider serviceProvider)
        {
            try
            {
                IPluginExecutionContext context =
                   (IPluginExecutionContext)serviceProvider.GetService(typeof(IPluginExecutionContext));


                // Get a reference to the Organization service.
                IOrganizationServiceFactory factory =                    (IOrganizationServiceFactory)serviceProvider.GetService(typeof(IOrganizationServiceFactory));

                IOrganizationService service = factory.CreateOrganizationService(context.UserId);
             
 if (context.InputParameters.Contains("Target") && context.InputParameters["Target"] is Entity)
                {
                    Entity objDetailDTO = (Entity)context.InputParameters["Target"];

                    ActivityParty fromUser = new ActivityParty
                    {
                        PartyId = new EntityReference(SystemUser.EntityLogicalName, objDetailDTO.Attributes["systemuserid"])
                    };

                    Email email = new Email();
                    email.From = new ActivityParty[] { fromUser };

                    email.To = new ActivityParty[] { /*Whom you want to send email(activityparty)*/ };

                    //email.Bcc = ccUsers.ToArray();

                    email.Subject = "subject";

                    email.Description = "body";

                    //Assign regarding    
                    email.RegardingObjectId = new EntityReference(objDetailDTO.Attributes["contactid"]);
                   
                    Guid emailGUID = service.Create(email);
                }
            }
            catch (FaultException<OrganizationServiceFault> ex)
            {
                if (ex != null)
                    throw new InvalidPluginExecutionException(string.Format("An error occurred : {0}", 
ex.Message), ex);

            }
        }

CRM Entity GUID in SSRS

= Parameters!CRM_URL.Value + "/tools/audit/audit_details.aspx?_CreateFromId=&_CreateFromType=2 &id={" & CType(Fields!contactid.Value, GUID).ToString & "}"

Database cannot be started in this edition of SQL Server because it contains a partition function 'AuditPFN'


Today I faced this problem when trying to restore a Dynamics CRM  database from a SQL Server  Enterprise Edition to a SQL Server  Developer Edition or Standard edition.

It got me crazy as I did not created any partition on the original DB and this problem didn’t allow to me to restore the DB

Cause:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Database 'Org_MSCRM' cannot be started in this edition of SQL Server because it contains a partition function 'AuditPFN'. Only Enterprise edition of SQL Server supports partitioning. Database 'Org_MSCRM' cannot be started because some of the database functionality is not available in the current edition of SQL Server.

Solution:
IF EXISTS (SELECT name FROM sys.partition_schemes WHERE name='AuditPScheme')
BEGIN
SELECT
  CASE WHEN ind.type != 1
   THEN
    'DROP INDEX [dbo].[AuditBase].' + QUOTENAME(ind.name) + ' '
   ELSE ' '
  END +
  'CREATE ' + CASE is_unique WHEN 1 THEN 'UNIQUE ' ELSE '' END  +
  ind.type_desc + ' INDEX ' + QUOTENAME(ind.name  COLLATE SQL_Latin1_General_CP1_CI_AS )  + ' ON [dbo].' +  QUOTENAME(OBJECT_NAME(object_id)) + ' (' +
 
  REVERSE(SUBSTRING(REVERSE((
   SELECT name + CASE WHEN sc.is_descending_key = 1 THEN ' DESC' ELSE ' ASC' END + ','
   FROM
    sys.index_columns sc
    JOIN sys.columns c ON sc.object_id = c.object_id AND sc.column_id = c.column_id
   WHERE
    OBJECT_NAME(sc.object_id) = 'AuditBase' AND
    sc.object_id = ind.object_id AND
    sc.index_id = ind.index_id
   ORDER BY index_column_id ASC
   FOR XML PATH('')
        )), 2, 8000)) + ')' +
  CASE WHEN ind.type = 1
   THEN
    ' WITH (DROP_EXISTING = ON) ON [PRIMARY]'
   ELSE
    ' '
  END  as Script
INTO #indexesScript
FROM sys.indexes ind
JOIN sys.partition_schemes ps on ind.data_space_id=ps.data_space_id
WHERE
  OBJECT_NAME(object_id) = 'AuditBase'
  AND ps.name = 'AuditPScheme'
  AND is_unique_constraint = 0
SELECT * FROM #indexesScript
 
DECLARE @recreateScript nvarchar(max)
DECLARE indScript CURSOR FOR
SELECT Script FROM #indexesScript
OPEN indScript
FETCH NEXT FROM indScript INTO @recreateScript
 
WHILE @@FETCH_STATUS = 0  
BEGIN  
  BEGIN TRANSACTION t1
  Execute sp_executesql @recreateScript
 
  IF @@ERROR > 0
  BEGIN
   ROLLBACK TRAN t1
   declare @message varchar(max)
   set @message = 'Audit history recreate index failed. SQL: ' + @recreateScript
      RAISERROR (@message, 10,1)
  END
  ELSE
  BEGIN
   COMMIT TRAN
  END
  FETCH NEXT FROM indScript INTO @recreateScript  
END  
DROP PARTITION SCHEME AuditPScheme
DROP PARTITION FUNCTION AuditPFN
 
CLOSE indScript  
DEALLOCATE indScript
DROP TABLE #indexesScript
END

Operator '+' is not defined for string SSRS

In the concatenation expression, one of the item value is not string. You have to convert to string and concatenate it.

Object address not found on party or party is marked as non-emailable

Usually this error occur when you want to send mail to Account or Contact or User from workflow or plugin


 Account or Contact

  • Check DonotEmail or DonotBulkemail is must set to "allow"


User 
You have to check the primary email field is filled in the user entity.