Gonzalez-Santini Pedro E. Gm

An existing on-premise client (a government regulatory agency) has developed various applications for internal processes using Microsoft Power Apps. They also use DocuWare as the system of record to store their documents.&#160;<br> <br> One of their Power Apps is simply used to register incoming correspondence, many still on paper, others by email and usually printed. Items are given a control number, assigned a few fields (sender, date, subject) and then distributed to the pertinent area for handling.&#160;<br> <br> From then on, each area has its own processes. Several manage cases on paper and eventually the completed files are scanned into DocuWare. Automating these processes is desired over time nd may or may not involve DocuWare Workflow Manager. It is not licensed at this site.&#160;<br> <br> The immediate objective is to be able to store incoming mail in DocuWare from the incoming correspondence system and later to be able to retrieve documents stored in DocuWare from the correspondence system and subsequent systems.<br> <br> Storing documents will require copying a document to DocuWare with metadata pulled from the item being recorded in the correspondence system.&#160;<br> <br> Regarding communications and authentication, sInce Power Apps is a Microsoft 365 Cloud application and DocuWare is on-premise, will web services need to be developed and will webhooks be available? Maybe Power Apps provides OAuth 2 as used in email authentication with Microsoft 365.<br> <br> I think URL integration will work in this case as well as the REST API.&#160;<br> <br> Any guidance and comments will be welcome.&#160;

Hello. I have the same need. Does the Workflow Manager now in version 7.7 allow this without a web service?  If not, can you provide a bit more detail on how the web service would work? This is for a Cloud installation. Best regards.

A couple of clients experienced this as well and with different KB updates. Deleting recent updates resolved this temporarily but in some cases the updates were automatically reinstalled and then it appears not all workstations experienced the error.  So far it is inconclusive. 

DocuWare version 7.7 replaced the Solr 4 full text engine that included Tomcat with the improved Solr 8 engine. For security, it is recommended that the default files be removed. Can this be done without affecting the DocuWare system?

References:

Synopsis

The remote web server contains default files.

Description

The default error page, default index page, example JSPs and/or example servlets are installed on the remote Apache Tomcat server. These files should be removed as they may help an attacker uncover information about the remote Tomcat install or host itself.

Solution

Delete the default index page and remove the example JSP and servlets. Follow the Tomcat or OWASP instructions to replace or modify the default error page.

https://www.owasp.org/index.php/Securing_tomcat

https://www.rapid7.com/db/vulnerabilities/http-tomcat-default-install-page/

Hello, Mike. We have the same need and have discussed this with Adobe, DocuWare and third party developers. Nothing is available yet, but with the new REST and webhooks functionality in DocuWare 7.5 this may be possible. Let me know if you still have a need to see how we could collaborate. I also opened a uservoice thread that so far has no votes here: https://docuware.uservoice.com/forums/230573-miscellaneous-english/suggestions/43561569-electronic-signature-integration-with-adobe-sign
 

DocuWare 7.5 introduced its webhooks functionality. Could this be useful to connect with SharePoint? The idea is for selected documents to be pulled into SharePoint. Any comments will be welcome.

Thank you for the comments. Best regards.

Update- I tested with two skipped records, one at a time after commenting out the  <CheckOutDoc section and changing the Flags value to "2". Both  records imported successfully. This seems to confirm that these differences in the XML are the cause of the skipped records. Now how can this be fixed? Editing the XML in thousands of records could be done but perhaps a better solution is available. 

A restore workflow from version 6 to version 7 successfully imports most records but skips others with this error message pointing to three invalid column names:

Exception information for document with Id: 825, DocuWare.DAL.XChange.DWDBException: Invalid column name 'DWUSRVERSION'.
Invalid column name 'DWVERSTATUS'.
Invalid column name 'DWVERCOMMENT'.
   at DocuWare.DAL.DataAccess.BaseSQLBuilder.ExecuteScalar(IDataCommand command, Int32 contextId)
   at DocuWare.DAL.DataAccess.SQLBuilder.ExecuteNonQuery(String sql, SQLCommandContent content)
   at DocuWare.DAL.DataAccess.BaseSQLBuilder.Ex.........etc

I checked the xml header files and found two differences, marked *** below. The Flags value is "2" in successful records. The CheckOutDoc section does not appear in the successful records. I also wonder if the checkin fcguid needs to be updated to match the new destination fc. I have not yet run a restore after eliminating the CheckOutDoc section.

***        <Flags>8194</Flags>
        <StoreUser>USERNAME</StoreUser>
        <Offset>0</Offset>
        <ModificationUser>USERNAME</ModificationUser>
        <StoreDateTime>2013-06-20T13:43:15</StoreDateTime>
        <ModificationDateTime>2014-01-09T15:44:28</ModificationDateTime>
 ***       <CheckOutDoc user="USERNAME" computer="dom.local\USERPC" datetime="2014-01-09T15:44:28">
 ***         <checkin fcGuid="11984f36-2c0d-4904-9d50-8eb11d24641d" docID="825" />
  ***      </CheckOutDoc>

Any clarification will be welcome. Best regards.

Just a note on the last comment above. In the Cloud one cannot assign multiple named licenses to the guest user, so the limit is only one, or is there a way around this?  I do not think one can assign multiple named licenses to a single user on-premise either.