Send Email Alerts for Tasks Due

[umutbesler]

Hi,

is there any option that sent an email alert messages for tasks due today.

I searched the software and forum but couldn't find any usefull information about this.

I want my sugar sends me alerts for due tasks.

Thanks

[jli]

this can most likely be done by creating a time based workflow

[jke]

Hi,

have you solved that problem? If so, could you post the solution.
A few threads exist in here with the same questions, but nobdy has posted a
solution.

That it can be solved with the worklow module really does not help.

THX,
Jens

[andopes]

Hi, all.

I believe if the flavor is CE the workflow is not available.
So you can create a new scheduled job for doing it.
If you has Linux or something like that you can configure the cron for trigger the cron.php in the root of you SugarCRM installation.
If you use Windows you can configure the Scheduled tasks for trigger the same cron.php.

What you could do:

1. Edit the file modules/Schedulers/_AddJobsHere.php and add a new entry into $job_strings array, in the end of this script, like:

 $job_strings[] = 'runTasksDueToday'; 
  

After that create this function:

 function runTasksDueToday() {
    if (!class_exists('LoggerManager')){
        require('log4php/LoggerManager.php');
    }
    $GLOBALS['log'] = LoggerManager::getLogger('emailmandelivery');
    $GLOBALS['log']->debug('Called:runMassEmailCampaign');
 
    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/Tasks/TasksDueToday.php');
    return true;
} 
  

After that, create this script: modules/Tasks/TasksDueToday.php, which can select all tasks due today and send their link to someone.

Cheers

--
André Lopes
Lâmpada Global Services
Rua Bela Cintra, 299 conjunto. 51
São Paulo, SP 01415-000
tel1. 55 11 3237-3110
cel. 55 11 7636-5859
e-mail: info@lampadacrm.com.br

[pinzosalvatore]

Oh very interesting.

But What do i have to write in TaskDueToday.php??

any ideas??????????

thanks!

[andopes]

Just here: modules/Tasks/TasksDueToday.php

Cheers

[darksultan]

Adopes,
But what should be INSIDE the modules/Tasks/TasksDueToday.php file?
It should just be blank?

[agdoudou]

Hi every body,

Could anyone help with what we can put in the "Taskduetoday.php"?
Thanks a lot!

[conankun]

Hi all,

same here, can you shed some light on what should be inside TasksDueToday.php? I had a look at TasksQuickCreate.php as an example, but it's very difficult to follow and it doesn't look like what I actually need as well.

Cheers,
HC

[andopes]

Hi every body,

Could anyone help with what we can put in the "Taskduetoday.php"?
Thanks a lot!

The Taskduetoday.php script should:
1. Set a sql query to retrieve the tasks whose date_due is today;
2. Send an email for each assigned user.

Cheers