Microsoft Gold Partnership for Data Analytics

Definitive Logic is pleased to announce reaching Microsoft Gold Partner status for Data Analytics.  Our new status adds to our existing Gold Application Development and Collaboration and Content status. This is a result of 10+ years of delivering successful Microsoft Solutions. Contacts us today for a free consultation in how Microsoft can help you.

The Do’s and Don’ts of PowerPivot – Excel 2016 and SharePoint 2013

When you do development for many years in one platform it gives you the chance to learn a thing or two about all the different limitations across all its different versions. The same rule applies to SharePoint. Recently our team had to develop in a SharePoint 2013 environment using PowerPivot on a SQL Server 2012 environment.  For about three months our work was going well, until we went from Office 2013 to Office 2016.  Several PowerPivot files began to get an error “Call to Excel Services Returned Error” during their scheduled refresh.  If we opened the file in Excel 2016 and refreshed the file, it refreshed with no issue. Our team got a hold of the ULS logs and while…

Securing Accounts on Office 365 with Multi-Factor Authentication

Securing Accounts on Office 365 with Multi-Factor Authentication If your organization is moving to Office 365, protecting your accounts in the cloud should be a top concern.  Thankfully Microsoft offers Multi-Factor Authentication (MFA) which requires that any user with MFA enabled prove their identity in at least two of the following ways: What you know What you have Who you are Since you’re reading this blog online, chances are you routinely deal with the “What you know” aspect, the username and password.  With Office 365, the second proof of identity involves “What you have” and is often enforced through either a text to your office or mobile phone.  As of November 2017 a “Who you are” approach is not available…

Legacy SharePoint Development (2007 and 2010) – Gulp and Robocopy

What is Robocopy and Why Should I Use It? If you're still developing with JavaScript in SharePoint 2007 or 2010, then gulp-spsave is not available.  Spsave relies on SharePoint's RESTful API which was not fully introduced until SharePoint 2013.  Thankfully there is an alternative called Robocopy.  Robocopy is a program that can quickly copy files and folders from a local source to a network-based destination.  With SharePoint's native WebDAV support we can leverage Robocopy to allow developers to build code for legacy SharePoint versions right in Visual Studio or its free alternative Visual Code.  This also means that developing in SharePoint Designer or manual file uploading is no longer necessary. In this example we are going to use a Node wrapper for…

SharePoint Development – Gulp and Spsav

What is spsave? In a few words, spsave has a Gulp plug-in that allows you to save files in SharePoint 2013/2016 or SharePoint Online (sorry SharePoint 2010 folks but there is an alternative).  For those who are not familiar with Gulp yet, it’s a Javascript toolkit that is used to automate common repetitive development tasks.  If you are interested in learning more about Gulp, you can get more information about it here. Why spsave? Spsave allows developers to build code right in Visual Studio, you have to pay for it, or Visual Code, a free IDE with great features. This also means that developing in SharePoint Designer or manual file uploading is no longer necessary, and if you’ve worked with Designer before…

Co-Authoring in SharePoint

What is Co-Authoring? One of the reasons to use SharePoint is to have a centralized location for sharing files. A team of users can store a set of common files on SharePoint so they can all share access to them as needed.  If they need to edit any of these documents collaboratively, SharePoint offers co-authoring as a solution.  Co-Authoring allows multiple users to work on the same document simultaneously. For example, when opening a Word document in the Microsoft Word Web App, a user can type in and utilize the application as usual.  However, if someone else is working on the same document simultaneously, they will be able to see who it is, the location of their cursor in the…

How I learned to stop fearing and start loving SharePoint… Sort Of – Part 2

SharePoint 2010 uses SOAP, which is messy (see what I did there?) Front-end development on SharePoint 2010 can get a little tricky.  Most web services these days use Representational State Transfer (REST) which is a nice improvement over SOAP but unfortunately that option is not always available.  If you are developing on SharePoint 2013 you are lucky and you have REST services available.  If not, be prepared to debug some weird errors with SOAP, and when I say debug I mean decrypting a modern day Rosetta Stone sans the stone or Rosetta. Use SPServices JavaScript Library For starters, I recommend using SPServices when doing any front-end development with SharePoint.  SPServices is a JavaScript library founded by Marc Anderson that takes care of a lot of the complexities…

Part 3: JavaScripting on SharePoint – Lists, Content Types, and Columns

To develop JavaScript applications that will store data on SharePoint, you should have a good understanding on how to design and store data in SharePoint lists.  If you followed Part 2 of this series, we now have three sites (Production, User Testing, and Development) to conduct SCA-JavaScript development and that means we have to keep the structure of SharePoint lists consistent across the three environments.  Fortunately, SharePoint has metadata features known as site columns and site content types to help us out.  In this section, I will discuss how to approach SharePoint lists and how you need to leverage site columns and content types to store data in those SharePoint lists. The first thing a developer on SharePoint must understand is…

How I learned to stop fearing and start loving SharePoint… Sort Of – Part 1

New to SharePoint? You are a seasoned developer and your boss just told you that they need your help on a SharePoint project.  The typical thoughts may roll through your head: Why me? I hate SharePoint. It isn’t for real developers anyways While these are all valid reactions there is one silver lining to remember.  Web development is transitioning towards front end single page applications that leverage new and exciting Javascript libraries including Knockout, Angular, and many other frameworks.  SharePoint can be used as your one-stop-shop for both the database and server side code.  This allows you to focus on front end development creating fast, responsive, and sexy apps that people would never guess were running on SharePoint.  With this…

New GitHub Project – SPLibraryTree Web Part for SharePoint

Recently I had a request that our clients wanted to see one of their SharePoint document libraries in a tree view. I did some searching around to see if there were any solutions already out there, and came across this solution on CodeProject:http://www.codeproject.com/Articles/37530/Document-Library-Tree-View-Web-Part-for-SharePoint That seemed completely suitable, but it was designed for SharePoint 2007, and I was working on SharePoint 2013, so I decided to adapt it to SP2013. Since it came from the SharePoint community, and since it seems like it might be useful to someone, I thought I'd share my new version with the community as well. So I have posted my updated version of this web part on Definitive Logic's GitHub repository: https://github.com/definitivelogic/splibrarytree A few notes regarding installation…