Note Archives - IT Blog

WordPress paging line is under 'related sites', not right below the article contents. To move it up with two steps: Wrap the line right below the article, in this example is "page view counter", "pvc_stats" class. Prepend paging element ".page-links" to the wrapper. See the code below:

2018-12-19 0 Comments 865 Views 0 Like IT Team Read more

In Dynamics 365, create a new user. The new user get error after login: "You do not have permission to access these records. contact your microsoft dynamics 365 administrator". Steps: Create a new user 1. Go to https://www.office.com 2. admin -> Home -> Add a user 3. click on the newly added user from the list -> Edit group memberships -> asign a group -> Edit user roles -> select Global administrator Assign security roles 4. admin -> Show more -> Admin center -> Dynamics 365 -> select an instance and click open 5. Top menu -> Settings -> Security -> User -> click on a user from the user list, click on MANAGE ROLES from top menu -> select the role name that you want to add. Now try again. Works. Reference video

2018-12-03 0 Comments 921 Views 0 Like IT Team Read more

The steps to use Sample data in Dynamics365: CRM Administrator goes to Settings Under Settings look to the System Menu Select Data Management Select Sample Data Click Install Sample Data When done with testing, repeat steps 1 through 4 Then click Remove Sample Data Verify sample Go to Sales -> Contact

2018-11-23 0 Comments 1123 Views 0 Like IT Team Read more

To start a build from Team Explorer, just follow the steps below. Navigate Team Explorer to Builds tab, and right click on the last line of XAML Build Definitions section. The context menu will popup. click on Queue New Build... In the first section My Builds will show the task, "xxxx just started". Notice the status change on My Builds section.

2018-11-13 0 Comments 866 Views 0 Like IT Team Read more

To convert UTC time into EST time directly, we may just use UTC time offsets, for EST it is -5. --UTC to EST declare @utcDate datetime = '2018-11-07 01:24:18.887'; SELECT GETUTCDATE() UTC, GETDATE() Local, @utcDate UTC_given, DATEADD(HH,-5,@utcDate) AS ESTTime Considering the daylight saving, we need to apply the hour offset. Starting in 2007, the United States and Canada will start Daylight Saving Time (DST) on the second Sunday of March and end on the first Sunday of November. From 1987 to 2006, DST began on the first Sunday in April and ended on the last Sunday of October. The logic is as following. --Get First Possible DST StartDay IF (@Year > 2006) SET @DSTStartDate = CAST(@Year AS CHAR(4)) + '-03-08 02:00:00' ELSE SET @DSTStartDate = CAST(@Year AS CHAR(4)) + '-04-01 02:00:00' --Get DST StartDate WHILE (DATENAME(dw, @DSTStartDate) <> 'sunday') SET @DSTStartDate = DATEADD(DAY, 1,@DSTStartDate) --Get First Possible DST EndDate IF (@Year > 2006) SET @DSTEndDate = CAST(@Year AS CHAR(4)) + '-11-01 02:00:00' --first Sunday in November at 2:00 AM ELSE SET @DSTEndDate = CAST(@Year AS CHAR(4)) + '-10-25 02:00:00' --Get DST EndDate WHILE (DATENAME(dw, @DSTEndDate) <> 'sunday') SET @DSTEndDate = DATEADD(DAY,1,@DSTEndDate) The entire solution in a UDF function. CREATE FUNCTION [dbo].[ufn_UTC_to_EST_DateTime](@prm_UTC_DateTime AS DATETIME ) RETURNS DATETIME AS BEGIN -- From 1987 to 2006, DST began on the first Sunday in April and ended on the last Sunday of October. -- after 2016: Daylight Saving Time (DST) in Canada starts on the 2nd Sunday in March and ends on the 1st Sunday in November. DECLARE @ESTOffset SMALLINT = -5; -- Timezone…

2018-11-07 0 Comments 840 Views 0 Like IT Team Read more

jQuery DataTables renders table into two parts: header, <div class="dataTables_scrollHeadInner"><div class="dataTable"> body, <div class="dataTables_scrollBody"> DataTables measures the current screen size and set the fixed width. In this case when resizing the browser, the table header and body are not resized automatically. The solution is to enforce their width to be set in percentage. The following code is the final. Note: file: \WebSites\WebBusinessSuite\Scripts\Main\BusinessSuit.css

2018-10-24 0 Comments 2890 Views 0 Like IT Team Read more

