Posted Thu, 25 Nov 2021 11:59:14 GMT by Rhys Woolley Software Developer
I need to be able to find all documents that have a duplicated field in a file cabinet, I've heard that this can be done with Autoindex, but so far, I haven't been able to get it to find the right documents. Does anyone know how to have an autoindex find a document and mark all additional documents that match a specified field. I have a field called "duplicate" so when the documents are found, I want the word "duplicated" in this field
Posted Thu, 02 Dec 2021 11:59:14 GMT by Matthias Wieland DocuWare Europe GmbH Sr. Director Support EMEA
Dear Rhys Woolley! It looks like the Community cannot answer your question. That's why we have opened a Support Request with the Number SR-165633-N7H4C for you. A Software Support Specialist will contact you directly to follow up. We will update this thread with the solution as soon as we have resolved the Support Request. With best regards, DocuWare Support Team
Posted Thu, 02 Dec 2021 12:42:06 GMT by Brian Whitford CBIZ Application Developer Analyst
I was able to do this for a recent migration.  I setup the criteria for Autoindex to search then in the match data tab I did a match on an external database.  This database was just the file cabinet database using the following SQL statement:

select count(DOCUMENT_ID) as counts, DOCUMENT_ID
from DWRPSTPA_ACTIVE.dbo.RPS_TPA
group by DOCUMENT_ID
having count(document_id) > 1

In the above SQL statement, DWRPSTPA_ACTIVE.dbo.RPS_TPA is the file cabinet's database and DOCUMENT_ID is actually an ID from another system used during the migration (not the DWDOCID).  It totals up the ID numbers and when the count is > 1 in the assign data tab I assigned the duplicate index a fixed value if yes for all matches

 
Posted Thu, 09 Dec 2021 14:40:12 GMT by Marco Mc Carthy Technician Software Support
Dear Rhys Woolley, Dear Forum-Users,
Thank you for opening this thread. I have checked your question and can provide you with the following description:
KBA-36518 - How to flag duplicate documents already stored in the file cabinet
Within our Knowledge Base, we have several How-tos and other interesting guides and content that can help you with using DocuWare.
I hope the description will help you to evaluate all duplicate documents.
Kind regards
DocuWare Support

You must be signed in to post in this forum.