Summary

Sends an e-mail for each row according to the input table.


Getting started

Prepare a table which has the following columns:

  • Recipient email address (string)
  • Send email (bool) – Should the mail be sent?
  • Subject (string)
  • Message (string)

    Optional the following columns can be provided:
  • HTML format (bool)
  • Different return address (bool)
  • Path and filename of attachment (string)
  • Message column (string) – Has the message be sent?

Settings


The setting within the operator are the sender name and the sender email. Additionally it can be chose whether the mail should be sent as HTML as default and if the attachments are in the TIS file system.

Configuration Settings

The operator „Send E-Mails" needs a configuration file named XimesEmailConfig.xml. It defines the following:

  • Which mail server should be used

Which settings/credentials are necessary to send mails

The content of XimesEmailConfig.xml has the following structure:

XimesEmailConfig.xml
<?xml version="1.0" encoding="utf-8" ?>
<XimesEmail>
<SMTP HOST="1.2.3.4" PORT="25" SSL="0" AUTHENTICATION="0" USERNAME="N/A" PASSWORD="N/A" Active="1"/>
</XimesEmail>

HOST

IP address of mail server

PORT

default for SMTP is 25

SSL

  • 0 = no SSL
  • 1 = secured with SSL

AUTHENTICATION

  • 0 = without authentication
  • 1 = with authentication

USERNAME

PASSWORD

  • credentials for the SMTP authentication
  • (warning) if username and password is used then AUTHENTICATION must be set to 1

ACTIVE

  • 0 = inactive (only one record can be active, in case there are multiple smtp entries)
  • 1 = active



Additionally there are two config files web.config for [TIS]Editor and TIServiceWindowsService.exe.config for the TIS Service. There the folder of XimesEmailConfig.xml needs to be defined.
In the TIS standalone these filescan be found in:

  • C:\inetpub\wwwroot\<web>\TIS\WebApp\web.config
  • C:\inetpub\wwwroot\<web>\TIService\bin\TIServiceWindowsService.exe.config

These files have a appSettings section where the following entry must be available and direct to the correct folder

<appSettings>
<add key="XimesEmailConfigPath" value="C:\inetpub\wwwroot\XIMES\TIService\config" />
</appSettings>

(warning) Please note that for SP-EXPERT deployments the directories are different, hence the XimesEmailConfig.xml would be located as well differently

  • C:\Interflex\SP-EXPERT Forecast\SPX-SmartClient-Rep-FC\WebApp\web.config
  • C:\Interflex\SP-EXPERT Forecast\SPX-SmartClient-Rep-FC\TIService\bin\TIServiceWindowsService.exe.config
  • C:\Interflex\SP-EXPERT Forecast\SPX-SmartClient-Rep-FC\TIService\config\XimesEmailConfig.xml


Configuration

Input settings of existing table

Name

Value

Opt.

Description

Example

E-Mail Address

System.String

-

Column with recipients' email addresses

-

Send e-mail

System.Boolean

-

Column with information whether email must be sent to the address of the current line

-

Subject

System.String

-

Column with email subject

-

Message

System.String

opt.

Column with text (message) of the email

-

HTML format

System.Boolean

opt.

Column specifies whether the e-mail must be sent in HTML format (Y/N)

-

Reply-to address

System.String

opt.

Column specifies an optional e-mail address

-

File attachment

System.String

opt.

Column containing the path to a file attachment

-

Message column

System.String

opt.

Column for feedback to sending the email

-

Settings

Name

Value

Opt.

Description

Example

Sender name

System.String

-

Name of the sender

-

Email sender

System.String

-

Email of the sender

-

Send as HTML by default?

System.Boolean

-

Specifies whether e-mails must be sent in HTML format. If required, can be overwritten for each individual e-mail using column 'HTML format'.

-

Attachments from TIS file system

System.Boolean

opt.

Defines that attachments originate from the TIS file system (default: server file system).

-

Screenshot

Troubleshooting

Nothing known up to now.


Related topics