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
you have several files to get because you use an itarate link with tFileList ?
Infact the tFTPget get a single files and use tftpget(oncomponentOK)--->tFileinputDelimited (main)-->tFileoutputexcel
else use the component from the ecosystem tFTPList (iterate)--->tftpget(oncomponentOK)--->tFileinputDelimited (main)-->tFileoutputexcel
Hi Davis, there seems no filemask defined in your tFtpGet. If this would not help. Can you please explain what the problem is? Is it just doing nothing, is there an exception? Bye Volker
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
I'm using this king of setting
details for :
ftpget
fileinputdelimited
fileoutputdelimited
and my test.txt file is almost 1.17mo
thx for your're help
david
I think the empty file is created by the tFileOutputDelimited. What is the name of the received file on your server? Or can you do a test only with the tFtpGet component?