Taking report from web page function sendReport() { var dataInput = {}; reportBody = $(".dataTables_scroll"); reportBody.prepend('<link rel="stylesheet" href="' + location.protocol + '//' + window.location.host + '/Scripts/Main/BusinessSuite.css" type="text/css" />'); reportBody.prepend('<link rel="stylesheet" href="' + location.protocol + '//' + window.location.host + '/Scripts/Libs/BootStrap/css/bootstrap.css" type="text/css" />'); reportBody.prepend('<link rel="stylesheet" href="' + location.protocol + '//' + window.location.host + '/Scripts/Libs/JQueryConfirm/css/jquery-confirm.css" type="text/css" />'); reportBody.prepend('<link rel="stylesheet" href="' + location.protocol + '//' + window.location.host + '/Scripts/Libs/JQueryDatatables/css/jquery.dataTables.css" type="text/css" />'); reportBody.prepend('<link rel="stylesheet" href="' + location.protocol + '//' + window.location.host + '/Css/Table/tableenhacements.css" type="text/css" />'); reportBody.prepend('<link rel="stylesheet" href="' + location.protocol + '//' + window.location.host + '/Scripts/Libs/JQueryUI/jquery-ui.css" type="text/css" />'); dataInput.ReportName = $("#ddlReports option:selected").attr("data-report-name"); dataInput.ReportPage = reportBody.html().replace(/height: 0px;/g, 'height: 30px;padding:5px 0 !important;') .replace(/dataTables_scrollHeadInner"/g, 'dataTables_scrollHeadInner" style="display:none"') .replace(/<table/g, '<table style="font-size:12px !important;"') .replace(/<th/g, '<th style="align:left;"') .replace(/<div class="dataTables_scrollHeadInner".*?(<\/div>)/gm,''); var ajaxParameters = { methodUrl: "Mail/SendReport", dataInput: dataInput }; new BaseClass().AjaxCall( ajaxParameters, function () { }, function (data) { } ); return false; Stored Proc: ALTER proc [dbo].[usp_BS_SendMail]( @PRM_LAN_ID VARCHAR(100)='', @REPORT_NAME nvarchar(150) =null, @REPORT_PAGE nvarchar(max) =null ) as if coalesce(@REPORT_NAME,'')='' or coalesce(@REPORT_PAGE,'')='' return; declare @typeid int,@subject nvarchar(255); select @typeid=ReportTypeID from [dbo].[tbl_BS_Reports_Configuration] where ReportName = @REPORT_NAME insert dbo.tbl_ReportPage (ReportTypeID, ReportName,ReportPage,CreatedBy) values (@typeid,@REPORT_NAME,@REPORT_PAGE,@PRM_LAN_ID) set @subject = 'Report: ' + @REPORT_NAME; EXEC msdb.dbo.sp_send_dbmail @profile_name = null, --@recipients = '"Vat, Moh" <abc.vat@ball.ca>;"Pill, Balak" <def.pill@ball.ca>', @recipients = 'xxxxx@gmail.com', @body = @REPORT_PAGE, @body_format = 'HTML', @subject = @subject; Calling sp using (var fnReturn = new DataTable()) { fnReturn.RunStoredProcedure(filters.Conn, "[dbo].[usp_BS_SendMail]", new Dictionary<string, object>() { { "@PRM_LAN_ID", filters.Lan_ID?? "" }, { "@REPORT_NAME", filters.ReportName}, { "@REPORT_PAGE", filters.ReportPage} }); return fnReturn; } ========================== report contents: <link href="http://localhost:1282/Scripts/Libs/JQueryUI/jquery-ui.css" rel="stylesheet" type="text/css"> <link href="http://localhost:1282/Css/Table/tableenhacements.css" rel="stylesheet" type="text/css"> <link href="http://localhost:1282/Scripts/Libs/JQueryDatatables/css/jquery.dataTables.css" rel="stylesheet" type="text/css"> <link href="http://localhost:1282/Scripts/Libs/JQueryConfirm/css/jquery-confirm.css" rel="stylesheet" type="text/css"> <link href="http://localhost:1282/Scripts/Libs/BootStrap/css/bootstrap.css"…

2018-06-26 2 Comments 1398 Views 0 Like IT Team Read more

$('#checkbox').val() is always = 'on'. User: $('#checkbox').is(':checked') to get correct value.

2018-06-22 0 Comments 825 Views 0 Like IT Team Read more

data is retrieved from web API in JSON format. Rendered on translation data completed. i18n.load( serviceLocation + 'api/language.php?page='+filename+'&lang='+i18n.locale, i18n.locale ).done( function() { var select = $("#gender"); select.empty().append('<option value="">'+$$("selectgender")+' *</option>'); select.append('<option value="1">'+$$("male")+'</option>'); select.append('<option value="2">'+$$("female")+'</option>'); select.append('<option value="3">'+$$("other")+'</option>'); Set option from data: function fillData(data){ //$('#gender option:contains("'+data.gender+'")').attr('selected','selected'); $('#gender option[value='+data.gender+']').attr('selected','selected'); } By text: $('#gender option:contains("'+data.gender+'")').attr('selected','selected'); By value: $('#gender option[value='+data.gender+']').attr('selected','selected');

2018-06-19 0 Comments 829 Views 0 Like IT Team Read more

Problem: If only a few columns, the space is too big. $tblContainer.html("<table class='dataTable striped border hovered'></table>"); var reportName = JSON.parse(this.data).ReportName; if (reportName.indexOf("Automation")>-1) { table = $tblContainer.DataTable({ "bSort": false, "createdRow": function (row, data, dataIndex) { if (data[0].indexOf("<b>") > -1) { $(row).addClass('header-lightblue'); } row.cells[0].width = '400px'; //first column if (data.length < 5) { for (var i = 1; i < data.length - 1; i++) { row.cells[i].width = '200px'; } } },

2018-06-13 0 Comments 799 Views 0 Like IT Team Read more

Moving elements around with jQuery

New team member have no permission to access - Dynamics 365

Install sample data for Dynamic 365 trial

Start build from Team Explorer

Convert UTC time to EST time considering daylight saving time

Fixing jQuery DataTables header non-responsive issue

Send web report by email from report page

JQuery get checkbox value

JQuery set selected option for supporting multi-language

Changing DataTable cell width