Thursday, April 23, 2009

SharePoint Facts, Top 10 Benefits of Moss

 SharePoint is the fastest-growing product in the history of Microsoft
• Over 75 million licenses of SharePoint have been sold worldwide
• SharePoint is listed, by Forrester, as the number 1 portal product
• SharePoint is positioned as a leader within the Gartner Magic Quadrant for Horizontal Portals products
• Over 400 case studies have been published on SharePoint

Microsoft Office SharePoint Server 2007 Top 10 Benefits

Provide a simple, familiar, and consistent user experience.

Office SharePoint Server 2007 is tightly integrated with familiar client desktop applications, e-mail, and Web browsers to provide a consistent user experience that simplifies how people interact with content, processes, and business data. This tight integration, coupled with robust out-of-the-box functionality, helps you employ services themselves and facilitates product adoption.

Boost employee productivity by simplifying everyday business activities.

Take advantage of out-of-the-box workflows for initiating, tracking, and reporting common business activities such as document review and approval, issue tracking, and signature collection. You can complete these activities without any coding. Tight integration with familiar client applications, e-mail, and Web browsers provide you with a simple, consistent experience. Modifying and extending these out-of-the-box workflow processes is made easy through tools like Microsoft Office SharePoint Designer 2007 (the next release of Microsoft Office FrontPage).

Help meet regulatory requirements through comprehensive control over content.

By specifying security settings, storage policies, auditing policies, and expiration actions for business records in accordance with compliance regulations, you can help ensure your sensitive business information can be controlled and managed effectively. And you can reduce litigation risk for your organization. Tight integration of Office SharePoint Server 2007 with familiar desktop applications means that policy settings are rendered onto client applications in the Microsoft Office system, making it simpler for employees to be aware of and comply with regulatory requirements.

Effectively manage and repurpose content to gain increased business value.

Business users and content authors can create and submit content for approval and scheduled deployment to intranet or Internet sites. Managing multilingual content is simplified through new document library templates that are specifically designed to maintain a relationship between the original version and different translations of a document.

Simplify organization-wide access to both structured and unstructured information across disparate systems.

Give your users access to business data found in common line-of-business systems like SAP and Siebel through Office SharePoint Server 2007. Users can also create personalized views and interactions with business systems through a browser by dragging configurable back-end connections. Enterprise-wide Managed Document Repositories help your organizations store and organize business documents in one central location.

Connect people with information and expertise.

Enterprise Search in Office SharePoint Server 2007 incorporates business data along with information about documents, people, and Web pages to produce comprehensive, relevant results. Features like duplicate collapsing, spelling correction, and alerts improve the relevance of the results, so you can easily find what you need. 

Accelerate shared business processes across organizational boundaries.

Without coding any custom applications, you can use smart, electronic forms–driven solutions to collect critical business information from customers, partners, and suppliers through a Web browser. Built-in data validation rules help you gather accurate and consistent data that can be directly integrated into back-end systems to avoid redundancy and errors that result from manual data re-entry.

Share business data without divulging sensitive information.

Give your employees access to real-time, interactive Microsoft Office Excel spreadsheets from a Web browser through Excel Services running on Office SharePoint Server 2007. Use these spreadsheets to maintain and efficiently share one central and up-to-date version while helping to protect any proprietary information embedded in the documents (such as financial models).

Enable people to make better-informed decisions by presenting business-critical information in one central location.

Office SharePoint Server 2007 makes it easy to create live, interactive business intelligence (BI) portals that assemble and display business-critical information from disparate sources, using integrated BI capabilities such as dashboards, Web Parts, scorecards, key performance indicators (KPIs), and business data connectivity technologies. Centralized Report Center sites give users a single place for locating the latest reports, spreadsheets, or KPIs.

Provide a single, integrated platform to manage intranet, extranet, and Internet applications across the enterprise.

Office SharePoint Server 2007 is built on an open, scalable architecture, with support for Web services and interoperability standards including XML and Simple Object Access Protocol (SOAP). The server has rich, open application programming interfaces (APIs) and event handlers for lists and documents. These features provide integration with existing systems and the flexibility to incorporate new non-Microsoft IT investments.

Top 10 Benefits of Windows SharePoint Services

Improve team productivity with easy-to-use collaborative tools

