Posted Fri, 31 Jul 2020 15:27:14 GMT by Steve Shriver Application Specialist
What is the maximum number of rows that can be entered into a table field?

Additionally, is there a way to import data into a table field?
I.e., in an invoice processing situation, a user is supplied with a CSV file of 60 to 80 GL number and amount entries for one invoice. I would like to avoid manually entering all of those if possible.

Thanks,
Posted Sat, 01 Aug 2020 11:13:26 GMT by Ross Lister Professional Services Engineer

Hi Steve,

I'm not sure on the maximum number of rows but will find out and get back to you.

You can link each field in the table in question to what we call a select list. This standardizes input into any field in DocuWare, table or otherwise. These select lists can be internal to DW or they can be linked to a live connection via the provided FTP site or, in most cases, with a line of business SQL data source. 

Typically our customers create an SQL view of the data they want to present in each list or link into an existing table. This way your ERP system and the data being entered into DW are always the same. 

In the newest version of DW you can also link the values presented into a field with the values already present in another field. Maybe a cost center only has a certain group of account codes; the system can use either an existing selection in the metadata of the document in either the main document fields or a field in that particular line item in the table to filter or drill down the information in another linked field.

Hope this helps!
Ross Lister
Professional Services Engineer
DocuWare

Posted Mon, 03 Aug 2020 07:53:03 GMT by Simon H. Hellmann Toshiba Tec Germany Imaging Systems GmbH IT-Consultant Document Management Solutions
Hi Steve, 

the maximum size for a table field is 50 columns and 1000 rows.
See documentation here: https://help.docuware.com/#/home/64638/2/2

Reading a CSV file into a table field is currently not that easy. As far as I know, the only way is via the API, as neither AIX nor Workflow Designer can write to table fields. This will hopefully be addressed in 7.4.

Hope this helps. 

Greetings from Germany,
Simon H. Hellmann
DocuWare System  Consultant

You must be signed in to post in this forum.