Hello Bob,
We have had OnBase for almost a year now & I have learned a lot of things the hard way, lol. I had to do something similar with keywords with successful results. I am not sure how many documents 8 years’ worth is but I have used the process below to add, modify, & remove keywords from over a 100,000 documents in our system.
Create a life cycle in Studio that has a rule in the Initial queue to look for the keyword Vendor Name when True use an Action to add the keyword Vendor ID. If False setup another rule to look for next Vendor Name & continue creating the rules until you have all the Vendor Names & IDs setup.
If you do not need those to stay in the life cycle I would have them remove from the life cycle after the action. I would set the rules up for all Vendors & then add the Document Types to the life cycle, save it & Reset the Cache.
Go into the Unity Client & use Retrieval to find the documents right click, Workflow, Execute workflow. Find the workflow you just created & add them to it.
Run a couple documents for a few different Vendors through first to verify everything is executing correctly & the correct Vendor IDs are being added. Then run larger batches through the workflow until everything has been updated.
I am not sure if this is the most efficient way but it may give you some ideas that may help.
Good luck & if you have any questions please let me know.
