Publié Mon, 22 Mar 2021 12:33:24 GMT par Rhys Woolley Software Developer
I want to set up a workflow which takes a value from a form and subtracts it from a value in an Excel file, then updates the Excel file with the result.

Any ideas?
Publié Mon, 29 Mar 2021 12:33:24 GMT par 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-147225-P7Z9S 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
Publié Fri, 23 Apr 2021 05:42:14 GMT par Michael Steidl Jr. Software Support Specialist
Dear Rhys Woolley,

as discussed in another Forum post.

You can do this by creating a Webservice and using the webservice activity in the Workflow Designer.
Unfortunately this is not possible with the DocuWare Web Client only, but you can archive this with Workflow Designer and a Webservice Activity.
You can create a WebService with our WebService Example and host it on a Server which DocuWare is able to reach.

You can change the value in the Excel File by Downloading the Excel File in the Webservice, changing the Value, and then Replacing the Excel File with the .NET API.
The process could be like this.
1. A Workflow will be triggered.
2. A Webservice activity will be executed.
3. The Webservice Activity will send the DocID of the Excel File and the values that have to be changed to the Webservice as parameter.
4. The Webservice will use our .NET API to get the Document.
5. You can now change the Excel file with a library of your choice.
6. Now replace the Excel file in DocuWare with the one you changed the value.

With best regards,

Michael Steidl

Technician Software Support Team Green EMEA
 
Germany: +49 89 894433 99
UK: +44 115 7180154
Spain: +34 93 1845879
France: +33 176360767

DocuWare | Planegger Str. 1  | 82110 Germering | Germany

You must be signed in to post in this forum.