Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

Description


You can use the Mail job entry to send a text or HTML e-mail with optional file attachments.

Options

Option

Description

Name of the job entry

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.

Destination address

The destination for the e-Mai.  You can specify multiple addresses if you separate them with a space.

Use authentication

Check this if your SMTP server requires you to authenticate yourself.

Authentication user

The user name to authenticate with

Authentication password

The password to authenticate with.

SMTP server

The mail server to which the mail has to be sent.

Reply address

The reply address for this e-Mail

Subject

The subject of the e-Mail

Include date in message

Check this if you want to include the date in the e-Mail

Contact person

The name of the contact person to be placed in the e-Mail

Contact phone

The contact telephone number to be placed in the e-Mail

Comment

Additional comment to be placed in the e-Mail

Attach files to message

Check this if you want to attach files to this message.

Select the result files types to attach.

When a transformation (or job) processes files (text, excel, dbf, etc) an entry is being added to the list of files in the result of that transformation or job. Specify the types of result files you want to add.

Zip files into a single archive

Check this if you want to zip all selected files into a single archive (recommended!) The zip filename Specify the name of the zip file that will be placed into the e-mail.

Note: All text fields can be specified using (environment and Kettle) variables, possibly set in a previous transformation using the Set Variable step.

How to attach a particular file to the e-mail


You can attach "Result Files" of a particular type(s) to the e-mail, either individually or as a single ZIP archive by checking the option "Attach files to message" and selecting the types to attach under "Select the result files types to attach".
What is a Result File and how to create one? Well, just about any file created during a transformation may become a Result File, you only need to mark it as such. There are several ways to do that:

  1. When creating a file with a step that supports it, allow it to mark the file as a Result File.
    For example the "Text file output" step has the check-box "Add filenames to result" on the File tab for that purpose. (I guess the file type would be General but aren't sure.)
  2. Use the step "Set files in result" from the Job category to mark a file as a result file of a particular type. This steps expects the file name to be in a field (you can use e.g. "Generate Rows" in combination with "Add constants" to produce a row containing the file name).

See this forum message with an example attached.

  • No labels