Wednesday, November 25, 2015

CRM Useful JScripts

Have started development on CRM 2015 Online.
My reference links are below:
https://lakshmanindian.wordpress.com/2012/05/12/crm-2011-jscripts/

Tuesday, November 3, 2015

Customizing the Dynamics CRM views

Would like to change the leads view with following criteria.
  • ·         Lead should be filter by Country. Country is not rendering in views.
  • ·         Leads should be filter by created by. Not by owner.
  • ·         Leads should be filter by company name.
  • ·         Is it possible to see his colleagues changes/entries in entities?















Finally Publish the customizations. Done.



An unknown function with name 'substringof' was found.

While doing some client script have faced the issue.





























  $.each(searchWords, function (key, word) {
                            if (key) filterWords += "%20and%20";
                            // double up any single quotes
                            word = word.replace(/'/g, "''");
                            // url escape word
                            word = encodeURIComponent(word);
                            filterWords += "contains(ProductName,'" + word + "')";
                        });

                        // create base portion of the URI
                        var queryUri = serviceUri + "Products?" +
                          "$select=ProductID,ProductName&" +
                          "$top=100&" +
                          "$filter=" + filterWords;
                        // configure datajs to allow cross domain callbacks using JSONP
                        OData.defaultHttpClient.enableJsonpCallback = true;
                        // run query
                        OData.read(queryUri, function (queryResponse) {
                            // for each result, add to list
                            $.each(queryResponse.value.results, function (o) {
                                $("#queryResultsList").append("

  • " + this.ProductName + "
  • ");


    Monday, November 2, 2015

    Calculated and Measure columns in PowerBI

    Have been generating couple of reports using the calculated columns like the below.












    https://www.youtube.com/watch?v=62mLfiNcqVM

    Sunday, November 1, 2015

    Power BI updates

    Generating reports using Power BI is part of my daily activities.
    Following link is for the latest updates of Power BI.
    http://blogs.msdn.com/b/powerbi/archive/2015/10/20/custom-visualizations-support-and-22-other-features-in-the-power-bi-desktop-october-update.aspx

    Thursday, October 22, 2015

    Remote desktop connection softwares

    We know the TeamViewer to full fill our requirement. Today i got one more software to do similar activities called Ammyy Admin

    Monday, October 19, 2015

    'advance' is unavailable: call the 'advancedBy(n)' method on the index

    'advance' API has been removed in Swift 2.0



    Below is some more examples







    Solution is in the screenshot and below is the reference
    http://stackoverflow.com/questions/32237243/advancedby-api-in-swift-2-0

    Saturday, October 10, 2015

    Access Is Denied: How to Identify and Fix a Security Role Issue in CRM 2015 Online

    Today got following issue

















    Log error :
    SecLib::AccessCheckEx failed. Returned hr = -2147187962, ObjectID: c27b7472-2210-e511-80fd-c4346bada1fc, OwnerId: 84055570-cf5d-e411-87c7-2c59e5420674,  OwnerIdType: 8 and CallingUser: 3466ec11-9283-e411-9cca-d89d6763df40.

    ObjectTypeCode: 1, objectBusinessUnitId: 8765d948-802f-e411-b567-2c59e5420674, AccessRights: AppendToAccess
    Resolution:
    Give the Bussiness Unit access level at Account entity.
    Resources:
    http://www.powerobjects.com/2015/02/13/access-denied-identify-fix-security-role-issue/
    http://www.consultcrm.co.uk/blog/2011/07/security-roles-microsoft-crm-2011


    Sunday, September 6, 2015

    Delete a list items using JavaScript library code in SharePoint 2013

    Would like to delete 13000+ records from the list in SPO.
    SCRIPT  BEGIN
    var itemId;
    var oListItem;
     $(document).ready(function() {
    SP.SOD.executeFunc('sp.js', 'SP.ClientContext', sharePointReady);

        });

    function sharePointReady(){
        var clientContext = new SP.ClientContext("XXX");
        var oList = clientContext.get_web().get_lists().getByTitle('Workflow History');
    for LOOP
    {
        this.oListItem = oList.getItemById(itemId);
        oListItem.deleteObject();

        clientContext.executeQueryAsync(
            Function.createDelegate(this, this.onQuerySucceeded),
            Function.createDelegate(this, this.onQueryFailed)
        );
    }
    }
    SCRIPT END
    https://msdn.microsoft.com/en-us/library/office/jj163201.aspx#BasicOps_SPListItemCRUD

    Monday, August 31, 2015

    Site Collection limit in SharePoint Online

    By default 4GB is the quota for each Site Collection. Updated the settings at Admin Center using the following url



    Wednesday, August 26, 2015

    Swift Bound value in a conditional binding must be of Optional type

    clang compiler error migrating to Xcode 6

    While compiling the new XCODE project have been getting  the below error
    Command /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/clang failed with exit code 11

    resolved using the below URLs
    http://www.raywenderlich.com/forums/viewtopic.php?f=2&t=19346
    http://stackoverflow.com/questions/18933321/deleting-contents-from-xcode-derived-data-folder

    Tuesday, August 4, 2015

    SharePoint 2013 has Out-of-box "Word to PDF Conversion". With "Print to PDF"

    SharePoint 2013 has another awesome feature that lets Out-of-box "Word to PDF Conversion". With "Print to PDF"
    http://www.learningsharepoint.com/2012/10/15/word-to-pdf-conversion-in-sharepoint-2013-via-print-to-pdf/
    It doesn't work if you apply IRM feature on the document library.

    Monday, August 3, 2015

    Item Level permissions using SPD 2013

    Some features are deprecated in SharePoint Designer 2013 or have been removed.
    For item level permission only option is to use SPD 2010 template and follow the below url.

    http://www.sharepointbriefing.com/spcode/article.php/3911751/Implementing-ItemLevel-Security-in-SharePoint-2010-and-2007.htm
    https://msdn.microsoft.com/en-us/library/office/jj728659.aspx

    Tuesday, July 28, 2015

    Scribe Insight training

    Today have attend the Scribe introduction training. We have subscribed for SCRIBE Workbench training schedule.
    Scribe Insight is a data integrator between ERP and CRM
    Scribe components
    Workbench = development
    Console=administration
    Integration service=mapping b/w the entities in CRM n ERP
    http://www.scribesoft.com/images/pdf/ScribeInsightTechnicalOverview.pdf
    http://www.scribesoft.com/Scribe-Insight-Training

    Sunday, July 26, 2015

    Tuesday, July 21, 2015

    CRM 2015 todays learning

    CRM 2015
    Customer relationship management.
    Customer is the CenterPoint/focus point in this product.
    This is sales forecasting tool.
    Customer is an account.
    Manage accounts, contacts, leads and opportunities etc
    Learned the following areas
    1.       Business units
    2.       Security roles
    3.       Add users

          Addd Office 365 license
    Configure security role
    Set manager

    4.       Customizations without code
    ·         Change page layout
    ·         Change data labels
    ·         Change field types
    ·         Add new fields

    Monday, July 20, 2015

    Introduction to Microsoft Dynamics CRM 2015

    have entered on CRM surface.
    In our company we are using CRM 2015 online along with SharePoint 2013 online. have been handling both.
    Finished the introduction course @ https://channel9.msdn.com/Series/Introduction-to-Microsoft-Dynamics-CRM-2013

    Sunday, June 28, 2015

    Create List View by filtering Month in SharePoint

    Create a calculated filed with
    =YEAR(Created)&"-"&CHOOSE(MONTH(Created),"01. January","02. February","03. March","04. April","05. May","06. June","07. July","08. August","09. September","10. October","11. November","12. December")

    http://guru-web.blogspot.ae/2006/02/some-of-my-favourite-date-wss-list.html

    Monday, June 15, 2015

    OData query operations in SharePoint 2013 Online REST requests

    Scenario: Get the employee(logged user) leave balance
    var userId = _spPageContextInfo.userId;
      //Retrive the leave balance of the current user--Start
      $.ajax({
       
            url:_spPageContextInfo.webAbsoluteUrl + "/_api/lists/getbytitle('Leave Balance')/items?$select=Balance&$filter=(EmployeeId eq '" + userId + "') ",
            method: "GET",
            headers: { "Accept": "application/json; odata=verbose" },
            success: function (data) {
    //alert(data.d.results[0].Balance);
    if(data.d.results.length>0)
    $( "input[id*='Balance']" ).val( data.d.results[0].Balance);
     else
     $("
    There is issue to retrieve the leave balance. Please contact HR!
    ").dialog();
            },
            error: function () {
                $("
    There is issue to retrieve the leave balance. Please contact HR!
    ").dialog();
            }
        });
      //Retrive the leave balance of the current user--End
    Ex1:
    var URL1=_spPageContextInfo.webAbsoluteUrl + "/_api/lists/getbytitle('LeaveRequests')/items?$select=Title&$filter=(Title eq '"+user.full_name+"' and ((Approval_x0020_Status ne 'Cancel') and  (Approval_x0020_Status ne 'Approved') and  (Approval_x0020_Status ne 'Rejected')))";


    Thursday, June 11, 2015

    SPEasy Form for SharePoint List customization.

    Customizing list form is part of daily job. Got a new tool over internet to customize the form in a simple way.
    Have a look @ http://speasyforms.com/


    Sunday, May 17, 2015

    How to check logs using Correlation ID in SharePoint 2013 Online environment

    Recently for one of my application, got some issue and we have Correlation ID. We contact the MS support team for the reason.
    Most of the issue might solve by viewing the logs.But in SP Online we can't find the root cause by our self for the problem.

    Got the shocking info from them.
    http://community.office365.com/en-us/f/148/t/155804.aspx

    Wednesday, May 13, 2015

    EIDA Toolkit demo

    Got the chance to read the UAE Emirates ID data using .NET Application.

    Tuesday, April 21, 2015

    How to Validate Date in a SharePoint 2013 List

    Got the chance to work on validation on list and list forms customization on SharePoint 2013 online.



    Wednesday, April 8, 2015

    Hide or show list form fields in SharePoint using jQuery

    David Lozzi has written a jquery library which is useful our daily development activites.
    http://davidlozzi.com/2014/01/14/sharepoint-2013-script-hide-or-disable-your-fields
    ExecuteOrDelayUntilScriptLoaded(function(){
      Lozzi.Fields.disableWithAllowance("Employee Name",["LeaveEntryAuthorization"]);

      },"sp.js");
    sp.js should load before execute the code.

    Monday, March 30, 2015

    Thursday, March 26, 2015

    Power Object Add-ons

    Recently got the chance to work on CRM add ons.
    Power Object has been offering great add-ons for MS CRM 2013 Online.





    http://www.powerobjects.com/powerpacks/powerwebform/
    http://www.powerobjects.com/powerpacks/powermailchimp/

    Tuesday, March 24, 2015

    How to get More than 100 items from SharePoint list using Rest API ?

    var url=_spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('ISOHSE')/items?$select=Title,Description$orderby=ISOOrder&$top=500";

    Monday, March 16, 2015

    NuGet Project Manager error

    Today have installed VS 2013 and tried to create a SharePoint app project. Got the below error.

















    Solution:
    https://docs.nuget.org/consume/installing-nuget

    Sunday, February 8, 2015

    Using HandleBars.js in SharePoint

    Recently got the chance to work on client side template.
    The below images,region,terminal ,desc and url are rendering by Handlebars















       if (result == true) {
                $.ajax({
                    type: "POST",
                    async: false,
                    contentType: "application/json; charset=utf-8",
                    url: L_Menu_BaseUrl + "/_layouts/DPW.GSE.Assessment/Service/AssessmentService.aspx/LoadImageReferences",
                    dataType: "json",
                    data: JSON.stringify({ question: question, category: category }),

                    success: function (data) {
                        data = eval(data.d);
                       // alert(data);
                        if (data.length > 0) {
                            ImageData = data;
                            if (ImageData != null && ImageData != "") {
                                var ResultAssesementImageData = new Object;
                                ResultAssesementImageData.ImageData = ImageData;
                                var source = $("#AssesementReferenceImageData-template").html();
                                var template = Handlebars.compile(source);
                                var ResultHtml = template(ResultAssesementImageData);
                              //  alert(ResultHtml);
                                $("#ppu342").html(ResultHtml);

                            }
                        }
                    }
                });
















    Handlebars.registerHelper("FILEURL", function (context, options) {

            if (context) {
                var queryString = window.location.href.split("/sites/")[0];
                if (context.indexOf('.jpg') > 1 || context.indexOf('.png') > 1 || context.indexOf('.JPG') > 1 || context.indexOf('.PNG') > 1) {

                    return queryString + "/" + context;
                }
                else {        
                    return queryString + "/" + "//_LAYOUTS//1033//IMAGES//cilayout_picker.gif";
                }
            }
        });
    https://rmanimaran.wordpress.com/2014/12/12/sharepoint-2013-using-handlebars-js-in-sharepoint-part-3/

    Thursday, January 22, 2015

    Wednesday, January 14, 2015

    Browse svc file over https

    For developing mobile app for one of the existing SharePoint application.
    We developed WCF services to consume the application features.
    In IIS we have created applicatoin for the service with should access over HTTPS.














    The url is https://apps.xxx.com/xxx.svc?wsdl








    In web.config level had the below change.

       

    Monday, January 12, 2015

    Generate Row Serial Numbers in SQL Query

    SELECT row_number() over (order by AAL.Record_ID) as "No"

    Monday, January 5, 2015

    Backup/Restore of SharePoint 2010 site Collection using Power Shell

    The below is the good link to perform the back up(Backup-SPSite) and restore(Restore-SPSite) the site collection using POWER SHELL

    http://www.c-sharpcorner.com/uploadfile/Roji.Joy/backuprestore-of-sharepoint-2010-site-collection-using-power-shell/

    How To Increase Space on Drive C of a Virtual Machine Running Windows Server 2008R2

    Requrement: Would like to extend my VM size to 10GB
    Shutdown the VM.
    Go to the VM Player settings->HD Settings-> Utilitites--> Expand





















    Then go to the VM My computer-> Manage-->Compute Mgt
    do the following.