SharePoint Red Neck: 2016

Wednesday, August 17, 2016

The first Kerberos guide for SharePoint 2013 technicians

https://blog.blksthl.com/2012/09/26/the-first-kerberos-guide-for-sharepoint-2013-technicians/

Monday, June 27, 2016

Convert Existing JavaScript Apps to SharePoint Framework

https://channel9.msdn.com/blogs/OfficeDevPnP/PnP-Web-Cast-Converting-existing-JS-apps-to-SharePoint-Framework

Wednesday, April 27, 2016

Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery

https://msdn.microsoft.com/library/hh781257.aspx

Note: The page has a link to download a Word doc Microsoft SQL Server AlwaysOn Solutions Guide
for High Availability and Disaster Recovery

Create a high availability architecture and strategy for SharePoint 2013

https://technet.microsoft.com/en-us/library/cc748824.aspx

Thursday, April 21, 2016

CamlJs: SharePoint JavaScript Caml Builder

https://camljs.codeplex.com/

CAML Schemas

https://msdn.microsoft.com/en-us/library/office/ms462365.aspx

Working with lists and list items with REST

https://msdn.microsoft.com/en-us/library/office/dn292552.aspx

The JavaScript reference

https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference

CAML query limitation of values in IN operator

http://sharepoint.stackexchange.com/questions/80210/caml-query-limitation-of-values-in-in-operator

Looks like limit is 500 values

List Joins and Projections

https://msdn.microsoft.com/en-us/library/office/ee539975(v=office.14).aspx

CAML – Query Lookup Field by ID; not by Value

https://abstractspaces.wordpress.com/2008/05/05/caml-query-lookup-field-by-id-not-by-value/

Big Bet #2 – SharePoint 2013 Apps

http://www.threewill.com/big-bet-2-sharepoint-2013-apps/

Using the $expand OData Query Option in SharePoint 2013

http://www.threewill.com/using-the-expand-odata-query-option-in-sharepoint-2013/

SharePoint View Filter order of precedence

http://wss-essentials.blogspot.com/2009/12/sharepoint-view-filter-order-of.html

Wednesday, April 20, 2016

Error - Input cannot be null for this coercion

http://social.technet.microsoft.com/wiki/contents/articles/31284.sharepoint-2013-error-input-cannot-be-null-for-this-coercion.aspx

Tuesday, April 19, 2016

Mann - SharePoint / JavaScript Resources

http://blog.mannsoftware.com/?page_id=328

CAML List Joins and Projections

https://msdn.microsoft.com/en-us/library/office/ee539975(v=office.14).aspx

CAML View Schema

https://msdn.microsoft.com/en-us/library/office/ms439798.aspx

CAML Query Schema

https://msdn.microsoft.com/en-us/library/office/ms467521.aspx

SharePoint 2010 CAML List Joins

https://blogs.msdn.microsoft.com/kaevans/2012/01/20/sharepoint-2010-caml-list-joins/

SharePoint 2010 Join 2 Lists by using CAML

http://www.ilikesharepoint.de/2012/12/sharepoint-2010-join-2-lists-by-using-caml/

Friday, April 15, 2016

Show/Hide Multiple Web Parts

https://wyly.wordpress.com/2009/05/22/showhide-multiple-web-parts/

Thursday, April 14, 2016

Adding a Tabbed View to A Web Part Page Using jQueryUI

http://sympmarc.com/2011/11/09/adding-a-tabbed-view-to-a-web-part-page-using-jqueryui/

Wednesday, April 13, 2016

Customize a list view in SharePoint Add-ins using client-side rendering

https://msdn.microsoft.com/en-us/library/jj220045.aspx

Hiding Empty SharePoint Web Parts Using JavaScript/jQuery on a Dashboard Page

http://itgroove.net/mmman/2014/06/22/hiding-empty-sharepoint-web-parts-using-javascriptjquery-on-a-dashboard-page/

How to: Customize a field type using client-side rendering

https://msdn.microsoft.com/en-us/library/jj220061.aspx

Custom Field Types in SharePoint 2013

http://blog.aptillon.com/2012/10/12/custom-field-types-in-sharepoint-2013-apps/

Tuesday, April 12, 2016

Get or Set value for SharePoint field in NewForm, EditForm and DispForm (Get only in DispForm)

http://spjsblog.com/2010/05/28/get-or-set-value-for-sharepoint-field-in-newform-editform-and-dispform-get-only-in-dispform/

A Dummies Guide to SharePoint and jQuery

http://geekswithblogs.net/SoYouKnow/archive/2011/07/28/a-dummies-guide-to-sharepoint-and-jqueryndashgetting-started.aspx

http://geekswithblogs.net/SoYouKnow/archive/2011/08/20/a-dummies-guide-to-sharepoint-and-jqueryndashgetting-amp-setting-sharepoint.aspx

