If SharePoint is Implemented On Premises, It Makes Sense for SharePoint Users to Consume Training Content On Premises, As Well

There is considerable rationale in 2014, with what seems to be an ever-increasing volume of data breaches of ever more prominent web sites, for an organization to opt for a strictly on premises implementation of SharePoint 2007, 2010, or 2013. Once this decision is made, it makes sense to choose a strictly on premises training method for SharePoint users. SharePoint-Videos offers solutions for this type of requirement. We offer three solutions directly targeted to the needs of organizations implementing SharePoint on premises:

More information can be found about these three solutions via a click on the Business tab on our web site.

An added benefit of maintaining a policy of implementing only on premises solutions is the opportunity it affords for SharePoint 2007, 2010, or 2013 stakeholders to make sure users are exposed to the right set of training content. The Internet is filled with a lot of training content on SharePoint. Much of this content communicates correct methods of accomplishing computing procedures. But some of this content fails to this test. When users are taught wrong methods of accomplishing tasks in a computing platform like SharePoint on premises, then the burden on support teams is dramatically increased. At the same time, the users who identified the wrong training content, and then proceeded to try to use it, are also disappointed. After all, with IT involved, the timeline for meeting an objective may have to be substantially re written. Worse yet, if procedures were followed which resulted in mistakes requiring remediation by the same support personnel charged with training the responsible users, then the price tag for a fix has to be factored into the overall maintenance cost for SharePoint.

Our solutions, regardless of whether we are speaking about our end user training sets, Corporate DVDs, or our help system for SharePoint, VisualSP, are all led by widely acknowledged subject matter experts in their fields. Several of our course leaders are on staff at Microsoft. Many others are SharePoint MVPs. So any organization striving to ensure their community of SharePoint users benefits from the right training methods can be confident a decision to purchase one of our offers will meet their requirements completely.

Ira Michael Blonder

©Rehmani Consulting, Inc. & Ira Michael Blonder 2014 All Rights Reserved

Finding the Common Thread Running Through Different Methods of Supporting SharePoint End Users in Need of Training Content

SharePoint-Videos offers Business Solutions for SharePoint, which are designed to satisfy the burning needs many organizations have for a reliable method of supporting SharePoint end users as they attempt to successfully complete computing tasks in a SharePoint computing environment.

There is a common thread running between these solutions. In this writer’s opinion, it will be helpful for anyone considering how best to address a need such as the one just presented, to keep this common thread in mind. In-Context access to training content uniquely capable of meeting the needs of SharePoint users, on demand, is the consistent theme running through each of our solutions, from VisualSP, through our Group and Multi User subscription offers, and even our Corporate DVDs.

What differentiates each of these solutions is the extent to which they each directly address the need of SharePoint end users, not to mention the support teams responsible for them, for a reliable in-context access method to training content, on demand. VisualSP is the most obvious solution of this need, but our Group ID and Multi-User subscriptions can also be crafted into a solution for this need. Finally, our corporate DVD offer, which includes a set of downloadable training content licensed for local use within the firewall, can provide the content of a custom solution addressing this need.

We have recently debuted a token system, which can be used in conjunction with our Group ID and Multi-User subscriptions to produce more of an in-context access method to technical training content than was previously possible. The in-context piece of the solution can be handled through implementing pages of links, to specific video tutorials on SharePoint-Videos. These pages should be added to SharePoint, locally. Title tags, and other metadata on the links pages should be crawled, locally, by SharePoint’s search service. So, when an end user faces a technical hurdle, a search query can be used to pull up the page of links. When this page of links is opened in a new browser window, then the video tutorial can be launched with a click of the mouse, while the user continues to address the work at hand in SharePoint in another open window. Through this method an in-context access method to repeatable training content can be crafted from one of our corporate subscription offers.

If you would like to learn more about this method, please let us know. We will be happy to discuss the solution with you at greater length at a mutually convenient time.

Ira Michael Blonder

©Rehmani Consulting, Inc. & Ira Michael Blonder 2014 All Rights Reserved

Working with OneDrive for Business is More Productive when SharePoint Online Users have Realistic Expectations

