Uploading bulk files into Sharepoint can be a nightmare when file names contain illegal / reserved characters. A useful utility called Name Munger can assist you in renaming all your files quickly & easily so that they are Sharepoint compliant.

Name Munger (pronounced “Name Munjer”) is a powerful, yet simple-to-use batch file renaming utility. Simply drag one or more files or folders onto the Name Munger icon and you can easily add text before or after the existing name, change one or more occurrences of part of the name or even remove some of the name. In a snap you can rename dozens or even hundreds of files.

Name Munger Features

Quickly rename one file or a thousand with a simple drag-n-drop!
Add to the beginning of file and folder names.
Add to the end of file and folder names.
Replace text anywhere in a file or folder name.
Remove text from anywhere in a file or folder name.
Strip any character or set of characters from file or folder names.
Strip leading and/or trailing spaces from a file or folder name.
Change file names to ALL UPPER CASE, all lower case, Title Caps, or Initial caps.
Add customizable numbers before, after or instead of file or folder names.
Renames items in nested folders or just those you select.
Preview your changes before applying them.

Bulk File Renaming Utility

More From pstilgoe

• How to embed a powerpoint presentation into a Sharepoint page
• How to Prevent users from changing views in Sharepoint
• Sharepoint: Removing illegal characters from filenames prior to bulk uploading

Ask pstilgoe To Recommend Your Posts

Works like a dream….

InfoPath – Get the current user without writing code

More From pstilgoe

• Error: There is no file with URL ‘http://test-url’ in this Web.
• PHP SEO Friendly Redirect Script
• Compare Office 2003 & Office 2007 functionality with MOSS 2007

Ask pstilgoe To Recommend Your Posts

Open web.config and look for the following lines:

add name=”GlobalNavSiteMapProvider” description=”CMS provider for Global navigation” type=”Microsoft.SharePoint.Publishing.Navigation.PortalSiteMapProvider, Microsoft.SharePoint.Publishing, Version=13.0.0.0, Culture=neutral, PublicKeyToken=94de0004b6e3fcc5″ NavigationType=”Global” EncodeOutput=”true”

add name=”CombinedNavSiteMapProvider” description=”CMS provider for Combined navigation” type=”Microsoft.SharePoint.Publishing.Navigation.PortalSiteMapProvider, Microsoft.SharePoint.Publishing, Version=13.0.0.0, Culture=neutral, PublicKeyToken=94de0004b6e3fcc5″ NavigationType=”Combined” EncodeOutput=”true” /

add name=”CurrentNavSiteMapProvider” description=”CMS provider for Current navigation” type=”Microsoft.SharePoint.Publishing.Navigation.PortalSiteMapProvider, Microsoft.SharePoint.Publishing, Version=13.0.0.0, Culture=neutral, PublicKeyToken=94de0004b6e3fcc5″ NavigationType=”Current” EncodeOutput=”true” /

add name=”CurrentNavSiteMapProviderNoEncode” description=”CMS provider for Current navigation, no encoding of output” type=”Microsoft.SharePoint.Publishing.Navigation.PortalSiteMapProvider, Microsoft.SharePoint.Publishing, Version=13.0.0.0, Culture=neutral, PublicKeyToken=94de0004b6e3fcc5″ NavigationType=”Current” EncodeOutput=”false” /

Add the following attribute to each provider definition: DynamicChildLimit=”” (0 indicates no limit).

e.g.

add name=”GlobalNavSiteMapProvider” description=”CMS provider for Global navigation” type=”Microsoft.SharePoint.Publishing.Navigation.PortalSiteMapProvider, Microsoft.SharePoint.Publishing, Version=13.0.0.0, Culture=neutral, PublicKeyToken=94de0004b6e3fcc5″ NavigationType=”Global” EncodeOutput=”true” DynamicChildLimit=”75″ /

More From pstilgoe

• View PDF documents in a webpart
• How to embed a powerpoint presentation into a Sharepoint page
• How to set a custom default masterpage for all sites in WSS3

Ask pstilgoe To Recommend Your Posts

When you send a meeting invitation in Outlook 2003 or in Outlook 2007, you can create a Meeting Workspace. A Meeting Workspace is a Web site for centralizing all the information and the materials for one or more meetings.

