Posted Wed, 31 Jan 2018 09:15:55 GMT by Benoit Vassart ASC

Dear All, 

We want to create a approval workflow which should start when an index entry is modified. In our case, we have a field 'Status', when this field has a defined value, the workflow should start. 

This 'value update' is driven by the customer ERP, which update directly the value on the Docuware SQL database. (dwdata database).

It's seems that updating directly values within SQL is not supported and the Workflow is not started. Only if an index is changed within the web client or with the Docuware API. 

We don't want to use the Docuware API which is difficult in our case.( Customer's programming is not .NET).

Any ideas to find a workaround? 

 

Kind Regards

 

 

 

Posted Wed, 31 Jan 2018 12:34:52 GMT by Phil Robson DocuWare Corporation Senior Director Professional Services, Americas

Workflows are triggered by Content Server. If Content Server does not perform the update then it will never be detected. You must ensure that DocuWare performs the update. You could have your external process update a different field, and have Autoindex run and look for a specific value in the other field, and when found set the status to the desired value. The workflows will then trigger.

 

Phil Robson
Senior Director Support Americas

Posted Wed, 31 Jan 2018 12:42:45 GMT by Josef Zayats

Benoit,

we use a custom stand alone Docuware API .NET 'rewrite' program that is activated by a SQL trigger (IF UPDATE of STATUS field). This solution does not require any changes to existing ERP processes.

 

Posted Wed, 31 Jan 2018 12:59:13 GMT by Benoit Vassart ASC

Dear Josef,

Do you have more technical details on your solution? If I understand, we set a trigger on a sql field, then, the SQL trigger is updating a field with the Docuware api? 

 

Kind Regards

Posted Wed, 31 Jan 2018 13:07:20 GMT by Josef Zayats

Benoit,

We've develoed a standalone Docuware API based program which re-writes specified index fields for specified Docuware documents. This program is called by abovementioned SQL trigger with required parameters specified (DOCID, Field)

You must be signed in to post in this forum.