Hello,
So I wanted to put this out there and see if anyone has an idea for this.  I recently took over administration of a 2013 on-prem farm where a “client site” solution was just implemented.  There is a site template that is used to generate a new client site for each existing or new client we have.  All docs and client info is stored there.  Here is the problem…Â
When they designed the template they used lookup columns instead of metadata.  So all this tagging is essentially useless. What I’d like to see is term sets, site columns, in a content type and then applied to each library in the client sites. Unfortunately thousands of client sites have already been created so just fixing the template isn’t going to help that much.  Anyone ever been tasked with fixing something like this? Maybe a third party migration tool?
Thanks ahead of time!
Sounds like you would need a custom solution to automatically accomplish this…
If you are actually moving data from Site A to Site B and actually moving the data to new specific places, I’m not sure where you are going to find a tool that will do something that specific.
Also, you would probably need to run through a process to ensure that the thousands of sites follow a consistent pattern before hand. Â That could probably be done by a script or something of the sort. Â For instance, if the old client file had two document libraries, you could check for that specifically.
Having said that, I would probably recommend a visual inspection for the thousands of client files by the end users. Â Or, make assumptions and keep the old sites locked but accessible for now.
We have a client that we migrated from an unstructured content approach using SharePoint 2010 with most of their client data in Word documents. Â When they started they were all paper. Â
From there, we figured out the appropriate content types and went to 99% SharePoint lists. Â And had to migrate all the content from the old sites to the new structure.