Free Pluralsight 6 Month Subscription

Follow the below link

http://absolute-sharepoint.com/2015/12/free-pluralsight-6-month-subscription.html

Change date format in SharePoint Online

https://community.office365.com/en-us/f/148/t/282603

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/

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?

• http://www.powerobjects.com/2015/01/09/workaround-show-company-name-lead-views-dynamics-crm/

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 + "

");

                            });
http://stackoverflow.com/questions/24994774/webapi-2-2-does-not-support-substringof-function

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

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

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

'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

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

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

How to exclude a list from search results

https://social.technet.microsoft.com/Forums/sharepoint/en-US/f53ec882-333e-4061-941d-18722952871b/exclude-lists-from-search-results

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

https://support.office.com/en-us/article/Manage-site-collection-storage-limits-77389c2c-8e7e-4b16-ab97-1c7103784b08

AirPrint code in iOS8 with Swift

http://www.ioscreator.com/tutorials/airprint-tutorial-ios8-swift

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

Started work on Apple apps. now a days am getting lot of issues.

http://stackoverflow.com/questions/27868103/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

SharePoint Responsive web design references

http://www.topsharepoint.com/avicia-free-sharepoint-online-theme
http://www.topsharepoint.com/shareboot-responsive-sharepoint-2013-theme
http://www.topsharepoint.com/motus-free-sharepoint-2013-theme
http://www.topsharepoint.com/xpecto-free-sharepoint-online-theme

Microsoft dropped the Public Website feature from SharePoint Online

http://www.zdnet.com/article/microsoft-confirms-it-is-dropping-public-website-feature-from-sharepoint-online/

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.

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

CRM 2015 Online – Folder Level Tracking

Folder level tracking is new feature in CRM 2015.

http://blog.sonomapartners.com/2015/05/crm-online-spring-2015-folder-level-tracking.html
https://www.youtube.com/watch?v=HiNpINvFKq8

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

Message when you try to log on to a Microsoft Dynamics CRM Online organization: "Your organization has moved

Recently our CRM 2015 Online has updated by Microsoft.

Few subscribers couldn't connect after it got updated.
After 24hrs the issue has resolved.
https://support.microsoft.com/en-us/kb/948661
http://www.mynetworks.me/2015/07/28/microsoft-crm-online-updates-cross-reference-dns-issue/

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

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

Sublime Editor

Like the new editor @ http://www.sublimetext.com/
http://www.creativebloq.com/netmag/10-great-text-editors-web-designers-71412411?utm_content=buffer69ede&utm_medium=social&utm_source=twitter.com&utm_campaign=buffer

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

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')))";

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/

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

EIDA Toolkit demo

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

Vertical Promoted Links in SharePoint 2013

Nice Tip of the day!
http://davidlozzi.com/2014/08/15/vertical-promoted-links-in-sharepoint-2013/

Add a SharePoint Designer Workflow Email BCC Recipient

Recently got the requirement to send email notifications to the recipients in BCC.
https://www.premierpointsolutions.com/training/help-and-how-to-articles/add-a-bcc-recipient-to-a-sharepoint-designer-2010-workflow/

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.

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.

Customizing the Content Query Web Part

Got the chance to customize the CQWP in SP2013 Online.

Reference Links:
http://blog.mastykarz.nl/generating-short-description-content-query-web-part/
http://blog.drisgill.com/

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/

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";

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

CRM 2011 Integration with SharePoint

https://crmconsultancy.wordpress.com/2011/10/27/crm-2011-integration-with-sharepoint-custom-document-management/
http://blogs.msdn.com/b/girishr/

Real-world Apps

http://blogs.msdn.com/b/richard_dizeregas_blog/archive/2013/03/04/real-world-apps-for-sharepoint-2013-kudos-part-2.aspx

http://sharepointdragons.com/2013/05/22/working-with-connection-strings-in-auto-hosted-apps/
https://channel9.msdn.com/Events/SharePoint-Conference/2012/SPC029
http://toddbaginski.com/blog/msdn-sample-code-and-sharepoint-apps/
https://code.msdn.microsoft.com/SharePoint-2013-Use-65c59e34

Client-side rendering links

https://code.msdn.microsoft.com/office/Client-side-rendering-JS-2ed3538a
http://www.connectorman.com/jslink-code-kpis-sharepoint-2013-2/
http://www.sharepointnutsandbolts.com/2013/01/using-jslink-to-change-ui-of-sharepoint_20.html

Branding links

https://samlman.wordpress.com/2015/03/01/using-dreamweaver-and-design-manager-with-sharepoint-2013/

https://chrisstahl.wordpress.com/2013/09/29/design-manager-in-sharepoint-part-iii/
http://www.sharethepoint.no/?p=528

Error occurred in deployment step 'Install app for SharePoint': Failed to install app for SharePoint

Have tried to deploy basic sharepoint hosted app on my brand new SP 2013 VM.
Got the below error.

Solution:
Follow the steps from the below URL
http://www.codeproject.com/Articles/515677/MyplusFirstplusSharepoint-HostedplusAppplusinplus

http://www.ashokraja.me/post/Develop-SharePoint-2013-Napa-App-In-Local-Dev-Environment-Configuring-On-Premises-without-DNS.aspx

Configuring an Environment for Apps in SharePoint 2013

Today got the chance to look into the configuration of the apps enviromnet in SP 2013.
Bellow is the reference of the configuration link.
http://community.bamboosolutions.com/blogs/sharepoint-2013/archive/2013/12/11/user-s-guide-to-configuring-an-environment-for-apps-in-sharepoint-2013-part-1-how-to-configure-the-domain-names-in-dns.aspx

KnockOut JS tutorial

Recently got the chance to take the training program from http://code.tutsplus.com/courses/one-two-knockout/ on KNOCKOUT JS
Following are the couple of useful links

http://knockoutjs.com/documentation/introduction.html

http://www.knockmeout.net/2011/04/utility-functions-in-knockoutjs.html

In SharePoint 2013 apps development would like to use knockout js and find the below useful link to integrate knockout in SP2013.

http://www.dotnetcurry.com/showarticle.aspx?ID=1041
http://www.ashokraja.me/post/Introducing-KoSp-Knockout-binding-handlers-for-SharePoint-2013-and-2010-Rest-API-and-SPServices.aspx
Use Knockout.js and the REST service to display list data

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/

https://web.whatsapp.com/

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.

   

Generate Row Serial Numbers in SQL Query

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

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.