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
-
Next step is to pass this to lists on a webpart page. With the employee list webpart on top.
-
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
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).
-
Go to Settings > Document Library Settings > Advanced Settings
-
Set "Allow management of content types" to Yes
-
Go back to the Document Library Settings
-
Add a new content type by
-
Site Actions > Site Settings > Galleries > Site Content Types
-
Create new content type as in the following image
- Go to Settings > Document Library Settings
- In the section Content types select: "Add from existing site content types"
- Select your Excel Site Content Type (which you just created)
- Modify the URL of an existing document template by:
- Site Settings > Site Content Type > Advanced Settings of the new content type
- Create an empty excel and powerpoint file on your desktop.
- Give this files the names: template.xls and tempate.ppt
- Upload a new document template:
- 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:
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.
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
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:
- Windows Server 2008 R2 Standard Evaluation Edition x64, running as an Active Directory Domain Controller for the “CONTOSO.COM” domain with DNS and WINS
- Microsoft SQL Server 2008 R2 Enterprise Edition with Analysis, Notification, and Reporting Services
- Microsoft Office Communication Server 2007 R2
- Microsoft Visual Studio 2010
- Microsoft SharePoint Server 2010 Enterprise Edition
- Microsoft Office Web Applications
- Microsoft FAST Search for SharePoint 2010
- Microsoft Project Server 2010
- Microsoft Office Professional Plus 2010
- Microsoft Visio 2010
- Microsoft Project 2010
- Microsoft Office Communicator 2007 R2
Virtual machine “b” contains the following pre-configured software:
- Windows Server 2008 R2 Standard Evaluation Edition x64, joined to the “CONTOSO.COM” domain
- 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
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
-
On the bottom choose "Add or Remove Custom Controls"
-
Click "ADD"
-
Select Active-X
-
Select "Contact Selector", click Next
-
Select don't include a .cab file
-
From the dropdown field select "Field or Group (any data type)
-
Click Finish
DataSource for the Contact Selector control
-
Add non Repeating group named "group1"
-
Add a repeating Group names "Person"
-
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.
-
-
Save the file as Context.xml (! Case Sensitive !)
-
Add new connection as "Receive Type" and source of data as "XML"
-
Option “Include the data as a resource file” shoule be enabled
Do you want to use more then one people picker in your form?
-
Create a new group for the new contact
-
Right click on the exiting Person group
-
Click reference and point it to the new group
-
That will copy the person xml structure under the new one
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>
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
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
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