Posts belonging to Category wss



SharePoint 2010: Open With Windows Explorer Slow

If using the “Open with Windows Explorer” option in SharePoint is slow use the following procedure to fix this and increase the performance:

  1. Open Internet Explorer
  2. Go to the Menu “Tools” > “Internet Options” then go to the “Connections” tab
  3. Click on button “LAN Settings
  4. Uncheck the box “Automatically detect settings” (culprit)
  5. Close and restart all running Internet Explorer processes
  6. Restart the “Web Client” Service, if needed.
  7. Try it again!

via Open with Windows Explorer in SharePoint (Fix Slow WebDAV Performance on Windows 7 / Vista)

linkedin SharePoint 2010: Open With Windows Explorer Slowdigg SharePoint 2010: Open With Windows Explorer Slowshare save 120 16 SharePoint 2010: Open With Windows Explorer Slow

Windows PowerShell Command Builder For SharePoint 2010

 Windows PowerShell Command Builder For SharePoint 2010

The Windows PowerShell Command Builder for SharePoint 2010 Products and Office 365 is a Silverlight application that enables IT pros and power users to visually assemble commands in the browser and then take those commands to their respective products.

Click to open the Windows PowerShell Command Builder in a new browser window.

For additional information, see the Getting Started Guide.

linkedin Windows PowerShell Command Builder For SharePoint 2010digg Windows PowerShell Command Builder For SharePoint 2010share save 120 16 Windows PowerShell Command Builder For SharePoint 2010

Browsing the User Information List

Tobias Zimmergren has a great post on his blog that explores the User Information List

Here is an excerpt:

