Talend community forum / ftpget with list of files

Augustine · 2009-04-30 14:44:06

Hello !

I have a java job in which I create a file listing a number of filepaths. How can I use a FTPget to retrieve this list of files ?
I tried with a tinpufullrow and with a tforeach and with the filemask field of ftpget but it doesn't seem to be it.
Is there a way ?

Thank you !

kboop · 2009-04-30 15:10:14

Hi Augustine,

Have you tried to use a tFlowToIterate between your tInputFullRow and your tFTPget ? I think it could do the trick ;-)
If your project is in java, you can find an example whith a tFlowToIterate in the following topic : http://www.talendforge.org/forum/viewto … 608#p22608

Regards,

Karine

Augustine · 2009-04-30 15:34:59

Thank you for your reply kboop !
Can you give me some more details though ? What do you write in your FTPget component settings to get the remote directory from the file ?

shong · 2009-04-30 16:07:17

Hello Augustine

Can you show us an example of content of your file?

Best regards

shong

thomascap · 2009-04-30 16:11:14

I have a similar problem.

Is it possible to use Context variable in a filemask (in a FTPgetComponent) ?

Uploaded Images

Augustine · 2009-04-30 16:18:05

Hello shong !
My file contains filepaths like that :

file/Log/info.log
aladin/Log/info.log
baco/Log/info.trc
Pog/Log/info.log
Details/Log/info.log
saph/Log/info.log
BEW/Log/info.log
Ocean/Log/inflo.log
caliso/Log/info.log
infg/Log/bkup/info.log
...

Thank you for your help

shong · 2009-04-30 18:11:34

Hello

Here is a scenario,
in.csv:

file/Log/info.log
aladin/Log/info.log
baco/Log/info.trc
Pog/Log/info.log
Details/Log/info.log
saph/Log/info.log
BEW/Log/info.log
Ocean/Log/inflo.log
caliso/Log/info.log
infg/Log/bkup/info.log

expression of var1:

Code:

row1.line.lastIndexOf("/")+1

expression of filePath:

Code:

row1.line.substring(0,Var.var1)

expression of fileName:

Code:

row1.line.substring(Var.var1)

tLogRow_1:

Code:

Starting job forum6407 at 00:02 01/05/2009.
.--------------+---------.
|       tLogRow_1        |
|=-------------+--------=|
|filePath      |fileName |
|=-------------+--------=|
|file/Log/     |info.log |
|aladin/Log/   |info.log |
|baco/Log/     |info.trc |
|Pog/Log/      |info.log |
|Details/Log/  |info.log |
|saph/Log/     |info.log |
|BEW/Log/      |info.log |
|Ocean/Log/    |inflo.log|
|caliso/Log/   |info.log |
|infg/Log/bkup/|info.log |
'--------------+---------'

Job forum6407 ended at 00:02 01/05/2009. [exit code=0]

Best regards

shong

Uploaded Images

Augustine · 2009-05-04 09:48:30

Great ! This is exactly what I needed ! Thank you shong !

Announcement

Unanswered posts

#1 2009-04-30 14:44:06

ftpget with list of files

#2 2009-04-30 15:10:14

Re: ftpget with list of files

#3 2009-04-30 15:34:59

Re: ftpget with list of files

#4 2009-04-30 16:07:17

Re: ftpget with list of files

#5 2009-04-30 16:11:14

Re: ftpget with list of files

#6 2009-04-30 16:18:05

Re: ftpget with list of files

#7 2009-04-30 18:11:34

Re: ftpget with list of files

Code:

Code:

Code:

Code:

#8 2009-05-04 09:48:30

Re: ftpget with list of files

Board footer