Page 1 of 2

Email History

Posted: 10 Jan 2017, 16:43
by nes
Hello everyone,

I saw a feature while testing candidATS that would be a really nice addition to OpenCATS, that is Email history and send email button in the candidate profile (see image below). Does anyone have implemented this in OpenCATS ?
If not, is there a way to get some help in developing this and maybe add it to the next release of OpenCATS ? I have a rather decent level in programming but I will need some help in order to know what files I should look into.

Image

Cheers,

Re: Email History

Posted: 20 Nov 2019, 14:15
by
dveos wrote: 09 Nov 2017, 19:03 Hi Russ,

It's a start!

Please find instructions below, it's not 100% perfect yet as I noticed an issue with emails being sent through the "Activity" pop up. But seems to work perfectly when you email candidates through the standard procedure.

1, Firstly need to create two columns in the email_history table entitled for_id and for_module.
2, I have attached amended files for upload, don't think I'm missing anything.. then job done!

Basically what should happen is when an email goes out it logs the Candidate ID in the for_id column, and also module (i.e. Candidates). Then returns each email in the data grid.

Any issues let me know, or similarly if you can solve the activity email issue please do let me know! :D


Okay, I have now spent about 5 hours trying to get this patch to work. It does log activity, however all for_id's (candidate id's) as 0. Looking at the modified file I cannot see how mailer.php can obtain the candidate id. This means that $id=0. Initially it also reported a sql error:

MySQL Query Failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
NOW()
)' at line 18

INSERT INTO email_history (
from_address,
recipients,
text,
user_id,
site_id,
for_module,
for_id,
date
)
VALUES (
'XXXXXXXXXXX@XXXXXXXX',
'test7@XXXXXXXX',
'Subject: HELLO 3\n\nMessage:\nHELLO 3',
1251,
180,
'candidates',
,
NOW()
)


This was correct by changing the for_id query from %s to %d i.e. from a string to an integer. Emails are now sent and logged, however, with 0 as the candidate ID.

Re: Email History

Posted: 10 Jan 2017, 21:01
by cptr13
You can put this as a feature request on the OpenCATS github. I would include the image.

Re: Email History

Posted: 08 May 2017, 14:08
by dveos
Hi nes,

Did you get any further with this?

Re: Email History

Posted: 20 Jun 2017, 11:54
by RussH
Hi.

Two things;

- does this give you what you need? https://github.com/opencats/OpenCATS/pull/246

"added the option to email a candidate from the candidate show page using OpenCATS email feature. emailing was already implemented through mailto:, but this option is through OpenCATS so the email templates can be used"

Alternatively there is a (stalled) project to poll your mailserver using IMAP , do a candidate lookup on inbound/outbound emails and insert the content to the appropriate candidate activity record. https://github.com/opencats/Opencats-email2activity ..you could give that code some love and see if it can be made operational. I believe it worked okay on small databases, but didn't scale well.

Re: Email History

Posted: 08 Nov 2017, 17:41
by dveos
Hi, just wanted to revive this thread to say that I am close to achieving this as shown in the image - I am one small hurdle away from completing. Will update shortly :D

Re: Email History

Posted: 09 Nov 2017, 14:05
by dveos
I now have this working, I'm not sure of the be best way to upload / contribute if it's something people would be interested in.

Re: Email History

Posted: 09 Nov 2017, 16:14
by RussH
Hi dveos.. yes yes yes .. email me the patch please or the installation instructions and I can add to opencats if you cant add on github yourself!

(ahem, kinda keen to see it working!)

Re: Email History

Posted: 09 Nov 2017, 19:03
by dveos
Hi Russ,

It's a start!

Please find instructions below, it's not 100% perfect yet as I noticed an issue with emails being sent through the "Activity" pop up. But seems to work perfectly when you email candidates through the standard procedure.

1, Firstly need to create two columns in the email_history table entitled for_id and for_module.
2, I have attached amended files for upload, don't think I'm missing anything.. then job done!

Basically what should happen is when an email goes out it logs the Candidate ID in the for_id column, and also module (i.e. Candidates). Then returns each email in the data grid.

Any issues let me know, or similarly if you can solve the activity email issue please do let me know! :D

Re: Email History

Posted: 10 Nov 2017, 09:56
by dveos
Hi Russ,

I just noticed it's the wrong nc file, please find attached.

Re: Email History

Posted: 10 Nov 2017, 12:38
by dveos
The following change in lib/pipelines.php from line 369 solves the activity issue:-
Code: Select all
/* Send e-mail notification. */
            //FIXME: Make subject configurable.
            $mailer = new Mailer($this->_siteID);
            $mailerStatus = $mailer->sendToOne(
                array($emailAddress, '', 'candidate->'.$candidateID),
                CANDIDATE_STATUSCHANGE_SUBJECT,
                $emailText,
                true
            );
        }
    }