Monday, 29 October 2018

Get individual Default Dimension Value



while select DimensionAttributeValueSet
                join     DimensionAttributeValueSetItem
                where    DimensionAttributeValueSet.RecId == DimensionAttributeValueSetItem.DimensionAttributeValueSet
                join     DimensionAttributeValue
                where    DimensionAttributeValueSetItem.DimensionAttributeValue    == DimensionAttributeValue.RecId
                join     DimensionAttribute
                where    DimensionAttributeValue.DimensionAttribute                == DimensionAttribute.RecId


Dimension Recid = DimensionAttributeValueSet.RecId

dimensionName = DimensionAttribute.Name

Dimension Value == DimensionAttributeValueSetItem.DisplayValue

Thursday, 2 August 2018

Download D365 CRM Developer Extension

https://marketplace.visualstudio.com/items?itemName=JLattimer.DynamicsCRMDeveloperExtensions

Sunday, 13 May 2018

Enable Portal in Dynamics 365 CRM

Go to Admin  --> Setting -- >Service Add-Ins



Click on Dynamics 365 under Service Add-Ins


Then Click on Manage yours Dynamics 365 Settings

It will navigate Dynamics 365 Administrator Center,
Select Portal Add-on which highlight and right hand side click on Manage Button


Configure your Portal
Fill the Below Details and it will take more than 30 mins to get configure


Friday, 20 April 2018

Web Resource for Configuration Page

WebPage (HTML) 

<html><head></head><body onload="load();" style="word-wrap: break-word;">


    <meta http-equiv="X-UA-Compatible" content="IE=EmulateIE10">
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">


    <!--   Task 1730 Commented by Govindu
      <script>
          if (window.dialogArguments != null && window.dialogArguments != 'undefined')
          {
              _Xrm = window.dialogArguments;
              window.ActiveXObject = _Xrm.ActiveXObject;
              Xrm = _Xrm.Xrm;
          }
      </script>
      End-->
    <link href="../ext60/themes/brave_theme/brave_theme_all_rtl.css" rel="stylesheet" type="text/css">
    <link href="CopyAgreementDialog.css" rel="stylesheet" type="text/css">

    <script src="../ext60/ext_all_rtl.js" type="text/javascript"></script>
    <script type="text/javascript" src="../../../WebResources/ClientGlobalContext.js.aspx"></script>
    <script src="../../msdyn_/Utils/sdk.jquery.js" type="text/javascript"></script>
    <script src="../../msdyn_/Utils/jquery1.4.1.min.js" type="text/javascript"></script>
    <script src="../../msdyn_/Utils/json2.js" type="text/javascript"></script>
    <script src="../SDK/SOAP/Sdk_Soap_min.js" type="text/javascript"></script>
    <script src="../Action/FieldServiceSystemAction/Sdk_msdyn_FieldServiceSystemAction_min.js" type="text/javascript"></script>
    <script src="../../msdyn_/fps/Utils/FpsUtils.js" type="text/javascript"></script>
    <script src="../../msdyn_/Utils/FieldOneSkyUtils.js" type="text/javascript"></script>

    <script src="../../msdyn_/Utils/sdk.jquery.js" type="text/javascript"></script>
    <script src="../../msdyn_/Utils/sdk.fetchutil.js" type="text/javascript"></script>
    <script src="../../msdyn_/Utils/sdk.metadata.js" type="text/javascript"></script>
    <script src="../../msdyn_/CrmControls/Lookup/Fetch.js" type="text/javascript"></script>
    <script src="../../msdyn_/CrmControls/Lookup/SDK.MetaData.js" type="text/javascript"></script>
    <script src="../../msdyn_/CrmControls/Lookup/Util.js" type="text/javascript"></script>

    <script src="../../msdyn_/fps/LocalizationLibrary/Localization.Library.js" type="text/javascript"></script>
    <script src="../../msdyn_/LocalizationLibrary/Localization.Library.js" type="text/javascript"></script>
    <script src="../ext60/ext_locale_all.js" type="text/javascript"></script>
    <script src="../../msdyn_/Agreement/CopyAgreementDialog.js" type="text/javascript"></script>


    <script>
        function load() {
            //Task 1730 Added by Govindu
            //Replacing ShowModal dialog with Internal.OpenDialog
            if (window.getDialogArguments() != null && window.getDialogArguments() != 'undefined') {
                _Xrm = window.getDialogArguments();
                if (_Xrm.ActiveXObject)
                    window.ActiveXObject = _Xrm.ActiveXObject;
                Xrm = _Xrm.Xrm;
            }
            //End
            if (_Xrm != null) {
                Agreement.Library.agreementIds = _Xrm.Ids;
                Agreement.Library.OnDialogOpen();
            }
        }
    </script>




