Friday, February 27, 2009
Custom Cross-Site Lookup Column Add-On
Wednesday, February 25, 2009
Incorporating a Master Page into a SharePoint site definition
Tuesday, February 24, 2009
Information Rights Management with SharePoint
Implementing IRM security in SharePoint Products and Technologies requires additional software that is not shipped with either Windows SharePoint Server 3.0 or Office SharePoint Server 2007. You must install the Microsoft Windows Rights Management Services Client, version 1, on every Web front-end server in your server farm. In addition,Microsoft Windows Rights Management Services (RMS) for Microsoft Windows Server® 2003, service pack 1.0 or later, must be available on your network.
You can implement IRM on document libraries. When IRM is enabled on a document library, and a document of a type that can be rights-managed is downloaded from the server to a client application, the SharePoint Products and Technologies server encrypts the document and adds an issuance license. When the document is uploaded back to the server, the SharePoint Products and Technologies server decrypts the file and stores it in the library in unencrypted form, as content is not encrypted in the SQL Server database. This enables features such as search and indexing to operate as usual on the files in the IRM-protected document library. The IRM permissions that are applied to a document when users upload it to a document library are based on each user's permissions for the content in the SharePoint Products and Technologies server security settings.
Microsoft Windows SharePoint Services 3.0 does not have the Microsoft® Office protector files that are required to automatically rights-protect a document when it is uploaded. You must use Office SharePoint Server 2007 to do this. More...
IRM Framework Architecture in Windows SharePoint Services
MOSS2007 and IRM – Step by Step Part 1
MOSS2007 and IRM – Step by Step Part 2
How do you apply IRM to a SharePoint List or Library?
Plan Information Rights Management
Video: IRM Use with SharePoint and Office
BDC Column for SharePoint List
This custom column type provides a BDC Column type that can be created at the Site Column level and therefore used in Site Content Types. Out of the box this is not possible, and the ability to reuse BDC columns across sites and content has been identified as a common requirement. At this stage there are a number of things that are not yet implemented, including related fields, refreshing and nicer admin UI. Read more...
You can download the WSP from here...
Monday, February 23, 2009
SharePoint Web Part for Google Search
Here I found one link which help to implement Google Search within your SharePoint site.
Friday, February 20, 2009
Guidline to Create a MOSS 2007 VPC image
Controlling publishing features from onet.xml
Custom site definition for Publishing site
Displaying SharePoint Fields by Permission Level
There are situations where certain fields in lists or libraries need to be hidden or displayed according to the permission level of the logged in user. Since there is really no out-of-box way to assign permissions to fields, here’s a way to do it using conditional formatting in SharePoint Designer. This is my favorite SP Designer trick.
How to Display Multiple Document Libraries?
And here is the answer to that...
Alerts Based on Views
This applies to any SharePoint document library or list (contacts, calendars, tasks, etc.). The following example will include how this is done on a document library with custom fields.
This applies to any SharePoint document library or list (contacts, calendars, tasks, etc.). The following example will include how this is done on a document library with custom fields.
Example Case
- An example hospital has different floors on their hospital. They have created a new field in the Patient Admissions list called “Floor”. Users are given a drop-down box of options for what floor a patient is admitted to. Users would like to know if they can set up Patient Admissions list alerts so that they are only notified when patients are admitted to THEIR floor. SURE THEY CAN!
- First, the appropriate VIEWS need to be created, one for each “floor”. Create 4 new views for: 1 North, 1 South, 2 North, 2 South
- The first view will have a filter of: Show the items when column Floor is equal to 1 NorthCreate the other 3 views with filtering for each of their appropriate floor names
Creating the Alerts.
- On the Patient Admissions list, click
and choose - In the Send alerts for these changes section, choose the very last option called “Someone changes an item that appears in the following view”
- Then, in the drop-down box for that option, choose the name of the floor for which you’d like to receive alerts.
- In summary, any data in any field of your list can be filtered into a View. Alerts can be created based on any *filtered* view, even “Personal” views.
Oh, and another good way to use this feature would be on an Announcements list. Each announcement would have a category, such as the department that the announcement is targeted to. Create a view for each category. This way, your users can set up their own alerts on the announcements list, and choose to only be alerted when a new one is added for their department.
The Best Workflow Tutorials
http://office.microsoft.com/en-us/sharepointdesigner/HA102564171033.aspx
Then, just recently, by popular demand, he posted all of the associated files that he used in his demo!!
http://blogs.msdn.com/sharepointdesigner/archive/2009/01/27/visio-diagram-and-site-template-from-office-online-workflow-videos.aspx
It might take half a day, but I recommend that you go through all of his tutorials when you get a chance.
Thursday, February 19, 2009
Best Practices: Using Disposable Windows SharePoint Services Objects
Applies to: Windows SharePoint Services 3.0, Windows SharePoint Services 2.0, Microsoft Office SharePoint Server 2007, Microsoft Office SharePoint Portal Server 2003
Contents
Introduction to Using Disposable Windows SharePoint Services Objects
Finding Incorrectly Disposed Objects
Coding Techniques
SPSite Objects
SPWeb Objects
Other Objects That Require Disposal
Conclusion
Additional Resources
Best Practices: Common Coding Issues When Using the SharePoint Object Model
Contents
Overview
Using SharePoint Data and Objects Efficiently
Working with Folders and Lists
Writing Applications that Scale to Large Numbers of Users
Using SPQuery Objects
Using Web Controls
Creating Timer Jobs
Conclusion
Additional Resources
Wednesday, February 18, 2009
SharePoint Developer Tips & Tricks
All XML files, or just about every XML file I've run across so far, in Windows SharePoint Services (WSS) v3 & Mirosoft Office SharePoint Server (MOSS) 2007 is validated by SharePoint using the WSS schema file found in the 12 hive: %12HIVE%/TEMPLATES/XML/wss.xsd.
Adding an XML Schema To a Specific File In Visual Studio 2005I think it is fairly common knowledge to most developers that you can specify an XML schema for a specific file in Visual Studio. To do this, when you have the XML file open, go to the Properties toolpane and click on the ellipses for the Schema field select the Add button in the XSD Schemas dialog, browse to the wss.xsd file in the 12 hive (location listed above) and OK out of the dialogs. Click to learn more...
Tip #2: Add Command Line Shortcut to "12 Hive"
I'm not talking about creating a shortcut to the 12 Hive (the directory where just about everything WSS v3 is installed) on your desktop/Quick Launch. Like most people, I create a "12" toolbar on my Start Menu (as shown in the image to the right)... not talking about that either.
When you're in a command prompt, sometimes you need to navigate to the 12 Hive directory. But no one wants to type the directory path to c:\Program Files\Common Files\Microsoft Shared\web server extensions\12. Wouldn't it be easier if you could just type the following to get there?
c:\>cd\c:\>cd %12hive%c:\Program Files\Common Files\Microsoft Shared\web server extensions\12
Here's how u can achieve that:
1. Create a new file called SharePointCommandPrompt.cmd and insert the following text in it (if you're on a 64 bit system, you'll want to make the appropriate changes): @echo offecho Setting 12HIVE environment variable.set 12HIVE="C:\Program Files\Common Files\Microsoft Shared\web server extensions\12""C:\Program Files\Microsoft Visual Studio 8\VC\vcvarsall.bat" x86
2. After saving the file, create a new shortcut with the following target: %comspec% /k ""c:\[Path To The File You Just Created]\SharePointCommandPrompt.cmd""
3. To put a cherry on top, drag the shortcut onto your Quick Launch toolbar... should work like a champ!
To try it out, click the shortcut and type CD %12HIVE% at the command prompt. You should change directories to the root of the 12 Hive.
Tip #3: Access STSADM.EXE From any Directory in a Command Prompt
STSADM.EXE, the main administration utility for SharePoint, is still just a command line utility. You'll find it in %12HIVE%\BIN. To run it, you have to actually be in that directory... an inconvenience to me! Instead, add the directory to the PATH environment variable so you can type STSADM.EXE from any directory on your system. To do this:
1. Start -> All Programs -> Control Panel -> System
2. On the Advanced tab, click the Environment Variables button.
3. Select the variable Path and click the Edit button.
4. Add the following to the end of the Variable value field (don't forget the semicolon... the Path environment variable is a semicolon delimited string of directories):;C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN
5. OK out of all the dialogs.
Next time your system restarts, you'll be able to type STSADM.EXE at a command prompt from any directory on your system.
Tip #4: Overcome Save Site Template size limitation in SharePoint
Once I was working with a client and they mentioned that they were trying to save a site template and move it to another server while retaining the content but the size of the site prohibited this. By default there is a 10MB size limitation built in. Something clicked in my head because I recently found a fix that will increase the size limitation to whatever value you want to make it. Type the following using the STSADM utility
stsadm -o setproperty -propertyname max-template-document-size -propertyvalue 50000000
I think its pretty self explanatory with what you can do here… if you have a site that is in excess of 50MB you will use 75000000 or whatever number you come up with. But this is not the recommended practice by Microsoft.
Tuesday, February 17, 2009
Working with Reporting Services Using Microsoft Sharepoint
Monday, February 16, 2009
SharePoint 2007 Maximum Limitations
Workaround for Lookup field in SharePoint list templates
Todd Bleeker has posted a cool workaround for this issue that can be used on a singular basis (it is not for solving this problem with custom created list definitions). Thanks Todd!
FULL POST HERE
01. Browse to the source Web's lookup list and choose Modify settings and columns.
02. Copy the source lookup list GUID from the URL.
03. Browse to the destination Web's lookup list and choose Modify settings and columns.
04. Copy the destination lookup list GUID from the URL.
05. Save the source Web's list that contains a lookup column to the lookup list as a list template called [yourlist].stp.
06. Export the list template STP from the source list template gallery to the file system.
07. Rename the [yourlist].stp file to [yourlist].cab so Windows can open it.
08. Open the file, right click on the manifest.xml file and export it to
the file system.
09. Edit the manifest.xml file; find the source Web's lookup list GUID and replace it with the destination Web's lookup list GUID.
10. Save the manifest.xml file.
11. Open a VS.NET command prompt.
12. Run the makecab command as follows:
makecab manifest.xml [yourlist].stp
13. Import the new STP into the destination Web's list template gallery. You will need to delete it if it has previously been imported.
14. Create a new list based upon the new STP file.
The lookup column on the new list should retain all the data that was in
the source list.
Trend Reporting Against a SharePoint List
To meet this requirement I knew that we had to create a 'snapshot' record on a regular basis, which would be completed by individual project managers. Some information would need to be recorded each week, with one variable field - the Forecast Date.
Hide/Show Navigation Panel on SharePoint Site
Lot many time User will ask you: I never use that, can’t you just hide it?
Using JQuery, you can reply: Others may need it. I’ll give you check boxes to turn it on and off.
PreSaveAction to EditForm.aspx
Data View WebPart example
Pat Iovanella has provided very nice example on that
Email and SharePoint Designer Workflow
Like many things with SharePoint Designer workflow, this is relatively easy to accomplish, but is sometimes harder than it would seem. In this article two tricky scenarios were addressed
Porting WorkFlow from One List to Another List
Every first-time SharePoint Designer workflow author faces this problem:
Design a workflow solution.Create a new workflow solution.Test it.Gain user acceptance and sign off.
At this point, everything is going swimmingly until it’s time to … 5. Move to production … full stop.Today, there is no End User friendly way to move a functioning SharePoint Designer workflow solution from
Porting a Simple SharePoint Designer Workflow One List to AnotherOverviewThis tutorial style article describes how to port a SharePoint Designer workflow from one list to another. It assumes a business case where we want to move a dead simple workflow from a development environment to a production
Searching Site Collections Using a Tabbed Search Center
Since this is a project needed to accomplish within his organization, Chris Quick had documented the steps as he complete them himself!
Employee of The Day Slide Show
The requirement I came across is showing the employees on the portal's home page.
We found the easy steps to do that.
- Convert each slide to a .jpg image (can be done very easily using PowerPoint 2007)
- Create a Picture Library named ‘Meet the Team’
- Upload the images to the ‘Meet the Team’ library
- Move to the page where you would like the slide show link created
- Insert the ‘This Week in Pictures’ web part onto the page
- Modify the Shared Web Part
- Change Image Library Name from “This Week in Pictures Library” to “Meet the Team”
Customized views of a SharePoint Survey
Dynamic Loading of Content on Mouse Hover
If you have SPD, you can make your own simple ASPX pages then link to them so you can load them dynamically in your pages. The possibilities are endless, have fun with this one!
Click “Read more” for setup instructions and the code sample…
Display Preview Pane for Calendar View
Many of our basic “tools” are missing from the Calendar View. The preview pane works great on other lists, so this little ditty gives you one for the Calendar too.
To make this work, place the Calendar in a large Web Part Zone–large enough to display the Calendar View, edit the view on the web part (it will default to a list). Place this code snipped in a Content Editor Web Part to the side, in the smaller zone.
How to Display SharePoint Blog Post Archives
Please note that it only works with the default SharePoint Blog site template.
Sunday, February 15, 2009
Accordion-style left navigation menu for SharePoint Sites
First, look at your left nav. If you changed it from the out-of-the-box setup, make sure you have “headers” and “submenus” that make sense. Click to get the more idea on this...
Visual Indicators for the Masses: KPIs in WSS
All of us must measure something in order to see if we are meeting our goals. They can be financial goals, customer satisfaction goals, or amount of work done measurements. KPIs (Key Performance Indicators) are a way to quickly gauge how you are doing, not by having to go through and analyze measurements through a spreadsheet, but through some simple visual indicators.
Putting KPIs into your dashboard allows you and your team to get an immediate view into how you are doing on your goals and measurements.
SharePoint comes with really cool web parts for presenting key performance indicators, but these are only available in the Enterprise edition. If you are running Windows SharePoint Services or SharePoint Server Standard, it is not available.
The only limitation of this concept is that you can only build KPIs on top of data stored in SharePoint lists.
Improving the SharePoint print experience
While moving the digital version of a page to its paper equivalent, important information is not accessible to the print job. Luckily you can quite easily provide your visitors with a richer printing experience using no more than a couple of lines of JavaScript. Click to find the answer how???
List the time range of an event in a Calendar
This solution: Create a calculated column to display as ‘Month View Title’:
List View Web Parts with File Size
Friday, February 13, 2009
Implement MAP using SharePoint List
Example of how we can implement MAP using SharePoint Lits
How to build same page?
Some more help on this...
Option-2
Using this web part you can display points and locations on a Google map and get directions to an from that point. You can either manually enter an individual point or select a list from your Sharepoint site that holds the information that is required - ie. a field for the Buidling Name, its Longitude and its Lattitude.
Implement MSN Live Search for SharePoint site
The first thing is to sign up an Application ID for and download the SDK from http://search.msn.com/developer/default.aspx?FORM=PDDD2
Create Chart from SharePoint List Data
For a small demo you can also visit http://www.wssdemo.com/Pages/graph.aspx
How to Resize the Web Part
Integrating External Document Repositories with SharePoint Server 2007
SCOT HILLIER's article on MSDN
A Quicker Way to Create Custom SharePoint List Templates
Thursday, February 12, 2009
Poadcasting Toolkit for SharePoint
Announcing open source Podcasting Kit for SharePoint - the power of social media for the enterprise
Visit GetSharp, 3Sharp’s external implementation of PKS to see a live site in action
Download PKS for free at Codeplex
WSRP for SharePoint
The WSRP Toolkit for SharePoint consists of the following assets:
Visual Studio sample projects that demonstrate two different approaches to producing WSRP conformant output from SharePoint lists and libraries
A whitepaper that provides details on the different architectural approaches of the two WSRP producer samples
Screen casts showing the two WSRP producer samples in action
The Toolkit demonstrates two possible methods of exposing SharePoint data through the WSRP interface and is intended to provide a starting point for customers who are interested in surfacing SharePoint data in non Microsoft portal environments. The first method focuses on maintaining high fidelity with the SharePoint user interface and the second method focuses on providing flexibility and control over the rendered output. We are releasing the source code for the two methods under the Microsoft Public License (Ms-PL), allowing developers to customize the solution to meet their specific requirements.
Organisation Chart or My Site in SharePoint
A very good presentation is also available which help you to understand how MySite works.
Converting ASP.NET site to SharePoint
http://www.codeproject.com/KB/sharepoint/ASPNET_to_Sharepoint.aspx
Insert Data into SharePoint List with Lookup column
Click Here to find out the answer :)
There is an adapter of SharePoint List for SSIS is also available.
If you don't want to go with adapter this is the way how you can create your own SSIS pacakage. Only drawback is it is not talking about inserting data in to lookup columns.
There is one tool also available who can help you in data migration from Database to SharePoint Lists. Data-Synchronisation-Studio
In addition, here is a good blog to describe how to use BDC to connect to Oracle Databases
User Control in SharePoint
But you can also build a web part that load a UserControl yourself
Using ASP.NET 2.0 code behind in SharePoint
Andrew Connell again...
Videos for SharePoint
Visual How Tos
SharePoint Screencasts
Video on Demand from EndUserSharePoint
How Do I ScreenCast
Anonymous user can Search on Public Site
Anyway, the problem is with OSSSearchResults.aspx page, specifically with one of the inheritance reference that ASPX page. I’m talking about the part of the code that sets the inheritance of the page from the generic application page base class, which is not really required for this page to function properly.
To allow anonymous users to search your publicly available sites you need to remove that inheritance from the code, so find part of the code inside the
Making those changes will not only allow anonymous users to search the SharePoint content, but also will keep the SharePoint search secure, meaning that anonymous users will only be able to search the part of the SharePoint they have permissions to view.
Dual Authentication for SharePoint
This is the first article I read on Andrew Connell's blog and after that I never stop following him.
Comperision on MOSS-2007 Vs. WSS 3.0
Multilingual site in SharePoint
I came across one editor as well which will help you for SharePoint Variations.
Site Collection in SharePoint
Customizing Search Result
What is Feature Stapling in SharePoint
Six-part series on ASP.NET Master Pages and SharePoint
A six-part series on getting the most out of SharePoint Designer 2007
http://office.microsoft.com/en-us/help/HA102199841033.aspx
I also found a good article on SharePoint Designer here...
Everything You Need to Know about BDC
This is one of the good article I found on SharePoint Magazine. This article containing 8 parts. I am listing 5 out of 8 as others are still not published.
Part 1, BDC Technical Architecture
Part 2, Application Definition File (ADF) and its Development
Part 3, Developing an ADF to Connect to Web Services
Part 4, Using BDC Web Parts to Consume BDC Data and Embedding BDC Data in Lists
Part 5, configure Enterprise Search to crawl BDC data.
Part 6, importing User Profiles from BDC
Part 7, BDC Object Model
How you can Connect Lookup Fields?
http://blogs.msdn.com/leonidly/archive/2007/06/24/connected-lookup-field.aspx
Connected Lookup Code