Monitor shared drive and read excel file as soon as one is available

Camunda 7 Topics Discussion & Questions
1

Hi Experts,

I am having a requirement where i have to read the details in excel file when its put on a NAS (shared drive).
Basically, i have following requirement.

  1. A listener which will monitor the shared path
  2. As soon a file is created, read it
  3. Save the result in DB

Any help will be appreciated.

Regards
Aj

2

If you search Java/Spring file monitor or watcher you will find several examples for instancee:
Camel: https://camel.apache.org/components/latest/file-component.html
Plain Java: https://docs.oracle.com/javase/tutorial/essential/io/notification.html
Spring Integration: https://github.com/spring-projects/spring-integration-samples/tree/master/basic/file
Commons: http://commons.apache.org/proper/commons-io/javadocs/api-release/org/apache/commons/io/monitor/FileAlterationObserver.html

In combination with Camunda I would consider Spring and Camel first.

3

Hi @ajay,

the same pattern as described here (Start workflow process when a row is inserted in DB Table) would fit this use case as well.

Hope this helps, Ingo