Export email from custom module?

[joeicooper]

I've created a custom "person" module. I can't seem to find a way to export email out of the module. Any ideas?

Running Sugar CE 6.2.4

Thanks,

Joe

[kuske]

You must write an own create_export_query in your custom module.
Just look to modules/Contacts/Contact.php for a template.

[joeicooper]

I was able to find a small code snippet for SugarBean.php in a bug that was created for Sugar 5.2

SugarCRM Bug Tracker | Open Source Business & Social CRM - SugarCRM

// begin andopes change: adding fix for bug 25723
if(isset($this->field_defs['email1'])) {
$ret_array['select'].= " ,email_addresses.email_address email1";
$ret_array['from'].= " LEFT JOIN email_addr_bean_rel on {$this->table_name}.id = email_addr_bean_rel.bean_id and email_addr_bean_rel.bean_module='{$this->module_dir}' and email_addr_bean_rel.deleted=0 and email_addr_bean_rel.primary_address=1 LEFT JOIN email_addresses on email_addresses.id = email_addr_bean_rel.email_address_id ";
}
// end andopes change: adding fix for bug 25723

Plugging this snippet in in the current SugarBean.php worked perfectly. Take a look at that bug and you'll see where to plug that small snippet in. This global fix will work with any of the custom modules that you've created. I think this should really find it's way into the release cycle. It's a problem that's existed for years.

Thanks, Andopes for your excellent work!

[christianknoll]

If a report is fine install our free KINAMU reporter, create a simple report with the email address in and export it.

regards, christian.

I've created a custom "person" module. I can't seem to find a way to export email out of the module. Any ideas?

Running Sugar CE 6.2.4

Thanks,

Joe