I wanted to see if it was at all possible to write a script task to download specific folders from a sharepoint active site in an automated
fashion. The way that we currently do this task is that we would use an excel sheet that contain "pms" which would be the six digit number
that we would use to manually copy and paste into the search to find the the folder within the active sites documents. From there we
would highlight all the contents within that folder and download them. When the file is done downloading we manually copy and paste the file
name of the file changing it to the corresponding six digit number from the excel sheet that we originally used to find the file in the directory.
Once the file is renamed we move the file from the downloads folder to a different folder on the desk top named "pms" for future reference.
We then would go back on sharepoint highlight and delete the folder and the relative files within it. From there we do the process all over again
going down a list of pm numbers on the excel sheet downloading and deleting. The goal is to backup the files individually from sharepoint then
deleting them from the site. My first question would be is this even possible to automate? If so what would be the best way to accomplish this.
For example, here is a step by step process.
1- Copy file number aka Pm number from the excel file.
2- Go to sharepoint admin portal, go to the specific url of the portal in this case we are currently working to remove files from our Fielding portal.
3- Use the file number you got from the excel document and paste that in the search bar. Then you are going to highlight all associated files/documents.
4- It will download as "One_drivefile_date" something like this. We will need to then take the original file number that we used to locate these files and rename the newly downloaded folder to the PM number(file number). This way once we archive these documents we will be able to find them in the future via the file number.
5- Once you have downloaded and renamed the file... go back to sharepoint and delete all associated files. This is being done to remove old files for archive and create space within Sharepoint. enter image description here
