Leads via php/mySQL

[holsum]

I am using PHP to insert leads into my Sugar database from a content management system ( Joomla) .

Everything works fine except that the Lead email address is not showing in Sugar. I am using 'email1' as the column name and checking the sugar database it is in there. Is there another column that is required in order for the email to show within the Sugar application?

I am using SugraCRM 5.0 community Edition.

Thanks,

-Holsum

[hangdog]

First - Nice Job!

I have the same thing happening when I create a web form form the campaign module.

everything populates but no email displays in the lead body.

Any suggestions?

I'm using Versoin 5.0.0 GA


If I can get this working I will be a happy man!

[sanjaykatiyar1]

Hi holsum,

email1 is the right field in the leads table. If data is going to this field in the 'leads' table then it should show in the sugar application.

[Superman]

Hello guys,

here are results of my research for this problem.
Emails now are being saved very interesting. It is saved in 'email_addr_bean_rel' table.

And Sugar calls for 'getEmailAddressWidget' function to retreive 'email1'.
In final, following function returns email:

 function getAddressesByGUID($id, $module) {
        $return = array();
        
        $q = "SELECT ea.*, ear.* FROM email_addresses ea 
                LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id 
                WHERE ear.bean_module = '{$module}'
                AND ear.bean_id = '{$id}' 
                AND ear.deleted = 0
                ORDER BY ear.reply_to_address, ear.primary_address DESC";
        $r = $this->db->query($q);
 
        while($a = $this->db->fetchByAssoc($r)) {
            $return[] = $a;
        }
        
        return $return;
    } 
  

So, what you need is just look at mentioned new table.

[Superman]

By the way, i have not found field 'email1' in 'leads' table