Office SharePoint Server 2007 Guide for MY SITE for Account Managers and Financial Analysts

Setting up the Role-Based My Site Template for Sales Account Managers 15 pages.

Setting up the Role-Based My Site Template for Controllers-Financial Analysts 18 pages.
--
P. Erol GIRAUDY MVP MOSS
www.clubsps.org
www.shareclubs.org

Guidelines using SharePoint 2007

Maybe it is time to write down some guidelines that you should keep in mind while working with SharePoint 2007, or you could just ignore them as well. I found these guidelines in Blogs, articles on the internet but I wanted to group them together. ...

http://www.u2u.info/Blogs/Kevin/Lists/Posts/Post.aspx?ID=7

These guidelines are not hard limits, meaning if you have 2005 lists on a site, your site will still work. The only thing that could happen by adding more items is that your performance could decrease.

--
P. Erol GIRAUDY MVP MOSS
www.clubsps.org
www.clubmoss2007.org
www.shareclubs.org

ARB Security Solutions is a full service security organization

Microsoft Office Server System (SharePoint 2007), like any other web based application, is subject to attackers for both internal as well as external threats. Using security policies and security software, it is possible to mitigate these risks.
The security of SharePoint Portal Server is often one of the most overlooked implementation and maintenance concerns with any deployment, even though 75% of cyber attacks are done at the weblevel. We recognized this gap and seek to provide our customers with all of the rich team services and collaboration tools in SharePoint while ensuring the integrity of data.
--
P. Erol GIRAUDY MVP MOSS
www.clubsps.org
www.shareclubs.org

CSS Reference Chart for SharePoint 2007 - PDF Version

Heather Solomon, the "MVP queen of SharePoint style", has put together a fabulous CSS reference for SharePoint 2007.

This covers both Microsoft Office SharePoint Server (MOSS) and Windows SharePoint Services (WSS) and displays the name of the style along with an example and where the style is defined in what file. Brilliant.

I've put together a PDF version of the reference guide if you're into that. You can download the 12 page reference guide from here.

Heather's original online version can be found here.
--
P. Erol GIRAUDY MVP MOSS
www.clubmoss2007.org
www.shareclubs.org

Floating ToolPane for SharePoint 2007

Ever been frustrated that the tool pane in SharePoint takes up your screen real estate, or that you have to scroll to see the buttons when editing a WebPart? ... If so, this is for you...
Following on from my previous post (which got a bit too long to mention this) the SharePoint controls include another useful addition...a floating toolpane for SharePoint. With two lines added to you site master page you can have all your tool panes appear in a floating window which is sizeable and can be minimized!
--
P. Erol GIRAUDY MVP MOSS
www.clubmoss2007.org
www.shareclubs.org

Downloadable books for Office SharePoint Server 2007

Downloadable books for Office SharePoint Server 2007 Updated: March 15, 2007

Some of the content in the Office SharePoint Server technical library is available in downloadable and printable form as Microsoft Office Word documents (.doc files).

