How do I add additional columns to Convert Lead page that shows existing Contacts that might match?

Question

How do I add additional columns to the page that says:

The contact record you are about to create might be a duplicate of an contact record that already exists. Contacts records containing similar names are listed below.
Click Create Contacts to continue creating this new contact, or select an existing contact listed below.

This page appears when trying to convert leads to contacts.

In addition to the correct answer.

The following needs to be done to complete the column labels:

In file ./custom/modules/Leads/language/en_us.lang.php there is an array of $mod_strings. The following needs to be added for each column.

Database field name(or alias given in query) = {field name}, example: primary_address_city.

'db_{field name}' => 'LBL_LIST_{FIELD NAME}',

'LBL_LIST_{FIELD NAME' => '{label for field name in english',

Example of Primary City:

'db_primary_address_city' => 'LBL_LIST_PRIMARY_ADDRESS_CITY',

'LBL_LIST_PRIMARY_ADDRESS_CITY' => 'City',

Amy Cox · Accepted Answer

OK, Amy Cox , I have something for you -- whoever designed this didn't make upgrade-proof customization easy, but here it is. In the Convert Leads process, the getDuplicateQuery() function is only called once. This is good news because it only requires one file copy and one new file creation. First, copy the file modules/Leads/views/convertleads.php into a new folder called custom/modules/Leads/views/convertleads.php . Then find the require_once call for ContactFormBase.php [in CE version 6.5.22 it is line 406 and 407 of that file] and change this require_once('modules/Contacts/ContactFormBase.php'); $contactForm = new ContactFormBase(); to this require_once( 'custom/modules/Contacts/CustomContactFormBase.php' ); $contactForm = new CustomContactFormBase(); Then create a few class module called custom/modules/Leads/CustomContactFormBase.php that contains this code: <?php require_once('modules/Contacts/ContactFormBase.php'); class CustomContactFormBase extends ContactFormBase { public function getDuplicateQuery($focus, $prefix='') { $query = 'SELECT contacts.id ' . ' , contacts.first_name' . ' , contacts.last_name' . ' , contacts.primary_address_city' . ' ,email_addresses.email_address' . ',accounts.name as "Account Name"' . 'FROM contacts ' . ' LEFT JOIN email_addr_bean_rel ON contacts.id = email_addr_bean_rel.bean_id ' . ' AND email_addr_bean_rel.bean_module = "Contacts"' . ' AND email_addr_bean_rel.primary_address = 1' . ' LEFT JOIN email_addresses ON email_addresses.id = email_addr_bean_rel.email_address_id' . ' LEFT JOIN accounts_contacts ON accounts_contacts.contact_id = contacts.id' . ' LEFT JOIN accounts ON accounts.id = accounts_contacts.account_id'; // or whatever you want to capture $query .= ' where contacts.deleted = 0 AND '; if(isset($_POST[$prefix.'first_name']) && strlen($_POST[$prefix.'first_name']) != 0 && isset($_POST[$prefix.'last_name']) && strlen($_POST[$prefix.'last_name']) != 0) { $query .= " contacts.first_name LIKE '". $_POST[$prefix.'first_name'] . "%' AND contacts.last_name = '". $_POST[$prefix.'last_name'] ."'"; } else { $query .= " contacts.last_name = '". $_POST[$prefix.'last_name'] ."'"; } if(!empty($_POST[$prefix.'record'])) { $query .= " AND contacts.id != '". $_POST[$prefix.'record'] ."'"; } return $query; } } Don't forget to run a Quick Repair. Hope this is what you were looking for!