How to make Docuware update an Excel file.

投稿済み Thu, 15 Apr 2021 07:59:24 GMT 、投稿者 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.

投稿済み Thu, 22 Apr 2021 07:59:24 GMT 、投稿者 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

投稿済み Thu, 22 Apr 2021 14:24:05 GMT 、投稿者 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.

WebService Example: https://developer.docuware.com/Extension_Services/examples/workflow_webservice_download.html

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.

.NET API: https://developer.docuware.com/dotNet/66b2ed1e-2aef-452a-97cd-5014bbf0242b.html

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

support.emea@docuware.com

Germany:	+49 89 894433 99
UK:	+44 115 7180154
Spain:	+34 93 1845879
France:	+33 176360767

DocuWare | Planegger Str. 1 | 82110 Germering | Germany

ヘルプを入手