Skip to main content

Wen He

Go Search
Wen He
Home
  

Other Blogs
Randy Williams
SharePoint Meditation in Motion
Working around the CEWP's absolute links...

Good to see this on Andrew Connell's blog (http://www.andrewconnell.com/blog/archive/2008/12/24/Working-around-the-CEWPs-absolute-links.aspx).  Here's his post in its entirety and I'm going to try Maxime Bombardier's workaround and keep you posted.

[via Stefan Gossner & Maxime Bombardier]

The Content Editor Web Part, as many people have realized who've tried to use it in Publishing sites and then extend multiple Web apps or leverage content deployment, stores links as absolute references rather than relative ones. For instance, if you have a link to http://staging.adventureworkstravel.com/pages/contactus.aspx in a CEWP on a page and then do content deployment to http://www.adventureworkstravel.com, the link will be pointing back to the staging site (which will... or should... be inaccessible).

Sidebar: In my opinion, you shouldn't using the CEWP in Publishing sites. In fact, for most if not all my deployments, we remove that Web Part from the Web Part gallery and add a <SafeControl /> entry in the site's web.config to flag is as NOT a safe control. You should be using field controls instead (see my blog post detailing this here which is also on the ECM team blog and also discussed in my MSDN article Prescriptive Guidance for MOSS 2007 WCM Sites).

Maxime Bombardier has come up with an interesting workaround to fixing this for all WSS 3.0 based sites, including Publishing sites. This approach uses a custom ASP.NET Control Adapter to do some link fixup. In his post he references Waldek's similar process.

» Maxime Bombardier: Fixing absolute URLs for all Alternate Access Mappings (AAM) of Content Editor Web Part with a Control Adapter

What Version of MOSS Am I Running?

If you have more than one MOSS farm, you probably want to know exactly which one has the latest service pack and updates. I often check the version before I perform the following tasks:

  1. To work with content databases
  2. To reproduce your moss farm via content database backup/restore

Here is a quick table of all MOSS service pack and updates

Service Pack/Hotfix Version MOSS 2007
December Cumulative Update 12.0.0.6335
MOSS September Cumulative update (KB956056 & KB956057)  12.0.0.6327
Infrastructure Update (KB951695 & KB951297)  12.0.0.6318
Post-SP1 hotfix (KB948945)  12.0.0.6303
Post-SP1 hotfix (KB941274)  12.0.0.6301
Post-SP1 hotfix (KB941422) 12.0.0.6300
Service Pack 1 12.0.0.6219
Release To Manufacturing (RTM) 12.0.0.4518

Hope this helps. Read recommendation from MSDN SharePoint Team Blog:

To keep all the files in a SharePoint installation up-to-date, we recommend that customers install updates in the following sequence:

1. Windows SharePoint Services 3.0 Service Pack 1

2. The 2007 Microsoft Office Servers Service Pack 1

3. December Cumulative Update for Windows SharePoint Services 3.0

4. December Cumulative Update for Microsoft Office Servers

After applying the preceding updates, run the SharePoint Products and Technologies Configuration Wizard or “psconfig –cmd upgrade –inplace b2b -wait” in command line. This needs to be done on every server in the farm with SharePoint installed.  The version of content databases should be 12.0.0.6335 after successfully applying these updates.

FBA and Client Integration Limitation

When you configure a zone to use forms authentication, the Enable Client Integration box is cleared by default. 

image

If a zone is configured in this way, the following changes occur in functionality:

  • Support for remote interfaces is turned off. That includes WebDAV, SOAP, and Microsoft Office FrontPage remote procedure calls (RPC). Some functionality is not available, such as Web folders or the Web services for accessing content in that site.

  • Some toolbar items no longer appear:

    • New Document

    • Open in Outlook

    • Open In Windows Explorer

    • Export to Spreadsheet

    • Open with Database Program

  • Explorer View option is hidden.

  • Create an Access View option is hidden.

  • In picture libraries, the following functionality is removed:

    • Upload Multiple

    • Edit Picture

    • Download

    • Send To

  • On the Edit Control Block (ECB) menu, the drop-down menu that appears when you click items in document libraries, the following items are removed:

    • Edit in Word

    • Edit in Excel

    • Edit in PowerPoint

    • Discuss

    • Connect To Outlook

  • In slide libraries the following functionality is removed:

    • Publish Slide

    • Send to PowerPoint

