Reminder by e-mail

[duffy]

Hello,

Is there a possibility that calendar reminder reminds event by sending an e-mail?

Thanks a lot

[andopes]

Hi, duffy.

You can do that creating a new ScheduledJobs into modules/Schedulers/_AddJobsHere.php script and create a new action into Activities module which will be called by this scheduled task and trigger reminders.

If you don't know how to do, please contact me.

Cheers

--
André Lopes
Lâmpada Global Services
SugarCRM Silver Partner
USA: +1 908 998-2278
BR: +55 11 3237-3110
www.lampadaglobal.com
email: info@lampadaglobal.com

Lampada Global Services delivers enterprise software and offshore programming services to customers around the world.

[duffy]

Hi Andre,

I have never done this. Could you please give me some hints how to do it? Is it possible to send reminders to every particular meeting/call attendee?

Thanks a lot in advance

[andopes]

Hi Andre,

I have never done this. Could you please give me some hints how to do it? Is it possible to send reminders to every particular meeting/call attendee?

Thanks a lot in advance

Hi, duffy.

Are you meaning to send the reminder to the assigned user of the activity?
Do you know php programming?

Cheers

[duffy]

Hi Andre,

Yes I mean reminder to assigned user activity.
And I know php programming, I just wanted some guide

[andopes]

Hi, duffy

You have to modify the script modules/Schedulers/_AddJobsHere.php and place this piece of code at the end of file:

 $job_strings[] = 'runEmailReminder';
 
function runEmailReminder() {
    if (!class_exists('LoggerManager')){
        require('log4php/LoggerManager.php');
    }
    $GLOBALS['log']->debug('Called:runEmailReminder');
 
    if (!class_exists('PearDatabase')){
        require('include/database/PearDatabase.php');
    }
    require_once('include/utils.php');
    global $beanList;
    global $beanFiles;
    require("config.php");
    require('include/modules.php');
    if(!class_exists('AclController')) {
        require('modules/ACL/ACLController.php');
    }
 
    require('modules/Emails/RunEmailReminder.php');
    return true;
} 
  

This script modules/Emails/RunEmailReminder.php is a normal action, which can be accessed by index.php?modules=Emails&action=RunEmailReminder

And it must contains the logic which search for activities to be reminded and send an email to the assigned user.

Cheers

[mikrob35]

Hi all,

I'm quite surprised that email notification on upcoming activities is not a native feature of SugarCRM !

Would anybody have written some code for the modules/Emails/RunEmailReminder.php action mentioned above? I personnaly don't know how to do it.

Thanks in advance for sharing.

[phpteam1]

hi, duffy

you have to modify the script modules/schedulers/_addjobshere.php and place this piece of code at the end of file:

 $job_strings[] = 'runemailreminder';
 
function runemailreminder() {
    if (!class_exists('loggermanager')){
        require('log4php/loggermanager.php');
    }
    $globals['log']->debug('called:runemailreminder');
 
    if (!class_exists('peardatabase')){
        require('include/database/peardatabase.php');
    }
    require_once('include/utils.php');
    global $beanlist;
    global $beanfiles;
    require("config.php");
    require('include/modules.php');
    if(!class_exists('aclcontroller')) {
        require('modules/acl/aclcontroller.php');
    }
 
    require('modules/emails/runemailreminder.php');
    return true;
} 
  

this script modules/emails/runemailreminder.php is a normal action, which can be accessed by index.php?modules=emails&action=runemailreminder

and it must contains the logic which search for activities to be reminded and send an email to the assigned user.

Cheers

the runemailreminder page does not exist. Please advice

[fabivomsee]

where do I get this runemailreminder.php script? or is it sugar non-opensourcecode?

best

fabian

[andopes]

You need to create such page.

I just added the code to show you how to implement.