03-08-2019 05:15 AM
I have a document (AP Invoice) that my users want to add a "Vendor ID" Keyword to. Currently the document type has a Keyword of "Vendor Name".
I have a list of the Vendor Names with their associated Vendor IDs. Is there a script way or "automated" way of back filling the IDs for the Vendor Names? I have about 8 years of invoice history they are wanting updated.
Thanks in advance,
Bob
03-11-2019 08:42 AM
Check out the Keyword Updater tool - it should have the functionality you are looking for to update documents based on a specific keyword value. See this post for more information: https://community.hyland.com/forum/threads/52280-keyword-updater
03-12-2019 08:49 AM
Corinthia,
Thank you for the reply. Yes, the Keyword Updater tool does do this but it is extremely slow versus running an SQL statement directly on the DB. I have years worth up updates to do with thousands of vendors. I was going to try to do it over a weekend. With the timing, this is not possible.
I believe support would frown on me running a SQL Statement to update the values needed.
03-12-2019 09:00 AM
What if you broke it up by doc type instead of doing a global update?
Or only globally update a smaller number of vendors than all vendors?
03-12-2019 11:50 AM
I am doing it by doc type. The problem is the system has been online for so long there are "boat load" of invoices to update. My first run was with 65,000 documents. The Keyword updater ran for 4 hours. After that I killed it. Opened the client and verified the update was completed. It was. No way of telling exactly when. In summary the keyword updater "freezes" after initiating. Not sure if it is running or not.
03-13-2019 09:41 AM
Hi Everyone,
I wanted to make it known that using SQL to insert, update or delete data contained in the HSI schema is against our Database Use Policy.
If any of you have any questions regarding this policy, please let me know.
Best,
Joel
03-13-2019 11:14 AM
Thanks Joel, figured so.
"I believe support would frown on me running a SQL Statement to update the values needed."
Bob
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.