Microsoft has expanded user accessibility to Office Online to include not only smart phones and tablets powered by Microsoft operating systems, but also iOS and Android devices. Nevertheless, Office Online performance is not uniform across all of these devices. So SharePoint Online stakeholders, administrators and power users should set reasonable expectations for end users, to ensure adoption does not suffer as the result of deploying OneDrive for Business and Office Online apps.

This writer recently tested performance of Excel Online on:

  • a PC running Windows 7, Professional with 8 GBs of RAM
  • a PC running Windows 8.1, Professional with 12 GBs of RAM
  • a Surface 2 tablet running Windows 8.1 RT
  • a Samsung Galaxy Note 2.1 10.1 running Android Jelly Bean

A large spreadsheet depicting monthly cash activity for over 100 types of transactions, over 8 years, provided the content for the test.

We observed substantially different results from each of the devices included in our test. Even the 2 PCs were challenged to easily scroll through columns of data. We could manouver around the spreadsheet with our Surface 2 RT, but were very challenged to achieve satisfactory results with our Samsung Android Tablet. We should also note the latter device supports several different browsers: Samsung’s version of Google Chrome, Chrome, and Firefox. We were not able to successfully work with Excel Online with either the native Samsung browsers, nor with Firefox. But we did obtain satisfactory results with Google Chrome on this device.

Excel Online does not include an actual “GoTo” button. Documentation we found about Excel Online claimed the GoTo feature still exists. All one need do is “[t]ype in a cell reference and jump to that location in the spreadsheet”. But type in a cell reference where?? Unfortunately the documentation does not specify just where a user should look for the form box required for this process to work. A click on the Excel keyboard shortcuts did not produce a keystroke combination for the GoTo feature.

As we noted above, in our opinion, SharePoint Online stakeholders will do well to thoroughly test Office Online performance across as many of the devices in use at a specific organization as they can, before rolling out Office Online to end users. The objective ought to be to minimize any negative impact on SharePoint Online adoption by end users.

Ira Michael Blonder

©Rehmani Consulting, Inc. & Ira Michael Blonder 2014 All Rights Reserved

Building Workflows for No-Code Solutions Using External Data with the BCS in SharePoint 2013

In the eleventh and twelfth units of a set of fifteen units of video training content on building workflows for external data, in either SharePoint 2013, on premises, or SharePoint Online, Office 365, Fabian Williams, a SharePoint Server MVP, presents a set of procedures, and their underlying components, most likely to be useful for an audience of SharePoint, or Office 365 application developers. These video tutorials will not likely be useful to SharePoint power users. An experience set which includes extensive work with JavaScript, modern Open Protocols (including OAuth and OData), and Visual Studio is required to digest the information Williams communicates, and to put it to good use.

The comparatively high barrier to entry implicit to the principles presented in these two video tutorials (the first of these is titled External Data and SharePoint Workflows. Both of these units are included in a set titled SharePoint 2013: Working with External Data in SharePoint 2013 using BCS and Workflows – On Premises, and Online, which is available for purchase and for local use by either individuals, or groups) should stand in contrast to how workflows, as a method of developing processes, is usually presented.

But the barrier to entry does exist and SharePoint stakeholders researching how best to develop custom solutions for specific implementations will do well to respect it. For example, in the first of these units Williams informs his audience the technical foundation underpinning no-code workflows has been substantially changed in SharePoint 2013, and SharePoint Online, Office 365:

  • SharePoint 2013 Workflows are Powered by Windows Workflow Foundation 4 (WF4)
  • WF4 is Built on the Messaging Functionality That is Provided by Windows Communication Foundation (WCF)
  • WF4 and WCF are Hosted in Workflow Manager Client 1.0 (WMC 1.0)
  • WMC 1.0 is Used to Manage Workflow Definitions. WMC 1.0 Also Acts as Host for the Execution Processes

In order to ensure optimum return on investment in the form of time, and, perhaps, cost, anyone viewing these videos should also have a grounding in Web Services and the new Stages feature of Workflows in SharePoint Designer 2013.

