Hi rajendhar47, You call it the same way that shong has specified, "cmd /c batchfile.bat". "cmd /c" runs the command shell of the OS, runs batchfile.bat, and then terminates. It might help to spawn a command shell and type "cmd /?" to see a full list of the syntax. One thing that may trip you up is the relative location of where the batchfile will be executed - I always put a "cd\" (change directory) as the first statement in my batch files. Cheers, c0utta
Hi, I'm trying to use the Tsystem component on a windows system to read a key in the key registery. In my windows console I don't have any problem but talend return to me Error unvalide keyname My shell script is "cmd /c reg query \"hkcu/software/PDFCreator/Program\" /v AutosaveFilename" cheers, cahsohtoa
hello I want to use a job with these component: File.xls >>>>tsystem>>>tuniqrow>>>>OutDB. I wrote a java code which enable me to extract cells from excelfile and put it in a tablemysql. This is the code: import jxl.*; import java.io.File; import java.io.IOException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement;
How can I change this code if I want to make it work on Talend with every component in entry and every table outmysql. I should wrote this in my tsysyem : cd C:\Program Files\Java\jdk1.6.0_10\bin javac Finalimport.java java Finalimport Please, how can I do this? Thanks.
hello to simplify what i have written before, I tried to put 3 component tsystem with a tlogRow: tsystem ("cmd /c")>>>>tsystem("cd C:\\Program Files\\Java\\jdk1.6.0_10\\bin")>>>tsystem ("java Finalimport") >>tLogRow I have always this error message that show me cd is not reconized as a command . How can I write these 3 command on only one tsystem component? Please, help me to resolve this problem. Thanks.
Apart of your error, honestly with such custom coding you are quite invalidating the reason to use an ETL tool like Talend that has the ability to seamlessly import and process excel files... that said, "cd" is not a command in windows, but a builtin function of the command processor cmd.exe... you can't invoke it directly. Also "cmd /c cd" isn't going to work because the "current dir" doesn't persist between shell calls... Just write a .bat or .cmd script file with the commands you want and use just one tsystem to invoke such script.
Hi, IM trying to use tsystem component to fire this command "cmd /c date | mail -s 'subject' firstname.lastname@example.org". It throw's error "mail is not recognized as a command".I'm unable to use tsendmail component since smtp host and port is not enabled.Kindly help me with how can i use the mail command in tsystem or anyother way to send mail.