OpenCATS 0.9.4-3

Free, Open-Source Applicant Tracking System including job-board. Entirely customisable!

Please describe the issue you're having
If you accept the answer, please mark the topic as [SOLVED] by clicking the tick.

Moderators: RussH, cptr13

Forum rules: Just please remember to play nicely once you walk through the door. You can disagree with us, or any other commenters in this forum, but respect our space and keep your comments directed to the topic at hand.
By nes
#2507
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,
By 
#4588
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.
User avatar
By cptr13
#2510
You can put this as a feature request on the OpenCATS github. I would include the image.
By dveos
#2967
Hi nes,

Did you get any further with this?
User avatar
By RussH
#3084
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.
By dveos
#3414
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
By dveos
#3425
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.
User avatar
By RussH
#3426
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!)
By dveos
#3427
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
Last edited by dveos on 24 Aug 2018, 07:29, edited 1 time in total.
By dveos
#3429
Hi Russ,

I just noticed it's the wrong nc file, please find attached.
Last edited by dveos on 24 Aug 2018, 07:29, edited 1 time in total.
By dveos
#3430
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
            );
        }
    }

Hi everyone. I am hoping to do some updating to t[…]

I have added sorting by whether a Contact is Hot o[…]

Bulk Emails

Thanks, however, I’ve now successfully imple[…]

Email Integration

sending emails from opencats I've funded a ver[…]

opencats current release does not support PHP 7.x,[…]

Sorry - I've replied to a separate thread on this.[…]

Hi I have a separate patch I had developed that l[…]

Guys, 99% of the issues I see reported are due t[…]

Hey @ormankanca , that's great news - but is it […]

MySql is not working.

Just to update and close of this thread. I did as […]