Editing accounts export fields

[bunglesan]

Hi,

I have a problem when exporting the accounts data from sugarCRM. I would need to have all the email addresses assigned to the account to be exported. In the current setup (5.0.0b) no emails are exported along with the account data. I know I would need to edit the account.php file for the export query part, but I am a bit unsure how to get all the emails to come along. Is there anybody who has already done this kind of modification or who knows how to do it?

All help is appreciated! Thanks!

[andopes]

Hi bunglesan

Bellow is the code.
You can copy the code between the andopes change and paste at the appropriate place.

     function create_export_query(&$order_by, &$where)
        {
            $custom_join = $this->custom_fields->getJOIN();
            $query = "SELECT
                    accounts.*,
                    users.user_name as assigned_user_name ";
 
// begin andopes change
            $query.= ", GROUP_CONCAT(DISTINCT ea.email_address ORDER BY ea.email_address DESC SEPARATOR ' ') AS email ";
// end andopes change
 
 
                     if($custom_join){
                        $query .=  $custom_join['select'];
                    }
                    $query .= "FROM accounts ";
 
 
 
 
            if($custom_join){
                    $query .=  $custom_join['join'];
                }
            $query .= " LEFT JOIN users
                        ON accounts.assigned_user_id=users.id ";
 
// begin andopes change
        $query.= " LEFT JOIN email_addr_bean_rel eabr ON accounts.id = eabr.bean_id AND eabr.bean_module = 'Accounts' AND eabr.deleted = 0 INNER JOIN email_addresses ea ON eabr.email_address_id = ea.id AND ea.deleted = 0 ";
// end andopes change
 
 
            $where_auto = " accounts.deleted=0 ";
 
            if($where != "")
                    $query .= "where ($where) AND ".$where_auto;
            else
                    $query .= "where ".$where_auto;
 
// begin andopes change
        $query.= "GROUP BY accounts.id";
// end andopes change
 
           if(!empty($order_by)){
                //check to see if order by variable already has table name by looking for dot "."
                $table_defined_already = strpos($order_by, ".");
 
                if($table_defined_already === false){
                    //table not defined yet, define accounts to avoid "ambigous column" SQL error 
                    $query .= " ORDER BY $order_by";
                }else{
                    //table already defined, just add it to end of query
                    $query .= " ORDER BY $order_by";    
                }
                    
            }
 
            return $query;
        } 
  

It is working properly.

Cheers

[bunglesan]

That is brilliant. Just what I needed. Thanks a lot!

[kingjatin]

Hi André Lopes,

I have custom module made for persons, where I have my some custom fields that i enter.

But when I am exporting the records I get all the fields including the system ones as well.

I need to limit the number of fields to be exported, can you please let me know of the file or function to modify my custom module.

thanks