Connect people with the information and resources they need. Users can create team workspaces, coordinate calendars, organize documents, and receive important notifications and updates through communication features including announcements and alerts, as well as the new templates for creating blogs and wikis. While mobile, users can take advantage of convenient offline synchronization capabilities.

Easily manage documents and help ensure integrity of content

With enhanced document management capabilities including the option to activate required document checkout before editing, the ability to view revisions to documents and restore to previous versions, and the control to set document- and item-level security, Windows SharePoint Services can help ensure the integrity of documents stored on team sites.

Get users up to speed quickly

User interface improvements in Windows SharePoint Services 3.0 include enhanced views and menus that simplify navigation within and among SharePoint sites. Integration with familiar productivity tools, including programs in the Microsoft Office system, makes it easy for users to get up to speed quickly. For example, users can create workspaces, post and edit documents, and view and update calendars on SharePoint sites, all while working within Microsoft Office system files and programs.

Deploy solutions tailored to your business processes

While standard workspaces in Windows SharePoint Services are easy to implement, organizations seeking a more customized deployment can get started quickly with application templates for addressing specific business processes or sets of tasks.

Build a collaboration environment quickly and easily

Easy to manage and easy to scale, Windows SharePoint Services enables IT departments to deploy a collaborative environment with minimal administrative time and effort, from simple, single-server configurations to more robust enterprise configurations. Because deployment settings can be flexibly changed, less pre-planning time is required and companies can get started even faster.

Reduce the complexity of securing business information

Windows SharePoint Services provides IT with advanced administrative controls for increasing the security of information resources, while decreasing cost and complexity associated with site provisioning, site management, and support. Take advantage of better controls for site life-cycle management, site memberships and permissions, and storage limits.

Provide sophisticated controls for securing company resources

IT departments can now set permissions as deep down as the document or item level, and site managers, teams, and other work groups can initiate self-service collaborative workspaces and tasks within these preset parameters. New features enable IT to set top-down policies for better content recovery and users, groups, and team workspace site administration.

Take file sharing to a new level with robust storage capabilities

Windows SharePoint Services supplies workspaces with document storage and retrieval features, including check-in/check-out functionality, version history, custom metadata, and customizable views. New features in Windows SharePoint Services include enhanced recycle bin functionality for easier recovery of content and improved backup and restoration.

Easily scale your collaboration solution to meet business needs

Quickly and easily manage and configure Windows SharePoint Services using a Web browser or command-line utilities. Manage server farms, servers, and sites using the Microsoft .NET Framework, which enables a variety of custom and third-party administration solution offerings.

Provide a cost-effective foundation for building Web-based applications

Windows SharePoint Services exposes a common framework for document management and collaboration from which flexible and scalable Web applications and Internet sites, specific to the needs of the organization, can be built. Integration with Microsoft Office SharePoint Server 2007 expands these capabilities further to offer enterprise-wide functionality for records management, search, workflows, portals, personalized sites, and more.

SharePoint Audience User Existance Check sample

if HR is the audience.
GetAudience("HR") give access denied error.

Use the following
 using (SPSite site = new SPSite(SPContext.GetContext(Context).Site.ID))
 {
   ServerContext context = ServerContext.GetContext(site);
   AudienceManager audManager = new AudienceManager(context);
   SPUser user = SPControl.GetContextWeb(Context).CurrentUser;
   foreach(Microsoft.Office.Server.Audience.Audience objAudience in audManager.Audiences)
   {
     if (objAudience != null && objAudience.AudienceName == "HR")
     {
        if (objAudience.IsMember(user.LoginName))
        {
//Your code goes here
        }
      }
   }
}

Friday, April 17, 2009

Changing the Language of Sites

Pre-Req: Specific Language Pack Installed. ( Korean )

SW_CD_Office_Srvr_Language_Pack_2007_64Bit_Korean_1_1_PA_BP_SvrISO_Onl_X12-34584.EXE

For changing the language of all sites in the content database to Korean the query would be:

UPDATE dbo.Webs SET Language = 1042

Changing the language of one site collection can be done with:

UPDATE dbo.Webs SET Language = 1042 WHERE SiteId = [[SiteCollectionId]]

And for changing the language of a single web or subsite you can use:

UPDATE dbo.Webs SET Language = 1042 WHERE Id = [[WebId]]

Thursday, April 16, 2009

Installing Language Packs on 64-bit Sharepoint Farms

Install additional language files on all the WFE’s

