-
Recent Posts
Archives
Categories
Meta
Category Archives: MS Dynamics CRM 2015
Reading Excel and Creating the Records in CRM
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
Generate the Word Document in JavaScript using Word Templates
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
Posted in CRM, Dynamics 365, Java Script, JavaScript, Ms Dynamics CRM 2013, MS Dynamics CRM 2015, MS Dynamics CRM 2016
Tagged CRM, CRM 2016, CRM Solution, Document, Documents, Dynamics CRM, Dynamics CRM 365, Generate, Generate Word Documents, Gereate the Word Templates, JavaScript, MS Dynamics, MS Dynamics 2016, MS Dynamics 365, MS Dynamics CRM 2016, Template, Templates, Word, Word Document, Word Templates
Leave a comment
How to find last login of users to Dynamics 365 On-Premise
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
Posted in CRM, Dynamics 365, Ms Dynamics CRM 2013, MS Dynamics CRM 2015, MS Dynamics CRM 2016
Tagged CRM, CRM 2016, Dynamics 365, Dynamics 365 Update 2, Dynamics CRM, Dynamics CRM 2015, Last Login, Last Login of User, Login, MS Dynamics, MS Dynamics 365, MS Dynamics CRM 2016, on-premise, SQL, SQL Server, User, Users
1 Comment
How to get Last Run of the Reports in Dynamics 365 On-Premise
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
Posted in CRM, Dynamics 365, Ms Dynamics CRM 2013, MS Dynamics CRM 2015, MS Dynamics CRM 2016
Tagged CRM 2016, Dynamics 365, Dynamics CRM, Dynamics CRM 2013, Dynamics CRM 2016, Last Report Run, Last Run, Last run of Reports, Last RUN Report, Last Run SSRS, Last SSRS Run, Last time, MS Dynamics CRM, on-premise, onpremise, Query, report, run, Scripts, SQL, SQL Server, SSRS
Leave a comment
Unable to export the solution after installing Dynamics 365 Update 2 on Dynamics CRM 2016 On-Premise
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
Posted in CRM, Dynamics 365, Ms Dynamics CRM 2013, MS Dynamics CRM 2015, MS Dynamics CRM 2016
Tagged CRM, CRM 2016, CRM 2016 Service Pack 2, CRM 2016 SP 2, CRM 2016 Update 2, CRM Solution, CRM Solution Export, Default Solution, Default Solution failing, Dynamics 365, Dynamics 365 Service Pack 2, Dynamics 365 Solution, Dynamics 365 SP 2, Dynamics 365 Update 2, Dynamics CRM 2016, Dynamics CRM 2016 Update 2, Export, Failing export, Failing Solution Export, MS Dynamics CRM 2016, Solution, Solution Export, Solution Export Failure
Leave a comment
Enable Tracing for Dynamics CRM On-Premise
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
Posted in CRM, Dynamics 365, Ms Dynamics CRM 2013, MS Dynamics CRM 2015, MS Dynamics CRM 2016
Tagged CRM, CRM 2013, CRM 2015, CRM 2016, DWORD, Dynamics 365, Dynamics CRM, Enable, MS Dynamics CRM, REGEDIT, Trace, TraceEnabled, Tracing
2 Comments
Update Current Format for the User
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);
Posted in CRM, Ms Dynamics CRM 2013, MS Dynamics CRM 2015, MS Dynamics CRM 2016
Tagged C#, Code, CRM, CRM 2016, Current Format, Dynamically, Dynamics CRM, Format, Language, Microsoft Dynamics CRM, Microsoft Dynamics CRM 2016, MS CRM, MS Dynamics CRM, MS Dynamics CRM 2016, Plugin, Update User Settings, User Settings, Users, UserSettings
Leave a comment