</body></html>

Saturday, 24 February 2018

Download Plugin Register tool latest version using windows powershell(Nuget) for CRM 365

https://docs.microsoft.com/pt-pt/dynamics365/customer-engagement/developer/download-tools-nuget

Download tools from NuGet

Applies to Dynamics 365 (online), version 9.x
You can download tools used in development from NuGet using the powershell script found below. These tools include:
ToolNuGet Package
Code generation tool CrmSvcUtil.exeMicrosoft.CrmSdk.CoreTools
Configuration Migration tool DataMigrationUtility.exeMicrosoft.CrmSdk.XrmTooling.ConfigurationMigration.Wpf
Package Deployer PackageDeployer.exeMicrosoft.CrmSdk.XrmTooling.PackageDeployment.WPF
Plug-in Registration Tool PluginRegistration.exeMicrosoft.CrmSdk.XrmTooling.PluginRegistrationTool
SolutionPackager tool SolutionPackager.exeMicrosoft.CrmSdk.CoreTools

Download tools using PowerShell

  1. In your Windows Start menu, type Windows Powershell and open it.
  2. Navigate to the folder you want to install the tools to. For example if you want to install them in a devtools folder on your D drive, type cd D:\devtools.
  3. Copy and paste the following PowerShell script into the PowerShell window and press Enter.
    PowerShell
    $sourceNugetExe = "https://dist.nuget.org/win-x86-commandline/latest/nuget.exe"
    $targetNugetExe = ".\nuget.exe"
    Remove-Item .\Tools -Force -Recurse -ErrorAction Ignore
    Invoke-WebRequest $sourceNugetExe -OutFile $targetNugetExe
    Set-Alias nuget $targetNugetExe -Scope Global -Verbose
    
    ##
    ##Download Plugin Registration Tool
    ##
    ./nuget install Microsoft.CrmSdk.XrmTooling.PluginRegistrationTool -O .\Tools
    md .\Tools\PluginRegistration
    $prtFolder = Get-ChildItem ./Tools | Where-Object {$_.Name -match 'Microsoft.CrmSdk.XrmTooling.PluginRegistrationTool.'}
    move .\Tools\$prtFolder\tools\*.* .\Tools\PluginRegistration
    Remove-Item .\Tools\$prtFolder -Force -Recurse
    
    ##
    ##Download CoreTools
    ##
    ./nuget install  Microsoft.CrmSdk.CoreTools -O .\Tools
    md .\Tools\CoreTools
    $coreToolsFolder = Get-ChildItem ./Tools | Where-Object {$_.Name -match 'Microsoft.CrmSdk.CoreTools.'}
    move .\Tools\$coreToolsFolder\content\bin\coretools\*.* .\Tools\CoreTools
    Remove-Item .\Tools\$coreToolsFolder -Force -Recurse
    
    ##
    ##Download Configuration Migration
    ##
    ./nuget install  Microsoft.CrmSdk.XrmTooling.ConfigurationMigration.Wpf -O .\Tools
    md .\Tools\ConfigurationMigration
    $configMigFolder = Get-ChildItem ./Tools | Where-Object {$_.Name -match 'Microsoft.CrmSdk.XrmTooling.ConfigurationMigration.Wpf.'}
    move .\Tools\$configMigFolder\tools\*.* .\Tools\ConfigurationMigration
    Remove-Item .\Tools\$configMigFolder -Force -Recurse
    
    ##
    ##Download Package Deployer 
    ##
    ./nuget install  Microsoft.CrmSdk.XrmTooling.PackageDeployment.WPF -O .\Tools
    md .\Tools\PackageDeployment
    $pdFolder = Get-ChildItem ./Tools | Where-Object {$_.Name -match 'Microsoft.CrmSdk.XrmTooling.PackageDeployment.Wpf.'}
    move .\Tools\$pdFolder\tools\*.* .\Tools\PackageDeployment
    Remove-Item .\Tools\$pdFolder -Force -Recurse
    
    ##
    ##Remove NuGet.exe
    ##
    Remove-Item nuget.exe    
    
  4. You will find the tools in the following folders:
  • [Your folder]\Tools\ConfigurationMigration
  • [Your folder]\Tools\CoreTools
  • [Your folder]\Tools\PackageDeployment
  • [Your folder]\Tools\PluginRegistration
To get the latest version of these tools, repeat these steps.