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:
Installing VPC Additions in a Win7 Guest operating system using VPC 2007
Sometimes (for however what reason) it could be possible that you can't install VPC 2007 SP1 (for example it's possible that you're not a local admin en your company doesn't allow to install VPC 2007 SP1. So you have to work without the Service Pack.
If you Install a Windows 7 Guest Operating System in VPC 2007 you could have some compatibility issues installing the Virtual Machine Additions.
By trying to install the additions you got the following message:
You could solve this issue by fixing the compatibility issue or remove the check. Fixing the issue could only by installing VPC SP1. Since this is inpossible we gonna disable the compatibility assistant.
- Run GPEdit.msc
- This should open the Local Group Policy Editor
- In the tree (on the left) select Local Computer Policy then
Computer Configuration, Administrative
Templates, Windows Components and finally
Application Compatibility
- Locate the entry for Turn off Application Compatibility
Engine and double click on it
- Select the Enabled radio button and then click
OK
- Next locate the entry for Turn off Program Compatibility Assistant
and double click on it
- Select the Enabled radio button and then click
OK
You should now have something that looks like this:
Now you will need to reboot your computer (forcing a group policy update is
not enough in this case (gpupdate /force doesn't work)).
Before moving on I would like to quickly discuss exactly what the impact
of these policy changes are:
- Disabling the Program Compatibility Assistant means that Windows will no
longer tell you when you are about to run a program with known compatibility
problems. It will just sit by quietly and let you try (and most likely
fail).
- Disabling the Application Compatibility Engine means that Windows will
no longer try to correct known compatibility issues. This means that there may
be programs that were working before that start failing – because Windows is no
longer fixing things up for them.
So the summary is that you should really only do this if you are running
a limited set of applications and can confirm that they all can run with the
application compatibility engine disabled.
Once the computer (VPC Image) has rebooted you should be able to run the Virtual Machine additions
installer with no problems.
Note: By using this trick I sometimes have problems by copy - pasting from the clipboard. However, this is better than no virtual machine additions.
Microsoft SharePoint Connections 2010 Autumn The Hague
Block your agenda for 28th and 29th of September for the Microsoft SharePoint Connections 2010, at World Forum, The Hague
Leading SharePoint experts from Microsoft and from the field have teamed up to bring to you the knowledge you need to succeed with SharePoint 2010.
Here is a sample of topics that we'll cover at SharePoint Connections:
- Upgrade & Deployment
- Upgrade Tips and Tricks
- Enterprise & Web Content Management
- LINQ
- Azure
- Business Connectivity Services
- Silverlight
- Workflow
- Communities and Social Networking
- Enterprise Search
- Business Intelligence
- Security
- Claims Based Authentication
- Virtualization
- Scalability
- Governance
- PowerShell
- PowerPivot
- Client Object Model
- Migration Tips and Tricks
Online Registration: http://sharepoint.msregistration.com/reg
http://www.devconnections.com/speurope/
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.
Windows 2008 R2 Server tweaks for your development machine
Configure Shutdown Event Tracker on the Local Computer
Source: MSDN
When Shutdown Event Tracker is enabled, users cannot shut down or restart the computer without providing a reason. If the computer is shut down or restarted unexpectedly, either as a result of power interruption or hardware failure, the first member of the local Users group to log in after the restart is prompted to enter a reason in Shutdown Event Tracker.
Shutdown Event Tracker can be enabled on the local computer by editing the local computer's Group Policy settings.
Membership in the local Administrators group, or equivalent, is the minimum required to complete this procedure.
To enable Shutdown Event Tracker in Group Policy
-
Click Start, click in the Search (or run) box, and type gpedit.msc.
-
The Group Policy Object Editor dialog box appears.
-
In the Local Computer Policy navigation pane, expand Computer Configuration, expand Administrative Templates, and click System.
-
In the console pane, scroll down to the list of objects (almost at the bottom?), right-click Display Shutdown Event Tracker, and click Properties.
-
On the Settings tab, click Enabled.
-
In the drop-down box, click Always, and then click OK.
Before:
After:
Disable Internet Explorer Enhanced Security Configuration (IE ESC)
- Open the Server Manager
- Scroll down to the Security Information Section and click "Configure IE ESC".
- You can turn off IE ESC for Administrators and/or for users.
Turn on Wireless Feature
By default the Wireless LAN service is disabled and turned off. In order to turn on Wireless LAN and WLAN AutoConfig service:
- Open the Service Manager (in administrative tools)
- Go to the features branch and click on Add Features
- Click and tick the check box for Wireless LAN Service.
- Complete the installation wizard to install wireless support.
Create a VHD in Windows 7 and Boot from it - Install windows 2008 R2 on VHD
Creating and booting from VHD's in Windows 7 is a really cool feature of the Windows 7 operating system. However it is possible to install SharePoint 2010 on Windows 7, installing it on a VHD has some pro's. One of it is, that you can easily backup a vhd and run it from another PC.
To Create and boot a VHD (and install Windows 2008 R2):
-
In Windows 7 go to Start > Computer (right click) > Computer Management
-
Right Click Disk Management > Create VHD and follow the wizard
-
-
To install Windows 2008 R2 on the created VHD:
-
Boot from your Windows installation DVD
-
When first installation dialog box appears pres SHIFT + F10 to open command prompt
-
Type diskpart (in command prompt)
-
Next, run select vdisk file=d:\yourvhdname.vhd
-
Run attach vdisk
-
Exit from diskpart and command prompt (type exit)
- Your vhd disk will be visible and Windows could be installed on this location
- After installation you have the choice (boot menu) to launch Windows 7 or your new installed Windows 2008
Install other software (e.g. SharePoint 2010) on your VHD partition (after booting Windows 2008) and you have a great development / demo environment!
Happy Coding!
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