Friday, August 8, 2014

Office365 SharePoint - Rename Multiple Files in Document Library

Unfortunately, Office 365 SharePoint doesn't let you to do too much using the built-in PowerShell cmdlets. Sometimes this trick can also come in handy with On Premise SharePoint installations when you just need a quick way to manipulate files in a library. Using PowerShell commands this is much more complicated.
Last day I ran into an issue (maybe I'll post that later) when I had to rename multiple files in a Document Library that resides on an Office 365 SharePoint instance.

What I did was the following:



Step1 - Add the website to the IE's Trusted Sites


First of all, you have to use Internet Explorer. Open in Explorer mode only works with this browser. Add the website to the trusted site's list then restart the browser. Otherwise it will complain later.


Now browse to your SharePoint Library again.



Step 2 - Open the Library in Explorer


Go to Library -> Open with Explorer



Step 3 - Map the location as a Network Drive


Now that you can see the library in Explorer, you need to grab the URL from the Address bar (ctrl + c) and map a network drive:



Press the ALT + T -> Map Network Drive



Choose a drive letter, paste your path and Finish. You may not want to reconnect the drive at logon.


Now, that you can see your files as a drive you can use your favorite tool to manipulate them.


Step 4 - Use your favorite tool to manipulate the files


I just used cmd to rename all pdf files but you can do much, much more with Total Commander if you have to.



Of course, this method work with SharePoint Server (On Premise) as well.

5 comments:

  1. Sharepoint has been a useful tool for us because we get to share one file in one location. Especially when we need research paper written project to be completed, we collaborate our ideas and input it on one file.

    ReplyDelete
  2. Your work is incredible and I like you and skipping for some more instructive posts. Much gratitude to you for conferring uncommon information to us.Useful for modification of site best essay writing service
    Thanks!

    ReplyDelete
  3. Highlight files in another Windows Explorer window and drag and drop to copy them into the document library (or hold down the shift key to move instead of copying the files) Highlight files in this window and drag and drop to copy them out of the library. find out best shirts and t-shirts with wide variety of famous brands in cheap rates at Online Stores In Pakistan

    ReplyDelete
  4. Last day I ran into an issue (maybe I'll post that later) when I had to rename multiple files in a Document Library that resides on an Office 365 . IT experts, it solutions, IT Experts Agency, Technical Support & IT Solutions, NOC, network monitoring, SEO, PPC, Google Adwords, Graphic Designing IT Experts

    ReplyDelete
  5. Highlight files in another Windows Explorer window and drag and drop to copy them into the document library (or hold down the shift key to move instead of copying the files) Highlight files in this window and drag and drop to copy them out of the library. Dars e nizami

    ReplyDelete