Pedro E. Gonzalez-Santini

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. 

A client want to use DocuWare forms to collect information from a factory floor. Each form has basic information and will always have one Excel file attached. Each Excel file contains specific producion data that is not entered on the form and is later transcribed into an inventory or quality control system. Each document will therefore have two sections, the PDF form and the Excel file.

Is it possible, using a workflow and/or web services/programming, to automatically download the Excel files and store them in a network folder? This is a hybrid Cloud system, with a local system as well. The on-premise system includes the workflow manager module.

Any guidance will be welcome. 

Hello, everyone. An update to this subject would be very welcome. We have a client that needs to migrate from another system but needs an on-premise solution (few users, lots of documents). A cloud system with a single server would be ideal. 

Does this not-officially-supported policy on AWS also apply to Azure?  I thought the problem with cloud services was that the DocuWare system architecture uses Message Queueing and that is not supported by AWS or does not work between two or more servers if your DocuWare system uses more than one. I cannot find the article where I think I saw this information.  Clarification would be welcome. 

I am testing to see if I can download a significant number of PDF one-page files (several hundred new ones a week) from DocuWare using the Windows Explorer Client and copy them to a local cloud drive connector (Dropbox, OneDrive or any other). The idea is to make those files available to external users. The document name is the only metadata needed. This seems to work but it is slow and hangs on occasion. There seems to be a limit of 1,001 files listed in the WEC. Does someone have experience with this and perhaps some recommendations?

The Checkbox method works if the text results of the checkboxes are the same text desired in the keyword field but this does not allow for free-fom text input. For example, if the checkbox is for 'Model' and allows A, B, C and D, one can choose any of those and they map to the keyword field. We need to capture  multiple names from a form, such as the names of family members traveling together.  Could this be accomplished?   

Hello. This works alright but what if we need more than one user at a time to log in? Can more than one user account be designated as a guest?  

We are looking for suggestions on how to best include non DocuWare users in workflows.

The client uses DocuWare on-premise with Import, SmartConnect, Workflow Manager and AutoIndex. A Cloud subscription may be added if justified and to introduce C2Mail and Forms.

A few rough ideas:
1-have the email user type Approve or Reject on the Subject line and forward to an email address. This will be received by Connect to Mail and used by AutoIndex to indicate the decision in the correct field and the workflow will continue accordingly.
2- have the user forward the email to either approve@email.xxx or reject@email.xxx with any comments. The address determines what the decision is and the workflow can take it from there. 
3-include links in the email text for Approve or Reject. What exactly to include is the question.
4-include a link to a DocuWare Form that simply allows to enter Approve or Reject and comments, but this would somehow need to be tied to the transaction being approved or rejected. Can parameters be passed to an online form in an URL so it prefills fields?

Any suggestions or additional ideas will be welcome.

Pedro