I'm currently working on a project where I need to quickly make pretty graphs and charts for data in small but important SharePoint lists. After looking through a number of books and consulting with my SharePoint buddies, PowerPivot for SharePoint 2010 seems to be the best tool for the job.

Getting it to work hasn't …

If you find that "Upload Multiple Files..." is greyed out or otherwise unavailable in SharePoint 2010 and you:

1. Are running 32-bit version of Internet Explorer
2. Don't have a copy of Microsoft Office 2007 or 2010 available
3. Have added your SharePoint site to the Trusted or Intranet Security zone in IE

You can …

Once, after viewing a SharePoint 2010 document library in Windows Explorer, I ran a net use and saw that Windows 7 had stored the credentials of my SSL-secured SharePoint intranet server. It took a bit of fiddling, but I eventually found you can, in fact, map a secure network drive using the command line:

net use W: …

I started on a new client site last week and my first task was immediately clear: I had to remove the Mixed Content Security prompt on the encrypted SharePoint intranet's front page. Firebug showed that my browser was making calls to feeds.feedburner.com even though the RSS feed was an entirely different address at …

Below is a formula for a quick and dirty autonumber for lists in SharePoint. There are a variety of ways to generate this field. Some solutions use workflow or external lists, but I prefer this method because of its simplicity.

Note: Because this solution depends on the record's ID column, it generates the autonumber …

The free tool SharePoint Manager 2010 is super useful. Imagine a centralized place to look at everything on the server level from Content Type usage to running jobs and IIS setting. Check it: …

Here is a script that will batch import Models, create associated ECT's, and set permissions for users and admins. Please modify the variables as needed.

# script from netnerds.net # Make sure the namespace is the same as the namespace in your exported bdcm files # My $siteURL happens to be the same as my $namespace. …

In order to invest as little effort as possible creating and recreating and recreating my External Content Types on my development server, I exported the ECT's then deleted External Content Types, External Systems, and BDC Models. I saved them all in a directory on the SharePoint server, then I placed …

Today has been miserable. All I wanted to do was import a SharePoint 2007 calendar into SharePoint 2010 to use as sample data for a prototype site. I was caaarraaazzy enough to believe it would be a simple import/export, but no. There's no such thing. Maybe I could use Outlook calendaring or idq files as a medium? No. …

Recently, after importing some bdcm files, I was unable to create new forms based off of my new External Content Types. The error I received was;

The system of the external content type cannot be accessed. It is either removed from the Business Data Connectivity Metadata Store or you do not have the necessary …