SharePoint 2010

SharePoint 2010 Client Object Model – CAML Query inaccurate results error

I ran into a frustrating scenario today, while working with SharePoint 2010’s Managed Client Object Model. My application queries a SharePoint document library using the file’s name (the FileLeafRef field). Given that this field is unique, I was expecting only one result with the following code: 1 CamlQuery qry = new CamlQuery(); 2 3 //filter the results to only get back the item with the filename we're looking for 4 qry.ViewXml = string.Format( 5 "<Query><Where>...

Share This Post:

Posted On Tuesday, November 08, 2011 10:17 AM | Feedback (0)

Error when trying to access SharePoint 2010 via PowerShell in a new environment

I got this error today while trying to access my new SharePoint 2010 environment via PowerShell: Cannot access the local farm. Verify that the local farm is properly configured, currently available, and that you have the appropriate permissions to access the database before trying again. If I would have just read the error message a little more carefully, I would have realized that I should start by looking at my permissions in SQL – which my account didn’t. This happened because I installed SQL...

Share This Post:

Posted On Tuesday, October 11, 2011 4:32 PM | Feedback (0)

Error creating PowerPivot Service Application in SharePoint 2010 (SP1 + June 2011 CU)

A few weeks ago I ran into an error while setting up our test farm. I was creating the service applications and when I got to PowerPivot, I got the following error: I was able to work around this error by using PowerShell to create the service application. Background First, some details of our installation: two web front ends, two application servers, and one SQL server. All are running Windows Server 2008 R2 x64 with Service Pack1. The SQL Server is 2008 R2 with SP1. The SharePoint servers are SharePoint...

Share This Post:

Posted On Sunday, September 18, 2011 7:51 PM | Feedback (2)

SharePoint 2010 Not Indexing OneNote 2010 files

Our SharePoint team at work noticed that our SharePoint 2010 farm wasn’t returning search results based on the contents of OneNote files that were saved in document libraries. I did a little research and found a solution, by putting together steps from different posts. First, some details: we’re running SharePoint 2010 SP1 (with the June 2011 CU) on Windows Server 2008 R2 SP1. However, this issue was seen before we applied the service packs and cumulative updates, so I’m not sure what effect, if...

Share This Post:

Posted On Tuesday, August 23, 2011 11:33 AM | Feedback (3)

SharePoint 2010–Error when deleting Content Type In Use

UPDATE! July 8th, 2011 -- I’ve been reading Chris Poteet’s blog for a while (probably since Day of .Net Ohio in 2008 or 2009) and he recently started a new blog covering odd user interface quirks and inconsistencies with SharePoint. He’s titled the blog, Unexpected Error. Well, today Chris was kind enough to mention me for follow Friday on Twitter and I followed the link to his blog again – and was stunned to see that I had written a post this week that is pretty much the same one he wrote two weeks...

Share This Post:

Posted On Wednesday, July 06, 2011 7:15 PM | Feedback (1)

Illegal characters for SharePoint 2010 Content Type name

Quick tip: you can’t include a backslash in the name of the SharePoint 2010 Content Type. In fact, there are several illegal characters: \ / : * ? " # % < > { } | ~ & , two consecutive periods (..), or special characters such as a tab. What, you didn’t know that after entering one of these characters in the name? Is it because you saw this screen: Oh, that’s right….you need to turn off custom errors in the layouts folder…See this blog post for details and you’ll also need to turn off for...

Share This Post:

Posted On Thursday, June 23, 2011 5:03 PM | Feedback (0)

SharePoint 2010 Developer Training

I’ve written a couple of posts about SharePoint 2010 Administrator training/learning, so I thought I should follow up with some tips for developer training as well…. Microsoft has two exams for SharePoint 2010 developers. The first is Exam 70-573, Application Development. The second is Exam 70-576, Designing and Developing Microsoft SharePoint 2010 Applications. Those links cover the topics for each exam as well as some Microsoft preparation materials. One of the best sites, and one that I relied...

Share This Post:

Posted On Tuesday, June 14, 2011 10:29 PM | Feedback (0)

SharePoint 2010 Administrator Training – UPDATE

I wrote a post last August with details about what materials I used in order to study for the two Microsoft SharePoint 2010 Administration Exams (70-667 & 70-668) : http://kellydjones.com/arch... This question still comes up a lot, so I thought I’d post an update with some more learning materials. First, I’ve recently discovered Safari books online. Safari books online has a lot of SharePoint books, including Wrox books – which I’ve found that I keep gravitating to. There’s...

Share This Post:

Posted On Tuesday, June 14, 2011 9:54 PM | Feedback (0)

Automatically setting file name when submitting InfoPath 2010 Form

After creating my InfoPath form and setting it to publish to a Forms Library in SharePoint 2010, I found that I wanted to fine tune the experience that the user has when submitting a form. The first thing to change was the annoying dialog asking the user for a filename. Many users will have no idea what SharePoint is asking them for, or worse, they enter a name that’s already used by another form (and either overwriting it or getting an error). To see what I mean, simply create an InfoPath 2010 form...

Share This Post:

Posted On Tuesday, May 31, 2011 9:51 PM | Feedback (2)

Using InfoPath 2010 with SharePoint 2010 Content Types

There are a couple of ways to integrate Content Types with InfoPath forms libraries. I’m going to cover one scenario, but I’m sure there are more. My scenario is that I want to submit a form to a SharePoint 2010 Forms library and align the data collected on the form to existing columns in my Content Type. Here’s a summary of the steps: · Create a Site Content Type in SharePoint 2010 (my example is HR Forms) · Create a Forms Library in SharePoint 2010 (my example is HR Forms Test) · Add the Site Content...