SharePoint Development Blog

Nick Boumans
View my LinkedIn Profile Follow me on Twitter View my Profile on FaceBook View my projects on CodePlex View my presentations on SlideShare



Recent posts

Tags

Categories

Navigation

Pages

Archive

Blogroll

Disclaimer

The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

Create Master Detail View of Custom Lists using WebPart Connections

Sometimes you want to have to lists, if you click on a record in the one list (e.g. name), you want details about that record (e.g. hollidays from that specific person). One of the options is to use Out of the Box WebPart Connections in SharePoint to realize this.

First I created two custom lists with the follow coloumns:

Custom List: Employees

Custom List: Holliday

  1. Next step is to pass this to lists on a webpart page. With the employee list webpart on top.
  2. Select Modify Shared WebPart (of the employeelist webpart) > WebPart Connections > Provide Row To > Holliday

In the next screen choose "Last Name"

Now you can select a row from the top (employee) tabel you get details in the bottom (holliday) table

Posted: Jun 23 2010, 20:41 by Nick Boumans | Comments (0) RSS comment feed |
  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5
Filed under: SharePoint General

How to get Excel and Powerpoint Button under New Button in SharePoint Document Library

Best you can do this at your top level site (=Site Collection to modify it on all subsites).

  1. Go to Settings > Document Library Settings > Advanced Settings
  2. Set "Allow management of content types" to Yes
  3. Go back to the Document Library Settings
  4. Add a new content type by
  5. Site Actions > Site Settings > Galleries > Site Content Types
  6. Create new content type as in the following image

 

  1. Go to Settings > Document Library Settings
  2. In the section Content types select: "Add from existing site content types"
  3. Select your Excel Site Content Type (which you just created)
  4. Modify the URL of an existing document template by:
  5. Site Settings > Site Content Type > Advanced Settings of the new content type
  6. Create an empty excel and powerpoint file on your desktop.
  7. Give this files the names: template.xls and tempate.ppt
  8. Upload a new document template:
  9. Select template.xls or .ppt (depending the content type you’re creating).

Do the same for powerpoint. Your document library new settings would look like:

Posted: Jun 22 2010, 21:30 by Nick Boumans | Comments (0) RSS comment feed |
  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5
Filed under: Office | SharePoint General

Hide Items in a List View older then a specific date

Sometimes you don't want to delete old files in a document library / list but don't want to show them to the user (because you only want to show up to date items).

You can specify this in the View (Modify Shared Web Part / Modify this View or Modify this View in a Listview) and then navigate to the section filter. If you only want to show items created in the last 30 days (= hide older items then 30 days / one month). You have to apply the following filter:

Note that you can change the numer to your own days.

Posted: Jun 15 2010, 21:35 by Nick Boumans | Comments (0) RSS comment feed |
  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5
Filed under: SharePoint General

Missing settings ak menu items in SharePoint 2007 Site Actions Menu

After a SharePoint update (Cummulative Update) I was facing problems with my Site Actions Button. I missed some items as: create and site settings. It was not a security issue since I could load the pages manually by typing the url (e.g. /_layouts/settings.aspx) and I'm in the role of Site Collection Administration.

I faced that my sitecollection was made readonly. This issue could be solved by code or by stsadm.exe

You can change it via code:

Microsoft.SharePoint.Administration.SPSiteAdministration siteAdministration = new SPSiteAdministration(siteCollectionUrl);
siteAdministration.ReadOnly = true;
siteAdministration.Dispose();

Or to remove all locks to the site via STSADM:

stsadm -o setsitelock -url http://servername -lock none
Posted: Jun 01 2010, 18:40 by Nick Boumans | Comments (0) RSS comment feed |
  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5
Filed under: SharePoint General

2010 Information Worker Demonstration and Evaluation Virtual Machine

 Brief Description
This download contains a two Windows Server 2008 R2 Hyper-V Virtual Machine set for evaluating and demonstrating Office 2010, SharePoint 2010 and Project Server 2010.

Overview

Virtual machine “a” contains the following pre-configured software:

  1. Windows Server 2008 R2 Standard Evaluation Edition x64, running as an Active Directory Domain Controller for the “CONTOSO.COM” domain with DNS and WINS
  2. Microsoft SQL Server 2008 R2 Enterprise Edition with Analysis, Notification, and Reporting Services
  3. Microsoft Office Communication Server 2007 R2
  4. Microsoft Visual Studio 2010
  5. Microsoft SharePoint Server 2010 Enterprise Edition
  6. Microsoft Office Web Applications
  7. Microsoft FAST Search for SharePoint 2010
  8. Microsoft Project Server 2010
  9. Microsoft Office Professional Plus 2010
  10. Microsoft Visio 2010
  11. Microsoft Project 2010
  12. Microsoft Office Communicator 2007 R2


Virtual machine “b” contains the following pre-configured software:
  1. Windows Server 2008 R2 Standard Evaluation Edition x64, joined to the “CONTOSO.COM” domain
  2. Microsoft Exchange Server 2010

Active directory has been preconfigured over 200 “demo” users with metadata in an organizational structure. All of these user profiles have been imported and indexed for search within SharePoint Server 2010.

SharePoint Server 2010 has been configured in a “Complete” farm using the default SQL Server 2008 R2 instance. A default site has been created using the Team Site template at http://intranet.contoso.com/ and a FAST Search Center at http://intranet.contoso.com/search/.