If you use Outlook 2003 or Outlook 2007 with a Microsoft Exchange Server e-mail account to set up the Meeting Workspace site, a link to the Meeting Workspace site is automatically added to the body of your meeting request. When invitees click the link in the body of the meeting invitation, the Meeting Workspace site opens in their browser. In their browser, the invitees can see and work with the agenda, the documents, and other meeting information. Outlook 2003 and Outlook 2007 also communicate with the Meeting Workspace site and automatically adds the subject, the attendee names, the date, the time, and the location from the meeting request to the Meeting Workspace site. If you later change the attendee names, the date, the time, or the location in Outlook 2003 or in Outlook 2007, Outlook 2003 or Outlook 2007 automatically updates the information in the Meeting Workspace site.

The meeting that you created the Meeting Workspace site for does not occur in the Meeting Workspace site. The meeting itself is conducted in person, over the telephone or from a conferencing program, such as Microsoft Windows NetMeeting. However, you can view the Workspace site and update it during the meeting. For example, you can update the attendees list to indicate who actually participated, list decisions, track tasks, and publish the meeting minutes. These features result in a complete record of the meeting for future reference.

A Meeting Workspace is a special type of Microsoft Windows SharePoint sub site under a parent Microsoft Windows SharePoint site. If your company uses Windows SharePoint Services, Microsoft Office SharePoint Portal Server 2003, or Microsoft Office SharePoint Server 2007, you can create shared workspaces with the documents, the photos, the presentations, the discussions, and all the other related information for an upcoming meeting or critical event.

In earlier versions of Microsoft Outlook, when you created a meeting, you would type an agenda and attach documents to the meeting invitation in your calendar and e-mail program. Now you can put that information in a Meeting Workspace site so that invitees can access it anytime to view, to edit, or to add information (depending on their permissions).

Your Meeting Workspace site is a sub Web. This means that it is a Web site in a Windows SharePoint Services site. Because it is a sub Web, you can gather important information and prepare for an upcoming meeting.

Windows SharePoint Services, SharePoint Portal Server 2003, SharePoint Server 2007, Outlook 2003, and Outlook 2007 all make it possible for you to set up a Meeting Workspace site for more than one meeting, such as for a recurring meeting or for multiple related meetings that are linked to the same Meeting Workspace site. Also, you can assign a delegate to set up the Meeting Workspace site for you.

For Meeting Workspace sites that are created in your company, you can invite anyone to the Meeting Workspace site that is in the same trusted domain as you and who has a valid e-mail address. For Meeting Workspace sites that are created on external sites, you can invite anyone who has a valid e-mail address.

To create a Meeting Workspace in Outlook 2003, click Meeting Workspace on the appointment screen.

To create a Meeting Workspace in Outlook 2007, follow these steps:1. On the File menu, click New, and then click Appointment.
2. In the Appointment window, click the Microsoft Office Button, and then click Meeting Request.
3. In the Attendees area, click Meeting Workspace, and then click Create.
4. Select a location and a workspace for the new Meeting Workspace, and then click OK.
The Meeting Workspace site is composed of one or more pages that contain meeting details and lists of information that are common when you plan, conduct, or follow up on a meeting. Typical lists for a Meeting Workspace site include the Objectives, the Agenda, the Attendees, the Decisions, and the Tasks lists.

Additionally, you can add a document library and a picture library where users can store materials related to the meeting. By default, the lists and libraries that appear on the home page depend on the template that you select when you create the Meeting Workspace site.

On the home page (or on any new pages that you add), the information is divided into parts named Web Parts. Web Parts exist for each type of list or library and for all the other types of information that you can add to the Meeting Workspace site. If the Meeting Workspace site does not contain all the information that you require, or if you do not like the layout or the look of the Meeting Workspace site that you created, you can customize it. Help for the Meeting Workspace, in addition to general Windows SharePoint Help, is available from the Meeting Workspace site.

If you use an Instant Messaging program that is compatible with Windows SharePoint Services, such as Microsoft Windows Messenger, Microsoft MSN Messenger, or the Microsoft Exchange Instant Messaging Service, you can use that program from the Attendees list in the Meeting Workspace site to communicate with other attendees. If an attendee is online, you can ask him or her to visit the Meeting Workspace site so that you can work together.

More From pstilgoe

• Creating a scheduled email reminder using Sharepoint Designer
• Creating filtered views in Sharepoint
• Sharepoint Search – How features work part 1

Ask pstilgoe To Recommend Your Posts

A recent study conducted by ioko for a typical NHS Trust indicated that over half the respondents found it difficult to find information and could not be sure they were using the latest version of the document. 32% indicated that they spent between 2 to 5 hours or more per week searching for information.

You do the maths !!

More From pstilgoe

• How to add Blackberry support for MOSS 2007 & Infopath Forms
• Error: Cannot retrieve the information for application credential key
• How to delete the Shared Service Provider in MOSS 2007

