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!
Turns out there is a solution here. I received a proposal today from our consultant. They proposed creating the new term sets, adding them to a content type, applying that to each doc library in the template, running a PS script to sync all client sites to the template, then finally running a script to tag each document with the new term by matching the choice already tagged to each document. Remove all the lookup choice columns and we’re done. No problem right! I will make sure to post the scripts used on here when we do it.