The flip side of the high bar represented by these two units, for those developers bringing the required experience set to this presentation, amounts to a highly condensed, information-packed, presentation of how to successfully build a complex process with no-code tools, in this case, SharePoint Designer, 2013.

Ira Michael Blonder

©Rehmani Consulting, Inc. & Ira Michael Blonder 2014 All Rights Reserved

In-Context Access to Training Content Presents Benefits Beyond a Reduction in the Cost of SharePoint Support

As Microsoft refines the features of SharePoint, and SharePoint Online, Office 365, and adds more services like Delve, these computer platforms will take on more of a mission-critical role for the organizations opting to implement them.

In posts published on earlier dates to this blog, this writer has presented opinions about why computer platforms playing a mission critical role for the organizations opting to implement them tend to deliver substantially more value than platforms not chosen for such a role. This lesson does not appear to be lost on Microsoft. One can be confident product marketing will continue to add more “high value” features to SharePoint and to SharePoint Online, Office 365 in the not too distant future.

An in-context access method like VisualSP can play more than one role in a mission critical implementation of SharePoint. This type of solution can be used to expose training content to a wide cross section of SharePoint users. But it also can be used to expose business specific training content directly to personnel as they perform computing tasks.

For example, consider a banking business, and, further, its commercial lending operation. There is no reason why video tutorials on how to safeguard electronic loan documents in shared document libraries could not be added to VisualSP. By adding this content, and availing of the out-of-the-box viewers we ship with the product, organizations can be confident personnel will not have to leave the corporate computing environment to “Google” unfamiliar terms, or to find explanatory content about procedures. All of the required content can be curated for them and organized into a content set for exposure with the system.

We are confident the increased productivity our customers have enjoyed as the result of implementing our system will be consistent for this type of business-specific application. Further, organizations looking to reduce the amount of one on one training time otherwise required to teach personnel to perform new procedures can consider adding video training content to our system specifically designed to answer “how to” questions on business topics.

If you are considering a mission critical role for either SharePoint, on premises, or SharePoint Online, Office 365 and would like to learn more about the method described in this post, please contact us.

Ira Michael Blonder

©Rehmani Consulting, Inc. & Ira Michael Blonder 2014 All Rights Reserved

Learn More About Why SharePoint End Users Benefit from an In-Context Method of Accessing Technical Training Content at SPTechCon Boston

If your organization would like to add a method of training end users in the technical procedures they need to learn to successfully complete work in SharePoint, and you plan on attending SPTechCon, Boston, next week (September 16 – 19, 2014), then please stop by our SharePoint-Videos booth. We will be exhibiting VisualSP, our award-winning help system for SharePoint at the Conference, on Thursday, September 18, and Friday, September 19, 2014.

A number of very prominent businesses, including:

  • Regeneron Pharmaceuticals
  • Deere
  • Visa, International
  • Zoetis
  • CoBank
  • First Republic Bank

and some very prominent public institutions, including:

  • the City of Tallahassee, Florida in the US
  • the City of Edmonton, Canada
  • the Parks Agency for Canada
  • the University of Colorado, Denver, Medical Center
  • West Georgia Technical College

have implemented VisualSP as a method of hastening end user adoption of SharePoint computing.

An important added benefit of their decision has been a decrease in the number of end user requests for help figuring out how to how to complete a process in SharePoint. SharePoint stakeholders at these organizations have learned about the availability of a type of instructional technical content particularly suited to end user consumption, with little, if any need for a support representative to play a role in the training process. This type of training content includes short, to-the-point video tutorials, light on abstraction and completely devoid of bobby heads. End users can consume this content on-demand, directly within a SharePoint workspace with VisualSP.

So, if you are registered to attend SPTechCon, Boston, next week, please stop by our booth. Asif Rehmani, CEO of SharePoint-Videos and creator of the VisualSP Help System will man our booth, along with Michael Blonder, Vice President of Business Development. We will be fully equipped to provide you with a tour of the VisualSP Help System and to spend time learning more about what your organization expects to get from its investment in SharePoint, and the role end user training is expected to play in the process. Please contact us to shedule a meeting.

Ira Michael Blonder

©Rehmani Consulting, Inc. & Ira Michael Blonder 2014 All Rights Reserved

