


This could take a few seconds, depending on the number of files that you have. Make sure that you have the following options checked:Īfter checking those boxes, click into the file list at the top right of the window and press the Ctrl + A keys on the keyboard to select all items. Copy and paste this list into this Character Translation popup window: Á=AĪfter pasting in the info, press OK and return to the main window: I copied and pasted all of the accented characters and their ANSI equivalents into Excel and formatted it for Bulk Rename Utility to be able to use the list. Inside the app, click on the option at Special > Character Translations. Instead of figuring out the right regex command and running a rename command in Powershell, I decided to keep it simple and use the Bulk Rename Utility app that I've used for other projects, including the project I wrote about to redact Microsoft Word files quickly.Īfter downloading and installing the app on the file server, open it and target the share location on the local drive. To fix the accent characters, I could go in manually an rename all of the files, but I needed an easier way to automate this. I needed to rename all of the non-migrated files from the accented characters into the ANSI equivalents and then run an incremental sync. They're also using a mix of MacOS and Windows PCs, so the folders can get pretty cluttered with UTF and non-Windows character sets.įrom the logs, the Sharepoint Migration Tool seems to only allow ANSI characters, probably for URLs and other internal compatibility.

They're an international organization and has French, Spanish, and Portuguese workers that connect into the shared drive. I set my source as the shared folder containing 1.8 TB of files and the target destination as the Documents library in a newly created Sharepoint site.Īfter letting the tool run for a few hours, the migration tool completed and reported that it had successfully moved 209,726 files, but 500 were not moved because the scanner has issues with special characters: To do this, I ran the official Microsoft Sharepoint Migration Tool from the file server. One of the companies that I'm working with wants to migrate all of their files on a local file share and move them into a Sharepoint site.
