upload CSV file from JSP page to talend job

[Anonymous]

hi team,
i want to is there any way to upload CSV file from JSP page to talend job.i am using talend data integration tool.
In my job i am inserting 1 lakh records to mysql table.After insertion i want to display number of records inserted properly in JSP page.
please help me if there is any way i can do this uploading  csv file in JSP and talend job 'tFileInputDelimited' component should take that uploaded jsp page as input file.
After that i have to display number of valid records and invalid records inserted in the output table in JSP page.
Plase look into my job and help me to accomplish this task.

i am very new to integrating talend with other technologies.

This link is exactly what i want  thread.

But the screenshots are missing.

One more doubt how can i upload CSV file in JSP and use that use file in TALEND JOB.
After going steps by shong in that link we can call only job from jsp but those points are not explaining how to pass my csv file from JSP as of my understanding.

Is my undersatnding is right?if not will u please explain me with screenshots.

[Anonymous]

Hi 
Topic 6945 was rather older so far, I did't save the screenshots. My thinking is to build a webservice with Talend ESB product, this webservice requires the file path as input parameter and output the number of inserted records in response message, call the webservice in your JSP program.

[Anonymous]

hi shong,
I am sorry,can u elobarate clearly.

My problem is i want to browse a file from html/jsp and i have to inject that file to 'tFileInputDelimited' in a JOB.

That job with tranfer data from CSV file  to MYSQL data base.(Please have a look of screenshots attached above in my post)

After that i used routines in the job for validation purpose.If any records fails in validation,i will mark that record as 'fail' in 'STATUS' column in MYSQL database table(output table).

Now in JSP i want display number of records failed,number of records passed.

Tell me wheather i need to call two jobs from JSP or is there any way to do with single job.

can i accomplish my task using TALEND DATA INTEGRATION or i need to use other TALEND products.

What is TALEND ESB ?I need to download that saperately or it is different web service component in TALEND DATA INTEGARTION TOOL.

Sorry my question can be silly but i am very new to this product.

I dont have any idea about how to write JSP code which calls WEBSERVICE JOB.

Plese help me with JSP code Calling WEBSERVICE in tALEND??

[Anonymous]

Hi 
For step1,  Axis web service is deprecated, I would suggest you to use Talend open Studio for ESB to build the webservice Job (  requires filepath as input parameter,  tranfer data from CSV file  to MYSQL data base, and returns the number of inserted rows in response), Talend ESB product is more flexible for building webservcie, you can get more information about ESB prodcut  from Talend website and download it. 

[Anonymous]

thanks