Posted Wed, 12 Jan 2022 20:55:30 GMT by Jon Weston File IT Solutions Sr Application Developer and RIM specialist
Can I use AutoIndex to add multiple values to a keyword field? I tried formatting the data with a comma between the values as well as with a space but in both cases it just added them as a single keyword entry.
Posted Thu, 20 Jan 2022 00:01:47 GMT by Matthias Wieland Senior Director Support EMEA
Dear Jon Weston! It looks like the Community cannot answer your question. That's why we have opened a Support Request with the Number SR-168728-Y3Y9Y for you. A Software Support Specialist will contact you directly to follow up. We will update this thread with the solution as soon as we have resolved the Support Request. With best regards, DocuWare Support Team
Posted Thu, 20 Jan 2022 23:05:22 GMT by Jon Weston File IT Solutions Sr Application Developer and RIM specialist
Short answer: Yes.

DW Support responded thusly:

After some testing and confirmation on our end, there are two ways we could find.
 
1.
Set auto index job to use file cabinet for processing list.
Set auto index job to use "Use all data records for indexing" with the multiple matches option.
Create .csv that would have multiple lines with the same match code. the multiple lines would just need the match code and the value for the keyword filled out.
This would require good filters on the cabinet side of the AIX job if it is a large cabinet as well. See below for example of csv setup.

 
CustNo,CustName,InvNo
1,Customer 1,11111
1,,22222
1,,33333
2,Customer 2, 11111
2,,22222

 
2:
This is very easy to set up too.

Created a text file with multiple sections for the same keyword field. In this case Invoice#,Invoice#2,Invoice#3,etc.
Then I created one AI job that populates all fields. This AI job points to the first Invoice# section in the text file.
Then I copied that job and modified it to not populate any fields except for the Invoice# using the second Invoice#2 section of the text file.
Then I repeated this for the third Invoice#3 section. And so on.

Run all three jobs and you should get the results I wanted.
 

You must be signed in to post in this forum.