09-24-2014 01:25 PM
09-24-2014 01:36 PM
09-24-2014 01:41 PM
Can do it via scripting.
Query for all docs in the Doc Type
Loop though each doc in the result list
Copy value in First Name_Old to First Name
Save KWs
09-25-2014 05:44 AM
09-25-2014 06:07 AM
I've done this with Workflow (specifically a system task).
I had to reindex about 500 HR docs. I wanted to change from using a Full Name keyword to using First Name and Last Name. Manually reindexing each doc was taking about 20sec each.
The logic was something like this. Assuming all Full Name Keywords are formatted "First Last" with no prefixes, suffexes, or punctuation (which in my case was true).
1. Is Last Name Blank KW (exists)? (my new KW, I simply renamed the Full Name Keyword to First Name)
T - Break Processing for this Doc
F - <nothing>
2. Prop Expression - Extract First Name
propFirstName = LEFT(%K00106;InStr(%K00106;" "))
3. Prop Expression - Extract Last Name
propLastName = Mid(%K00106; InStr(%K00106;" ")+2; LEN(%K00106)-InStr(%K00106;" ")+2 )
4. Copy propFirstName to First Name KW (delete existing values)
5. Copy propLastName to Last Name KW (delete existing values)
The workflow task executed in about 8 seconds correcting all 500 docs at once.
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.