Send Multiple E-mails

Operation Name

Send Multiple E-mails

Function Overview

Based on the contents of the input data, send mail to SMTP server.

Data Model

Data model of this type of component is table model type.

Properties

For information about using variables, refer to "variables".
Basic settings
Item name Required / Optional Use of Variables Description Remarks
Name Required Not available Enter the name on the script canvas.  
Input data Required Not available Select the component on the script canvas.  
Required settings
Item name Required / Optional Use of Variables Description Remarks
Destination Required Not available Select Global Resources.
Refer to "Global Resource Properties" to set up a global resource.
  • [Add]:
    Adds new global resource.
  • [Edit list]:
    Global resource settings can be edited with "Edit Resource list".
  
Authentication
Item name Required / Optional Use of Variables Description Remarks
Authentication mode Required Not available Select the authentication mode when sending mail.
  • [None]:(default)
    No authentication.
  • [POP before SMTP]:
    Before sending authentication to POP3.
  • [SMTP AUTH (LOGIN)]:
    Use SMTP AUTH (LOGIN) to authenticate the system.
  • If [POP before SMTP] is selected, connection timeout for POP server is 15 seconds.
Hostname Required Available Enter POP mail server host name or the IP address.
  • Enabled when [Authentication mode] to [POP before SMTP] is selected.
Port number Required Available Enter the POP port number to access the mail server.
  • The default value is "110".
  • Enabled when [Authentication mode] to [POP before SMTP] is selected.
User name Required Available Enter a user name for SMTP AUTH or to access to POP mail server.
  • Enabled when [POP before SMTP] or [SMTP AUTH (LOGIN)] is selected in [Authentication mode].
Password Required Available Enter a password for SMTP AUTH or to access to POP mail server.
  • Enabled when [POP before SMTP] or [SMTP AUTH (LOGIN)] is selected in [Authentication mode].
SSL connection Optional Not available Select whether to make the SSL connection to POP mail server.
  • [Checked]:
    Make SSL connections.
  • [Not Checked]: (default)
    Do not make SSL connections.
  • Enabled when [POP before SMTP] is selected in [Authentication mode].
  • SSL/TLS is used for SSL connection.
  • If [Checked] is selected, the certificate of the POP3 server must be imported to the keystore which DataSpiderServista is referring to.
    • For information regarding how to import to the keystore, refer to "Import of certificate".
Property Action
Item name Description Remarks
Authentication test Use [User name] and [Password] to test a login to a given [Hostname].
  • Enabled when [POP before SMTP] or [SMTP AUTH (LOGIN)] is selected in [Authentication mode].
  • If the following happens, [Authentication test] is disabled.
    • [Hostname] or [Port number], [Username], [Password] have not been entered
    • [Hostname] or [Port number], [User name], [Password] are specified with variables
Transmission setting
Item name Required / Optional Use of Variables Description Remarks
Encoding Optional Available Select or enter type of encoding when sending mail.
  • [Japanese (JIS)]: (default)
  • [Japanese (Shift JIS)]:
  • [Japanese (EUC)]:
  • [US-ASCII]:
  • [ISO 8859-1]:
  • [UTF-8]:
  • [EUC-KR]:
Use only the canonical name supported by Java SE Runtime Environment 8 when specifying the encoding directly in the field.
Refer to "Supported Encodings"(http://docs.oracle.com/javase/8/docs/technotes/guides/intl/encoding.doc.html) for details.
  • If omitted sends in "UTF-8".
Skip input data that cannot be sent Optional Not available Selects the operation when data is entered can not be sent.
  • [Checked]:
    Messages that cannot be sent will be skipped and continue to process.
  • [Not Checked]: (default)
    When data is entered can not be sent, error occurs.
  • If checked, when an error occurs when sending a message, skip the message and continue.
  • Connection error remains an error when specified the host that cannot be connected because process cannot continue even though have checked the provider.
  • Input data that cannot be send is output into log with WARN log level.
Header
Item name Required / Optional Use of Variables Description Remarks
Header list Optional - Specifies a header to give when sending mail.
  • Refer to schema if you set the schema information for the header.
Header list / Header Required Available Enter the key header to give when sending mail.
  • Double-byte key value is not supported.
  • If the double-byte characters are included, the value is encoded according to RFC 2047 compliant encoding.
Comment
Item name Required / Optional Use of Variables Description Remarks
Comment Optional Not available You can write a short description of this adapter.
The description will be reflected in the specifications.		  

Schema

Input Schema

<?xml version="1.0" encoding="UTF-8" ?>
 <table>
   <row>
     <column>Header 1</column>
     <column>Header 2</column>
       :
     <column>From</column>
     <column>To</column>
     <column>CC</column>
     <column>BCC</column>
     <column>Reply To</column>
     <column>Subject</column>
     <column>Content-type</column>
     <column>Message</column>
     <column>Attachments</column>
   </row>
   <row>
     :
   </row>
 </table>
Column name Description Remarks
Header Specify for each key defined in the [Header List].
  • If a single key holds multiple values, they need to be represented as a comma-delimited string.
  • No element occurs if nothing is specified in the [Header List].
From  
  • To specify multiple value, separate the values with the delimiter character(i.e. semi colon';' or comma ',')
To  
  • To specify multiple value, separate the values with the delimiter character(i.e. semi colon';' or comma ',')
CC  
  • To specify multiple value, separate the values with the delimiter character(i.e. semi colon';' or comma ',')
BCC  
  • To specify multiple value, separate the values with the delimiter character(i.e. semi colon';' or comma ',')
Reply  
  • To specify multiple value, separate the values with the delimiter character(i.e. semi colon';' or comma ',')
Subject    
Content-type    
Message    
Attachments  
  • To specify multiple value, separate the values with the delimiter character(i.e. semi colon';' or comma ',')
  • Please specify the absolute path of the file system as the file path.

Output Schema

None.

Loading schema in Mapper

Schema is loaded automatically.
For any details, please refer to the 'Editing Schema'

Transaction

Transaction is not supported.

PSP Usage

PSP is not supported.

Available component variables

Component variable name Description Remarks
count Returns the number of messages sent.
  • The value defaults to null.
message_category Stroes the category to which corresponding message code belongs to, when an error occurs.
  • The value defaults to null.
message_code Stores its corresponding message code of occured error.
  • The value defaults to null.
message_level Stores the severity of the corresponding message code of the occured error.
  • The value defaults to null.
error_type Returns the error type when error occurred.
  • The value defaults to null.
  • Error is represented in the format depicted below.
    Example:java.io.FileNotFoundException
  • The message may vary depending on the DataSpider Servista version.
error_message Return the error message when error occurred.
  • The value defaults to null.
  • The message may vary depending on the DataSpider Servista version.
error_trace Return trace information when error occurred.
  • The value defaults to null.
  • The message may vary depending on the DataSpider Servista version or the client application used.

Grant charset parameter to attached file setting

If you send text format attached file, default encoding of OS will be set to charset parameter of Content-Type.
By setting up the following property, you can stop granting charset parameter to attached file's Content-Type.

Key Location Description Remarks
mail.mime.setdefaulttextcharset $DATASPIDER_HOME/server/conf/
system.properties
  • [true]:
    Grants default charset parameter if you attach text format file.
  • [false]:
    Does not grant default charset parameter if you attach text format file.
  • Default value is"true", and if you omit, "true" will be set.

Specification Limits

Main exceptions

Exception Name Causes Solution
ResourceNotFoundException
Resource definition could not be found.Name:[]		 [Destination] is not specified. Please specify [Destination] .
ResourceNotFoundException
Resource definition could not be found.Name: [<name of Global Resources>]		 Resource definition selected in [Destination] is not found. Please check the global resource specified in [Destination]
InvalidPropertyConfigurationException
<Property name> is not specified.		 [<Property name>] is not specified. Specify the [<Property name>] .
InvalidSchemaException [Input data] is not valid schema. [Input data] Please check the schema.
RecipientsNotFoundException No receiver is specified in [Input data]. Check the following.
  • The [Input data] has a receiver address.
  • The receiver address specified in the [Input data] does not contain any multi-byte characters.
SenderNotFoundException No sender is specified in [Input data]. Please confirm whether the sender has been specified in [Input data] .
InvalidMailAddressException
<sender> is an invalid email address.		 The sender specified for the [Input data] is invalid. Ensure that the sender specified for the [Input data] is valid.
java.io.UnsupportedEncodingException Encoding set to [Encoding] is not supported. Please check the specified encoding in [Encoding] .
javax.mail.AuthenticationFailedException: [User name] or [Password] is incorrect. Check [User name] and [Password] .
javax.mail.MessagingException:
ConnectionException		 [Hostname] failed to connect to the specified host. Check that you are not wrong about [Hostname], [Port number] . Check whether services are provided in the specified host specified in [Hostname].
javax.mail.MessagingException:
UnknownHostException		 [Hostname] not found . Please check the host name specified with [Hostname].
javax.mail.MessagingException:
SSLHandshakeException		 It occurs when selected [SSL/TLS] or [STARTTLS] in [SSL Connection] in global resource properties.The reason is that the server certificate registered in Java is different from the one that is used to SSL connection,so the validity cannot be verified. Check if the server certificate is registered in JAVA when connecting to SSL server. If registered,check if the server is the same as the one registered in JAVA and check if the server certificate has expired.
javax.mail.SendFailedException
 Failed to send message. Ensure that To, CC, and BCC for the [Input data] are correct.
javax.mail.SendFailedException
Invalid Addresses		 Failed to send message. Ensure that To, CC, and BCC for the [Input data] are correct.
This exception can happen with a correct email address when the mail server returns an error .
com.sun.mail.smtp.SMTPSendFailedException Failed to send message. Please check the message and take appropriate measures.