Also, syncing SharePoint data with Microsoft Office Outlook no longer works.

When operating in this mode, users can still work with documents in SharePoint libraries, but they must right-click items and choose to save a copy to disk. They can then edit and update the document, and then upload it and check it back in when they are finished editing.

You are using forms authentication and might still want to have the Enable Client Integration turned on.  It is helpful to examine the limitations.

image

When a user accesses a page on a site protected by forms authentication, the server looks for a valid authentication cookie. If no cookie is found, or if the cookie is not valid, the server redirects the browser to the logon page by using an HTTP 302 status code. At this page, the user is allowed to authenticate by using his or her credentials. After the credentials are validated, the server creates a valid authentication cookie and sends it back to the browser, with the originally requested page. The browser keeps the cookie in memory and sends it back to the server with every subsequent request to that Web server. With each request, the server checks the validity of the cookie to ensure that it is good (that it has not expired or been tampered with), and then processes the request.

Because the authentication cookie is in memory with the browser process, it introduces some limitations:

  • The cookie is retained only as long as the browser is open; when the browser is closed the cookie is destroyed with everything else in memory that the browser was using.

  • The cookie belongs to the browser's application process (such as the .exe file for the browser), and cannot be shared with other processes. Office system applications run in their own processes, for example, msword.exe for Microsoft Office Word. As such, a cookie that a user generated when logging into the site in the browser cannot be shared with Word.

  • Office system applications do not know how to respond to the 302 response sent back from the server. For example, if you are using forms authentication and have the Enable Client Integration feature turned on, the Enable Client Integration menu includes an Open In Windows Explorer

image

If you click the Open with Windows Explorer menu, instead of opening Explorer View in Windows Explorer, Windows Explorer displays the Windows logon window shown below.

image

If you proceed to logon using your Windows account (note: this is under FBA), then SharePoint will "damage" the FBA-based the Web application and cause it to fail.

Import Profile via LDAP Membership Provider

To be able to import profile from LDAP store, which is not AD or ADAM, you need Authenticated Bind to LDAP by specifying the account that has the access displayName field in LDAP which was mapped to Preferred Name in SharePoint. It's the same as you would use Authenticated Bind to perform "subtree" search, "authenticated bind" has to be enabled.  Thanks to my coworker Andrew who tried it out.  Great job!

image

image

Ready for Windows 2008 R2?

What's new about R2

With R2:

  • You can now run PHP-based applications on IIS 7.
  • You can run .NET-based application on Server Core.
  • R2 is the first Windows operating system to be offered for only 64-bit processors.
  • R2 now supports up to 256 logical processor cores for a single operating system instance. Hyper-V™ virtual machines are able to address up to 32 logical cores in a single VM.
  • IIS 7 Extension

IIS 7 Extensions

See all the extensions at http://www.iis.net/extensions

(To be continued)

Creating a English and Chinese Multilingual MOSS Farm

Suppose you need a MOSS environment that can host Chinese Web site to the Chinese clients. With MOSS  you can do this, you can host different language Web sites all on the single server farm.

Thumbnail for version as of 20:45, 13 September 2007Back in China, the SharePoint experts' best practice to create a multilingual MOSS farm is "English OS, Chinese MOSS, and English VS", which means install the English version of Windows and Visual Studio, and the Chinese version of MOSS. Though this is a good approach for other products but MOSS has this great "Site Provisioning" feature that enables you to provision a site or site collection in any specific language as long as the language for that language is installed without requiring separate installations of MOSS.

