Invalid/Opted out email id

[qmv]

Is there a way to search which leads/contacts/targets etc..have invalid or opted out set for their email id's.
I"d like to export a list for these.

Thank you

[qmv]

moderator please help on this!!!

[andopes]

It is possible, but you will need to add the fields opted out / invalid on the contacts Search Form.
For this purpose you will need to customize some scripts, in an upgrade safe way.

Let us know if you need further informations.

Cheers

[qmv]

Hi andopes,

Can you let me know how to add those fields to the source files?

Thanks for your help

[qmv]

It is possible, but you will need to add the fields opted out / invalid on the contacts Search Form.
For this purpose you will need to customize some scripts, in an upgrade safe way.

Let us know if you need further informations.

Cheers

Andopes your help on this will be appreciated...Thank you in advance

[qmv]

It is possible, but you will need to add the fields opted out / invalid on the contacts Search Form.
For this purpose you will need to customize some scripts, in an upgrade safe way.

Let us know if you need further informations.

Cheers

andopes help ?

[zaska]

One solution:

Edit custom/modules/Contacts/metadata/searchdefs.php and in the advanced_search array add:

       'opted_email' =>
      array (
        'name' => 'opted_email',
        'label' => 'LBL_OPTED_EMAIL',
        'type' => 'bool',
        'default' => true,
      ),
      'invalid_email' =>
      array (
        'name' => 'invalid_email',
        'label' => 'LBL_INVALID_EMAIL',
        'type' => 'bool',
        'default' => true,
      ), 
  

Then copy modules/Contacts/metadata/metafiles.php to custom/modules/Contacts/metadata. Change the location of searchfields there:

  
        'searchfields'    =>    'custom/modules/Contacts/metadata/SearchFields.php', 
  

Copy modules/Contacts/metadata/SearchFields.php to custom/modules/Contacts/metadata and add these:

                 'opted_email'=> array(
                        'query_type' => 'default',
                        'operator' => 'subquery',
                        'subquery' => 'SELECT eabr.bean_id FROM email_addr_bean_rel eabr JOIN email_addresses ea ON (ea.id = eabr.email_address_id) WHERE eabr.deleted=0 AND ea.opt_out =',
                        'db_field' => array(
                                'id',
                        )
                ),
                'invalid_email'=> array(
                        'query_type' => 'default',
                        'operator' => 'subquery',
                        'subquery' => 'SELECT eabr.bean_id FROM email_addr_bean_rel eabr JOIN email_addresses ea ON (ea.id = eabr.email_address_id) WHERE eabr.deleted=0 AND ea.invalid_email =',
                        'db_field' => array(
                                'id',
                        )
                ), 
  

Add the new LBLs:
custom/modules/Contacts/language/en_us.lang.php:

 <?php
$mod_strings = array (
  'LBL_OPTED_EMAIL' => 'Opted Out',
  'LBL_INVALID_EMAIL' => 'Invalid Email',
);
?>  

[mmllcid1]

i followed these instructions and i got opt out and invalid email to show up on my advanced contacts search page, however when i try to query using these fields, i get an error saying:
SQL Error : Invalid column name 'invalid_email'.

HELP!!!!

[mmllcid1]

bump.... anyone know how to fix the SQL error?

[mmllcid1]

still trying to figure out why the code above from zaska give this error:
SQL Error : Invalid column name 'invalid_email'.

if i follow the above instructions but make the edits in the modules rather than CUSTOM/modules i get a different SQL error.

I get this:
SQL Error : Conversion failed when converting the varchar value '1%' to data type bit. (when selecting yes)
and
SQL Error : Conversion failed when converting the varchar value '0%' to data type bit. (when selecting no)

So i can see that it is taking the 1 or 0 depending on if I pick yes or no but it adds a '%' sign that makes the where clause think its varchar instead of boolean.

can ANYONE help solve this? please please please!!!!!