The content in these 4 books is a copy of selected content in the Office SharePoint Server technical library (http://go.microsoft.com/fwlink/?LinkId=84739) as of the date listed for each book.

The 4 books for WSSv3 are here :
http://technet2.microsoft.com/windowsserver/WSS/en/library/decec839-73d9-4e23-b167-11e05dfc2feb1033.mspx?mfr=true

For the most current content, see the technical library on the Web.

--
P. Erol GIRAUDY MVP MOSS
www.clubmoss2007.org
www.shareclubs.org

Microsoft Office Groove and SharePoint Integration

This document discusses the you can integrate Groove and SharePoint to enhance and facilitate collaboration in your enterprise.
--
P. Erol GIRAUDY MVP MOSS
www.clubmoss2007.org
www.shareclubs.org

Using the BDC feature of MOSS 2007 to interact with information stored in external data sources, for example SQL Server and Oracle data bases - Part 2

Many enterprises manage a lot of information stored in data bases that are distinct that the ones used by SharePoint (SQL Server), for example internal applications like CRM’s, ERP’s or any other application developed by themselves, we could say “in house”. Now, we know that all the documents we upload to SharePoint Sites are stored in SQL Server. So, we have SharePoint data from one hand, and external information stored in other data sources on the other hand.
Is there any chance to provide final users the possibility to have only one web site to work with SharePoint data and also to interact with information stored in external data sources, through the same SharePoint Site?

Guess What!!, we have now the power of the Business Data Catalog, that allow us to interact with information stored in distinct sources and not necessarily need to be in SharePoint data bases. What’s the beauty of this, we can provide to our users the possibility to have one site (site collection) working with SharePoint data, from document libraries, lists and everything you know from SharePoint, but also with other kind of data…external data.

--
P. Erol GIRAUDY MVP MOSS
www.clubmoss2007.org
www.shareclubs.org

Estimate performance and capacity requirements for search environments

Usage profile : The following tables show the usage profile for the Office SharePoint Server 2007 search test environment.

Type of document - Number of documents -
Content on SharePoint sites 10 million items, including the following:
• 420 site collections
• 4,000 sites
• 24,200 lists
• 47,780 document libraries

Content on file shares 15 million items
HTTP content 15 million items
People profiles 2.5 million
Stitch (in-memory test tool that generates documents in memory) 7.5 million
Properties (metadata) 1 million
---
Read also : Recommendations
This section provides general performance and capacity recommendations. Use these recommendations to determine the capacity and performance characteristics of the starting topology that you created in Plan for availability (Office SharePoint Server) , and to determine whether you need to scale out or scale up the starting topology.
--
P. Erol GIRAUDY MVP MOSS
www.clubmoss2007.org
www.shareclubs.org

Windows SharePoint Services 3.0 Tools: Visual Studio 2005 Extensions

Brief Description : (Visual Studio 2005 extensions for Windows SharePoint Services 3.0, Version 1.0)Tools for developing custom SharePoint applications: Visual Studio project templates for Web Parts, site definitions, and list definitions; and a stand-alone utility program, the SharePoint Solution Generator.
--
P. Erol GIRAUDY MVP MOSS
www.clubmoss2007.org
www.shareclubs.org

SharePoint Server 2007 Language Pack

Brief Description : Language packs enable creation of SharePoint sites and site collections in multiple languages without requiring separate installations of SharePoint Server 2007. Multiple language packs can be installed on the same server. Application of a Language Pack will not change the language of the installed Office server product SKU, or the language of the administrative features.
--
P. Erol GIRAUDY MVP MOSS
www.clubmoss2007.org
www.shareclubs.org

SharePoint Server 2007 Presentations: Enterprise Search Deep Dives

Brief Description : This download provides six detailed presentations on enterprise search in Microsoft Office SharePoint Server 2007. This download presents packaged presentations and videos of the following conference sessions:

Enterprise Search Strategy and Opportunities (SharePointServer2007SearchDeepDiveA.exe) This session starts with an overview of Microsoft's enterprise search strategy, reviews the various products that it affects, and outlines what is new in SharePoint Search for the 2007 Microsoft Office system. Lastly, it discusses opportunities for partners building on the platform.

SharePoint Search Extensibility (SharePointServer2007SearchDeepDiveB.exe) This session addresses the core extensibility scenarios in Microsoft Office SharePoint Server 2007 (MOSS) search, such as customizing the user interface, custom search using client applications, and crawling new repositories, including line-of-business data. It also covers the administration object model.

Protocol Handlers and IFilters (SharePointServer2007SearchDeepDiveC.exe) Learn about the overall architecture of Microsoft Office SharePoint Server 2007 (MOSS) search. Protocol Handlers and iFilter interfaces are described in detail with code examples.

Customizing and Extending Search in Office SharePoint Server 2007 (SharePointServer2007SearchDeepDiveD.exe) Learn how to customize Microsoft Office

SharePoint Server 2007 (MOSS) search user interface and build search based applications in this session. Branding, Web parts and extending search using the object model and Web services are discussed.

Business Data Search (SharePointServer2007SearchDeepDiveE.exe) The Business Data Catalog (BDC) enables search to reach into line-of-business repositories and provide integrated search results. Learn about the Business Data Catalog including the design motivations, scenarios, and the apis.

SharePoint Search Deployment Scenarios (SharePointServer2007SearchDeepDiveF.exe) This session reviews both Windows SharePoint Services 3.0 and Office SharePoint Server 2007 search topologies, and various deployment scenarios such as a collaboration environment, enterprise portals, and internet facing portals.
--
P. Erol GIRAUDY MVP MOSS
www.clubmoss2007.org
www.shareclubs.org

Templates (40) for Windows SharePoint Services 3.0 plus the Application Template Core solution

This download package includes all forty of the Application Templates for Microsoft Windows SharePoint Services 3.0 plus the Application Template Core solution, which is required to deploy server administration templates.
--
P. Erol GIRAUDY MVP MOSS
http://clubsmoss2007.org
www.shareclubs.org

Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies

The Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies is a Web download that provides features for running a report server within a larger deployment of Windows SharePoint Services 3.0 or Microsoft Office SharePoint Server 2007. (see : http://blogs.msdn.com/sharepoint/archive/2007/02/19/microsoft-sql-server-2005-sp2-reporting-services-integration-with-wss-3-0-and-moss-2007.aspx and

5.0 Features in This Release (in english - french and...) :

1. This section summarizes the available features when you run a report server in SharePoint integrated mode.
2. Use the revised Reporting Services Configuration tool to create a report server database in SharePoint integrated mode.
3. Use the new report server configuration pages in Central Administration to grant the service accounts access to the SharePoint configuration and content databases.
4. Use SharePoint security to control access to report server content and operations.
5. Add reports and models that you created in SQL Server 2005 Reporting Services design tools to a SharePoint library. You can publish reports from Report Designer, or use the Upload action on a SharePoint library to upload any report server item. If you publish the files, be sure to specify fully qualified URLs.

An example URL for a file uploaded to Shared Documents on the top-level site of a SharePoint Web application might be :

http://example-server-name/Shared Documents/CompanySales.rdl.

The URL must include a file name extension.

If the library is on a site, you must also include any sites and subsites before the library.
---
For more information,
see "Deploying Reports, Models, and Shared Data Sources to a SharePoint Site" in SQL Server Books Online.
---
Create new shared data source (.rsds) files from a SharePoint site to use with the reports and models that you add to the library. A new file name extension named .rsds is introduced in this release; it is used for shared data source files that you create and store in a library.
Use the new Report Viewer Web Part to view reports.

Use Report Builder from a SharePoint site. You can open or modify an existing Report Builder report definition file from a library. You can load a model in Report Builder to create new reports from report model (.smdl) files that have been uploaded or published to a SharePoint library.

Use new Web pages and configuration options to set permissions and properties on reports (.rdl), models (.smdl), resources, and shared data sources (.rsds) that you add or create on a SharePoint site. You can also use Web application pages to define schedules and subscriptions.
---
Note:
Earlier versions of Reporting Services include two Web Parts that provide minimal integration between a report server and a SharePoint site.
Those Web Parts are not part of the Reporting Services Add-in and have different requirements and functionality.
---
For more information
about how those Web Parts compare with the Web Part that is included in the Reporting Services Add-in, see "Comparing Levels of Integration Across Versions of Reporting Services and SharePoint Technologies" in SQL Server Books Online.
http://www.microsoft.com/sql/default.mspx
---
SP2 SQL : Download Service Pack 2 for Microsoft SQL Server 2005.
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=d07219b2-1e23-49c8-8f0c-63fa18f26d3a
--
P. Erol GIRAUDY - MVP MOSS
www.clubmoss2007.org
www.shareclubs.org

MOSS 2007 and Related Technologies pricing

Check out the licence pricing model for MOSS 2007 (finally). These are the US prices, but it gives a good impression.

http://office.microsoft.com/en-us/sharepointserver/FX102176831033.aspx

Servers Estimated Price
Office SharePoint Server 2007 $4424
Office SharePoint Server 2007 for Search Standard $8213
Office SharePoint Server 2007 for Search Enterprise $57,670
Office Forms Server 2007 $4424

Client Access Licenses Estimated Price
Office SharePoint Server 2007 Standard CAL $94
Office SharePoint Server 2007 Enterprise CAL1 $75
Office Forms Server 2007 CAL $54
Office SharePoint Designer 2007 $187

Internet Facing Sites Estimated Price
Office SharePoint Server 2007 for Internet sites $40,943
Office Forms Server 2007 for Internet sites $22,118
----
1
To be licensed for the Enterprise Edition functionality of Office SharePoint Server 2007, both the Standard and Enterprise client access licenses are required.

--
P. Erol GIRAUDY MVP MOSS
www.clubmoss2007.org
www.shareclubs.org

2007 Office System Tool: Microsoft Best Practices Analyzer for Windows SharePoint Services 3.0 and the 2007 Microsoft Office System

Brief Description : The Microsoft Best Practices Analyzer for Microsoft Windows SharePoint Services 3.0 and the 2007 Microsoft Office System creates detailed reports to help administrators achieve greater performance, scalability, and uptime. This tools for 2007 Office System : Microsoft Best Practices Analyzer for Windows SharePoint Services 3.0 and the 2007 Microsoft Office System. After the analysis is complete, open sharepointbpa.report.htm in a web browser. See also my web site on the tools for MOSS and WSSv3 : http://outilsmoss.blogspot.com/
---
P. Erol GIRAUDY MVP MOSS
www.clubsps.org
www.shareclubs.org

Changing the theme when a new SharePoint 2007 site is created.

Posted by Scot Hillier under ApressNo Comments

A common need is to change the theme (and the alternate style sheet) of a site when it is created. In order to do this in SharePoint 2007, you must create a feature that makes the changes and then either “staple” the feature to a site or reference the feature within the site definition.

I have created a feature that you can use to make these changes.

It can be found at http://codegallery.gotdotnet.com/features.

ThemeChanger v1.0 (ThemeChanger.zip, 3k, 3 downloads)

PlaceHolder Master v1.0 (PlaceholderMaster.zip, 9k, 26 downloads)

Presence Contact List v1.0 (PresenceContactList.ZIP, 13k, 40 downloads)

http://blogs.msdn.com/modonovan/archive/2005/05/11/416376.aspx.

Content Type Hierarchy Viewer v1.0 (ContentTypeHierarchy.zip, 3k, 56 downloads)

Log Viewer v1.0 (Log Viewer.zip, 4k, 78 downloads)

--
P. Erol GIRAUDY MVP MOSS
www.clubsps.org
www.shareclubs.org

PDF Icon Update

Aimless Ramblings from a Blithering Lunatic . . . : PDF Icon Update: "Ever since I blogged about my batch file to simplify the task of getting a PDF icon to display in SharePoint 2.0 document libraries back in October of 2004, it has been the single-most popular post on my blog (with almost 60,000 hits to date). Well, ever since Windows SharePoint Services 3.0 was released, I knew that I needed to update my batch file, it just wasn't quite at the top of the to-do list. But now the wait is over - I have posted an updated package here. "
---
P. Erol GIRAUDY
www.shareclubs.org
http://clubmoss2007.org

25 Tips to Lockdown Your SharePoint Environment

I was preparing for a TechReady (internal Technical Readiness conference) Presentation and for my advanced deployment presentation I really needed to beef it up. Here's a list I put together for a few lockdown slides. This is not meant to be fully comprehensive, but get you started down the right track. All of these may not apply.
--
P. Erol GIRAUDY MVP MOSS
www.clubmoss2007.org
www.shareclubs.org

Using Wikis as Project Documentation Tools

A nice idea, I was talking to Charles Arnold after the last STC-Suncoast chapter meeting about using wikis as project documentation tools. Neil Perlin just presented on Web 2.0, and referenced James Surowiecki’s The Wisdom of Crowds: Why the Many Are Smarter Than the Few and How Collective Wisdom Shapes Business, Economies, Societies and Nations. Surowiecki’s main idea is that collective wisdom almost always outstrips individual wisdom....
---
I was playing around with the SharePoint 2007 wiki features and also those of Socialtext. Here are the barriers I’m up against:

• Wiki wysiwig’s are primitive (technical documentation can have some complicated styles, with several levels of lists).
• Once all the info is in the wiki, how do I generate a manual or online help? I don’t want to maintain two separate files.

...
--
P. Erol GIRAUDY MVP MOSS
www.clubmoss2007.org
www.shareclubs.org