Gerardo Lisanti Team Leader Product Management

Hi Ameen,

as this requires a CAST or CONVERT operation on the database, you need to provide the SQL Statement (see screenshot attached)
e.g. for MSSQL: [YEAR]=CAST(YEAR(GETDATE()) as CHAR(4))

To do this, you must first activate the "Allow database access via SQL statement" option in DocuWare Administration > DocuWare System > General. Then you can specify a SQL WHERE clause.

However, this is only possible for DocuWare On-Premises.
For DocuWare Cloud, as far as I know, there is currently no solution to make this dynamic.

Viele Grüße / With best regards,

--

Gerardo Lisanti
Product Manager  |  DocuWare GmbH

Hi Steve,

I understand. At the moment you can add table rows only when you transfer data from one table to another.
There you can only map table columns to table columns, e.g.

• '[MyTable]Last Vendor Name' = '[MyOtherTable]Last Vendor Name'
• '[MyTable]Last Invoice Amount' = '[MyOtherTable]Last Invoice Amount','
• ...

The missing piece is the assignment of index fields to table columns, e.g. like in your case:

• '[MyTable]Last Vendor Name' = 'Last Vendor Name'
• '[MyTable]Last Invoice Amount' = 'Last Invoice Amount'
• ...

We will look at that and see if we can improve things in the future.
Currently we are working on improving and extending the mapping of data between 2 tables by being able to match rows.

Viele Grüße / With best regards,

--
Gerardo Lisanti
Product Manager  |  DocuWare GmbH

Hallo Patrick,

eine 2-Faktor Authentifizierung für die Anmeldung mit DocuWare Benutzername und Passwort ist aktuell noch nicht geplant.
Wir empfehlen die Integration von DocuWare mit einem Identity Provider bzw. die Umstellung auf Single Sign-On und die Einrichtung der 2-Faktor Authentifizierung direkt im Identity Provider. In Kombination mit der Richtlinie, dass man sich in DocuWare nur noch über Single Sign-On anmelden kann, wird auch 2FA verlangt. Siehe auch https://help.docuware.com/#/home/80227/1/1

Mit der nächsten DocuWare Version, werden wir eine universelle Open-ID Connect Anbindung für die Einrichtung von Single Sign-On anbieten.
Damit kann man, neben den aktuell bereits unterstützten Identity Providern von Microsoft (Azure AD und ADFS) auch zahlreiche weitere Identity Provider anbinden.

Viele Grüße / With best regards,

--
Gerardo Lisanti
Product Manager  |  DocuWare GmbH

Hallo Herr Acker,

wenn ich das richtig verstanden habe möchten Sie immer alle 3 Abkürzungen austauschen, sofern sie vorkommen.
Die IF abfrage benötigen Sie in diesem Fall nicht, da die Replace Funktion die Abfrage im Prinzip selbst mitbringt:
"Wenn dieser Wert vorkommt, dann tausche ihn mit folgendem Wert aus"

Daher müssen Sie lediglich 3 Replace Anweisungen verschachtelt ausführen, z.B.:
Eingabe: WW und WZ und KÜ sind ausgefallen
Ausdruck: Replace(Replace(Replace(DW_BETREFF,"WW","Warmwasser"),"WZ","Wohnzimmer"),"KÜ","Küche")
Ausgabe: Warmwasser und Wohnzimmer und Küche sind ausgefallen


Wenn Sie case-insensitiv austauschen möchten, also "WW" oder auch "ww", dann geben Sie eine 1 als CompareMethod Parameter mit:

Eingabe: ww und Wz und KÜ sind ausgefallen
Ausdruck: Replace(Replace(Replace(DW_BETREFF,"WW","Warmwasser",1,-1,1),"WZ","Wohnzimmer",1,-1,1),"KÜ","Küche",1,-1,1)
Ausgabe: Warmwasser und Wohnzimmer und Küche sind ausgefallen

Beschreibung der Funktion:
Replace(String, Find, Replacement, [Start], [Count], [CompareMethod])

Optionale Parameter:

• [Start] beschreibt die Startposition der Eingabe, auf welche die Funktion angewendet werden soll. Standard: 1
• [Count] beschreibt die Zeichenlänge der Eingabe, auf welche die Funktion angewandt werden soll. Standard: -1 (unbegrenzt)
• [CompareMethod] beschreibt welche Vergleichsmethode der bei der Auswertung verwendet werden soll. 0 binärer Vergleich ; 1 textueller Vergleich 

Weitere Infos finde sie unter https://go.docuware.com/workflow-expression-parser

Viele Grüße / With best regards,