Working with the OData Protocol, Web Parameters and URIs to Expose External Data in SharePoint

Expressions of the OData protocol are usually incorporated within Uniform Resource Identifiers (URIs). These expressions add parameters to Internet locations, at the application layer (hypertext). Once the syntax of a URI has been successfully completed, a web browser can be used as a “universal client” to parse data repositories for targeted segments of data, which users can consume as web pages.

In two video tutorials included in a new set of video training content led by Fabian Williams, SharePoint Server MVP, we demonstrate not only the importance of a thorough grounding in web application development to a successful effort to build Apps to expose external data, with the BCS, in either SharePoint 2013, or SharePoint Online, Office 365 via Visual Studio and OData sources, but, further, the value of knowing how to leverage debugging skills to correct errors and to keep a development project on track.

These videos are titled, respectively:

  • BCS External Data, Visual Studio, REST and OData – Part 2, and
  • BCS External Data, Visual Studio, REST and OData – Part 3

They are both included in a set titled SharePoint 2013: Working with External Data in SharePoint 2013 Using BCS and Workflows On Premises and Online.

The first of these videos presents viewers with a problem: Fabian attempts to add data from an OData repository to resources for a project in Visual Studio, and, subsequently as new content for SharePoint Online, Office 365. Both attempts fail. Fabian demonstrates how to debug the failures with an emphasis on the web application nature of the task. Accordingly, he spends a considerable amount of time looking at how the data has been encoded for browser display, and makes several adjustments to it. Later, he also investigates viewing permissions, and makes additions to the Metadata Term Store to ensure the proper privileges are in place to 1) add the content to SharePoint Online, and, later, 2) to work with it.

The second of these videos amounts to a demonstration of how to construct a working URI, complete with a series of parameters. The objective of the series is to populate a web page with specific sections of data parsed from an external data set via the OData protocol.

Ira Michael Blonder

©Rehmani Consulting, Inc. & Ira Michael Blonder 2014 All Rights Reserved

Using the BCS to Pull External Data into SharePoint 2013 with Visual Studio

Microsoft is attempting to rebrand its code editor, Visual Studio, as a preferred method for developers to product Apps conforming to the Office 2013 App model. In a set of three video tutorials, Fabian Williams, a SharePoint MVP and widely acknowledged subject matter expert, demonstrates how the BCS can be used, via Visual Studio, to pull external data into SharePoint 2013.

All three of these video tutorials are included in a new set of training content titled SharePoint 2013: Working with external data in SharePoint 2013 using BCS and Workflows. This set is available, exclusively, on SharePoint-Videos.com.

In the first of the three videos, titled “BCS External Data, Visual Studio, Rest and OData – Part 1″ we demonstrate how to build the development environment, including:

  • Configuring OData End Points URI
  • Create and Configure a BDC Service Application
  • Create and Configure a Secure Store Service Application
  • Add a Set of Permissions to the BCS Metadata Store (optional)

An added benefit to viewers is the demonstration Fabian Williams provides of how Microsoft Azure can be used as a cloud IaaS, for OData, to support the development examples included in this set of tutorials. Anyone with an interest in rapidly putting together a working example of one of the applications included in this set will likely want to consider using Azure, so the tips on how to get servers, and sites set up quickly and correctly will likely come in handy. As to the rationale for using OData, Fabian Williams remarks on several occasions, throughout the entire set of videos, on the comparative ease of building each of the examples he demonstrates with the OData protocol (even in comparison to the approaches supported by SharePoint Designer 2013).

Included in this video tutorial, as well, is a discussion about “auto hosted” vs “provider hosted” app development options for SharePoint, including a note on how Microsoft is deprecating the “auto hosted” option. Steve Fox also spent sometime on this topic in his set on SharePoint 2013: Beginning Development, which is also exclusively available from SharePoint-Videos.com.

Ira Michael Blonder

©Rehmani Consulting, Inc. & Ira Michael Blonder 2014 All Rights Reserved

An Overview of Secure User Authentication for Office 365

