10 December 2014

Quickly view schema name and guid in crm form

Most of the time we need to refer to our CRM entity/ form for schema name during development.
Here is some script which can allow developer to identify via the CRM record form.

Create a file with following code, save as Debug.url extension, so you can use this as shortcut in bookmark to trigger the script.  Just copy to Favorite folder, it is ready to use.



[DEFAULT]
BASEURL=http://mscrm:5555/DEV/main.aspx
[DOC_contentIFrame]
BASEURL=http://mscrm:5555/DEV/_root/homepage.aspx
ORIGURL=/DEV/_root/homepage.aspx
[{000214A0-0000-0000-C000-000000000046}]
Prop3=19,15
[InternetShortcut]
URL=javascript:(function(){javascript:var x = 0; while (frames[x].Xrm.Page.data == null) {x++;} frames[x].Xrm.Page.ui.tabs.forEach(function(b){b.setVisible(true);b.sections.forEach(function(c){c.setVisible(true);})}); frames[x].Xrm.Page.ui.controls.forEach(function(a){a.setVisible(true); if (a.setDisabled != null) {a.setDisabled(false);} var span = document.createElement('span'); span.innerHTML = ''; if (frames[x].document.getElementById(a.getName() + '_c') != null) {frames[x].document.getElementById(a.getName() + '_c').appendChild(span);}}); var span = document.createElement('span'); span.innerHTML = ''; frames[x].document.getElementById("form_title_div").getElementsByTagName("div")[0].appendChild(span); var span = document.createElement('span'); span.innerHTML = ''; frames[x].document.getElementById("form_title_div").getElementsByTagName("div")[0].appendChild(span);})();
IDList=
IconFile=http://mscrm:5555/favicon.ico
IconIndex=1
HotKey=0
[Bookmarklet]
ExtendedURL=javascript:(function(){javascript:var x = 0; while (frames[x].Xrm.Page.data == null) {x++;} frames[x].Xrm.Page.ui.tabs.forEach(function(b){b.setVisible(true);b.sections.forEach(function(c){c.setVisible(true);})}); frames[x].Xrm.Page.ui.controls.forEach(function(a){a.setVisible(true); if (a.setDisabled != null) {a.setDisabled(false);} var span = document.createElement('span'); span.innerHTML = ''; if (frames[x].document.getElementById(a.getName() + '_c') != null) {frames[x].document.getElementById(a.getName() + '_c').appendChild(span);}}); var span = document.createElement('span'); span.innerHTML = ''; frames[x].document.getElementById("form_title_div").getElementsByTagName("div")[0].appendChild(span); var span = document.createElement('span'); span.innerHTML = ''; frames[x].document.getElementById("form_title_div").getElementsByTagName("div")[0].appendChild(span);})();

26 November 2014

CRM 2015 Available for Download

Installer can be downloaded from Microsoft website now, apply below trial keys

Microsoft Dynamics CRM Workgroup Server 2015 (5 CAL limit): 
XY8GN-DF2MC-FV482-YM9YP-HH6H2

Microsoft Dynamics CRM Server 2015 (no CAL limit): 
C6BDP-T6NK9-8TXJP-36WTB-TXW7V

Links :

CRM Server 2015 
CRM 2015 Outlook Client 
CRM2015 Email Router
CRM 2015 List Component for SharePoint 
Report Authoring Extension
Language Package

12 October 2014

CRM Email router failed to load data

Faced one issue during email router configuration, prompt me error when I try to load data:

The decryption key could not be obtained because HTTPS protocol is enforced, but not enabled


The request failed because system is expecting HTTPS connection but SSL is not enable in website.
Solution is to add add a key in registry:
1. Click Start , Run , type regedit
2. Navigate to registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM
3. Click New , and then click DWORD Value .
4. Name subkey to DisableSecureDecryptionKey .
5. Right-click DisableSecureDecryptionKey
6. Type 1 in the Value data field  

06 September 2014

TFS not compatible with SQL collation during setup

Installing TFS in existing database and come across this issue.

The following SQL Server instance is not compatible with Team Foundation Server: TFS\tfs_db. The default collation is set to Latin1_General_CI_AI. Team Foundation Server requires that the default collation be case insensitive and accent sensitive. You must choose a SQL Server instance whose default collation settings match these requirement

Solution is to run the following code in visual studio command prompt, the code can change the sql collation to support collation. Latin1_General_CI_AS

Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=TFS /SQLSYSADMINACCOUNTS=sa /SAPWD=pass@word1 /SQLCOLLATION=Latin1_General_CI_AS

18 August 2014

Issue install .NET3.5 in Windows Server 2012

Using windows server add role feature to install .net3.5 framework in server 2012 has an issue in one of the wizard steps as it prompt me:
Do you need to specify an alternate source path?...missing source file on destination

weird...seems like a defeat in the wizard.

Solution is to use the CD with command prompt to execute it.
Insert the windows server 2012 disk into CDrom, example (d:)

Type following command in command prompt:
dism /online /enable-feature /featurename:NetFX3 /all /Source:d:\sources\sxs /LimitAccess

This solved my problem.

25 March 2014

Update Rollup 2 for CRM 2013 (2919956)

Released on 22/3. This is a cumulative updates.
Support for the following items:
    -Windows 8.1 and Internet Explorer 11 using CRM 2013 web application and CRM for Tablets
    -iOS7 support with Safari on iPad using the web application
    -Support for Safari using web application and CRM for Tablets using the tablet app for iPad Air
    -Windows Server 2012 R2 for CRM Server

Download from here
KB2919956

24 February 2014

Visual Studio Error: The project type is not supported by this installation

Just some quick tips on how I solve the visual studio error "the project type is not supported by this installation"
I got this error when I tried to copy a plugin solution into another VM.

Solution:
Open the csproj file in notepad
Search and replace the ProjectTypeGuids with the line below:

<ProjectTypeGuids>{349c5851-65df-11da-9384-00065b846f21};{fae04ec0-301f-11d3-bf4b-00c04f79efbc}</ProjectTypeGuids>

20 February 2014

SQL Server 2008 Native Client cannot be found

 Hit a weird issue while trying to install SQL server 2008 native client. I'm sure i have the correct installer and is extracted to local drive. Throw me resource unavailable 'sqlncli_x64.msi' not found.

Log file shows : "An installation package for the product Microsoft SQL Server 2008 Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli_x64.msi'."

Endup is the issue with previous installation caused some incomplete setup on the client, go into control panel, find the SQL 2008 native client.
Unintall the existing client, then reinstall. Everything run successfully after that.