Utility for Renaming Files and Folders for OneDrive,
OneDrive for Business and SharePoint Online
from the author of DelinvFile and SharePrep
- - - NOTICE - - -
Sale of licenses for
SharePrep, OneDriveRx and Delinvfile
will terminate December 31, 2024.
On that date, Assistance and Resources for Computing, Inc,
will have been in the Shareware business for 25 years.
Support for these three current programs will continue
through September 30, 2025, to provide 9 months of
support for any last minute license sales.
Furthermore, we will have been incorporated for a total of
40 years in September, 2025.
We are taking this opportunity to thank the thousands of
individuals and companies that have licensed our products.
We are looking forward to retirement and being able to get
away from the computers.
Jim Lawler
JimLawler@PurgeIE.net
Microsoft's SharePoint Migration Tool simplifies the transfer of your files to
SharePoint Online or OneDrive for Business.
SharePrep can be used to prepare your files for that transfer.
SharePrep can identify and correct most, if not all, of the problems related to naming and path length restrictions.
At a minimum, you can use the free trial days to analyze your data for the known restrictions.
OneDriveRx 5.02 supports Win-7 thru Win-11 [32 & 64 bit]
Version 5.02 implements a new Code Signing Certificate as the existing Code Signing Certificate was about to expire.
Version 5.01 implements new functionality for working only with the files and their paths which exceed the user specified maximum combined (path + file) length.
The new Scan & Repair window tab, Max Lengths, processes only the files that exceed the specified limit.
The Shorten File Names only to Max Length option can be used to prevent shortening File Names more than absolutely necessary.
The Process only if Exceeds Max Length option can be used for the File Names, Folder Names, File Lengths, Folder Lengths and
Path Lengths functions to limit processing only to the necessary file and folder names.
The Scan and Repair window was
redesigned in version 4.01 to give the user greater control. The new design incorporates a
tabbed interface to access the various operational modes:
File Names - Work with characters for File Names
Folder Names - Work with characters for Folder Names
File Lengths - Work with lengths for File Names
Folder Lengths - Work with lengths for Folder Names
Path Lengths - Work with lengths for Paths
Path compression - the Path
Lengths processing is new with Version 4.01. This can be used to
reduce path lengths to a given target length.
The Truncation option was changed to a Shorten option which removes characters from the middle of the file name or subfolder name. For paths, the shortening is prorated based on the length of each subfolder name.
The recent change to SharePoint Online and OneDrive for Business to change the maximum number of characters from 256 to 400 gives you more flexibility with your file and folder names.
However, not all of the 400 characters are available for your use. You need to verify the actual limit for your installation. Please see "Max Length" and "TestSPOL" below.
OneDriveRx is a limited and less expensive version of SharePrep.
OneDriveRx is limited to processing only the OneDrive, OneDrive for Business and SharePoint Online "sync" files and folders.
OneDriveRx is not recommended for migrations of a large number of files and folders to OneDrive.
For large migrations,
If you are seeing either of the following SharePoint messages, OneDriveRx 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 a dot and cannot contain consecutive dots. |
| The specified file or folder name is too long. The URL path for all files and folders must be 260 characters or less (and no more than 128 characters for any single file or folder name in the URL). Please type a shorter file or folder name. |
In addition to truncation, OneDriveRx provides for user-defined character string substitutions which you can use to abbreviate common words in the file and folder names. This can help you retain usable names.
If you are having Sync problems or if you are seeing any of the following
messages,
OneDriveRx should prove useful...
| Error 0x8007007A: The data area passed to a system call is too small. |
| The specified file or folder name is too long. The URL path for all files and folders must be 260 characters or less... |
| The URL for this file is too long for the application. A temporary copy of this file will be opened on your computer. You must save this copy as a new file. |
| A file or folder can't be created because the path is too long. |
| ...path to a file is too long... |
The current version of OneDriveRx is 5.02.
The following are the some of the known File and Folder name
restrictions for OneDrive / 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 folder name and file name length depends on the SharePoint / OneDrive system used.
Separate documentation for determining your maximum folder name and file name
lengths is available at
A Free Utility is available to help determine these maximum
values at
OneDriveRx 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.
OneDriveRx is configurable. 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. A string of characters can be used for both the search and the replacement characters. This gives you a means for abbreviating portions of file and folder names for the purpose of shortening their names to meet the OneDrive / SharePoint name length restrictions.
OneDriveRx provides a convenient User Interface for selecting the folder for processing, setting the Options table and Repairing the file and folder names.
Shortening
For the File Lengths tab and the Folder Lengths tab, folder names will be shortened to the length specified in the Max Folder field and file names will be shortened to the length specified in the Max File field.
In previous versions, this was documented as a separate function,Truncate, which removed characters from the right end of the names. In the current version, the characters are removed from the center of the names which should yield more readable names.
The current version includes a function for reducing path lengths to the length specified in Max Path. The Repair function under Path Lengths performs its name reductions by attempting to remove a proportional number of characters from each level based on the number of characters available for removal.
The Resolve Duplicate Names function can be used to resolve any duplicates created by shortening, etc..
Trial Period and Limitations
OneDriveRx is currently distributed only as a Limited-Trial.
The rename and delete functions are available, but limited, in Limited-Trial mode.
The reason for this marketing approach is that
many organizations may need OneDriveRx for only a single day to
cleanup their sync folders.
The Limited-Trial
is limited to
However, this approach permits you to use OneDriveRx 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 OneDriveRx
before committing to the purchase of a license.
Upon purchasing a license, you will be sent a Registration Code which
you enter into OneDriveRx to complete the registration process. This
will enable all of the program's functions.
Site Licenses or Multiple-use Licenses are available for larger organizations
that need them. These licenses are priced based on the number of computers
that would make use of the program. An additional 25%
discount is available for Site Licenses for educational
institutions, public libraries and government facilities.
If your company requires you to fully test software prior to purchase
and you are likely to purchase if you could verify that OneDriveRx
would work on your projects and systems,
SharePrep and OneDriveRx makes use of the short form of file and folder names to perform the
renames. This is the older 8.3 format of the names that are normally
maintained in the directories of the drive volumes. Some have modified
their systems to avoid the creation of the 8.3 names on NTFS
volumes. This can cause some renames to fail.
Further, some larger data centers have transferred MAC-created files
to their servers. As MAC systems allow filenames considered invalid
to Windows systems, SharePrep and OneDriveRx may have trouble with these
particularly when the invalid character occurs within the short name.
Therefore, Assistance & Resources for Computing, Inc. will refund
the license fee upon receipt of proof that OneDriveRx is unable to
perform as advertised. Any request for a refund
must be made within 30 days of the purchase.
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
- https://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.
Once again, OneDriveRx is a limited version of SharePrep.