Hi, I'm newbiz with Talend, and i just begin to use it. I wanted to it in order to test it for an application. I would like to transfer a txt file by FTP and get in local directory and transform it in excel format=> this my first test. (After that i would like to load data collected in a Mysql or SQL database => second test i would like to do)
Then i first try to make a job like that : -tFTPget (onsubjobok link) --> linked to tFileList (iterate link) --> linked to a tFileinputDelimited (row1main)--> linked to tFileoutputexcel
I tried it but it is not working. I tried to find information about it and i have finally tried to follow this : 2284 But it still not working Thx a lot for your help Merci beaucoup de votre aide David
Hi, when i run the job i have this kind of error : Starting job test_job at 23:04 01/09/2008. Exception in thread "main" java.lang.Error: Unresolved compilation problem: The method add(String) in the type List<String> is not applicable for the arguments () at test.test_job_0_1.test_job.tFTPGet_1Process(test_job.java:238) at test.test_job_0_1.test_job.runJobInTOS(test_job.java:1158) at test.test_job_0_1.test_job.main(test_job.java:1073) Job test_job ended at 23:04 01/09/2008.
My goal is to define a scenario with theses steps : - transfer a file from a FTP directory here : /www/test_import/ - and get this file in local that's all for the moment but i have few problems tot do it :-(
Did you try to define a fileMask? Can you give us the code around your messageß To see the code: open the code view (a tab in the lower left corner of your job window) Past a little bit around before and after line 238. This problem indicates a misuse of a component, so it should be resolve easily. Bye Volker
Curiously I can't see any mistake. Some points to check: a) Are you sure there is a file? b) Can you use another ftp client to get the file (on windows just ftp on commandline)? c) are you behind a firewall which will block some functionality? d) Is there a message in the lgile (workspace/.metadata)? e) Which version of TOS are you using f) Slowly I'm running out of ideas... Bye Volker
message after runing : Starting job test_job at 22:57 02/09/2008. Job test_job ended at 22:57 02/09/2008.
a) Are you sure there is a file? => yes sure in this directory => /www/test_import/ i try to change the name : /www/import/ b) Can you use another ftp client to get the file (on windows just ftp on commandline)? c) are you behind a firewall which will block some functionality? after desactivating zonealarm, i get the same result d) Is there a message in the lgile (workspace/.metadata)? no message (but i not sure to look in the right place) e) Which version of TOS are you using 3.0.0M2
I really don't know what could happend That just a setting for a connection :-( Thx
Hi david, I do not understand it too... I do not know if it would help to send you a job / screen shot. But (if no one else will have an idea) I can send you a job and a ftp-connection for tests. But please give me time until this weekend. Bye Volker
Hi david, I tested the component with TSO 2.4.0 and added two screen shots. This simple test should work. If you want to have the exported script please sen me a PM. This script should download one file from the server. By Volker
Hello you have several files to get in the directory remote with tFileList. After put tFTPget, but I don't know configure this tFTPGet because I don't know to pass the name files that I get with tFTPGet. Could someone help me? thank you very much