Steve Shriver Application Specialist

Some further testing has shown this: If I prefill the table with one row of data, the workflow will populate the table with the data I want, overwriting the prefilled row. When a second invoice is stored it will update the table, but will again overwrite the first row. I have the filter set to 'is not empty'. If I change the filter to 'is empty' it will not write any data.

What I would like to do is add a new row for the second and all subsequent invoices. Also, there does not seem to be anyway to prefill the table row/columns when using a form.

Again, any ideas are appreciated,

Thanks Simon and Gerado for your comments. Here is what I am trying to accomplish:

A Purchase Order Document is on file in the PO File cabinet. When an Invoice is added to the Invoice File Cabinet with a PO Number field that is not empty, an AutoIndex job is triggered which finds the matching PO number in the PO File Cabinet and updates the 'Last Vendor Name', 'Last Invoice Amount',' Last Invoice Number' and 'Last Invoice Store Date' field of the PO document. This triggers a workflow on that document that updates the 'Remaining Amount' field of the PO document with some simple math. There is a table field also in the PO Document with 4 columns. I want to capture the 'Last Invoice Amount', Last Invoice Number' etc. fields from the PO Document fields and update the columns in this table so I will have a history of all of the invoices added to the Invoice File Cabinet that posted against this PO document when viewing this PO. The PO document is a DocuWare Form submitted by the requesting user and at the time of submission the table field is empty.

Any suggestions are appreciated.

Thanks again,

According to what I read here ;https://docuware.uservoice.com/forums/230570-client-english/suggestions/38934235-include-the-ability-to-write-to-table-fields-autom. we should be able to load table fields automatically in a workflow using the Assign Data activity. I have tried it to no avail. The configuration looks correct and there are no errors or faults in the workflow. The table is simply not written to and the document history for this step simply says "Variable is empty"

Ant clues appreciated

For those using v7.7 and the new internal database v3 on premises...

What are you using to do your automatic nightly backups?

Thanks,

A customer uses the account number field on some utility vendor invoices in place of an invoice number as these invoices are not numbered. They then add today's date to the account number in the invoice number field to make the invoice number unique. They have been doing this for some time in several document trays configured for Intelligent Indexing.

They are now complaining that Intellix is capturing the account number and adding a date to it automatically. Not today's date but some date from the past.

Is it possible that Intellix is 'remembering' the previously manually entered data when capturing a recognized field? I would not expect that behavior, but is that part of the Intelligent Indexing process?

Thanks, 

An on premises v7.5 system is using the maximum amount of CPU available requiring a server reboot at times. Is there a performance guide document available or know ways to determine which processes are at fault?

Any clues appreciated

Simon, thank you for that info. Can you suggest the syntax for finding the highest number currently in the file cabinet? I tried this as a where clause; DW_Auto_Number = MAX(DW_Auto_Number) but the workflow faulted as the MAX function is not available.

Thanks again, any clues appreciated.

A file cabinet for data records only has an Autonumber field that is updated correctly when a new record is created using the Store Dialog.

An AutoIndex job also runs on this file cabinet with the "create new record if no match" option enabled. New records are created but the Autonumber field is left empty.

This makes sense as the number group is specified in the store dialog. But the user requires Autonumbering for all records. 

Does anyone have a suggestion or way around this?

I have had several problems with Connect to Outlook after upgrading my Desktop Apps from 7.5 to 7.6. Outlook crashed several times and would not resume normal function until I uninstalled the desktop. Then, after uninstalling the desktop I tried to uninstall the client setup from control panel. This brought up the desktop uninstall again, which errored out saying it could not uninstall Connect to Outlook, as it was not installed. But each time I try to uninstall the client setup it repeats this same problem.

No I have no desktop functionality and cannot reinstall the 7.5 version.

Are there problems generally with the 7.6 Desktop update?

Any clues appreciated.

Thank you for that info Simon. I do have one customer that want's to upgrade his DocuWare DB due to some security concerns. In a case like this is it necessary to engage DocuWare Professional Services, or can the MySQL DB be upgraded to the latest version without problems?

Thanks again,