As shipped virtual machine “a” requires image “b” for email. Running image "b" is optional.

Download Link: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=751fa0d1-356c-4002-9c60-d539896c66ce

Posted: May 10 2010, 21:54 by Nick Boumans | Comments (0) RSS comment feed |
  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Use a People Picker Control in InfoPath 2007

Default there's no People Picker control in InfoPath, however you can get a People Picker control, even in browser mode.
There is a Active-X control which takes care of the part named "Contact Selector Control".

Add Contact Selector to Controls Pane

  1. On the bottom choose "Add or Remove Custom Controls"
  2. Click "ADD"
  3. Select Active-X
  4. Select "Contact Selector", click Next
  5. Select don't include a .cab file
  6. From the dropdown field select "Field or Group (any data type)
  7. Click Finish

DataSource for the Contact Selector control

  1. Add non Repeating group named "group1"
  2. Add a repeating Group names "Person"
  3. Add following test field to the "Person" group (DisplayName, AccountId, AccountType)

Add Secondary datasource XMl file with details about the SharePoint Server, this is required by the form in order to validate the user against a particular sharepoint server.

  1. Open Notepad and add the following Tag <Context siteUrl="http://<servername>"/>
  2. Save the file as Context.xml (! Case Sensitive !)
  3. Add new connection as "Receive Type" and source of data as "XML"
  4. Option “Include the data as a resource file” shoule be enabled

Do you want to use more then one people picker in your form?

  1. Create a new group for the new contact
  2. Right click on the exiting Person group
  3. Click reference and point it to the new group
  4. That will copy the person xml structure under the new one
Posted: May 09 2010, 13:45 by Nick Boumans | Comments (0) RSS comment feed |
  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Visited Image Hyperlink in HTML has olive color border in some browsers

In a SharePoint page I noticed the following: 

If you use an image as an hyperlink it could be that your browsers shows an olive (purple) color border around it after it is visited. You can solve it by defining the attribute border="0" in the image tag:

<A HREF="http://www.google.com">Google link<IMG SRC="google.png" ALIGN="BOTTOM" BORDER="0" WIDTH="200" HEIGHT="50"></A>
Posted: Feb 21 2010, 18:00 by Nick Boumans | Comments (0) RSS comment feed |
  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5
Filed under: SharePoint General

Adding and Deploying Solutions with PowerShell in SharePoint 2010

Visual Studio 2010 makes it really easy to add and deploy solutions when you are developing (the F5 experience), but you may eventually want to deploy those solution packages elsewhere then on your development machine. We can still use the stsadm tool, but that is effectively considered deprecated now in favor of PowerShell.

To get started with PowerShell, run the SharePoint 2010 Management Console located in your Microsoft SharePoint 2010 Products folder on your start menu. This automatically loads the Microsoft.SharePoint.PowerShell snappin so that we can execute SharePoint commands.

 


[code:xml]


Add-SPSolution c:\codefolder\SharePointSolution.wsp
Install-SPSolution –Identity SharePointSolution.wsp –WebApplication http://yoursharepointurl -GACDeployment
Update-SPSolution –Identity SharePointSolution.wsp –LiteralPath  c:\codefolder\SharePointSolution.wsp –GACDeployment
Uninstall-SPSolution –Identity SharePointSolution.wsp –WebApplication http://yoursharepointurl
Remove-SPSolution –Identity SharePointSolution.wsp

Also cool is getting your SharePoint version by using Powershell

function global:Get-SPFarm
{
       return [Microsoft.SharePoint.Administration.SPFarm]::Local
}
$farm = Get-SPFarm
$farm.BuildVersion

The result looks like

Major  Minor  Build  Revision
-----  -----  -----  --------
14     0      4536   1000
Posted: Dec 30 2009, 12:32 by Nick Boumans | Comments (0) RSS comment feed |
  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Developing SharePoint Solutions using Visual Studio 2010

On MSDN you can read about SharePoint 2010 Development walk-throughs: http://msdn.microsoft.com/en-us/library/ee231593%28VS.100%29.aspx

Visual Studio 2010 beta 2 SharePoint Development Samples: http://code.msdn.microsoft.com/Release/ProjectReleases.aspx?ProjectName=SharePointDev2010&ReleaseId=3346

 

Posted: Dec 24 2009, 13:54 by Nick Boumans | Comments (0) RSS comment feed |
  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Sharepoint 2010 Beta Developer Training Kit

"The SharePoint 2010 Beta Developer Training Kit provides developers with deep guidance on how to develop for SharePoint 2010. Through PowerPoint decks, Hands-On Labs, Source Code, and Instructor-Led Videos, the developer kit walks you through an array of important developer topics--including Developer Roadmap, Visual Studio tooling, Workflow, Business Connectivity Services, and much, much more."
  • Supported Operating Systems: Windows 7; Windows Server 2008 R2

To use the guidance properly, you'll need to have SharePoint Server 2010 Beta and Visual Studio 2010 Beta installed on a Windows operating system. Supported Operating Systems: Windows Server 2008 R2 (64 bit) and Windows 7 (64 bit).

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=bfd1603b-7550-4b8e-be85-4215a5069b90

Posted: Dec 22 2009, 14:57 by Nick Boumans | Comments (0) RSS comment feed |
  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5