Sharepoint Online - Metadata and large amount of files
Good Morning,
My company is a tenant of Sharepoint Online and I am the administrator for it.
I have been given the task of moving all of the companies files from a file server to Sharepoint Online.
In my attempts I have been successful, but due to the amount of folders/files, I have exceeded the ‘Limit View Threshold’ (LVT) for some of my document libraries.
I have been reading that enabling metadata for a document library and using different views would help with avoiding the LVT problem.
I have one particular document library with 17,280 folders and 340,162 files within it. Restructuring this folder will take too long, so I would like to try the metadata option. But, as there are so many files assigning the metadata would also take too long. I’ve read that I can use a excel spreadsheet to speed the process up of all the files, but I am unable to find any clear guide on doing this process from start to finish.
Can someone please provide the steps on how I can proceed with tagging all of these files to use metadata. If there is an easier way to use metadata for a large group of files I would like to know this as well.
Please note that increasing the LVT limit or removing it completely is not an option. Also please do not recommend any alternative systems to use instead of Sharepoint, as we have been instructed by Corporate to use it. Using Sharepoint Document Center (for static content) is also not an option.
Appreciate your time and assistance with this.
Kind Regards,
K
My company is a tenant of Sharepoint Online and I am the administrator for it.
I have been given the task of moving all of the companies files from a file server to Sharepoint Online.
In my attempts I have been successful, but due to the amount of folders/files, I have exceeded the ‘Limit View Threshold’ (LVT) for some of my document libraries.
I have been reading that enabling metadata for a document library and using different views would help with avoiding the LVT problem.
I have one particular document library with 17,280 folders and 340,162 files within it. Restructuring this folder will take too long, so I would like to try the metadata option. But, as there are so many files assigning the metadata would also take too long. I’ve read that I can use a excel spreadsheet to speed the process up of all the files, but I am unable to find any clear guide on doing this process from start to finish.
Can someone please provide the steps on how I can proceed with tagging all of these files to use metadata. If there is an easier way to use metadata for a large group of files I would like to know this as well.
Please note that increasing the LVT limit or removing it completely is not an option. Also please do not recommend any alternative systems to use instead of Sharepoint, as we have been instructed by Corporate to use it. Using Sharepoint Document Center (for static content) is also not an option.
Appreciate your time and assistance with this.
Kind Regards,
K
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SharePoint is not the answer in all situations. Seems like you made a good decision for you needs.
Thanks for the kind words. Have a good one...
Thanks for the kind words. Have a good one...
ASKER
We've decided to abandon the sharepoint idea. Turns out to be too much headache. Apparently head office had no problem with the decision, I'm assuming they are realizing sharepoint is is just not realistic for a replacement file server.