Posted Thu, 15 Apr 2021 07:59:24 GMT by Rhys Woolley Software Developer
I posted this a few weeks ago and got no response, hopefully this time I'll have a little more luck.

I'm creating an Excel spreadsheet with the intention of creating a workflow that activates when a new Docuware Form is submitted and populates the fields on an Excel sheet with fresh calculations. For example, subtracting the amount of days approved for a holiday from the total amount of remaining holidays for that employee.
Posted Thu, 22 Apr 2021 07:59:24 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-148677-X0M3M 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, 22 Apr 2021 14:24:05 GMT by Michael Steidl Jr. Software Support Specialist
Dear Rhys Woolley,
thank you for this Question in our Forum.

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.