The User Information List can be accessed (Only if you’re admin) via the browser by navigating to /_catalogs/users/simple.aspx from your site. (Ex: http://zimmergren/_catalogs/users/simple.aspx)

This works for both Windows SharePoint Services 3.0 (WSS 3.0) and Microsoft Office SharePoint Server 2007 (MOSS 2007)

linkedin Browsing the User Information Listdigg Browsing the User Information Listshare save 120 16 Browsing the User Information List

Browsing the User Information List

Tobias Zimmergren has a great post on his blog that explores the User Information List

Here is an excerpt:

The User Information List can be accessed (Only if you’re admin) via the browser by navigating to /_catalogs/users/simple.aspx from your site. (Ex: http://zimmergren/_catalogs/users/simple.aspx)

This works for both Windows SharePoint Services 3.0 (WSS 3.0) and Microsoft Office SharePoint Server 2007 (MOSS 2007)

linkedin Browsing the User Information Listdigg Browsing the User Information Listshare save 120 16 Browsing the User Information List

Web Parts in WSS vs. MOSS

Here is a listing that I found of web parts that are in WSS versus MOSS:
via Out of the box web part listing for WSS and MOSS

Web Parts in common with WSSv3
Content Editor Web Part Use for formatted text, tables, and images.
Form Web Part Use to connect simple form controls to other Web Parts.
Image Web Part Use to display pictures and photos.
Members Use the Members Web Part to see a list of the site members and their online status.
Page Viewer Web Part Use to
display linked content, such as files, folders, or Web pages. The
linked content is isolated from other content on the Web Part Page.
Relevant Documents Use this webpart to display documents that are relevant to the current user.
User Tasks Use this webpart to display tasks that are assigned to the current user.
XML Web Part Use for XML, and XSL Transformation of the XML.
List View Web Part A list
view web part is provided for every list created in a site (a list
template may include more than one view). The list view renderes the
CAML markup defined in the view.
Data View Web Part This
web part is configured with SharePoint Designer. It can use a wide range
of data sources including XML files, web services, SQL and Oracle
databases and SharePoint list/library content. The rendering is XSLT
driven with SharePoint Designer providing a drag-and-drop interface to
generate the XSL.
Web Parts specific to MOSS 2007
Business Data (Enterprise CAL)
Business Data Actions Display a list of actions from the Business Data Catalog.
Business Data Item Display one item from a data source in the Business Data Catalog.
Business Data Item Builder Creates
a Business Data item from parameters in the query string and provides
it to other web parts. This web part is only used on Business Data
profile pages.
Business Data List Display a list of items from a data source in the Business Data Catalog.
Business Data Related List Display a list of items related to one or more parent items from a data source in the Business Data Catalog.
Content Rollup (Standard CAL)
Colleague Tracker Displays your list of colleagues and any recent changes they made have had.
Memberships Displays your site and distribution list memberships.
My Links Use to display your links
My SharePoint Sites Use to display documents authored by you on sites where you are a member and sites of your choice.
My Workspaces Displays sites created under your My Site.
Site Aggregator Use to display sites of your choice.
Table of Contents You
use the Table of Contents Web Part to automatically generate a site map
that point to various parts of your Office SharePoint Server 2007 site
collection. You can specify which part of your site collection the Web
Part should generate links to, how the links are presented, and how the
links are organized.
Dashboard (Enterprise CAL)
Key Performance Indicators Shows a
list of status indicators. Status indicators display important measures
for your organization, and show how your organization is performing
with respect to your goals.
KPI Details Displays
the details of a single status indicator. Status indicators display an
important measure for an organization and may be obtained from other
data sources including SharePoint lists, Excel workbooks, and SQL Server
2005 Analysis Services KPIs.
Other
Excel Web Access Use the Excel Web Access to interact with an Excel 2007 workbook as a Web page. (Enterprise Feature)
I need to… Displays tasks and tools from a list
IView Web Part Displays iViews from SAP portal servers. (Enterprise Feature)
RSS Viewer Renders RSS Feed
This Week in Pictures Use to display the images library in the News web
WSRP Consumer Web Part Displays portlets from web sites using WSRP 1.1. (Enterprise Feature)
Filters
Authored List Filter Filter the contents of web parts using a list of values entered by the page author.
Business Data Catalog Filter Filter the contents of web parts using a list of values from the Business Data Catalog.
Current User Filter Filter the contents of web parts by using properties of the current page.
Date Filter Filter the contents of web parts by allowing users to enter or pick a date.
Filter Actions Filter Actions
Page Field Filter Filter the contents of web parts using information about the current page.
Query String (URL) Filter Filter the contents of web parts using values passed via the query string.
SharePoint List Filter Filter the contents of web parts by using a list of values from a Office SharePoint Server list.
SQL Server 2005 Analysis Services Filter Filter the contents of web parts using a list of values from SQL Server 2005 Analysis Services cubes.
Text Filter Filter the contents of web parts by allowing users to enter a text value.
Misc
Contact Details Use to display details about a contact for this page or site
Outlook Web Access
My Calendar Use to display your calendar. This part works with Microsoft Exchange Server 2003 and above.
My Contacts Displays your contacts using Outlook Web Access for Microsoft Exchange Server 2007.
My Inbox Displays your inbox using Outlook Web Access for Microsoft Exchange Server 2003 or later.
My Mail Folder Displays your calendar using Outlook Web Access for Microsoft Exchange Server 2000 or later.
My Tasks Displays your tasks using Outlook Web Access  for Microsoft Exchange Server 2003 or later.
Search
Advanced Search Box Entry point for advanced search
People Search Box Entry point for people search
People Search Core Results Web part to display the people search results.
Search Box Entry point for search.
Search Core Results Web part to display the search results.
Search High Confidence Results Web part to display the special term and high confidence results.
Search Paging Displays search paging.
Search Statistics Displays search statistics.
Search Summary

Displays search summary.

Site Directory
Categories Displays categories from the Site Directory
Sites in Category Displays sites in the Site Directory
Top Sites

Display the top sites from Site Directory

Publishing
Content Query Displays items from any site in current site collection based on site, list, column criteria

linkedin Web Parts in WSS vs. MOSSdigg Web Parts in WSS vs. MOSSshare save 120 16 Web Parts in WSS vs. MOSS

Comparison of Sharepoint 2007 Features: MOSS vs. WSS

Below is a list of the features available in Sharepoint 2007 MOSS compared to WSS
via What’s a MOSS 2007 vs. WSS v3 Feature

Windows SharePoint Services v3 Features:

33 Features in WSS v3

  • AdminLinks
  • AnnouncementsList
  • BasicWebParts
  • ContactsList
  • ContentLightup
  • ContentTypeSettings
  • ctypes
  • CustomList
  • DataSourceLibrary
  • DiscussionsList
  • DocumentLibrary
  • EventsList
  • fields
  • GanttTasksList
  • GridList
  • IssuesList
  • IssueTrackingWorkflow
  • LinksList
  • MobilityRedirect
  • NoCodeWorkflowLibrary
  • PictureLibrary
  • SiteSettings
  • SPSearchFeature
  • SurveysList
  • TasksList
  • TeamCollab
  • UpgradeLinks
  • WebPageLibrary
  • WikiWelcome
  • WorkflowHistoryList
  • WorkflowProcessList
  • XmlFormLibrary

Microsoft Office SharePoint Services 2007 Features:

107 Features Added in MOSS 2007*

  • AddDashboard
  • Analytics
  • AnalyticsLinks
  • BaseSite
  • BaseSiteStapling
  • BaseWeb
  • BaseWebApplication
  • BDCAdminUILinks
  • BDR
  • BizAppsCTypes
  • BizAppsFields
  • BizAppsListTemplates
  • BizAppsSiteTemplates
  • BulkWorkflow
  • BulkWorkflowTimerJob
  • DataConnectionLibrary
  • DataConnectionLibraryStapling
  • DeploymentLinks
  • DMContentTypeSettings
  • EawfSite
  • EawfWeb
  • EnhancedHtmlEditing
  • ExcelServer
  • ExcelServerSite
  • ExcelServerWebApplication
  • ExpirationWorkflow
  • FeaturePushdown
  • GlobalWebParts
  • GradualUpgrade
  • Hold
  • ipfsAdminLinks
  • IPFSAdminWeb
  • IPFSDocumentConversion
  • IPFSSiteFeatures
  • IPFSWebFeatures
  • LegacyDocumentLibrary
  • ListTargeting
  • LocalSiteDirectoryControl
  • LocalSiteDirectoryMetaData
  • LocalSiteDirectorySettingsLink
  • MasterSiteDirectoryControl
  • MigrationLinks
  • MySite
  • MySiteBlog
  • MySiteCleanup
  • MySiteHost
  • MySiteLayouts
  • MySiteNavigation
  • MySiteQuickLaunch
  • Navigation
  • NavigationProperties
  • OffWFCommon
  • OSearchBasicFeature
  • OSearchCentralAdminLinks
  • OSearchEnhancedFeature
  • OSearchPortalAdminLinks
  • OSearchSRPAdminLinks
  • OsrvLinks
  • OsrvTasks
  • OssNavigation
  • OSSSearchSearchCenterUrlFeature
  • OSSSearchSearchCenterUrlSiteFeature
  • PageConverters
  • PortalLayouts
  • PremiumRootSite
  • PremiumRootSiteStapling
  • PremiumSite
  • PremiumSiteStapling
  • PremiumWeb
  • PremiumWebApplication
  • ProfileSynch
  • Publishing
  • PublishingLayouts
  • PublishingPrerequisites
  • PublishingResources
  • PublishingSite
  • PublishingStapling
  • PublishingWeb
  • RecordsManagement
  • RedirectPageContentTypeBinding
  • RelatedLinksScopeSettingsLink
  • ReportCenterCreation
  • ReportCenterSampleData
  • Reporting
  • ReportListTemplate
  • ReviewWorkflows
  • SearchAndProcess
  • SearchWebParts
  • SharedServices
  • SignaturesWorkflow
  • SitesList
  • SkuUpgradeLinks
  • SlideLibrary
  • SlideLibraryActivation
  • SpellChecking
  • SPSDisco
  • SpsSsoLinks
  • SRPProfileAdmin
  • StapledWorkflows
  • TranslationWorkflow
  • TransMgmtFunc
  • TransMgmtLib
  • UpgradeOnlyFile
  • UserMigrator
  • ViewFormPagesLockDown
  • WebPartAdderGroups

linkedin Comparison of Sharepoint 2007 Features: MOSS vs. WSSdigg Comparison of Sharepoint 2007 Features: MOSS vs. WSSshare save 120 16 Comparison of Sharepoint 2007 Features: MOSS vs. WSS

Sharepoint WSS Search Server Stuck On “Pausing”

I ran across an issue this morning that had the Sharepoint WSS Search Server in a “Pausing” state.  I had to restart the Office SharePoint Server Search service in order to resolve the issue.

Now to see if it will complete successfully.

linkedin Sharepoint WSS Search Server Stuck On “Pausing”digg Sharepoint WSS Search Server Stuck On “Pausing”share save 120 16 Sharepoint WSS Search Server Stuck On “Pausing”

Delete An Extended Web Application

Extended web applications are not listed in the web application list and cannot be deleted using the Delete Web Application link in Central Administration.

Use the following steps to delete extended web applications:

  1. Start Central Administration
  2. Go to Application Management
  3. Click Remove SharePoint from IIS Web Site to get a page with a form similar to the following.
    image thumb Delete An Extended Web Application
  4. Select the web application that the extended web app was extended from
  5. Select which extention/zone to delete
  6. Select whether to keep or delete the IIS Web site
  7. Finally click OK
linkedin Delete An Extended Web Applicationdigg Delete An Extended Web Applicationshare save 120 16 Delete An Extended Web Application

SQL To Search Every Column Of Every Table

I was trying to export a site that had been moved from a MOSS farm to a WSS farm and was getting an error that a list did not exist.  Well, I’ve fought with this particular web application for quite a while and was sick of getting stupid little errors because of the move from MOSS to WSS.  So, I was able to find a SQL Stored Procedure that I could use to delete all references to the “orphaned” list.

I found this Stored Procedure on Vyas Kondreddi’s website.

CREATE PROC SearchAllTables
(
	@SearchStr nvarchar(100)
)
AS
BEGIN

	-- Copyright © 2002 Narayana Vyas Kondreddi. All rights reserved.
	-- Purpose: To search all columns of all tables for a given search string
	-- Written by: Narayana Vyas Kondreddi
	-- Site: http://vyaskn.tripod.com
	-- Tested on: SQL Server 7.0 and SQL Server 2000
	-- Date modified: 28th July 2002 22:50 GMT

	CREATE TABLE #Results (ColumnName nvarchar(370), ColumnValue nvarchar(3630))

	SET NOCOUNT ON

	DECLARE @TableName nvarchar(256), @ColumnName nvarchar(128), @SearchStr2 nvarchar(110)
	SET  @TableName = ''
	SET @SearchStr2 = QUOTENAME('%' + @SearchStr + '%','''')

	WHILE @TableName IS NOT NULL
	BEGIN
		SET @ColumnName = ''
		SET @TableName =
		(
			SELECT MIN(QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME))
			FROM 	INFORMATION_SCHEMA.TABLES
			WHERE 		TABLE_TYPE = 'BASE TABLE'
				AND	QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) > @TableName
				AND	OBJECTPROPERTY(
						OBJECT_ID(
							QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME)
							 ), 'IsMSShipped'
						       ) = 0
		)

		WHILE (@TableName IS NOT NULL) AND (@ColumnName IS NOT NULL)
		BEGIN
			SET @ColumnName =
			(
				SELECT MIN(QUOTENAME(COLUMN_NAME))
				FROM 	INFORMATION_SCHEMA.COLUMNS
				WHERE 		TABLE_SCHEMA	= PARSENAME(@TableName, 2)
					AND	TABLE_NAME	= PARSENAME(@TableName, 1)
					AND	DATA_TYPE IN ('char', 'varchar', 'nchar', 'nvarchar')
					AND	QUOTENAME(COLUMN_NAME) > @ColumnName
			)

			IF @ColumnName IS NOT NULL
			BEGIN
				INSERT INTO #Results
				EXEC
				(
					'SELECT ''' + @TableName + '.' + @ColumnName + ''', LEFT(' + @ColumnName + ', 3630)
					FROM ' + @TableName + ' (NOLOCK) ' +
					' WHERE ' + @ColumnName + ' LIKE ' + @SearchStr2
				)
			END
		END
	END

	SELECT ColumnName, ColumnValue FROM #Results
END
linkedin SQL To Search Every Column Of Every Tabledigg SQL To Search Every Column Of Every Tableshare save 120 16 SQL To Search Every Column Of Every Table

A potentially dangerous Request.Form value

We were having trouble adding a user to a site collection.  Every time we hit the search button or clicked the check userid button the system would just sit there and spin. I added the following section of the web.config to resolve the issue.


The error that we were getting in the trace logs is similar to below.

Exception Type: System.Web.HttpRequestValidationException  Exception Message: A potentially dangerous Request.Form value was detected from the client (ctl00$PlaceHolderDialogBodySection$ctl04$OriginalEntities="").

via Solien Technology

linkedin A potentially dangerous Request.Form valuedigg A potentially dangerous Request.Form valueshare save 120 16 A potentially dangerous Request.Form value