Added by Matt Casters, last edited by Matt Casters on Jul 14, 2008

Labels:

Enter labels to add to this page:
Wait Image 
Looking for a label? Just start typing.

Description

You can use the FTP job entry to get one or more files from an FTP server.

Options

Option Description
Job entry name The name of the job entry. This name has to be unique in a single job. A job entry can be placed several times on the canvas, however it will be the same job entry.
FTP server name The name of the server or the IP address
User name The user name to log into the FTP server
Password The password to log into the FTP server
Remote directory The remote directory on the FTP server from which we get the files
Target directory The directory on the machine on which Kettle runs in which you want to place the transferred files
Wildcard Specify a regular expression here if you want to select multiple files. For example:
.*txt$ : get all text files
A.*[ENG:0-9].txt  : files tarting with A, ending with a number and .txt
Use binary mode? Check this if the files must be transferred in binary mode.
Timeout The FTP server timeout in seconds.
Remove files after retrieval? Remove the files on the FTP server, but only after all selected files have been successfully transferred.
Don't overwrite files Skip a file when a file with identical name already exists in the target directory.
Use active FTP connection Check this to use active mode FTP instead of the passive mode (default).
Control The encoding to use for the ftp control
Encoding instructions, the encoding matters e.g. for the ftp'ing of filenames when they contain special characters. For Western Europe and the USA "ISO-8859-1" should suffice. You can enter any encoding that is valid on your server.

Notes

Some FTP servers do not allow files to be FTP'ed when they contain certain characters (spaces for example). Therefore, when choosing filenames for files to be FTP'ed, be sure to check up front whether your particular FTP server is able to process your kind of filenames.