Any Way to Control (Inbound Email Created) Case Details?

[machineghost]

I just discovered the SugarCRM inbound email => new case feature, and I love it. Previously we had a custom-written Perl script that created records in a Bugzilla database, and while that did work it was much, much messier than the Sugar solution.

However, I do have a problem: there doesn't appear to be any way to control the details of the case that Sugar creates in response to an inbound email. For instance, if I create "category-1-issues@" and "category-2-issues@" email addresses, and feed them in to Sugar, there seems to be no way to specify that emails from the first address should have a category of "Category 1", while emails from the second should instead have a category of "Category 2".

So, my question is: can I control these details somehow by manually editing the PHP files, and if so can anyone point me towards what files/how I would do so? I don't need step-by-step instructions or anything (unless you are super-generous and have lots of free time), just basic details to get me started would be greatly appreciated.

[eggsurplus]

I'm sure you could use logic hooks for this. We wanted to check a checkbox anytime an email came in so we created two files in custom/modules/Emails:

logic_hooks.php (hook definition file):

 <?php
// Do not store anything in this file that is not part of the array or the hook version.  This file will    
// be automatically rebuilt in the future. 
 $hook_version = 1; 
$hook_array = Array(); 
// position, file, function 
$hook_array['before_save'] = Array();
$hook_array['before_save'][] = Array(6, 'flag_new_email_history', 'custom/modules/Emails/NewEmailHistory.php','NewEmailHistory', 'flag_new_email_history'); 
 
?>  

NewEmailHistory.php:

 <?php
if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
 
 
class NewEmailHistory {
 
function flag_new_email_history(&$bean, $event, $arguments)
{
    //$GLOBALS['log']->fatal("flag_new_email_history");
    require_once('modules/Emails/Email.php');
    require_once('modules/Cases/Case.php');
 
    //get id...if not set then it is a new record so create an id here
    if(empty($bean->id)) {
        $bean->id = create_guid();
        $bean->new_with_id = true;
    }
 
    /** for inbound emails */
    if(isset($bean->parent_type) && $bean->parent_type == 'Cases' && !empty($bean->parent_id)
        && $bean->type != "archived" && strpos($bean->name,"[Case:") !== false
    ) {    
        //$GLOBALS['log']->fatal("setting new history flag");
/**
//triggers more logic hooks which we don't want so manually run the update query instead
        $case = new aCase();
        $case->retrieve($bean->parent_id);
        $case->new_history_c = '1';
        $case->save();
*/
        require_once('include/utils.php');
        global $db;
        
        $query = "UPDATE cases_cstm SET new_history_c = '1' where id_c = '".$bean->parent_id."'";
        $db->query($query,true,"Error seting email new history for case: ".$bean->parent_id);
        
    }
 
 
} 
 
}
?>  

With some creativity you should be able to do what you need.