http://geekswithblogs.net/SoYouKnow/archive/2011/09/01/a-dummiesrsquo-guide-to-sharepoint-and-jqueryndasha-real-world-example.aspx

Saturday, April 9, 2016

JSLink Client Side Rendering (PNP)

https://dev.office.com/patterns-and-practices-detail/5825

Friday, April 8, 2016

JSLink and Display Templates Part 1 of 7 – Overview, URL Tokens and Applying JSLink to objects

http://www.martinhatch.com/2013/08/jslink-and-display-templates-part-1.html

JS Link for SharePoint 2013 Web Parts–A Quick Functional Primer

http://www.idubbs.com/blog/2012/js-link-for-sharepoint-2013-web-partsa-quick-functional-primer/

NewForm and EditForm simple Field Rendering with JSLink in SharePoint 2013

http://www.sharepointbreak.com/2015/04/13/newform-and-editform-simple-custom-field-rendering-with-jslink-in-sharepoint-2013/

Customize Fields in NewForm.aspx (Hide,Disable,Pre-Populate) with JS Link in SharePoint 2013

http://www.learningsharepoint.com/2013/06/24/customize-fields-in-newform-aspx-hidedisablepre-populate-with-js-link-in-sharepoint-2013/

Customize List Form Fields in Display Form (DispForm.aspx) using JS Link in SharePoint 2013

http://www.learningsharepoint.com/2013/04/01/customize-list-form-fields-in-display-form-dispform-aspx-using-js-link-in-sharepoint-2013-2/

Client-side rendering (JS Link) code samples

https://code.msdn.microsoft.com/office/Client-side-rendering-JS-2ed3538a

Introduction to Client-Side Rendering

http://www.kaptyn.com/SharePoint/client-side-rendering-2013/

Custom Field Rendering with JS Link

http://www.lestersconyers.com/custom-field-rendering-with-jslink/

Customising the NewForm with JSLink

http://www.kaptyn.com/sharepoint/customising-new-form/

Facebook Wall WebPart

https://code.msdn.microsoft.com/Office-365-Facebook-Wall-edc86722

https://code.msdn.microsoft.com/Office-365-SharePoint-2013-b06576fd

SharePoint 2013 JS Link Tutorial

http://www.learningsharepoint.com/2013/04/13/sharepoint-2013-js-link-tutorial/

Customize Fields in NewForm.aspx with JS Link

http://www.learningsharepoint.com/2013/06/24/customize-fields-in-newform-aspx-hidedisablepre-populate-with-js-link-in-sharepoint-2013/

Validation on SharePoint Forms - PreSaveAction()

http://sympmarc.com/2009/05/28/validation-on-sharepoint-forms-part-four/

Validation on SharePoint Forms - Dates

http://sympmarc.com/2009/05/13/validation-on-sharepoint-forms-part-two/

Using JavaScript to Manipulate a List Form Field

https://blogs.msdn.microsoft.com/sharepointdesigner/2007/06/13/using-javascript-to-manipulate-a-list-form-field/

SharePoint Designer Team Blog

https://blogs.msdn.microsoft.com/sharepointdesigner/

Validation on SharePoint Forms

http://sympmarc.com/2009/05/13/javascript-validation-on-editform-aspx-part-one/

Adding Validation to a Custom NewForm.aspx in SharePoint & Redirect

http://meherkanthch.blogspot.com/2014/08/adding-validation-to-custom-new-form-in.html

Thursday, April 7, 2016

Referencing SharePoint list columns with spaces in names

http://sharepoint.stackexchange.com/questions/16087/referencing-sharepoint-list-columns-with-spaces-in-names

Using JSLink to Change UI of List View

http://www.sharepointnutsandbolts.com/2013/01/using-jslink-to-change-ui-of-sharepoint_20.html

My sample code:

(function () {
    var overrideContext = {};
    overrideContext.Templates = {};
    overrideContext.Templates.Item = overrideTemplate;
    overrideContext.Templates.Header = overrideHeader;
    overrideContext.Templates.Footer = overrideFooter;
    SPClientTemplates.TemplateManager.RegisterTemplateOverrides(overrideContext);
})();
function overrideTemplate(ctx) {
    return "<div style='font-size:18px;border:solid 1px Silver;margin-bottom:6px;padding:4px;width:200px;'>"
        + ctx.CurrentItem.Project_x0020_Name
        + "</div>";
}
function overrideHeader() {
    return "<h2>Projects</h2>";
}
function overrideFooter() {
    return "<h3></h3>";
}

Customize a list view in SharePoint Add-ins using client-side rendering

https://msdn.microsoft.com/en-us/library/office/jj220045.aspx

Set up a development environment for SharePoint Add-ins on Office 365

https://msdn.microsoft.com/en-us/library/office/fp179924

Calculated Column Formulas

