CONFIGURATION

E-mails can be imported from a mailbox via a resource import or an event import.

The data source is a CSV file generated by the VISUAL PLANNING server by calling the following URL: http://vp_server/importmail.do?ACCOUNT=exemple-adresse@mail.com

Where:

  • vp_server is the address of the VISUAL PLANNING server;

  • the ACCOUNT setting is the e-mail address where the e-mails will be retrieved.

Defining the import URL

This URL address can take the following settings (separated in the URL by an and):

  • ACCOUNT: Specifies the e-mail address where the e-mails will be retrieved.

  • FOLDER: Specifies the name of the folder in the mailbox from which the e-mails will be imported,

  • DELAY: Specifies a delay in minutes. Only e-mails whose reception date is later than the current date minus this delay will be retrieved. If the value is -1, all the e-mails marked as unread will be retrieved. If in this case the protocol is IMAP, they are marked as read once they have been imported.

  • MAX_MESSAGES: Specifies the maximum number of messages retrieved by the import.

Warning

The conditions of the DELAY and MAX_MESSAGES settings are combined. In other words, the first limit reached determines the imported e-mails.

Creating the import context

Once the URL has been built, in General Settings > Right-click on Imports/Exports > Create a context:

Definition of the import context

When configuring the import context, in the Source tab:

  • the Type must be equal to Csv File,
  • and the Path to the e-mail export URL.

Once these two settings have been entered correctly, it is possible to match up the VISUAL PLANNING headings (created previously either in the dimension or in the form) with the information returned by the URL.

The information returned by the URL is:

  • ID: Unique e-mail identifier,

  • DATE: E-mail reception date,

  • FROM: Sender’s e-mail address,

  • SUBJECT: Subject of the e-mail,

  • TO: Recipient’s e-mail address,

  • CC: E-mail addresses of recipients in copy,

  • BODY: Body of e-mail text,

  • ATTACHMENTS: URL for access to attachments that will first be downloaded on the VISUAL PLANNING server,

  • IMAGES: URL for access to images contained in the e-mail that will first be downloaded on the VISUAL PLANNING server,

  • EML: URL for access to the complete e-mail file in .eml format which will first be downloaded on the VISUAL PLANNING server.

ghostghostghostghostghost
loading table of contents...