Send One E-mail

Operation Name

Send One E-mail

Function Overview

Send a mail to SMTP server.

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.

Required settings

Item name	Required / Optional	Use of Variables	Description
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".
From	Required	Available	Enter the email address of the sender.
To/Cc/Bcc	Required	-	Enter the email address of the destination. Each column can be operated with the following buttons. [Add]: Add a column. [Up]: Move the order of the selected column upwards by one. [Down]: Move the order of the selected column downwards by one. [Delete]: Delete the column.
To/Cc/Bcc / Category	Required	Available	Select the type of destination. [TO]:(default) [CC]: [BCC]:
To/Cc/Bcc / Mail Address	Required	Available	Enter your email address.

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

Message

Item name	Required / Optional	Use of Variables	Description	Remarks
Subject	Optional	Available	Enter the subject.
Message	Optional	Available	Enter the text.
Content-type	Optional	Available	Select or enter the Content-Type. [text/plain]:(default) [text/html]:	If omitted, set "text/plain".Charset parameter [Encoding] set value.
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".

Attachments

Item name	Required / Optional	Use of Variables	Description	Remarks
Attachments	Optional	-	Specify the path of the attachment file. Each column can be operated with the following buttons. [Add]: Add a column. [Up]: Move the order of the selected column upwards by one. [Down]: Move the order of the selected column downwards by one. [Delete]: Delete the column.
Attachments / File path	Required	Available	Enter the prefix file path .	Please specify the absolute path of the file system as the file path. Constrained characters of DataSpider File System cannot be used except for path separator "/".

Reply

Item name	Required / Optional	Use of Variables	Description	Remarks
Reply-To	Optional	-	Specify the email address to reply. Each column can be operated with the following buttons. [Add]: Add a column. [Up]: Move the order of the selected column upwards by one. [Down]: Move the order of the selected column downwards by one. [Delete]: Delete the column.
Reply-To / Mail address	Required	Available	Enter the email address to reply.

Header

Item name	Required / Optional	Use of Variables	Description	Remarks
Header list	Optional	-	Specifies a header to give when sending mail.
Header list / Header	Required	Available	Enter the key header to give when sending mail.	Double-byte key value is not supported.
Header list / Value	Required	Available	Enter the value header to give when sending mail.	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

None.

Output Schema

None.

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

Pat attention to deal with machine-dependent characters and some characters.

Some characters
If you send some of the following characters, send in UTF-8.

Characters Character code (Unicode)

― 0x2014

～ 0x301C

‖ 0x2016

－ 0x2212

￠ 0x00A2

￡ 0x00A3

￢ 0x00AC

Characters	Character code (Unicode)
―	0x2014
～	0x301C
‖	0x2016
－	0x2212
￠	0x00A2
￡	0x00A3
￢	0x00AC

Model dependent characters (CP932)
Transmit and receive following machine-dependent characters in UTF-8 .

Characters	Character code (Unicode)
①	0x2460;
②	0x2461;
③	0x2462;
④	0x2463;
⑤	0x2464;
⑥	0x2465;
⑦	0x2466;
⑧	0x2467;
⑨	0x2468;
⑩	0x2469;
⑪	0x246A;
⑫	0x246B;
⑬	0x246C;
⑭	0x246D;
⑮	0x246E;
⑯	0x246F;
⑰	0x2470;
⑱	0x2471;
⑲	0x2472;
⑳	0x2473;
Ⅰ	0x2160;
Ⅱ	0x2161;
Ⅲ	0x2162;
Ⅳ	0x2163;
Ⅴ	0x2164;
Ⅵ	0x2165;
Ⅶ	0x2166;
Ⅷ	0x2167;
Ⅸ	0x2168;
Ⅹ	0x2169;
㍉	0x3349;
㌔	0x3314;
㌢	0x3322;
㍍	0x334D;
㌘	0x3318;
㌧	0x3327;
㌃	0x3303;
㌶	0x3336;
㍑	0x3351;
㍗	0x3357;
㌍	0x330D;
㌦	0x3326;
㌣	0x3323;
㌫	0x332B;
㍊	0x334A;
㌻	0x333B;
㎜	0x339C;
㎝	0x339D;
㎞	0x339E;
㎎	0x338E;
㎏	0x338F;
㏄	0x33C4;
㎡	0x33A1;
㍻	0x337B;
〝	0x301D;
〟	0x301F;
№	0x2116;
㏍	0x33CD;
℡	0x2121;
㊤	0x32A4;
㊥	0x32A5;
㊦	0x32A6;
㊧	0x32A7;
㊫	0x32AB;
㈱	0x3231;
㈲	0x3232;
㈹	0x3239;
㍾	0x337E;
㍽	0x337D;
㍼	0x337C;
≒	0x2252;
≡	0x2261;
∫	0x222B;
∮	0x222E;
∑	0x2211;
√	0x221A;
⊥	0x22A5;
∠	0x2220;
∟	0x221F;
⊿	0x22BF;
∵	0x2235;
∩	0x2229;
∪	0x222A;
ⅰ	0x2170;
ⅱ	0x2171;
ⅲ	0x2172;
ⅳ	0x2173;
ⅴ	0x2174;
ⅵ	0x2175;
ⅶ	0x2176;
ⅷ	0x2177;
ⅸ	0x2178;
ⅹ	0x2179;
￢	0xFFE2;
￤	0xFFE4;
＇	0xFF07;
＂	0xFF02;

Some formats of RFC2231 encoding cannot be read.If the file contains an attachment with Japanese, it will be handled in RFC2231 encoding ,the one with long name may not be handled.
Example

filename*1=...
filename*2=...

Order of appearance and location of the header set is not guaranteed.

Value is an empty or null if the header is not included in the message header.

Each attachment Content-Type can not be set.

If you send text format attached file, default encoding of OS will be set to charset parameter of Content-Type.
You cannot individually set charset parameter value.
- Therefore, depending on attached file encoding, it does not correspond to charset parameter encoding, and garbling may occur once you preview contents of attached file with some mailer.
  In that case, dodging garbling may be possible if you set stop granting charset parameter to attached file's Content-type.
  For how to setup, refer to "Grant charset parameter to attached file setting".

PGP, S / MIME is not supported.

APOP authentication, CRAM-MD5 authentication, NTLM authentication, Kerberos authentication is not supported.

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>] .
RecipientsNotFoundException	[Destination] is wrong.	Check the following. [Destination] that is configured with one or more [Destination / Type] correctness [Send / mail address] is entered. [Send / mail address] does not contain any multi-byte characters.
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.SendFailedException	Failed to send message.	Check [Send / mail address] .
javax.mail.SendFailedException Invalid Addresses	Failed to send message.	Check [Send / mail address] . 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.
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.