https://msdn.microsoft.com/en-us/library/office/bb862071(v=office.14).aspx

Script Editor Web Part - JavaScript example of button to launch modal dialog

<div>Engagements</div><br/>
<input onclick="javascript:SP.UI.ModalDialog.showModalDialog({ url: '/Lists/ListName/NewForm.aspx', title: 'New List Name'}); return false;" id=newListNameBtn type="button" value="New List Name"></input>

Wednesday, April 6, 2016

How to Open a List Form in a Modal Dialog Box

https://blogs.msdn.microsoft.com/sharepointdev/2011/06/23/how-to-open-a-list-form-in-a-modal-dialog-box/

Content Editor Web Part

Content-Editor-Web-Part-C1350FF6-934C-4C2E-8E53-1EC3B548A0DC

Tuesday, April 5, 2016

List View Web Part

https://support.office.com/en-us/article/List-View-Web-Part-ced04ead-c6b5-4c43-a3f0-70c5408ef5a6

jQuery and SharePoint

https://jquerysharepoint.wordpress.com/
https://jquerysharepoint.wordpress.com/getting-started/jquery-ui/

Using the JavaScript Object Model in a Content Editor Web Part

https://blogs.msdn.microsoft.com/sharepointdev/2011/04/14/using-the-javascript-object-model-in-a-content-editor-web-part-kumar-abhishek-verma/

Using the SharePoint REST Service with Windows PowerShell - See more at: https://www.itunity.com/article/sharepoint-rest-service-windows-powershell-1381#sthash.yRkSAAow.dpuf

https://www.itunity.com/article/sharepoint-rest-service-windows-powershell-1381

Wednesday, March 30, 2016

WCF Impersonation from SP 2013 Claims

From my colleague Steve Stefanovich:

It looks like the issue is that the WCF services expect a Windows Identity but all SharePoint has is a Claims Identity so when it attempts to impersonate while calling WCF, it passes the default Windows Identity which is IUsr. The solution is not pretty but you can request a Windows Identity and then impersonate it while calling the service like this:

System.Security.Principal.WindowsIdentity ctx = null;

Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(delegate()

{

ctx = Microsoft.SharePoint.SPSecurityContext.GetWindowsIdentity();

});

using (ctx.Impersonate())

{

//Call WCF Service here

}

I’m going to try and clean this up some but at least this gives you the general idea. You do need to have the Claims to Windows Token Service setup properly for this to work.

Final follow-up, I promise. It looks like you can fix this using am End Point Behavior and Message Inspector which means less code to touch. Here’s the code for anyone interested. Just apply it to your endpoints either in the config file or in code like this: client.Endpoint.EndpointBehaviors.Add(new ClaimsContextIdentityBehavior());

I’m sure there are some fringe combinations of impersonation options I haven’t hit but it seems to solve the immediate issue we had of not being able to impersonate the logged in user in a call to the WCF service from a SP 2013 claims based web app. Also need to add error handling around the call to the C2WTS.

public class ClaimsContextIdentityBehavior : IClientMessageInspector, IEndpointBehavior