To create a multilingual English and Chinese MOSS farm, all you need is just to add the Chinese Language Packs to your base English installation so that you can create both English and Chinese site or site collections.  This approach gives you the simplicity of maintaining just one version of tools ideal for developer training and class environments. I call this approach "English OS + additional Chinese,  English MOSS + Chinese Language Packs, and English VS".  First let's see what it looks like:

image

It is not that strange after all.

Now let's create a English/Chinese MOSS farm in the following three steps:

Step I:  Install additional language - Chinese to the OS

Windows 2003: install the East Asian Language Files via Control Panel --> Regional and Language Options then click the Languages tab and in the Supplemental Language section check the Install files for East Asian Languages checkbox.

image

Windows 2008: install additional languages via Control Panel --> Regional and Language Options --> Keyboards and Languages

image 

image

 

Step II:  Install Chinese Language Packs (语言包) to the MOSS

Download and Install Language Packs for

Change Language to Chinese

image image

  1. SharePoint Server 2007, Forms Server 2007, Project Server 2007, and SharePoint Server 2007 for Search (ServerLanguagePack.iso)
  2. WSS SP1 (wssv3lpsp1-kb936988-x86-fullfile-zh-cn.exe)
  3. Microsoft Office Language Pack 2007 Service Pack 1 (SP1)  (officeserverlp2007sp1-kb936984-x86-fullfile-zh-cn.exe)

Final Check

Once this is complete it is a good idea to check the TEMPLATE folder in the server "12 Hive", besides the well-known 1033 folder for English, there's a new folder called 2052 and if you open the files within, you will see Chinese content.

Step III:  Provision Site Collection and Site

Before and After Language Packs (Create a site collection)

image

Before and After Language Packs (Create a site)

image

image  image  

User Experience Comparison

Chinese OS + Chinese MOSS

English OS + Chinese MOSS

English OS + English MOSS + Chinese Language Pack

User Experience 

Chinese

English

English

Central Admin

Chinese

Chinese

English (Select Chinese Site Template)

Site Admin and Application Pages

Chinese

Chinese

Chinese

Site Collection and Site

Chinese

Chinese

Chinese

Lists, List Setting, Manage Shared Web Part, etc

Chinese

Chinese

Chinese

Becoming a Master (aka MCM or Microsoft Certified Master)

Microsoft Certified Master

From MSDN:  Last week at IT Forum in Barcelona, we announced the Microsoft Certified Master (MCM) for Office SharePoint Server 2007 and the Microsoft Certified Architect (MCA) for Office SharePoint Server 2007.

The Master program is designed to be the top-tier technical certification for SharePoint Products and Technologies for years to come. The goal of the MCM is to provide a means for training, recognizing, and developing the top SharePoint technical experts in the world. Specifically, the MCM is intended for technical professionals whose primary responsibilities include designing, building, configuring, deploying, and supporting large, often complex, MOSS 2007 environments.

Building on the MCM, the MCA certification is designed for professionals who possess an additional skill set focused on the larger business strategies and technical architecture as a whole. This skill set includes the ability to communicate with business and technology leaders, to understand the customer’s current and long-term organizational and technical needs, and to design a solution to meet those needs. To receive the MCA for SharePoint, students must first graduate from the MCM for SharePoint program and will then have the option of sitting for a comprehensive Review Board interview conducted by Microsoft experts and MCA’s.

If you feel you have the skills and experience to excel in this program, and are interested in being one of the first SharePoint Masters and/or MCA’s, I’d encourage you to visit the the MCM homepage for additional detail and prerequisites for the program.  We are accepting applications into the program here.

