Category Archives: SharePoint

SoftArtisans at SharePoint Saturday The Conference

Mr. Jones Goes to Washington

Plus three more of us, but Ben’s surname is most conducive to Capra-homage. Anyways, this Wednesday through Saturday, the SA Crew is storming das Kapital/Annendale, VA with the lofty intentions of a) getting to know the people behind the avatars, b) talking shop, which in our case translates to demonstrating some of the things you can do when you integrate OfficeWriter into SharePoint, c) learning about everything from Office365 to migration to branding to unicorns, d) blasting our speaker-sourced SPSTCDC playlist all day, urry day. If you have some downtime between sessions, please stop by booth 320 to hang out/bust some moves/ ogle some schmancy SharePoint-to-Office reports with us. Also, if you’re a developer, admin or BI analyst, you should definitely check out Ben’s two sessions on  custom workflow actions and advanced document processing with OfficeWriter in SharePoint: Continue reading SoftArtisans at SharePoint Saturday The Conference

NEUGS Part 4: A Workspace by Any Other Name Would Be a Site

[The Team Site. Really feeling the beige blazer and mildly ethnically diverse group of mildly pleased office workers.]

I’ve already danced over the different sites available in SharePoint 2010; now I’m going to dive into them. Essentially, the gist is that there are a bunch of different site templates in SharePoint and mostly they are different in name and in focus, but not in format. Before we go further, I’d like to tell you a little bit about the site collection, top level sites and subsites.

The site collection is not a type of site–it is the collection of sites that fall under one top-level site. Your organization could have hundreds of them, if it so choosed. Certainly, you want more than one, as each comes with its own administration and security settings, libraries, recycle bins etc…

Continue reading NEUGS Part 4: A Workspace by Any Other Name Would Be a Site

NEUGS Part 3: SharePoint Permissions Basics

Halt, Who Goes There?

 

 

 

 

 

Okay, so now that we’ve gone over the basic types of things that can be done in SharePoint and the four most basic things you will be doing, I’d going to throw a little sand under these wheels and talk about permissions. Because in SharePoint, you’re not just restricted by what you don’t yet know. There are many things you may never be able to do because the site owner doesn’t think you’re the right person to do them. No offense. What you can do depends on what user permission level you’ve been given.

Basically, there are two brackets of permissions levels: those for team sites and those for other sites. Each bracket has several types of users with expanding permissions, kind of like those Russian nesting dolls. Continue reading NEUGS Part 3: SharePoint Permissions Basics

NEUGS Part 2: Whatcha Gonna Do with All That Junk

In Part 1, I introduced you to the main capabilities of SharePoint, and the parts through which these capabilities are manifested. Now, as promised, I’m going to walk you through some of the basic end-user tasks: creating new sites, uploading documents to a library and editing them, and adding items to a list.  Why these tasks? Because, essentially, they are the gist of what you will need to do on SharePoint.

1.      How to create a new site

