MOSS2007: Create a Hyperlink to SharePoint List Export to Spreadsheet

From http://weblogs.asp.net/wkriebel/archive/2005/08/22/LinkToExportToSpreadsheet.aspx:

How To Create a Hyperlink to SharePoint’s List Export to Spreadsheet
Published Monday, August 22, 2005 1:27 PM

Because you can’t copy the hyperlink on the “Export to spreadsheet” link on SharePoint lists, here is how you can create your own hyperlink.

http://[Server]/[Site]/([Subsite]/)_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List=[ListGUID]&View=[ViewGUID]&CacheControl=1

Replace the [Placeholders] with your environment’s information.
A handy way to get the list and view GUIDs is to go into “Modify Columns and Settings” then scoll down to the views section and click on the view that you want to use.
You will notice the escaped list and view GUIDs in the resultant URL.
Here is an example:

http://MyWSS/sites/samplesite/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List=%7BD109453A%2D1A6E%2D4F83%2DAFF9%2DCCA04A75D76D%7D&View=%7B8FB21A2F%2DB62C%2D41D8%2DBA0C%2D7BD9C31FAA51%7D&CacheControl=1

See also, MSDN’s article: URL Protocol
and
my article: How To Add a Hyperlink To a SharePoint Event Outlook Export by wkriebel

MOSS2007: Everything Search…

Set, so the column is available for search
http://www.mosssearch.com/searchcolumn.html

Customize search:
http://dattard.blogspot.com/2007/11/sharepoint-2007-creating-custom.html

Customize XSL search:
http://www.sharepointblogs.com/zimmer/archive/2007/10/28/moss-2007-customize-the-search-result-using-xslt-part-3-customize-using-sharepoint-designer-2007.aspx

Connect a custom Search Page to a custom Search Scope:
http://www.sharepointblogs.com/zimmer/archive/2007/08/25/moss-2007-connect-a-custom-search-page-to-a-custom-search-scope.aspx

Find It All with SharePoint Enterprise Search:
http://technet.microsoft.com/en-us/magazine/cc162512.aspx

Index FTP content with SharePoint 2007/Search Server 2008:
http://blogs.msdn.com/opal/archive/2008/04/10/index-ftp-content-with-sharepoint-2007-search-server-2008.aspx

MOSS2007: Add webpart for any web part page

To add webpart for any web part page (even the one where “Edit Page” is unavailable), simply append the following text to the URL:

&ToolPaneView=2

Thus, if my original URL was:

http://moss/portal/Lists/IT%20Assets/DispForm.aspx?ID=2&Source=http%3a%2f%2ftidemo%2ftftp%2fLists%2fIT%2520Assets%2fAllItems.aspx&PageView=Shared

Then my new URL is:

http://moss/portal/Lists/IT%20Assets/DispForm.aspx?ID=2&Source=http%3a%2f%2ftidemo%2ftftp%2fLists%2fIT%2520Assets%2fAllItems.aspx&PageView=Shared&ToolPaneView=2

TFS: Installation

http://ozgrant.com/2007/07/15/hands-free-tfs-install-part-3-installing-team-foundation-server-unattended/

FMEA: (1) Introduction

FMEA (Failure Mode and Effects Analysis) is about make a prediction…

It is a systematic approach to:

• recognize the potential failure of product or process and the effect of the failure
• identify actions that could eliminate or reduce the chance of potential failure occurring

The differences between FMEA and FMA or FA:

• FMEA – the failure is not yet happened. FMA/ FA the failure is happened already.
• FMEA – work on forecasted failure, the causes and its effects/ impacts. FMA/FA – work on known trouble units.

Types of FMEA:

• Design FMEA (d-FMEA) or Product FMEA.
  The focus is on the product itself, such as: components, raw materials, feature, or characteristics.
• Process FMEA (p-FMEA) or Manufacturing FMEA or Production FMEA.
  The focus is on manufacturing process, such as: Process flow, Equipment, Tooling, Operators.
• System FMEA (SFMEA).
  Focus on potential failures associated with the functions performed at the system, subsystem and lower functional levels. It is also about the interaction between systems, subsystems, and the interface between system elements.
• Service FMEA (s-FMEA)
  Focus on field service after sales
  or
  Focus on Instruction and Warning label
  or
  Focus on reliability, maintainability, spare part availability and other field service related activities
• Application FMEA (a-FMEA)
• On supplier side, focus on supplier design as well as manufacturing process to maintain the key/significant characteristic of the products.
• On customer side, focus on customer manufacturing process, with prime interest is on compatibility between your products and your customer’s process
  or
  your process with your customer’s process.

 

That’s it for now… will be continued latter.