Ask pstilgoe To Recommend Your Posts

Web Parts

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
Data View Web Part

Web Parts specific to MOSS 2007

Business Data
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

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.

Dashboard

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.
I need to… Displays tasks and tools from a list
IView Web Part Displays iViews from SAP portal servers.
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.

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

More From pstilgoe

• How to configure Kerberos for SharePoint / MOSS 2007
• Enabling MySites in MOSS 2007
• The ‘not so talked about’ limitations of MOSS 2007

Ask pstilgoe To Recommend Your Posts

Very handy webpart from Codeplex:

Description: Override the default content query web part, and add advanced features such as context menus for the items, toolbar for lists (if the web part is connected to a single list) and so on.

More to follow…………………..

Download here:

Enhanced Content Query Web Part

More From pstilgoe

• Content Type Toolbar Web Part
• Error: There is no file with URL ‘http://test-url’ in this Web.
• SharePoint: How to display blog feed using XML Web Part?

Ask pstilgoe To Recommend Your Posts

When installing Blackpoint Beta in a MOSS standalone environment, if you have problems connecting to the SQL database try the steps below which should resolve your issue:

1) Open SQL Server Configuration Manager, expand SQL Server 2005 Network Configuration, Protocols for SQLEXPRESS, Enable Named Pipes.

2) Open SQL Server 2005 Surface Area Configuration, select Surface Area Configuration for services and connections, Expand Data base Engine node and select Remote connections in the tree view, Under Local and remote connections select a option that include named pipes.

3) Make sure to add your database name in the K2 configuration as TESTSQL\SQLEXPRESS

More From pstilgoe

• Enable anonymous access on a Sharepoint site
• Does K2 Blackpoint (or Blackpearl) work in a HTTPS / SSL environment?
• Change InfoPath View Before Uploading Form Using K2 Blackpoint

Ask pstilgoe To Recommend Your Posts

When trying to upload a document in Sharepoint / MOSS you get the following error:

Hashtable insert failed. Load factor too high

This appears something to do with the .NET Framework although Im not sure what’s causing it as of yet. However by doing an ‘iisreset’ on your front end webservers fixes this problem (Not sure for how long).

Will post once a long term fix is found!

More From pstilgoe

• View PDF documents in a webpart
• Error: There is no file with URL ‘http://test-url’ in this Web.
• Sharepoint list error <!– #RENDER FAILED –>

Ask pstilgoe To Recommend Your Posts

By default your MOSS installation won’t index / provide search for PDF files, to get MOSS to index PDF files follow the steps below:

1. Download Adobe Reader (v.8 or higher)

2. Add PDF to the File types crawled:

Start -> Program -> Microsoft Office Server -> SharePoint 3.0 Central Administration -> -> Search Settings -> File Types -> New File Type (Add extension pdf here)

3. Change the following Registry keys by changing their “Default” value to the new CLSID of the Adobe IFilter: {E8978DA6-047F-4E3D-9C78-CDBE46041603}

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office
server\12.0\Search\Setup\ContentIndexCommon\Filters\Extension\.pdf

Default –> {E8978DA6-047F-4E3D-9C78-CDBE46041603}

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server
Extensions\12.0\Search\Setup\ContentIndexCommon\Filters\Extension\.pdf

Default –> {E8978DA6-047F-4E3D-9C78-CDBE46041603}

4. Add the Installation directory of the Adobe Reader v.8 to the System Path. For example, if the Reader is installed on “D:\Program Files\Adobe”, then add “D:\Program Files\Adobe\Reader 8.0\Reader” to the system path by:

–> Right Click on My Computer -> Properties -> Advanced -> Environment Variables -> Path (Under System Variables) -> Edit -> (Add “D:\Program Files\Adobe\Reader 8.0\Reader”).

This effectively tells the adobe IFilter where to pick up the dependent DLLs.

5. Recycle the search service: > net stop osearch

> net start osearch

6. Now we can crawl and search PDF documents with v.8 Reader.

To add the PDF Icon to search results:

1) Download pdf icon file from http://www.adobe.com/misc/linking.html

2) Save the icon to ‘C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\Template\Images’ folder

3) Edit DOCICON.XML found in C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\XML

4) Add inside the node and save the document

5) Perform a full crawl on your content sources

More From pstilgoe

• How to add Blackberry support for MOSS 2007 & Infopath Forms
• How to delete the Shared Service Provider in MOSS 2007
• How to configure Kerberos for SharePoint / MOSS 2007

Ask pstilgoe To Recommend Your Posts