--
Gerardo Lisanti
Product Manager  |  DocuWare GmbH

Hi Steve,

according to your configuration the workflow will loop through the rows of the destination table and add the specified values to the selected columns. Maybe you can explain a little what you are trying to achieve and I can help to find a solution.

@Simon
The workflow can add new rows, if you transfer data from one table to another using "mulitple columns" as destination type.
In this case you can either tick the "Replace" checkbox, which will replace all existing rows in the destination table or
you can untick the "Replace" checkbox, so that the new rows will be appended at the end of the table.

Viele Grüße / With best regards,

--

Gerardo Lisanti
Product Manager  |  DocuWare GmbH

Hi Jason,

try to use the "is (where clause)" condition with "THISMONTH".

Viele Grüße / With best regards,
--
Gerardo Lisanti
Product Manager  |  DocuWare GmbH

 

Hi Pedro,

you can do this by retrieving the entries in the file cabinet with a suitable WHERE statement.
The steps are to find the entries, temporarily store the DOCIDs in a global variable, and then count the entries in the global variable.
However, since retrieving the entries from file cabinets is limited to 100, this only works if you want to count up to 100 (see example below)

Example: Count the documents with "Document Type" = "Invoice In" and return the number to a global variable MyCount.
Perform following steps in a workflow wihtin the Workflow Designer:

• Create a global variable of type Keyword, e.g. MyKeyword
• Create a global variable of type Integer, e.g. MyCount
• Add an Assign Data activity
• There add a new assignement
  • Choose destination global variable MyKeyword
  • Choose source File Cabinets
  • Select the file cabinet and the field, e.g. DOCID
  • Specify the WHERE clause, e.g. DOCUMENT_TYPE = 'Invoice In'
  • Set the "Maximum number of returned documents" to "100"
• Add a second assignment
  • Choose destination global variable MyCount
  • Choose source Arithmetic Expression
  • Use expression: Count(GV_MyKeYword)

For more informations on the Workflow Expressions see: https://go.docuware.com/workflow-expression-parser


If you want to count more than 100, you will need to solve this via a web service request from the workflow to any middleware, which takes the request from the workflow, does the count and returns the result to the workflow.

You can do this for example using an iPaaS platform such as make.com.

• Set up a new scenario and add "incoming webhook", where you send the request from the workflow.
  • You'll get a URL which has to be registered in the DocuWare system as a web service.
• In Workflow Deisgner add a web service activity and configure the request to the the registered web service.
  • Within the request you could for example also provide the values which should be searched for (HTTP Query or Body)
• Once the request is received by iPaaS platform, use the DocuWare connector to perform the search (search for documents).
• After that send a "webhook response" including the count result (total_number_of_bundles) from the DocuWare connector back to the workflow.

For more information on the DocuWare connector on Make.com see: https://www.make.com/en/help/app/docuware​​​​​​​

​​​​​​​
Viele Grüße / With best regards,
 --
Gerardo Lisanti
Product Manager  |  DocuWare GmbH

Hi Frederic,<br> <br> yes, DocuWare Version 7.5 supports following operating systems:<br> &nbsp; <ul> <li>Windows 8.1 (32+64bit)</li> <li>Windows 10 (32+64bit)</li> <li>Windows Server 2012 R2 (64-bit)</li> <li>Windows Server 2016 (64-bit)</li> <li>Windows Server 2019 (64-bit)</li> </ul> <a href="https://help.docuware.com/#/home/82276/2/2" target="_blank">https://help.docuware.com/#/home/82276/2/2</a><br> <br> Viele Grüße / With best regards,<br> &nbsp;<br> --<br> &nbsp;<br> Gerardo Lisanti<br> Manager Product

Hi Marcin,<br> <br> please check our White Paper System Architecture, section&nbsp;<a href="https://help.docuware.com/#/home/60980/2/2" target="_blank">Scalability<br> https://help.docuware.com/#/home/60980/2/2</a><br> <br> With an ENTERPRISE License you can set up Scaling Forms "XS" to "L".<br> <br> Viele Grüße / With best regards,<br> <br> --<br> <br> Gerardo Lisanti<br> Manager Product

Hi Peter,<br> <br> please find more information in the Whitepaper DocuWare Cloud - Section Data Security and Data Protection:<br> <a href="https://help.docuware.com/#/home/64594/2/2" target="_blank">https://help.docuware.com/#/home/64594/2/2</a><br> <br> Viele Grüße / With best regards,<br> &nbsp;<br> --<br> &nbsp;<br> Gerardo Lisanti<br> Manager Product