Posted Tue, 17 May 2022 14:24:34 GMT by Gisèle Casabianca Responsable d'applications et projets IT
Hi everybody,

I want to update the indexes of a cabinet file B when the trigger is from a cabinet file A.
The help section has not much details.

I would need some explanations on some features.

In the first tab "Trigger" I have the cabinet file I want to update (cabinet file B), and the trigger conditions, but from the same cabinet.
Here I want to set a trigger from a specific cabinet file in order to update another cabinet file.
I kind of solved my problem in setting the Scheduled menu, and launching the Autoindex every minute, but that's not a very clean solution for me (I filter from the Assign date tab in Configure data source). It works fine, but I would like a more elegant solution.

I was wondering if with the "File Event" menu I could use the SQL Statements and set my trigger (when index from cabinet file A is "xx")
But I wasn't able to find any example in the web.
Posted Wed, 25 May 2022 00:00:16 GMT by Matthias Wieland Senior Director Support EMEA
Dear Gisèle Casabianca! It looks like the Community cannot answer your question. That's why we have opened a Support Request with the Number SR-177273-Z6M3Z 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 Fri, 17 Jun 2022 07:00:00 GMT by Marco Mc Carthy Specialist Software Support
Create a "File Cabinet Event" Auto-Index and choose the file-cabinet A as trigger, now set your conditions to activate the process.
 
In the "Match Data" section, you should pick the option "file cabinet database" and select file-cabinet B. Select the appropriate matching field(s). 
 
The "Assign Data" can remain empty, as you do not want to change any entries within your file-cabinet A.
Please note, that "File Cabinet Event" Auto-Index do not create a log output (Last Run column - in the Autoindex overview) where you could check the execution.
Therefore, you could update a status field in file-cabinet A, to show that the update was executed. (Exception for Assign Data)
 
Now in the "Write Back" section select the fields, which you would like to update / change in file-cabinet B. 
Posted Mon, 20 Jun 2022 10:10:25 GMT by Gisèle Casabianca Responsable d'applications et projets IT

I confirm that it works perfectly fine ! Thanks

You must be signed in to post in this forum.