From MSDN:  This week at TechEd EMEA in Barcelona,  Jason Zander, the GM for Visual Studio, announced and demonstrated the Visual Studio 2010 tools for SharePoint.  Here's a quick summary of what he showed:

  • Server Explorer for SharePoint viewing Lists and other artifacts in SharePoint directly inside of Visual Studio

  • Windows SharePoint Services Project (WSP file) Import to create a new solution

  • Added a new web part project item and showed the Visual web part designer which loads a user control as a web part for SharePoint

  • Showed adding an event receiver for SharePoint and using the wizard to choose the event receiver and to just create a source file with that event receiver.

  • Added an ASPX workflow initiation form to a workflow project and showed how this workflow initiation form has designer capability

  • Showed the packaging explorer and the packaging editor which lets you structure the SharePoint features and WSP file that is created

Real World SharePoint

25 Practical Business Solutions for SharePoint

Are you ready to experience the full potential of SharePoint?  Come join us as we demonstrate 25 great business solutions and offer insights that will help you harness and extend SharePoint’s power.  This will be a rapid-fire series of custom demos that will cover nearly all aspects of SharePoint.  Both executive and technical attendees will find value in this event.

 

Please mark your calendar for Tuesday, November 11th 2:00 PM – 4:00 PM for our next User Group Meeting and an opportunity to learn from Hawaii’s two leading SharePoint experts, Randy Williams and Wen He. The meeting will be held at:

 

Davies Pacific Center

841 Bishop Street, STE 1830

Tuesday, November 11th from 2:00 PM to 4:00 PM

*Suggested Parking Spots (below)*

Pupus will be served

 

Don’t forget to bring your Business Card, so you can participate in the drawing to win a fabulous prize. We look forward to seeing you all.  Please RSVP to wenhe@eworldes.com.

 

Suggested Parking Spots:

1.       Alli Place

2.       Harbor Court

3.       Kukui Plaza

Re-Cap of Dan Holme's "SharePoint at Beijing Games" Presentation

In early September we welcomed home Dan Holme from Beijing.  Dan was back in town speaking at the Hawaii SharePoint Users Group which I help run with close friend Wen He.  We were lucky to get the fellow Hawaii-based and SharePoint MVP as he did a fantastic talk on the use of SharePoint technology at the NBCOlympics.

image

As many of you know, Microsoft was very much involved with the broadcast with a beta version of Silverlight v2.  Some of the numbers that Dan provided were simply staggering.  These include:

  • > 3600 hours of content on multiple networks
  • ­> 2200 hours of web content
  • ­> 210 million unique TV viewers which was the most watched event in television history (although I just read yesterday that the Republican and National conventions may have scored higher in the Nielson’s)
  • Millions of page hits & streams

Last month, various outlets had posted that SharePoint was also the platform portal of choice for a kiosk called Info 2008.  This provided info on athletes, officials, and partners that tourists and fellow athletes could easily browse.  For some reason, however, the online case study that Microsoft has posted has been taken down. 

In addition, Dan and his team used MOSS 2007 in some clever ways to quickly solve some sticky problems that would have otherwise taken much longer if a custom solution was developed. Some of these “quick wins” included:

  • Using Forms Services along with an InfoPath form to help tag video content.  The output XML which was stored in a document library was then consumed by external systems that streamed the content. 
  • Using MS Access and Excel as a front end to SharePoint.  The integration with Office 2007 is quite good, and I do have to admit, I often forget the power these thick clients have when integrating with SharePoint. 
  • Using WebDav to quickly publish documents into SharePoint.  I’ve been meaning to to a blog on this, and this reminded me of the value here.  Expect one shortly.
  • Developing declarative workflows using SharePoint Designer.  Yes, many know the limitations that SPD-based workflows have, but let’s face it, for a single list or library, they can provide a fast solution to many workflow needs.

So, welcome home Dan, and great job helping the NBC and its partners put on a great event.  You can find Dan’s presentation deck here.

Posted by: Randy Williams

Creating a Host Header-based Site Collection

What is a host head-based site collection?

