How to use tFTPget :-(

One Star

How to use tFTPget :-(

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
One Star

Re: How to use tFTPget :-(

Hello,

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


Jeremie
One Star

Re: How to use tFTPget :-(

Thx Jeremy,
I'm goint to test it that way
Thanks
One Star

Re: How to use tFTPget :-(

Jeremie,
I try but it is not working
you will find my setting bellow :
One Star

Re: How to use tFTPget :-(

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
One Star

Re: How to use tFTPget :-(

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 :-(
One Star

Re: How to use tFTPget :-(

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
One Star

Re: How to use tFTPget :-(

Hi Volker,

I try to define a filemask as : ".txt"
i try the job, but now the file (test.txt) i recieve in the folder : "C:/ETL/Test_Talend/"
is empty.

Thx for your're help
david
One Star

Re: How to use tFTPget :-(

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
One Star

Re: How to use tFTPget :-(

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?
One Star

Re: How to use tFTPget :-(

Hi Volker,
I try using only th tFTPget fonction.
But there is no transfer of the file
screen below

thx
david
One Star

Re: How to use tFTPget :-(

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
One Star

Re: How to use tFTPget :-(

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
One Star

Re: How to use tFTPget :-(

Volker,
do you have a job that i could import as example just to test it with my setting.
I really don't know how to do :-(
thx for your're help
david
One Star

Re: How to use tFTPget :-(

Hi,
Is there anyone who have a solution , please help :-)
I do not understand how it is not working

thx
david
One Star

Re: How to use tFTPget :-(

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
One Star

Re: How to use tFTPget :-(

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
One Star

Re: How to use tFTPget :-(

Hi Volker,
Thank you very much for your help
I found a solution and it works :-)
In fact i gave the name in the filemark and i load the file
Not i'm working to finish my layout (i mean i try )

See you later on
thx again for your help
David
One Star

Re: How to use tFTPget :-(

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