User Tools


Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
en:adminmanual:lead_conversion [2016/09/11 00:58]
joebordes [Lead Field Mapping]
en:adminmanual:lead_conversion [2016/09/11 01:01] (current)
joebordes [Lead Field Mapping]
Line 56: Line 56:
  
 The row that is found contains the information we need to make the second change. Look in the column //​tablename//,​ there is the name of the table that holds the real value of the field. Let's suppose that our cf_891 custom field belongs to the Accounts module. We will see that the column //​tablename//​ has a value of //​vtiger_accountscf//​. So we navigate to the vtiger_accountscf table and go to the structure of the table. We will see that the cf_891 has been defined as //​VARCHAR(10)//,​ we must ALTER that definition to //​VARCHAR(20)//​ The row that is found contains the information we need to make the second change. Look in the column //​tablename//,​ there is the name of the table that holds the real value of the field. Let's suppose that our cf_891 custom field belongs to the Accounts module. We will see that the column //​tablename//​ has a value of //​vtiger_accountscf//​. So we navigate to the vtiger_accountscf table and go to the structure of the table. We will see that the cf_891 has been defined as //​VARCHAR(10)//,​ we must ALTER that definition to //​VARCHAR(20)//​
 +
 +Both phpmyadmin and adminer will permit you to do that change in the graphical interface but in the end the necessary SQL will look something like this:
 +
 +<code SQL>​ALTER TABLE vtiger_accountscf CHANGE cf_891 cf_891 varchar(20) NULL</​code>​
  
 After those two changes you should be able reload the Lead mapping screen and do the assignment you need. After those two changes you should be able reload the Lead mapping screen and do the assignment you need.