SharePoint File Extractor

Mike BerrymanDo not try and find SharePoint files, that’s impossible.  Instead, only try to realize the truth… there are no SharePoint files.

In SharePoint, most (not all) files don’t actually exist in the conventional way.  What I mean by this is that you can’t just browse to a directory and open a SharePoint page in your favorite text editor and make changes.  Instead, most files in SharePoint exist as BLOB data in a SQL database and the only way to actually edit these files is through SharePoint Designer.

So what if you want to have any of these files in source control?  Of course you could use SharePoint Designer to copy/paste the contents of each target file to your file system, but that is extremely cumbersome (you can’t just copy/paste a file itself, you need to actually open it and copy the contents).  As our clients have become more and more proficient with using SharePoint Designer to make their own changes we have had an increasing need to actually get these changes in source control.

Continue reading “SharePoint File Extractor”

SharePoint’s Data Form Web Part, Edit Mode, and “Id” Query Parameter

Mike BerrymanSo a few days ago, I stumbled upon a baffling bug in SharePoint while using a data form web part to allow for editing a list item in a custom list.  In the past, whenever I’ve created custom data form web part pages for editing, I’ve always followed SharePoint’s schema of using the “Id” query parameter to indicate which list item is being editted.  In this case, I was already using “Id” in another web part on the same page, so I just modified my data form web part to use some other query parameter, like “ItemId”.  Simple, right?

Continue reading “SharePoint’s Data Form Web Part, Edit Mode, and “Id” Query Parameter”

Getting solution files from SharePoint

Mike BerrymanAnyone who has ever done any sort of custom development for SharePoint knows about .wsp files.  If you don’t know, .wsp files are packaged (IE zipped) collections of files that are deployed to a SharePoint farm.  This includes dlls, features, custom controls – just about anything done in a custom development situation for SharePoint gets packaged into a .wsp file for deployment purposes.  You can view the .wsp files deployed to any SharePoint farm via central administration.

Continue reading “Getting solution files from SharePoint”

User Information in SharePoint Foundation

Mike BerrymanSharePoint Foundation does not have a User Profile Service, so how are users managed?

It turns out that there is a hidden system list on SharePoint Foundation (actually all versions of SharePoint, but much more useful in SharePoint Foundation).  To view this list, you simply visit http://<YourSharePointSite>/_catalogs/users/simple.aspx or details.aspx.

Continue reading “User Information in SharePoint Foundation”

SharePoint products and technologies configuration wizard cannot connect to the database server

Scott ZischerkAfter installing SharePoint 2010 SP1 with the June CU on a clients server.  I ran the SharePoint 2010 Products Configuration Wizard like I always do and I got an error that said that it couldn’t connect to the database.  The Actual message from the PSConfig log was:

Continue reading “SharePoint products and technologies configuration wizard cannot connect to the database server”

Dual Login Method for Sharepoint

Mike BerrymanI recently had a client with a unique situation regarding logging in to their Sharepoint environment.  Without going into too much boring detail, the bottom line was the client needed to allow their Active Directory users to log in to a Sharepoint site that only used Forms-Based Authentication.  (Sidenote: If you’re truly curious, the Sharepoint site itself wasn’t actively denying people using windows credentials.  The problem was that the browser the client’s AD users were using to access this particular Sharepoint site didn’t play well with windows credentials).

Continue reading “Dual Login Method for Sharepoint”

Migrating Sharepoint 2007 Lists to 2010

Mike BerrymanUpgrading custom web parts from Sharepoint 2007 to Sharepoint 2010 can be an iffy prospect at best, but I recently ran into situation I had yet to encounter while doing such an update.  I had a web part that used a few custom lists to both configure and control the web part and capture user input.  While the web part itself was actually quite easy to get working in 2010 (when does that ever happen?), the lists posed a problem.

Continue reading “Migrating Sharepoint 2007 Lists to 2010”