EMail To DMS

Email To DMS block receives email message from server and addes it to Documentation module. Email message is stored in Documentation as text file for now (with all email message info). Received email is saved into message.eml file without attachments inside. Attachments are extracted from received email message and are saved as independed files.

Insert email settings to form for sending emails.
If no POP3/IMAP settings are set in block use settings from Administration panel with selecting option Use system settings from a drop-down menu (Mail server type).

Use Test button to check connection to email server.

When mailbox is selected in EmailToDMS settings form then info about received emails will be saved into tMN_MailboxLog table. Suggestion is to add independed mailbox for each email server. You can review log info in Administration Panel (Nastavitve->Dokumentacija->Mailboxes). You will not select mailbox in EmailToDMS settings form (Mailbox field is empty) than log info will not be saved.
Each email message has Message-ID field in its header. Value for this field is fiiled by outgoing server and it is globally unique. Message-ID value is saved in tMN_MailboxLog table into acExternalId field.
If you selects Mailbox than acExternalId value for selected mailbox will be used to check for duplicates. If we receive email with Message-ID that already exists in tMN_MailboxLog table than such message will not be processed. This is important for IMAP servers but it is also valid for POP3 servers.
There are three bugs that I can see with Message-ID:
- if selected folder of IMAP server contains a big amount of messages than EmailToDMS block will chack all these messages. This is needs a long time;
- we check Message-ID value filtering data by acMailboxGuid and acExternalId in sql where part of query. May be we need to add index for these fields in tMN_MailboxLog table. Andrej what are you thinking about it?
- we saving values for anDocumentQId, anMailboxQId and acExternalId into tMN_MailboxLog table. If user will delete one or more documents from Documentation than corresponding data will be deleted from tMN_MailboxLog table and we will lost info that we already processed email messages. So, such email messages will be inserted into Documentation agail. Andrej, may be we have to save Message-ID values somewhere else. What do you think?

Please, test and notify if you will have any problems with EmailToDMS block. You can use for testings WF that is already attached to this remark.

We cann't get email from Datalab for testing. I used my personal email on gmail.com server for testing. Jure, can use your own email on gmail or other server. As alternative you can create independent email on gmail (or other email servers) for testing.