I have configured simple job which takes excel file input (tfileinputexcel component) and further translates that file data into database table. This DB table is further used for otheractions. Currently I am giving this excel input file manually in talend component but what I am looking for is an interactive user friendly UI for users to be able to select the excel file by navigating in their local folders. Does Talend have any known UI components to be able to select the file navigating from folders? If not, how do I connect to HTML page (HTML page navigates and selects the path) where the selected file path, will automatically be added to "FileName/Stream" section of the tFileinputexcel component?
My idea is to provide a file chooser for user to upload the Excel file and store the file to a folder on server. In Talend job, use tWaitForFile to monitor the folder, extract data from the file once it has new file and process the data.
Export the Talend job, deploy it to the server where the Excel files are stored, and run it.
Thanks @Shicong Hong. Let me try to put it differently.
1) Do we have any UI (third party is fine too as long as they are open source) that can connect to Talend easily?
2) I reviewed above link and lets say, I manage to get the full path once user selects the file, how do I plug it automatically in the "FileName/Stream" section of the "tfileinputexcel" component?
@Shicong Hong Any update on above? I am just not able to wrap my head around that there is no way to connect Talend to front end like Tkinter or any UI for the fact.
