Simon H. Hellmann Toshiba Tec Germany Imaging Systems GmbH IT-Consultant Document Management Solutions

Hi David,

this man page from MySQL lists all official ways to backup the database.
https://dev.mysql.com/doc/refman/8.4/en/backup-methods.html

It is probably possible to run mysqldump.exe from a scheduled task in Windows.

Greetings from Germany,
Simon H. Hellmann
DocuWare System Consultant

Hallo Roger Goetzendorff,

wenn durch einen LDC Fehler 3000 General Error entstehen, haben Sie kein Problem damit, dass die Aufgaben sich nicht en masse beenden lassen, sondern mit einem schlecht Konfigurierten Workflow.

Selbst wenn ein IT Admin auf eine große Menge von General Error Aktivitäten läuft, ist die simple Lösung ein fünfzeiliges AutoHotKey Skript.
Ich wäre überrascht, wenn jemand dafür bereit ist, Ihnen einen unbestimmten Geldbetrag zu zahlen.

Gruß,

Simon H. Hellmann
DocuWare System Consultant

Hi Brian,

thank you for your testing. I have just referenced this thread from here: Link

also, because the formatting in your last message broke, here it is again:
 

I've continued to experiment on figuring out how to get the longest possible free query based solely on DWDOCID.

METHOD 1: Each DWDOCID are listed separated with OR statements. Example: [DWDOCID]=2953384 OR [DWDOCID]=2953383 OR [DWDOCID]=2953382 OR [DWDOCID]=2953381 OR [DWDOCID]=2953380

Result: Maximum documents that can be retrieved is: 140. If you try to pull 141, you will get an error message of "Oops! 422 Unprocessable Entity. Wrong Query! If you try to pull 480, you will get a 404 error.

METHOD 2: Pairs of DWDOCID's are encapsulated in parenthesis. Example: ([DWDOCID]=2953381 OR [DWDOCID]=2953380) OR ([DWDOCID]=2953379 OR [DWDOCID]=2953378)

Result: Maximum documents that can be retrieved is: 274 If you try to pull 275, you will get the Oops! message. If you try to pull 456, you will get 404 error.

Method 3: Three DWDOCID's are encapsulated in parenthesis. Example: ([DWDOCID]=2953384 OR [DWDOCID]=2953383 OR [DWDOCID]=2953382) OR ([DWDOCID]=2953381 OR [DWDOCID]=2953380 OR [DWDOCID]=2953379)

Result: Maximum documents that can be retrieved is: 408 If you try to pull 409, you will get the Oops! message. If you try to pull 468, you will get 404 error.

Method 4: Four DWDOCID's are encapsulated in parenthesis. Example: ([DWDOCID]=2953383 OR [DWDOCID]=2953382 OR [DWDOCID]=2953381 OR [DWDOCID]=2953380) OR ([DWDOCID]=2953379 OR [DWDOCID]=2953378 OR [DWDOCID]=2953377 OR [DWDOCID]=2953376)

Result: Maximum documents that can be retrieved is: 462 If you try to pull 463, you will get 404 error.

Method 5: Steadily increasing the number of ID's in parenthesis has marginal rate of return from this point onward with a recap of: 1 - 140 2 - 274 3 - 408 4 - 462 5 - 463 6 - 465 7 - 467 8 - 470 9 - 475 10 - 478 11 - 482 12 - 486 20 - 490 50 - 492 90 - 495

Hi Sander Helfensteijn,

you can do "number1" OR "number2" OR "number3" in any text field to do this.
However, there is a maximum charater limit for the search fields which you might hit.
The limit is a lot higher when using search query URLs, there was a forum post testing the limits on this two years ago, however, the formatting broke. Link

I think the best solution would be to use the list as a data source for Autoindex (should be easy if you can get the list as csv).

You could then create an Autoindex job which runs whenever the csv file is changed.
It searches for each number in the list and sets an index field to a specific value, for example STATUS to value waiting for payment.
In DocuWare, you can then create a (Task Manager) List which displays all documents with STATUS set to waiting for payment.

Hope this helps.

Greetings from Germany,
Simon H. Hellmann
DocuWare System Consultant

 

Oh, another version which might work is using the C# function Math.Abs() - this returns the absolute value.

Math.Abs(DW_AMOUNT) > 2000

However, I am not 100% sure if this function is supported by arithmetic expressions.
 

Hello Sander Helfensteijn,

yes, you can just add multiple checks to the condition. For example (written from memory, not tested):
DW_AMOUNT > 2000 || DW_AMOUNT < -2000 this is C# syntax. Arithmetic expressions and Conditions can use a mix of C# and VBA, check out the "Workflow expression parser" document from the partner portal for more details.
In VBA Syntax you could do something like this: DW_AMOUNT > 2000 OR DW_AMOUNT < -2000

Greetings from Germany,
Simon H. Hellmann
DocuWare System Consultant

Hi Thomas Stephens,

a loop is probably the easiest way.
Currently there is no way to send a mail to more than one recipient using a single variable. I would create a keyword field (variable) to store the mail addresses and then loop over this keyword field, store keywordField[index] into a GV mailAddress and send the mail.

Greetings from Germany,
Simon H. Hellmann
DocuWare System Consultant

Hello Daryl Foxhoven, 

if the ticket number is unique and the same on the ticket and the invoice, why do you need to to a LIKE fuzzy search? Could you not just check if it is equal?

Also, what value does GV_Ticket_Number_Expense have here? It should be just one single ticket number. You might need to loop over all the table rows and process them one after another.

Last: Are you sure that there is no other document with the same ticket number, for example the invoice in the workflow? You could exclude the invoice by adding AND DW_DWDOCID <> GV_DWDOCID.

Hope this helps. 

Greetings from Germany,
Simon H. Hellmann
DocuWare System Consultant

Hello George Charisis,

DocuWare currently has more than 10000 cloud customers plus test/demo systems for partners - it is possible that all the names you tried are taken already.
You can just check that yourself by opening the URL you are trying to create in another browser tab.

If the URLs do not redirect to a DocuWare Login Page and the creation still does not work, please create a support request.

Greetings from Germany,
Simon H. Hellmann
DocuWare System Consultant

Hallo Daniel Reusch, 

mit der Dokumentenverknüpfung können maximal zwei Archive verknüpft werden. Natürlich ließen sich mehrere Verknüpfungen mit den gleichen Kriterien, aber unterschiedlichen Archiven einrichten.

Im Normalfall sollten die genannten Dokumenttypen aber alle im gleichen Archiv liegen, weshalb das gar kein Problem wäre.
Ansonsten ist das hier eher ein Anwendungsfall für die Funktion "Suche über mehrere Archive" (versteckt sich im WebClient unter "Suchen").

Gruß aus Neuss,
Simon H. Hellmann
DocuWare System Consultant