Windows Scripting
  Home arrow Windows Scripting arrow Page 4 - MS SQL and Searching MCMS with SharePoint
ASP Free Forums 
.NET  
ASP  
ASP Code  
ASP.NET  
ASP.NET Code  
BrainDump  
C#  
Code Examples  
Database  
Database Code  
IIS  
Microsoft Access  
MS SQL Server  
Visual Basic.NET  
Windows Scripting  
Windows Security  
XML  
ASP Web Hosting  
ASP.NET Web Hosting 
Mobile Linux 
App Generation ROI 
Windows Web Hosting
 
IBM® developerWorks 
Sun Developer Network 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid 
Request Media Kit
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
WINDOWS SCRIPTING

MS SQL and Searching MCMS with SharePoint
By: PACKT Publishing
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 3 stars3 stars3 stars3 stars3 stars / 2
    2006-10-26

    Table of Contents:
  • MS SQL and Searching MCMS with SharePoint
  • Building the Microsoft SQL Full-Text Query
  • Building the MSQuery XML String
  • Summary

  • Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
     
     
    ADVERTISEMENT


    MS SQL and Searching MCMS with SharePoint - Summary


    (Page 4 of 4 )

     

    In this chapter we discussed a few of the options available to MCMS developers for adding search functionality to their sites. We proceeded to take an in-depth look at the searching features built into SharePoint Portal Server and how they can be leveraged as a back-end search workhorse for an MCMS site. Before we could start adding the search functionality, we had to make a few changes to our site and templates, as well as build an index using SharePoint to crawl our site.

    Once our site was configured for index crawls and SharePoint was configured to crawl our site and build an index, we explored in detail two options for adding search functionality to the Tropical Green site using the SharePoint crawler:

    • First we implemented search using the MCMS Connector for SharePoint Technologies, an out-of-the-box solution.

    Then, we built our own solution using the SharePoint Query Service Web Service and custom full text T-SQL queries to provide search filters and customized results.

    Advanced Microsoft Content Management Server Development:

    Working with the Publishing API, Placeholders, Search, Web Services, RSS, and SharePoint Integration

    Following on from Building Websites with Microsoft Content Management Server (Packt Publishing, January 2005, ISBN 1-904811-16-7), this book takes MCMS development to a higher level of both power and integration. Like its predecessor, this book is packed with code examples and never-before-seen secrets of MCMS.

    Microsoft Content Management Server 2002 is a dynamic web publishing system with which you can build websites quickly and cost-efficiently. MCMS provides the administration, authoring, and data-management functionality and you provide the website interface, logic, and workflow. Microsoft SharePoint Portal Server (SPS) also features in this book. SPS 2003 enables enterprises to deploy an intelligent portal that seamlessly connects users, teams, and knowledge so that people can take advantage of relevant information across business processes to help them work more efficiently.

    You've mastered the basics of MCMS, and have set up your own MCMS installation. But you've only scratched the surface. This book is your gateway to squeezing every penny from your investment in MCMS and SPS, and making these two applications work together to provide an outstanding richness of content delivery and easy maintainability.

    What This Book Covers

    Chapter 1 demonstrates the power of the MCMS Publishing API (PAPI) by building the CMS Explorer administration tool to manage an MCMS website. Chapter 2 builds on the CMS Explorer by adding the ability to manage channels and postings. Chapter 3 looks at the creation, submission, copying, moving, and deletion of templates, template galleries, and resources through the PAPI.

    In Chapter 4, you will learn how to prepare postings for search indexing. We look at several techniques that can improve the accuracy of search results and optimize your search engine.

    SharePoint Portal Technologies complement MCMS by providing collaboration, document libraries, and searching to the robust publishing workflow of MCMS. Chapter 5 takes you through the process of adding searching to an MCMS Site using SharePoint Portal Server, either using the MCMS Connector for SharePoint Technologies or by building your own solution.

    Chapter 6 demonstrates how you can use the MCMS Connector for SharePoint to build your own components to share content between MCMS and SharePoint. Chapter 7 shows how you can build Web Parts that integrate content from MCMS on a SharePoint portal site.

    Chapter 8 discusses five custom placeholder controls that provide some frequently requested features that are not present in the default controls: a date-time picker placeholder control, a placeholder control that permits multiple attachments, an image-rotator placeholder control, a placeholder control to store all kinds of HTML tags, and a DataGrid placeholder control.

    Validation of content is a key requirement in many MCMS implementations. Chapter 9 looks at how you can apply ASP.NET validation techniques to each of the out-of-the box placeholder controls.

    Static pages are often used in direct mailers, help files, and even for archiving purposes. Chapter 10 discusses a couple of techniques that you can use to create static snapshots of postings.

    The authoring experience doesn't always need to be through the browser. One author-friendly way of maintaining content is detailed in Chapter 11. In this chapter, we leverage the power of InfoPath to quickly create a GUI that allows authors to submit content directly from Microsoft Word, with the help of MCMS Web Services.

    Since the release of MCMS in 2002, a lot of technologies have changed. Syndication of websites using RSS is the norm, and to capitalize on this, Chapter 12 takes you through the steps involved in creating a dynamic RSS feed of your website's recent changes.

    Finally, Chapter 13 provides many invaluable insider's tips and tricks for MCMS, as well as solutions to common MCMS issues, including gems such as how to revert a posting to a previous version, change a posting's template, build a recycle bin, and export resource gallery items using the Site Deployment API.

    Where to buy this book

    You can buy Advanced Microsoft Content Management Server Development from the Packt Publishing website: http://www.packtpub.com/more_mcms/book.

    Free shipping to the US, UK, Europe, Australia, New Zealand & India.

    Alternatively, you can buy the book from Amazon, BN.com, Computer Manuals and most internet book retailers.


    DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware.

       · This article is an excerpt from the book "Advanced Microsoft Content Management...
     

    Buy this book now. This article is excerpted from chapter five of the book Advanced Microsoft Content Management Server Development, written by Lim Mei Ying et al. (PACKT, 2005; ISBN: 1904811531). Check it out today at your favorite bookstore. Buy this book now.

    WINDOWS SCRIPTING ARTICLES

    - Introducing Two-Way Data Binding using Silve...
    - Silverlight 2.0 Application Development with...
    - Burning Multisession CDs with IMAPI2 in WSH
    - Creating a Silverlight 2.0 Application that ...
    - Burning CDs with the IMAPI2 Control
    - Burning CDs in Windows XP with WSH
    - Advanced Word Object Scripting
    - Reading and Printing Word Documents in WSH
    - Scripting Microsoft Word
    - Using WSH to Catalog MP3 Files
    - Reading MP3 ID3 Tags in WSH
    - A Brief Look at Menus in WPF
    - More Examples of Simplified Image Processing...
    - Completing a WPF To-Do List Application
    - Simplified Image Processing in GDI+





    © 2003-2008 by Developer Shed. All rights reserved. DS Cluster 5 hosted by Hostway
    Stay green...Green IT