First of all, a host header-based site collection is a site collection that allows you to specify your own host header on the site collection level. This provides you with tons of power and flexibility.  Who could it be possible?  Read along...

In my previous blog, I talked about you can extend a Web application to use a different authentication. So basically you have two IIS Web Applications that share the same content database and same site collection. This is cool when you need to authenticate different type of people to access the same site collection. 

Why host head-based site collection?

What if you have a Web application that's already configured to use FBA, and you want to share the same authentication that you've already configured and the same users that are already registered, and you just want to add a site collection to "inherit" all that, but you want the new site collection to use "root" URL. (A "root" URL is a top-level URL that cannot be a managed path or sub-site collection.)

This is exactly what we were wanting to do: host www.HawaiiDotNetUserGroup.com on the same Web application where http://SharePointHawaii.com is hosted to achieve the goals:

  1. Serve the same community
  2. Share the same FBA authentication store and user profile
  3. Have different permissions in each site collection

One of the coolest things you can do is create host header based site collections, enabling a single SharePoint web application the ability to contain http://SharePointHawaii.com and www.HawaiiDotNetUserGroup.com. Given that Microsoft recommends a maximum limit of 20 Web Applications on a farm, the ability to use site collections as the entry point for host headers is very significant (expanding the potential total number of sites on a single farm into the thousands).

image

How to create a host head-based site collection?

You could use STSAdm -o CreateSite command and specify -URL and -HHURL. But we wanted www.HawaiiDotNetUserGroup.com to have its dedicated database for better maintenance & management. So we used CreateSiteInNewDB switch. Here's the complete command:

STSAdm -o CreateSiteInNewDB 
-URL www.HawaiiDotNetUserGroup.com 
-owneremail hewen@hotmail.com 
-ownerlogin sharepoint\wen 
-HHURL http://SharePointHawaii.com 
-databaseserver SharePointHI 
-databasename WSSContentHawaiiDotNETGroup

To resolve the name www.HawaiiDotNetUserGroup.com, you need to register the domain and have its DNS point to the outer IP of SharePoint. Once the request from that site reaches the IIS, how does IIS know where to direct the traffic? Well, just add the new Host Header to the existing SharePointHawaii.com Web application (see below)

image

Host headers in the Site Bindings

Now when you browse to this site www.HawaiiDotNetUserGroup.com now, you will be directed to select a site template because I purposely left that part which lets you pick the template in the format of STS#1. Of course, we could add the switch to the CreateSite command which lets you pick the template in the format of STS#1 (for blank sites).

image

Now the site www.HawaiiDotNetUserGroup.com has been provisioned as root URL (Host Header-based) site collection on the same Web application as http;//SharePointHawaii.com.

In conclusion, there are some caveats:

  1. You can do host headers on site collections in a web application as long as the host header is in the same domain as the web application. It will work automatically without manually adding the host header.
  2. If you try creating a site with a URL that isn't in the exact same domain as the web application, the command will tell you it was successful but you cannot actually access the site collection. You will have to add the host header manually to the Site Bindings (see above Host headers in the Site Bindings).
  3. You cannot manage the site collection's access mapping like you can a web application. As a matter of fact, AAM has no idea that the site collection has a host header.
  4. You cannot use SSL on a host header-based site collection, because it's applied to the web application. Site collections aren't a security boundary like web applications are. Site collections are contained in web applications and play by the web app's rules. However, if you are using a wildcard certificate on the web application containing the site, and if the site collection's host header is in the same domain, it can work.
  5. You cannot search the host header site that uses both HTTP and HTTPS (see KB927919)
    If you want the host-named site collection to be searchable over HTTP, put the host-named collection in the HTTP Web application. If you want the host-named site collection to be searchable over HTTPS, put the host-named site collection in the HTTPS Web application.

Hope this helps. Please send your feedback and comments. Mahalo!

1 - 10 Next

 RSS from Randy's Blog

Retrieving Data

 ‭(Hidden)‬ Admin Links