• Creating Lists in DocuWare 7.2

    Is it possible to create a list that will only display records if your first and last name equal what's in the supervisor field?

    I didn't want to have to create a list for each supervisor - I want it to filter based off the supervisor name but I can not find any reserved words you can use.  

    I've added a picture of the list.
     
  • File Cabinet - Unique Vendor and Invoice #

    I have created a file cabinet and I want to know if I can make the "Vendor" and "Invoice #" unique together.  Example, company "ABC" has an invoice "123" and I want to make sure that invoice number can't be used again for that vendor.  But if company was "DEF" and invoice number "123" that can be entered as it is different by vendor name.

    I am on DocuWare 7.2.
  • DocuWare - Old Document Trays

    I have a file cabinet I am looking to remove but I cannot because there is old document tray still tied to it.  The user does not exist anymore and I found the file cabinet by going to select * from DWFCSettings where name = 'paulette' and then I looked at the settings and it referenced web basket WEB_BASKET_BUFFER_91 so I then looked at dwbaskets and I see the tables for WEB_BASKET_BUFFER_91

    How do I remove this web basket so I can remove the file cabinet that is no longer needed?  Do I just delete the tables for WEB_BASKET_BUFFER_91 and then the entry from DWFCSettings?
  • DocuWare 7.1 - Full Text Search

    We recently upgraded to 7. a few months back and I've noticed that the full text is not working.  I've checked all the services - everything is running.  What should I check to see why it's not doing a full text index?

    I tried on one file cabinet to reset it - before that it was able to search and find 1 document and now it is able to find 10 but there are a lot more documents.

    I checked the log file for full text index and there are no log files.
  • Notifications (OnPrem)

    I am having a problem where I setup notifications based on the index fields changes and they are not firing off.  I was looking around and everything looked right - I tested the SMTP connection and that is working.  I deleted the notification and then recreated it and still cannot get the notification to kick off.

    So I went to the log file for Notifications and I am seeing this:

    <event timestamp="2020-03-11T04:14:35.0028696-05:00" level="Error" logger="DocuWare.Communication.AuthenticationServer.Management.ServerManagement" SequenceID="16" Type="DocuWare.Communication.AuthenticationServer.Management.ServerManagement" Method="StartServer" DomainName="CSP-DOCUWARE" MachineName="CSP-DOCUWARE" Thread="4" WindowsUserName="Administrator">
      <message>Authentication failed!</message>
      <exception>DocuWare.Communication.AuthenticationServer.Exceptions.DWAuthenticateException: Cannot find active authentication server. All servers are either stopped or the communication channel settings don't allow a connection. ---&gt; DocuWare.Common.Exceptions.DWRemotingException: Cannot access server url  'gtcp://localhost:9000' . Check that server is accessible and use compatible communication options ---&gt; Belikov.GenuineChannels.GenuineExceptions+CanNotConnectToRemoteHost: Can not connect to the remote host "gtcp://localhost:9000". System error message: No connection could be made because the target machine actively refused it 127.0.0.1:9000.
       at Belikov.GenuineChannels.GenuineTcp.TcpConnectionManager.LowLevel_OpenConnection(HostInformation remote, GenuineConnectionType genuineConnectionType, String localUri, Int32 localPort, String connectionName, String&amp; remoteUri, Int32&amp; remoteHostUniqueIdentifier)
       at Belikov.GenuineChannels.GenuineTcp.TcpConnectionManager.GetConnectionForSending(Message message)
       at Belikov.GenuineChannels.GenuineTcp.TcpConnectionManager.InternalSend(Message message)
       at Belikov.GenuineChannels.Connection.ConnectionManager.Send(Message message)
       at Belikov.GenuineChannels.DotNetRemotingLayer.GenuineTcpClientTransportSink.ProcessMessage(IMessage msg, ITransportHeaders requestHeaders, Stream requestStream, ITransportHeaders&amp; responseHeaders, Stream&amp; responseStream)
       at DocuWare.Remoting.SwitchChannel.FakeClientChannelSink.ProcessMessage(IMessage msg, ITransportHeaders requestHeaders, Stream requestStream, ITransportHeaders&amp; responseHeaders, Stream&amp; responseStream)
       at DocuWare.Remoting.SwitchChannel.SwitchClientChannelSink.ProcessMessage(IMessage msg, ITransportHeaders requestHeaders, Stream requestStream, ITransportHeaders&amp; responseHeaders, Stream&amp; responseStream)
       --- End of inner exception stack trace ---

    Server stack trace: 
       at DocuWare.Remoting.SwitchChannel.SwitchClientChannelSink.ProcessMessage(IMessage msg, ITransportHeaders requestHeaders, Stream requestStream, ITransportHeaders&amp; responseHeaders, Stream&amp; responseStream)
       at Zyan.SafeDeserializationHelpers.Channels.SafeBinaryClientFormatterSink.SyncProcessMessage(IMessage msg)

    Exception rethrown at [0]: 
       at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
       at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData&amp; msgData, Int32 type)
       at DocuWare.XChange.IServer.Responce()
       at DocuWare.Communication.AuthenticationServer.Config.ASClient.CreateServerProxy(String url)
       at DocuWare.Communication.AuthenticationServer.Config.ASClient.GetServerProxy(String url, Func`3 nextUrl, Int32 context)
       --- End of inner exception stack trace ---
       at DocuWare.Communication.AuthenticationServer.Config.ASClient.FindNextAuthenticationServerUrl(Int32 context, Exception ex)
       at DocuWare.Communication.AuthenticationServer.Config.ASClient.GetServerProxy(String url, Func`3 nextUrl, Int32 context)
       at DocuWare.Communication.AuthenticationServer.Config.ASClient.get_AuthenticationServer()
       at DocuWare.Communication.Server.Server.LogIn(ServerID sId)
       at DocuWare.Communication.Server.Server.Start(InternalServerSettings internalSettings, Boolean saveSettings)
       at DocuWare.Communication.AuthenticationServer.Management.Managers.GenericServerManager.Start()
       at DocuWare.Communication.AuthenticationServer.Management.Managers.NotificationServerManager.Start()
       at DocuWare.Communication.AuthenticationServer.Management.ServerManagement.StartServer()</exception>
    </event>

    But all the services are running.  I stopped and restarted the services and I can log into DocuWare with no problem.
  • DocuWare 7.1 - Server Migration

    I am currently running DocuWare on a server that I need to migrate to a new server.  I am looking at KBA36247 on how to move a DocuWare System (7.x) - has anyone done this before?  If so - is there anything I should be aware of?  It seems straight forward but just wanted to see if anyone had any issues before.
  • DocuWare Platform .NET API - Checking Documents In/Out

    Hello,

    I have been writing a small program that will collect our computer inventory and store that in DocuWare.  Everything is working great.  I have a question on checking a document in/out.  I want to be able to check a document out and attach the new specs sheet to the old one and check it back in.  I've followed the example https://developer.docuware.com/dotNet_CodeExamples/8949abfb-4386-4e6d-81fc-e0b674ec3fb4.html 

    Is there a way to make this sync vs async?  I would want my program to wait while the file is being downloaded from DocuWare so I can merge my spec sheets together and then initiate an upload.
  • RE: DocuWare 7.1 - Store Dialog

    Hi Simon,

    Thank you - I was able to resolve item #1.  I'm still a little stuck on item #2.  I've attached a copy of my store dialog.  I would like it if I can select the RIN from the drop down list and then it populates the name from the client name.  Example, I select 123 and it is associated with Doe, Jane - I would want that to be automatically filled in.  Same if I edit the client name field and remove Doe, Jane and put Doe, John and it would update the RIN field with 124.  Is that possible?  I thought there was a way to filter an index field based off the entry in another.  

  • RE: Permission to Use SQL Statements

    Phil,

    This was very helpful - thank you.

    Ed
  • DocuWare 7.1 - Store Dialog

    I have two questions on this - I'm use to the 6.8 version of DocuWare so I'm not sure how to do this in 7.1.  

    1. I have my store dialog working where I have 1 field pull from a fixed list of available document types.  When a user searchs and right clicks to edit the index entrires - they can type what ever they want.  How do you prevent this in 7.1 making sure it's only in the available select list?

    2. On store dialog - field one is where they will type an ID - how do I now make that an external sql query to pull back the name of the client in the "client name" field?  So if I type 1234 and I go to the next field I'd like to be able to run a query to fill that in so we don't get staff members spelling a name differently each time.