On September 1, 2014, a successful hack of a celebrity’s iCloud account was heavily publicized. In the aftermath of this type of event, it is normal for consumers of similar services from other ISVs, most prominently, Office 365 from Microsoft, to look for assurance from their IT department of the comparative security of their online computing policies and procedures. Fortunately, a white paper is directly available from Microsoft which speaks to these concerns.

This white paper was published in May, 2014, and is titled Security in Office 365. For readers who have not had an opportunity to review this white paper, much of the information in the first 12 of the 24 pages in the document is taken up with a description of the data security architecture Microsoft has implemented for Office 365, and some of the automated tools built specifically to safeguard the process of consuming data from this cloud, SaaS offer.

On page 13, Microsoft specifically addresses “Secure end-user access”. Mention is made of Azure Active Directory and more information about this method of user authentication can be found via a search with Microsoft’s Bing Search engine.

A point of debate with regard to the iCloud hack mentioned at the top of this post is two-step verification. This white paper describes “multi-factor authentication” options for Office 365. Notably absent is any recommendation about whether or not organizations with a public tenancy on Office 365 should use this feature. In this writer’s opinion, consumers should be led towards a “right decision” on topics like user authentication, and the defense options available to SharePoint, SharePoint Online, and Office 365 administrators. On the other hand, the absence of a recommendation can be understood as, unfortunately, this type of verbiage can be crafted into a point of exposure to law suit, culpability, etc. for a cloud, SaaS ISV like Microsoft.

Also noticeably absent from the white paper is any discussion of the need for Office 365 tenants to implement an operational risk management policy to support the automated tools and features already built into Office 365. Once again, and for the very same reasons just mentioned with regard to whether or not it would be helpful for Microsoft to recommend an approach, this writer can understand why the need for procedures is not addressed in this white paper.

Nevertheless, it is strongly recommended service administrators implement policies and procedures to support the user access controls described in this white paper. Readers should not be lulled into a complacent attitude about the need for supportable, proven procedures to ensure the security of personnel availing of online services like Office 365. Automated tools are not enough. Secure procedures are, and will be definitely required.

Ira Michael Blonder

©Rehmani Consulting, Inc. & Ira Michael Blonder 2014 All Rights Reserved

A Hands On Example Using SharePoint Designer, SQL Server and the Secure Store for SharePoint 2013 to Work with External Data

In a video tutorial titled Using SQL Server to interact with BCS External Data, Fabian Williams, a SharePoint Server MVP demonstrates each of the steps required to create an external content type in SharePoint 2013. The steps are taken with SharePoint Designer 2013, SQL Server, and the Secure Store.

This video tutorial is included in a set of video training content titled Working with External Data in SharePoint 2013 using BCS and Workflows. The set is available for purchase for local, on premises unlimited viewing by organizations of any size. The set is also included as a course for SharePoint 2013, and is available for unlimited viewing by anyone with a valid subscription to SharePoint-Videos. The target audience for this video tutorial set are SharePoint Administrators, Developers, Designers and Architects.

As anyone watching the above mentioned video tutorial will note, Fabian actually recommends viewers consider passing over SharePoint Designer 2013, for Visual Studio for one simple reason: OData has not yet been added as a method of connecting to SQL Server in SharePoint Designer, 2013. In contrast, OData can be used with Visual Studio, with no requirement for any hard coding, to accomplish the same objective depicted in this video. Per Fabian, opting to use Visual Studio for the task will reduce the amount of time required to build the external content type depicted in this example to “a few seconds”.

This writer was impressed with the granularity of the presentation. Fabian actually builds the external content type in the video. So viewers benefit from a step-by-step depiction of each of the procedures required to accomplish the task. The steps taken, as mentioned at the top of this post are effected with SharePoint Designer 2013, SQL Server and the Secure Store. Of course, as a video tutorial, this presentation can be paused, or repeated as frequently as viewers require, which provides the best opportunity for maximum retention of the material presented.

One final note: the video is likely to be of greatest value to the intended audience. It is not likely SharePoint power users will get much out of it, unless the right permissions are in place to afford specific viewers an opportunity to practice the procedure.

Ira Michael Blonder

©Rehmani Consulting, Inc. & Ira Michael Blonder 2014 All Rights Reserved