SharePoint, like honeybees and the British, operates on a hierarchical system. At the top of this hierarchy is the portal, which is the container that houses all your organizations’ sites, subsites, pages, mysites etc… Assuming you have a portal, please navigate to it (http://portal). Good. Now across the top navigation bar you’ll see links to whatever sites your org already has going. These are team sites. Click on one of them (in my case, it’s “Marketing”).  Now, see that button in the top lefthand corner that says “site actions?” Click it and from the drop-down, select “create new site.” Now you’ll get a pop-up menu with all the different site templates you have at your disposal. Decide which one you need, and give it a title and url, then click create. I’m going to go with “document workspace.”

 

 

 

 

 

 

2.       How to upload a document/spreadsheet/ppt etc to a SharePoint library

In case I forgot to mention this, documents are stored in libraries. All files are stored in libraries. Navigate over to your new site or any other site of your choosing that has a document library or the ability to have a document library. Click on the lefthand link that says “libraries.” It will be empty save for “Shared Documents.” “Shared Documents” is your default library, so that is where we’re going to upload to today. Click the link and then click “add document.” You’ll be guided through a routine doc upload process.

 

 

 

 

 

 

 

 

3.       How to edit a document in SharePoint

If you want to edit a document in SharePoint, just click it and change the prompt toggle form “read only” to edit. If you want to make sure nobody else makes edits while you have it, check out the document first. You do this by clicking the check box next to your document and then choosing “check out” from the ribbon options above. After you’re done editing the doc, save it and it will ask you if you want to check it back in, which you do.

 

 

 

 

 

4.       How to add an item to a list

Again, in your new site or any other site with lists, click “lists” and then select one of the available lists. I’m going with “tasks.” Because I’ve just created this new site, there are no tasks yet. Click “add new item.” A dialog box will come up asking you to at the very least give your task a name. Do so, and then assign it to someone. You can also give it a priority level, a predecessor (eg a task that needs to be completed first), a due date, a status and a % complete. When you assign the task to someone else, they’ll get an email in outlook, or they should if your SharePoint has been properly configured by someone other than yourself.

Done? Congratulations! You now know the nuts of your SharePoint bolts. Stay tuned for Part 3, wherein we’ll take on customization.

 

NEUGS Part 1: Welcome to the SharePoint Jungle

Before I came to SoftArtisans, I’d never heard of SharePoint. (You can gasp here or save it for later in the post.) As is my wont, I began using it without ever reading any documentation or general how-it-works-for-essentially-tech-illiterate-fools-type information. Which, in terms of doing most of what I need to do (uploading docs to libraries and writing blog posts on my My Site), is not the worst strategy, but it left a lot of gaps. So, with Ben’s encouragement, I recently began a comprehensive SharePoint-for-the-End-User curriculum. And, to my surprise and chagrin, found that there really isn’t one. Don’t get me wrong, End User SharePoint is an amazing resource—but I’d say it’s more tailored to post-bacs. Microsoft used to have a series of training videos, but they seem to be down at the moment, and their getting started articles are pretty skimpy early on and fragmented after the ABCs. So, like any great innovator (if you’ve been holding in that gasp, you can let it out now), I decided to create my own guide. Welcome to part one of many: What SharePoint does for me and which of its parts I will use. Continue reading NEUGS Part 1: Welcome to the SharePoint Jungle

Solving the ‘double hop’ issue using Secure Store


[Image via Fabian Williams]

Last week I was working on some ASP.NET web forms that generated internal reports against MS CRM using ExcelWriter and I wanted to port the application to one of our SharePoint instances. Though it seemed simple at first, I ran into a few issues. One of the issues happened to be authentication related. It was a typical ‘double hop’ problem where this SharePoint instance was using integrated Windows NTLM authentication and my code was trying to access the CRM SQL Server database. By nature, NTLM is unable to pass the credentials to the database thus producing access errors. (You can find more information on the NTLM issue and using Kerberos as a solution here.)

Since we don’t have Kerberos configured on this environment, our best solution was Secure Store. This service allows a user to authenticate with domain credentials and then use an account established in Secure Store to access the database. In our case, this was the read-only CRM account. This also enables easy to use and convenient access control using AD groups. Continue reading Solving the ‘double hop’ issue using Secure Store

Cloudy with a Chance of SharePoint

There’s been a lot of talk, recently and not so recently, about SharePoint in the cloud, especially with the release of Office 365. Hell, there’s been a lot of talk about cloudification, period (though perhaps not using that particular term). Cloud computing provider CloudShare just finalized a$10 million round of vc funding, Apple is letting users store and stream backups of their iTunes downloads in the iCloud, Google Docs now has pivot tables…From financial and ease-of-use standpoints, it’s easy to see why moving data to the cloud is such an appealing proposition. From a security standpoint, as we witnessed with the Amazon/Playstation hack this year, it’s rather less appealing. And then there’s the current lack of feature paritybetween SharePoint 2010 and SharePoint Online, and the fact that the latter doesn’t support farm-scoped solutions, full-trust solutions or WebApplication-scoped features. Continue reading Cloudy with a Chance of SharePoint

How to Create a Renewal Forecast Report with CRM, ExcelWriter and SharePoint

After finishing off our ASP.NET, SQL, and ExcelWriter training, the Technical Services Interns were given a project to create a proof of concept involving the dynamic generation of internal reports. We would use our new SQL knowledge to pull data from a customer relations database (Microsoft CRM), our ExcelWriter knowledge to create a rich Excel report from that data, and our ASP.NET skills to create a Web Form whereby users could constrain the reports they received. The reports would then be ported into SharePoint webparts. The reports were split into three categories:

  • Renewal Forecast
  • Case Distribution
  • Customer Activity

This post addresses the first of these reports. The Renewal Forecast report gives a company’s Sales and Support departments insight into customer contracts coming up for renewal.

Creating the Renewal Forecast Report

The purpose of this report is to provide a detailed overview of customers’ support contracts that are nearing expiration so employees can better manage the renewal process. The front-end in SharePoint is customizable so the report is generated completely dynamically and populated using queries from CRM. It is all ASP.NET code and uses a very sharp looking jQuery datepicker. Of course, the report generation is handled nicely using an ExcelWriter template. Not a current ExcelWriter user? No problem: you can download a free evaluation and follow along! Continue reading How to Create a Renewal Forecast Report with CRM, ExcelWriter and SharePoint

Error installing OfficeWriter for Reporting Services 2012 in SharePoint integrated mode

Problem

When installing OfficeWriter for SQL Server Reporting Services 2012 in SharePoint mode (SharePoint 2010), the OfficeWriter installer aborts with message:

SoftArtisans OfficeWriter Setup Wizard ended prematurely because of an error. Your system has not been modified. To install this program at a later time, run Setup Wizard again. Click the Finish button to exit the Setup Wizard.

Solution

Starting in SQL Server 2012, the SharePoint integration for Reporting Services was re-architectured: SSRS 2012 is configured as a shared service against SharePoint 2010. Configuration information is stored in a database and can be managed through SharePoint Central Administration or with Powershell.

Due to this change in architecture, the OfficeWriter installer is not currently equipped to run against SSRS 2012 in SharePoint integration mode. We will be adding support for this configuration to the OfficeWriter installer in a future release.

Update 4/11/2013: Instructions for manually installing OfficeWriter in this configuration are now available in our documentation: Manual Installation for SSRS 2012 with SharePoint 2010. The fix to the installer will be available in a soon to be released version of OfficeWriter.

Note:

This does not happen outside of SSRS 2012 with SharePoint 2010. OfficeWriter has full compatibility with SQL Server Reporting Services 2012 in native mode starting in v8.2. OfficeWriter also works with other combinations of SSRS and SharePoint.

Things Learned at SPTechCon

[Striking a pose with the Hillbilly. Pre clog-off.]

1. The lack of readily available caffeine was kind of a problem,

2. A lot of the attendees we met were about to take the SharePoint plunge, and we salute your courage. But also, learning your way around won’t be that difficult – it only appears that way.

3. Dux was so right when he said we need to stop thinking about SharePoint as a solution and start thinking about it as a platform. (Upon which anything is possible. Almost.)

4. People are totally willing to fill out a survey if you ply them with SD cards

5. The SharePoint Hillbilly is just as nice in person as he seems on his blog. Actually, sometimes he seems cranky on his blog—but then again, when we met him, he’d just won an iPad.

6. Planking has nothing to do with SharePoint. But a lot to do with SharePints.

7. You don’t have to watch Jersey Shore to see a staged fight. Continue reading Things Learned at SPTechCon