Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Tip: Attaching transformation's log

...

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

Only send comment in mail body?

Leave unchecked if you want details of the job's execution included in the mail (job name etc., job statistics [number of rows read/written/..., number of errors etc.], the job's log)

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. See the Tips below.

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.

Tips

How to attach a particular file to the e-mail

...

See this forum message with an example attached.

Attaching transformation's log

You may easily attach a log file with log of a transformation run by the job prior to sending the mail as follows (suppose we have the job Start -> Transformation -> Mail):

  1. In the Transformation job entry's options, check "Specify logfile?" and enter a name and extension for the file. You can also specify the desired log level.
  2. In the Mail job entry's options, check "Attach files to message" and select (at least) the file type "Log".
  3. Voila! The next time the mail is send, it will have the transformation's log attached.