On your front-end Web server, click Start, point to Settings and then Control Panel, and then click Regional and Language Options, on the Languages tab, in the Supplemental Language Support section, select one or both of the following checkboxes:

·         Install files for complex script and right-to-left languages

·         Install files for East Asian languages

Restart the Servers.

The following installation sequence should be followed.

Remember to unblock the downloaded software from the properties.

Cancel the Configuration wizard for the first 3 installations.

For the last installation run the configuration wizard and restart the servers. 

1. Windows SharePoint Services 3.0 Language Pack x64

http://www.microsoft.com/downloads/details.aspx?FamilyId=45FA2637-EFC0-4ED6-8F47-8A013E9CE9D9&displaylang=en

2. Windows SharePoint Services 3.0 Language Pack Service Pack 1 (SP1), 64-Bit Edition

http://www.microsoft.com/downloads/details.aspx?FamilyId=C7CF102B-5DD8-4D86-BE5A-D56F63EF37A4&displaylang=en

3. SharePoint Server 2007 Language Pack (x64)

http://www.microsoft.com/downloads/details.aspx?familyid=318d8562-58bd-4329-b1f6-f1941a38bc7f&displaylang=en&tm

4. The 2007 Microsoft Office Servers Language Pack Service Pack 1 (SP1), 64-Bit Edition

http://www.microsoft.com/downloads/details.aspx?FamilyId=56681742-7D2C-4A6F-9178-DACD32AADC6C&displaylang=en

SharePoint Master Pages

Do not use the CTRL (K+D) option from the VS 2008 for the master pages.
This option applies the indenting and space formatting for the language as specified on the Formatting pane of the language in the Text Editor section of the Options dialog box.

I have noted extra space appearing just by that

Wednesday, April 15, 2009

SharePoint Object Model - Discussion

using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SharePoint;
using Microsoft.SharePoint.Utilities;

namespace DiscussionBoardPoster
{
    class Program
    {
        static void Main(string[] args)
        {
            SPSite site = new SPSite("http://kopperla:2030/Movies");

            using (SPWeb web = site.OpenWeb())
            {

SPList list = web.Lists["Prince"];
                SPListItemCollection myListCol = list.Items;
                SPListItem disc = SPUtility.CreateNewDiscussion(myListCol, "Excellence2");
                disc["Body"] = "C Sharp is great";
                SPFieldUserValue oUser = new SPFieldUserValue(web, 289, "matcha");
                disc.Update();

                SPListItem reply = SPUtility.CreateNewDiscussionReply(disc);
                reply["Body"] = "I like C Sharp and VB.NET much";
                reply["Author"] = oUser;
                reply["Editor"] = oUser;
                reply["Created"] = DateTime.Parse("14 Jul 2006");
                reply["Modified"] = DateTime.Parse("14 Jul 2006");
                reply.Update();

                SPListItem reply2 = SPUtility.CreateNewDiscussionReply(reply);
                reply2["Body"] = "I like C Sharp and VB.NET too mubh";
                reply["Author"] = oUser;
                reply2["Editor"] = oUser;
                reply2["Created"] = DateTime.Parse("10/22/2008");
                reply2["Modified"] = DateTime.Parse("10/22/2008");
                reply2.Update();

                disc["Author"] = oUser;
                disc["Editor"] = oUser;
                disc["Last Updated"] = DateTime.Parse("10/22/2008");
                disc["Created"] = DateTime.Parse("10/22/2008");
                disc["Modified"] = DateTime.Parse("10/22/2008");
                disc.Update();


            }

        }
    }
}

Wednesday, April 8, 2009

Installing Adobe PDF iFilter 9 for 64-bit platforms

1. Download Link: http://www.adobe.com/support/downloads/detail.jsp?ftpID=4025
2. Add Path C:\Program Files\Adobe\Adobe PDF iFilter 9 for 64-bit platforms\bin) to the Environmental Variables. Dummies Steps below.
(Right-click MyComputer)->Properties->Advanced->Environmental Variables->System Variables
selct PATH and click Edit, Click End button to reach the end to avoid replace.
Add ;C:\Program Files\Adobe\Adobe PDF iFilter 9 for 64-bit platforms\bin
Click OK, Ok, Ok to apply the changes and to close the System Properties Window
3. Restart the machine
4. Follow the steps in the following link. - Simplified version of the following version coming soon.