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
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
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 )
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
