CMDBuild Forum

Received mails in E-mail grid

Old Versions
#1

hi tecnoteca team,

Is there no automated process implemented in CMDBuild which shows replied emails in the grid?

I noted that in the database the Card(integer) will not be updated by replied emails.

At the moment I've added a trigger function after INSERT like this:

 

DECLARE
    emailId integer := trim(both '[]' from substring(NEW."Subject" from '([[]\d+[]]){1}'))::int;
    card integer;
BEGIN
    IF NEW."Card" IS Null THEN
        SELECT public."Email"."Card" into card FROM public."Email" WHERE "Id" = emailId;
        UPDATE public."Email" SET "Card" = card WHERE "Id"=NEW."Id";
    END IF;
    RETURN NEW;
END;


But is this realy nessecarily? I had the opinion that CMDBuild did it automaticaly in previously versions. I use the Version 2.4.3 and 2.5.0 in both versions it's the same.


thanking you in anticipation and best regards.

Roger

#2

The
replies to the mail sent by CMDBuild are visible in the TAB Email of
the card (if activated), as in previous versions of
CMDBuild.
CMDBuild Team

#3

Previously Tecnoteca wrote:

The replies to the mail sent by CMDBuild are visible in the TAB Email of the card (if activated), as in previous versions of CMDBuild.
CMDBuild Team

Without my trigger function I didn't see received email in the email tab.

In the database the attribute "Card" is empty in received email tubles.

 

Following i tested:

1. sended an email from CMDBuild.

2. received the mail with subject for example: [1234] abcd.

3. replied the email with email program.

4. the reply email is in the database without value in "Card".

5. CMDBuild didn't show any received emails in the email tab.

 

At the moment my trigger function fills the "Card" attribute with the Card Id by comparing the email Id from the email subject with the Id of the original email.

 

If the "Card" attribute in the reply email tuple is filled with the Card Id CMDBuild shows the received email.

 

But my CMDBuild 2.4.3 and 2.5.0 installations doesn't do it automaticaly.

#4

The incoming email was sent as a reply to the email sent by CMDBuild?
Have you configured a task to receive and notify these types of email in the Task Manager of the Administration Module?
On page 82 of the Administrator Manual Version 2.5 ENG you will find information on this.
CMDBuild Team

#5

Previously Tecnoteca wrote:

The incoming email was sent as a reply to the email sent by CMDBuild?
Have you configured a task to receive and notify these types of email in the Task Manager of the Administration Module?
On page 82 of the Administrator Manual Version 2.5 ENG you will find information on this.
CMDBuild Team

Yes, I reply to the email thru outlook.

The idea is that an user could do little requests for example a hd drive exchange, without a workflow in background. (perhaps a bad example)

And the system engineer could reply to the mail and the requester sees (in CMDBuild) that the engineer have done the work.

 

Yes, I configured an E-mail Task in the Task manager for incoming emails. The incoming emails where stored in database in the table Email but the "Card" attribute was empty. According to this the link to the Card is missing.

 

 

 

#6

Have you activated the notification action (page 85 of the manual) ?
The current implementation does not create the link if the notification action has not been selected.
CMDBuild Team

 

 

 

#7

Previously Tecnoteca wrote:

Have you activated the notification action (page 85 of the manual) ?
The current implementation does not create the link if the notification action has not been selected.
CMDBuild Team

 

Thanks i'll try it again.

best regards
Roger