topic Re: How to use tFTPget :-( in Talend Studio

How to use tFTPget :-(

Anonymous — Sat, 16 Nov 2024 14:14:50 GMT

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

Re: How to use tFTPget :-(

Anonymous — Mon, 01 Sep 2008 14:55:21 GMT

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

Re: How to use tFTPget :-(

Anonymous — Mon, 01 Sep 2008 15:09:24 GMT

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

Re: How to use tFTPget :-(

Anonymous — Mon, 01 Sep 2008 21:17:18 GMT

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

Re: How to use tFTPget :-(

Anonymous — Mon, 01 Sep 2008 22:05:05 GMT

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

Re: How to use tFTPget :-(

Anonymous — Mon, 01 Sep 2008 22:10:01 GMT

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 😞

Re: How to use tFTPget :-(

Anonymous — Mon, 01 Sep 2008 23:33:01 GMT

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

Re: How to use tFTPget :-(

Anonymous — Mon, 01 Sep 2008 23:37:41 GMT

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

Re: How to use tFTPget :-(

Anonymous — Mon, 01 Sep 2008 23:53:10 GMT

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

Re: How to use tFTPget :-(

Anonymous — Tue, 02 Sep 2008 06:18:59 GMT

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?

Re: How to use tFTPget :-(

Anonymous — Tue, 02 Sep 2008 22:03:02 GMT

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

thx
david

Re: How to use tFTPget :-(

Anonymous — Tue, 02 Sep 2008 22:27:51 GMT

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

Re: How to use tFTPget :-(

Anonymous — Tue, 02 Sep 2008 22:53:08 GMT

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

Re: How to use tFTPget :-(

Anonymous — Wed, 03 Sep 2008 15:48:19 GMT

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

Re: How to use tFTPget :-(

Anonymous — Thu, 04 Sep 2008 10:32:33 GMT

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

thx
david

Re: How to use tFTPget :-(

Anonymous — Thu, 04 Sep 2008 22:49:41 GMT

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

Re: How to use tFTPget :-(

Anonymous — Sat, 06 Sep 2008 21:41:34 GMT

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

Re: How to use tFTPget :-(

Anonymous — Sun, 07 Sep 2008 20:38:24 GMT

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

Re: How to use tFTPget :-(

Anonymous — Thu, 16 Apr 2009 14:30:26 GMT

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