August 17, 2023

tFTPRename – Docs for ESB 5.x

tFTPRename

tFTPRename_icon32.png

tFTPRename Properties

Component Family

Internet/FTP

 

Function

tFTPRename renames the selected
files via an FTP connection.

Purpose

tFTPRename renames files on an
FTP server.

Basic settings

Property type

Either Built-in or Repository.

Since version 5.6, both the Built-In mode and the Repository mode are
available in any of the Talend solutions.

 

 

Built-in: No property data stored
centrally.

 

 

Repository: Select the Repository
file where properties are stored. The following fields are
pre-filled in using fetched data.

 

Use an existing connection/Component List

Select this check box and in the Component List click the
relevant connection component to reuse the connection details you already defined.

 

Host

FTP IP address.

 

Port

FTP server listening port number.

 

Username

Connection login to the FTP server.

 

Password

Connection password to the FTP server.

To enter the password, click the […] button next to the
password field, and then in the pop-up dialog box enter the password between double quotes
and click OK to save the settings.

 

Remote directory

Path to the remote directory.

 

Move to the current directory

This option appears when Use an existing
connection
is enabled. Select this check box to
change the directory to the one specified in the Remote directory field. The next FTP
component that is linked to the tFTPFileList in the Job will take this directory as
the root of the remote directory when using the same
connection.

 

Overwrite file

List of available options for the transferred file.

Append: Select this check box to
write the data at the end of the record, to not delete it.

 

SFTPSupport/ Authentication method

Select this check box and then in the Authentication method list, select the SFTP
authentication method:

Password: Type in the password
required in the relevant field.

Public key: Type in the private key
or click the three dot button next to the Private key field to browse to it.

Note

If you select Public Key as
the SFTP authentication method, make sure that the key is added
to the agent or that no passphrase (secret phrase) is required.

 

Files

Click the [+] button to add the
lines you want to use as filters:

Filemask: enter the filename or
filemask using wildcharacters (*) or regular expressions.

New name: name to give to the FTP
file after the transfer.

 

Connection Mode

Select the SFTP connection mode you want to use:

Active: You determine the
connection port to use to allow data transfer.

Passive: the FTP server determines
the connection port to use to allow data transfer.

 

Encoding type

Select an encoding type from the list, or select Custom and define it manually. This field
is compulsory for DB data handling.

 

Die on error

This check box is selected by default. Clear the check box to skip
the row in error and complete the process for error-free
rows.

Advanced settings

Use Socks Proxy

Select this check box if you want to use a proxy. Then, set the
Host, Port, User and
Password proxy fields.

 

Ignore Failure At Quit (FTP)

Select this check box to ignore library closing errors or FTP
closing errors.

 

tStatCatcher Statistics

Select this check box to gather the Job processing metadata at a
Job level as well as at each component level.

Global Variables

ERROR_MESSAGE: the error message generated by the
component when an error occurs. This is an After variable and it returns a string. This
variable functions only if the Die on error check box is
cleared, if the component has this check box.

NB_FILE: the number of files processed. This is an After
variable and it returns an integer.

CURRENT_STATUS: the execution result of the component.
This is a Flow variable and it returns a string.

A Flow variable functions during the execution of a component while an After variable
functions after the execution of the component.

To fill up a field or expression with a variable, press Ctrl +
Space
to access the variable list and choose the variable to use from it.

For further information about variables, see Talend Studio
User Guide.

Usage

This component is generally used as a subjob with one component,
but it can also be used as an output or end component..

Log4j

The activity of this component can be logged using the log4j feature. For more information on this feature, see Talend Studio User
Guide
.

For more information on the log4j logging levels, see the Apache documentation at http://logging.apache.org/log4j/1.2/apidocs/org/apache/log4j/Level.html.

Limitation

Due to license incompatibility, one or more JARs required to use this component are not
provided. You can install the missing JARs for this particular component by clicking the
Install button on the Component tab view. You can also find out and add all missing JARs easily on
the Modules tab in the Integration perspective
of your studio. For details, see https://help.talend.com/display/KB/How+to+install+external+modules+in+the+Talend+products
or the section describing how to configure the Studio in the Talend Installation and Upgrade
Guide
.

Scenario: Renaming a file located on the FTP server

This scenario renames a file on the FTP server via tFTPRename. Before the renaming, the file on the FTP server is shown
below:

use_case_tftprename_1.png

Linking the components

  1. Drop tFTPConnection and tFTPRename from the Palette onto the design workspace.

  2. Link tFTPConnection to tFTPRename using the OnSubjobOk trigger.

    use_case_tftprename_2.png

Configuring the components

  1. Double-click tFTPConnection to open its
    Basic settings view.

    use_case_tftprename_3.png
  2. In the Host and Port fields, enter the connection details.

  3. In the Username and Password fields, enter the authentication details.

  4. Double-click tFTPRename to open its
    Basic settings view.

    use_case_tftprename_4.png
  5. Select the Use an existing connection
    check box and then select tFTPConnection_1
    from the Component List.

  6. In the Remote directory field, enter the
    directory on the FTP server where the file exists. Clear the Move to the current directory check box.

  7. In the Files table, click the [+] button to add a line.

  8. In the Filemask column, enter the
    existing file name.

  9. In the New name column, enter the new
    file name.

Executing the Job

  1. Press Ctrl+S to save the Job.

  2. Press F6 to run the Job.

  3. Go to the FTP client UI:

    use_case_tftprename_5.png

    As shown above, the file on the FTP server has been renamed from movies.json to action_movies.json.

Related scenario

For a related scenario, see Scenario: Putting files on a remote FTP server .


Document get from Talend https://help.talend.com
Thank you for watching.
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x