Phil Robson DocuWare Corporation Senior Director Professional Services, Americas

David,
Good idea from Josef. If you do, replace GETDATE() with CURRENTDATE() that is what I used with my test.

Phil Robson
Senior Director Support Americas

David,
It would appear the the IS(WHERE...) clause does not support trancact SQL. I was able to execute a query as I indicated, but I used the SQL Query option, which is not supported for the Cloud.

Your clause is not quite right. Remove the word DATE at the start. Moot point though because it still won't work.

Sorry. But I don't have a solution right now. I'll give it some more thought.

Phil Robson
Senior Director Support Americas

David,
I have not tested this but MSSQL supports DATEADD. So look to do something like this:

All before this month:

DATE <= DATEADD(month,-1,GETDATE())

Only last month:

(DATE >= DATEADD(month,-2,GETDATE()) AND DATE <= DATEADD(month,-1,GETDATE()))

Phil Robson
Senior Director Support Americas

Brian,

First I'll need to know how you are arriving at your figures. 86,518 DocId's and 86,578 "image" files. How are you arriving at the "image" files count?
Look at the DWPAGECOUNT field. This is not a Page Count, but a Section count. Each section being a document. So what does the total of the DWPAGECOUNT field yield?

If it equals your "image" count then you are good to go.
 

Phil Robson
Senior Director Support Americas

Phil Robson
Senior Director Support Americas

We have reviewed the claim of a security vulnerability in our Fulltext server. When DocuWare is installed on a server running the default configuration of the Windows firewall, the fulltext ports are blocked. That is, there is no access to the fulltext server. Therefore, the only way for the fulltext index data can be accessed outside of the DocuWare server is for the firewall to be reconfigured in an insecure manner. DocuWare does not alter firewall configurations in any way. We maintain therefore, that there is no inherent security vulnerability in DocuWare on a Windows server in its default configuration.  It is always the responsibility of the system administrator to ensure that their network is secure.
We accept however, that when DocuWare is installed in a multi-server environment, that the dispersed DocuWare services require access to the fulltext server. For most the easy way to achieve this is to simply open the DocuWare ports in the firewalls, or worse still turn the firewalls off altogether. This practice immediately exposes client data to a security risk.

DocuWare does not condone this practice. The system administrator must always follow best practices when allowing specific traffic between servers that is not exposed to any client, either local or remote.
There may well be a further arguement, that even with the firewall correctly configured, that access to the fulltext server will still be possible when logged in to the server. Again, we would stress that proper security measures must be in place to limit access to any server by other than system administrators.

In order to mitigate the possibility in the future of inexperienced administrators creating a security vulnerability in their DocuWare system we will be modifying our installation package to issue  a warning when installing DocuWare. This warning will indicate the need to properly configure firewalls on all servers, and will require the installer to accept the warning before continuing the installation.

Phil Robson
Senior Director Support Americas

Marie,
Unfortunately that tool is no longer available. I was not even aware that there was any reference to it. I had advised our Bloggers to amend the blog. I appologize for the inconvenience.

Phil Robson
Senior Director Support Americas

There is no function to copy import jobs. This is becasue import jobs in DocuWare desktop are created at a user level and are stored under the user Windows security id. However, as you know import configurations can be copied.
Import speed will entirely depend on the architecture of the entire system, howeverd depending on the version of DocuWare certain perormance tweaks can be made. Please refer to the Desktop Performance guide at https://www.docuware.com/support_faq/

Phil Robson
Senior Director Support Americas

Do you mean transfer user accounts from an On-Premise system to a Cloud system, or an Active Directory snchonization?

Professional services can certainlt assist with the first, and DocuWare 7 will offer Active Directory synchronization to the Cloud.

Phil Robson
Senior Director Support Americas

David,
Add a numeric field to the file cabinet - call it DocId.
Run this MySQL Query (replace words in italics with your info)
UPDATE dwdata.tablename SET DOCID = DWDOCID

Now the DocId field will be available in your result list.

Phil Robson
Senior Director Support Americas

Steve,
It could be the auto-refresh is stalled. Have you tried a manual refresh? Also, back on that version sometimes clearing the browser cache cleared things up.

Phil Robson
Senior Director Support Americas