{

public void AfterReceiveReply(ref System.ServiceModel.Channels.Message reply, object correlationState)

{

WindowsImpersonationContext wic = correlationState as WindowsImpersonationContext;

if (wic != null)

{

wic.Undo();

wic.Dispose();

}

public object BeforeSendRequest(ref System.ServiceModel.Channels.Message request, System.ServiceModel.IClientChannel channel)

{

System.Security.Principal.WindowsIdentity ctx = null;

Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(delegate()

{

ctx = Microsoft.SharePoint.SPSecurityContext.GetWindowsIdentity();

});

if (ctx != null)

{

return ctx.Impersonate();

}

else

{

return null;

}

public void AddBindingParameters(ServiceEndpoint endpoint, System.ServiceModel.Channels.BindingParameterCollection bindingParameters)

{

}

public void ApplyClientBehavior(ServiceEndpoint endpoint, ClientRuntime clientRuntime)

{

clientRuntime.MessageInspectors.Add(this);

}

public void ApplyDispatchBehavior(ServiceEndpoint endpoint, EndpointDispatcher endpointDispatcher)

{

}

public void Validate(ServiceEndpoint endpoint)

{

}

Wednesday, March 16, 2016

How to copy SharePoint 2013 workflows from one site collection to another

http://www.qdoscc.com/blog/how-copy-sharepoint-2013-workflows-one-site-collection-another

How to copy workflows from one site collection to another with SharePoint Designer

http://sharepoint-community.net/profiles/blogs/how-to-copy-workflows-from-one-site-collection-to-another-with

Tuesday, March 15, 2016

Define a workflow lookup

https://support.office.com/en-us/article/Define-a-workflow-lookup-D7FCC0DD-6E2D-4E10-BD07-F22627F5C2F3

Monday, March 14, 2016

SharePoint 2013: can't edit Rich Text column in Quick Edit mode

https://community.office365.com/en-us/f/154/t/185863

Thursday, March 10, 2016

Send e-mail in a workflow

https://support.office.com/en-us/article/Send-e-mail-in-a-workflow-11d5f9dd-955f-412c-b70f-cde4214204f4

Workflows in SharePoint 2013

https://msdn.microsoft.com/en-us/library/office/jj163986.aspx

SharePoint Journey

http://www.sharepoint-journey.com/

How to Copy a SharePoint List Workflow

http://www.sharepointbasic.com/2012/04/how-to-copy-sharepoint-list-workflow.html

Wednesday, March 9, 2016

You cannot start a SharePoint 2007 out-of-box workflow in SharePoint 2010

https://support.microsoft.com/en-us/kb/982249

Tuesday, March 8, 2016

InfoPath Error 5566

https://support.microsoft.com/en-us/kb/981684

Monday, March 7, 2016

Understanding how to package and deploy workflow in SharePoint 2013

https://msdn.microsoft.com/en-us/library/office/jj819316.aspx

You cannot save a SharePoint 2010 list or site workflow as a template.

Sunday, March 6, 2016

Manage Office Data with SharePoint 2013

https://app.pluralsight.com/player?course=manage-office-data-sharepoint-2013&author=bill-kulterman&name=manage-office-data-sharepoint-2013-m1&clip=0&mode=live

Friday, March 4, 2016

Migrate SharePoint Designer Workflow from 2007 to 2013

http://blogs.technet.com/b/vinitt/archive/2013/04/21/migrate-workflow-from-sharepoint-2007-to-sharepoint-2013.aspx

Set up and manage access requests

https://support.office.com/en-us/article/Set-up-and-manage-access-requests-94b26e0b-2822-49d4-929a-8455698654b3

Thursday, March 3, 2016

Using InfoPath and the Web service GetUserProfileByName

http://thinketg.com/using-infopath-and-the-web-service-getuserprofilebyname/

User Profiles and User Information List Synchronization

http://www.sharepointchick.com/archive/2009/06/17/user-profiles-and-the-user-information-list-or-userinfo-table.aspx

Hidden users list in SharePoint

http://sharepointviews.com/hidden-users-list-in-sharepoint/

SharePoint's hidden user-list - User Information List

https://zimmergren.net/sharepoints-hidden-user-list-user-information-list/

Introduction: Control user access with permissions

https://support.office.com/en-US/article/Introduction-Control-user-access-with-permissions-ab2d1ab1-07cf-4c69-bdd9-390bfd787b26

Edit permissions for a list, library, or individual item

https://support.office.com/en-US/article/Edit-permissions-for-a-list-library-or-individual-item-02d770f3-59eb-4910-a608-5f84cc297782

Overview of site permissions in SharePoint 2013

https://technet.microsoft.com/en-us/library/jj219771.aspx

Permissions planning for sites and content in SharePoint 2013

https://technet.microsoft.com/en-us/library/cc262939.aspx

Thursday, February 25, 2016

Using InfoPath 2013 to Query Data from the User Profile Service in SharePoint 2013

http://www.cdhtalkstech.com/2013/05/31/using-infopath-2013-to-query-data-from-the-user-profile-service-in-sharepoint-2013/

Wednesday, February 24, 2016

JavaScript Plotting

http://www.jqplot.com/

Building Charts in SharePoint 2013 using JavaScript and REST

http://www.cardinalsolutions.com/blog/2013/05/building_charts_ins

Tuesday, February 23, 2016

Excel Services - Consuming a SharePoint List using the ListData.svc

http://blogs.technet.com/b/excel_services__powerpivot_for_sharepoint_support_blog/archive/2015/07/28/excel-services-consuming-a-sharepoint-list-using-the-listdata-svc.aspx

Excel Services - Using a SharePoint List as a data source

http://blogs.technet.com/b/excel_services__powerpivot_for_sharepoint_support_blog/archive/2013/07/11/excel-services-using-a-sharepoint-list-as-a-data-source.aspx

Monday, February 22, 2016

SharePoint Add-ins

https://msdn.microsoft.com/en-us/library/office/fp179930.aspx

Saturday, February 20, 2016

Getting started with SharePoint Server 2013 workflow

https://msdn.microsoft.com/en-us/library/jj227177

Understanding Dictionary actions in SharePoint Designer 2013

https://msdn.microsoft.com/en-us/library/jj554504(v=office.15)

Friday, February 19, 2016

How to work with web service using “Call HTTP Web Service” action in SharePoint Designer 2013

https://blogs.msdn.microsoft.com/sharepointdesigner/2012/09/04/how-to-work-with-web-service-using-call-http-web-service-action-in-sharepoint-designer-2013/