Forum Discussion

jcgonzalezmartin's avatar
Mar 10, 2017

Tool recommendation to remediate problems in Google Drive files before migrating to ODFB

Hello all,

I'm working on a migration project from Google Apps to Office 365 and one of the parts that need to be fixed before starting the migration is about how to remediate problems in the names of files and folders that contains invalid characters....so the question here is if anyone is aware of a tool / script that can help on the task of renaming files and folders

 

Thanks in advance!

4 Replies

  • Zoltan Bagyon's avatar
    Zoltan Bagyon
    Steel Contributor

    Sharegate can automatically replace invalid characters in file/folder names, but it's probably not the cheapest solution if you are using an other migrator tool. :)

    Worst case -but it depends on the volume of the data you need to fix this way-, syncing offline with the Drive sync client and running through on the affected files/folders with a PS script can do the job.

    • jcgonzalezmartin's avatar
      jcgonzalezmartin
      MVP
      I was thinking more on doing this remediation without having to sync files locally...in this particular case, migration is done through FastTrack so the remediation should be done ideally with a tool that allows to replace this ilegal caracters at Google Drive without having to locally sync the files in each user PC
      • Zoltan Bagyon's avatar
        Zoltan Bagyon
        Steel Contributor

        There some tools (like Netdrive) that can map Google Drive (and other cloud storages) under a drive letter via webdav. This way you don't have to sync locally, yet you can go through on the items with powershell, like:

         

        Dir -Recurse | Where { $_.Name.Contains("&")} | Rename-Item -NewName { $_.Name -replace "&","_" }

        Just tried it: slow, but works well.

         

Resources