Install the following Packages Reference the DLLs Use the following Code: var filePath = @”D:\CRM\records.xlsx”; using (var stream = File.Open(filePath, FileMode.Open, FileAccess.Read)) { // Auto-detect format, supports: using (var reader = ExcelReaderFactory.CreateReader(stream)) { do … Continue reading
Pre-Requisites: Add XRMServiceToolKit Library (Click Here) Add Process Helper Library (Click Here) Follow the Steps below. //Fetch XML for Getting the ID of Document Template var templateName = “Testing Template”; var fetchXml = “<fetch version=’1.0′ output-format=’xml-platform’ mapping=’logical’ distinct=’false’>” + “<entity … Continue reading
SELECT ORG.FriendlyName as ‘Organization Name’, SU.Name as ‘User Name’ ,SUO.LastAccessTime as ‘Last Login’ FROM MSCRM_CONFIG.dbo.SystemUser SU INNER JOIN [MSCRM_CONFIG].[dbo].[SystemUserOrganizations] SUO ON SUO.UserId = SU.Id Inner Join [MSCRM_CONFIG].[dbo].[Organization] ORG on ORG.Id = SUO.OrganizationId INNER JOIN [MSCRM_CONFIG].[dbo].[SystemUserAuthentication] SUA ON SUA.UserId = SUO.UserId … Continue reading
Navigate to the CRM Organization Database – Right Click – Select “New Query” Paste the following Query and replace the “ORG_MSCRM” with your Organization Database and “ReportServer_MSCRM” with your Report Server Database. Execute the Query. with ReportNames as ( select … Continue reading
To investigate this issue enable the tracing on the CRM Server To enable Tracing Click Here After enabling the Tracing. Follow the steps below. When you try to export the Default Solution if following error occurs Once you get the … Continue reading
How to enable the Tracing for Dynamics CRM? Open the CRM Server Open regedit 3. Navigate to HKEY_LOCAL_MACHINE à SOFTWARE àMicrosoftà MSCRM 4. Right Click on MSCRM, click “New” and Select DWORD (32-bit) Value 5. Provide the Following a. Value … Continue reading
Updating the Current Format of the User to English (United States) Entity updateUserSettings = new Entity(“usersettings”); updateUserSettings.Attributes.Add(“systemuserid”, userId); updateUserSettings.Attributes.Add(“localeid”, 1033); orgService.Update(updateUserSettings);
