I am looking for the logic or entry to use to use in the where part of a SQL Table data Assign to exclude NULL entries.
CustomerNumber IS NOT NULL
CustomerNumber = 'is empty'
I do not see any reference in the KB or Forums for this.
It depends on the version of DocuWare you have. I believe in version 6.10 and older you can go to the Admin tool right click a file cabinet and select the full text menu item and it will show you a count.
On newer version you can do a SQL query for the number of rows in each cabinets root SQL table.
I know in v7.1 you can "Undo Check Out" if you log in as the Organization Admin.
All other users will get a red error showing who checked it out but the Org Admin it will just Undo the check out.
The issue is that in DocuWare it uses the barcode to decide which configuration to use, the splitting there of of the document is done after the decision is made and in the configuration it choose.
You can have them scanned in sections or have someone split the document before it is put into the hot folder. By doing this, you can embed the document type in the barcode and DocuWare will select the correct configuration for each document and switch automatically per document.
There are 3rd part applications that you could drop the documents to a sparate folder that is monitored by a 3rd part software that would split the large pdf into separate pdf's at each barcode. Then have it deposit them to the DW hotfolder and allow it to determine the configuration.
It is a good idea to set your configurations to consider file age so that they are not picking up documents as they are being written.
This question has been answered from a support ticket. The answer was:
"Yes , all of the native languages are covered that you sent, for china we cover Mandarin."
Asupport ticket has been opened for this issue. Please disregard the question here.
You may want to consider that this is a VIEW and will be subject to the performance of the SQL server that the view is coming from.
Many times a separate remote SQL server for say accounting is used, it is busy, where the task queue is buried in requests and that view takes a while to populate or the memory or cpu is peaking on that server. This will cause the VIEW to be slow.
Sometimes modifying the view to have more distilled results of what it returns is the fix. Sometimes fixing the remote servers resources is the fix.
Also, if you can run the VIEW from SQL Mgnt Studio to see how long it takes to load you may find that it is just slow. This is nothign to do with DocuWare.
I have seen this increased performance with Chrome as well. Starting in v7 Chrome has been the gold standard to use with DocuWare.
DocuWare has removed the need for Silverlight in its new version and I have seen speed differences of 4 times faster for chrome. DW also has moved most of the Admin tool to the Configuration page which makes switching back and forth less likely.
Agreeing with Joe that IE is antiquated (garbage) and Chrome is the future. I have found no fixes for speeding up IE in the slightest.
Rebooting the server has resolved this issue