Exporting the Opt-Out field

[status101]

Hi There, and sorry if this is a silly question but is it possible to export the opt-out field/flag (email_opt_out) in CE from a contacts export?

I have searched the forum, the web and nothing?? I am using an external email marketing app, and I have populated this field during import/transfer from our old system (SFDC), not realising that ( as far as I can tell ) it wont export.

I can get it to appear in the list view (correction.. I can add it in Studio to the list view but it does not appear), but can not search on it to "Filter" my export either...

I have found in the forum that in the pro edition you can access it via reports, but I am running CE so thats no help to me unfortunately. It is a little bit of a shock to me that it's not in the export as standard in any CRM nowadays.

I can obviously create a custom field to use for this functionality, but if I was to do that... how do I get my data out from the standard field, with the contact sugar ID, so I can do an import to the new custom field?

[EDIT] - Ok.. now I am a bit more confused.. I looked at export_utils.php and there I see "email_opt_out"=>"Email Opt Out" as one of the array items for the export??

One idea did occur to me. I was looking in studio, and early on in the process I must have created a custom field "email_opt_out_c" .. Could this be causing a problem? I would remove it, but it appears there is data in it, and if it is not the problem, then I don't really want to do through the whole process or clearing it first if I don't have to.

Any thoughts, pointers, ideas would be greatly appreciated.

OS: Linux Kernal 2.6.18-92.1.22.el 5PAE , Sugar version: v5.2K CE, PHP: v5.2.5, MySql: v5.0.81, Apache:v1.3.41

[sugarcane]

Hello,

To add the Opt out field to the Contact export, go to modules/Contacts/Contact.php

Find the function called create_export_query

Add the following to the top query:
email_addresses.opt_out

[status101]

Hi Sugarcane,

Thank you so much! It worked like a charm, all up and running now... back to sorting out the actual data now

Thanks again.