Utility for Renaming Files and Folders for SharePoint
from the author of
PurgeIE - Purge Cache, Cookies and Tracks for Internet Explorer
SharePrep is a special-purpose utility program for SharePoint that you can use to correct file and folder names in preparation for importing data into Microsoft's SharePoint Server and MOSS. The folder and filenames within SharePoint have more restrictions than for normal Windows operation. These restrictions are for both special characters and length of the file names and folder names.
If you have seen the following message, SharePrep can help...
| The file or folder name <name> contains invalid characters. Please use a different name. Invalid characters include the following: ~ " # % & * : < > ? / \ { | }. The name cannot begin or end with dot and cannot contains consecutive dots. |
The current version of SharePrep is 1.02.
SharePrep supports Win-2000, XP, 2003 and VISTA
Recent changes include a "Logging file" for recording name changes and a File Filter on the Scan and Repair Window.
The following are the currently known File and Folder name
restrictions for SharePoint:
1. The name can not contain any of the following characters:
|
"
|
-
|
Quotation mark |
#
|
-
|
Number sign |
|
%
|
-
|
Percent Sign |
&
|
-
|
Ampersand |
|
*
|
-
|
Asterisk |
:
|
-
|
Colon |
|
<
|
-
|
Less than Symbol |
>
|
-
|
Greater than Symbol |
|
?
|
-
|
Question Mark |
\
|
-
|
Backslash |
|
{
|
-
|
Left Brace |
}
|
-
|
Right Brace |
|
|
|
-
|
Pipe |
~
|
-
|
Tilde |
|
/
|
-
|
Slash |
2. The name can not begin or end with a period
3. The name can not contain a double period
4. The file name can not exceed 128 characters in length
5. The folder name can not exceed 128 characters in length.
SharePrep provides a convenient user interface to allow you to search your file names and folder names for the above restrictions and provides functions for automatically renaming the file and folder names to replace the restricted characters.
You can define the action to be used by the rename function for each of the restricted characters. For each, you can choose to delete the character, replace with a blank or replace with a character or string of characters you specify.
You can add additional entries to Options table. Actually, a string of characters can be used for both the search and the replacement characters.
SharePrep provides a convenient User Interface for selecting the folder for processing, setting the Options table and Repairing the file and folder names.
SharePrep is not just for SharePoint. Some are using SharePrep to bulk rename invalid files and folders. For example, some backup / recovery programs have name restrictions.
Trial Period and Limitations
SharePrep is currently distributed only as a "Demo".
The rename and delete functions are disabled in "Demo" mode.
You can use the program in "Demo" mode to analyze your files
for needed name changes. The reason for this marketing approach is that
many organizations may need SharePrep for only a single conversion.
However, this approach permits you to use SharePrep as a
diagnostic tool to check the lengths of file and folder names as well as
to identify the quantity of names that require renaming. In short,
you can determine whether you need the rename functions of SharePrep
before committing to the purchase of a license.
Upon purchasing a license, you will be sent a Registration Code which
you enter into SharePrep to complete the registration process. This
will enable all of the program's functions.
Site Licenses and Server Licenses are available for larger companies
that need them. These licenses are priced based on the number of computers
that would make use of the program.
Credits
The credit for the idea to create SharePrep belongs to Göran Husman.
He is an author, SharePoint MVP, Consultant & Trainer residing in
Stockholm, Sweden. Göran is president of HumanData Inventus AB
- http://www.humandata.se/
He has published several SharePoint books.
Göran first requested a change in the scan function of Delete
Invalid Files, to search for additional characters. After
receiving a pre-release copy of the program with the enhanced function, he
requested that the program be enhanced to automatically rename files to
replace the given characters.
He explained that he had a client with
a project containing over 55,000 files to be imported into SharePoint.
The scan revealed that there were over 1,000 files with restricted
characters that would have to be manually modified before importing into SharePoint.
Development of SharePrep began the next day.