topic how do I connect Talend to any HTML like UI? in Talend Studio

how do I connect Talend to any HTML like UI?

jbhatt1810 — Sat, 16 Nov 2024 01:47:56 GMT

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?

Re: how do I connect Talend to any HTML like UI?

Anonymous — Tue, 28 Jul 2020 03:05:17 GMT

Hi @jbhatt1810

I think it is a web development issue, I am not a HTML expert, maybe this page on stackover can help you.

https://stackoverflow.com/questions/2809688/directory-chooser-in-html-page

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.

Regards

Shong

Re: how do I connect Talend to any HTML like UI?

jbhatt1810 — Tue, 28 Jul 2020 12:35:26 GMT

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?

Re: how do I connect Talend to any HTML like UI?

jbhatt1810 — Tue, 25 Aug 2020 19:19:56 GMT

@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.