Business Mapping:: Contacts2Accounts

Nombre:
Contacts2Accounts
Type:
businessmapping
Tipo Regla:
Field Mapping
Descripción:
Convert a Contact into an Account
Palabras Claves:
contact, account, conversion
Versión:
1.0
Fecha Publicación:
2016-05-01
Licencia:
MPL
Precio:
Free
Distribución:
Free
Nombre Autor:
JPL TSolucio, S.L.
EMail Autor:
info(at)tsolucio(dot)com
EMail de Soporte:
info(at)tsolucio(dot)com


<map>
  <originmodule>
    <originid>4</originid>
    <originname>Contacts</originname>
  </originmodule>
  <targetmodule>
    <targetid>6</targetid>
    <targetname>Accounts</targetname>
  </targetmodule>
  <fields>
    <field>
      <fieldname>accountname</fieldname>
      <Orgfields>
        <Orgfield>
          <OrgfieldName>firstname</OrgfieldName>
          <OrgfieldID>778</OrgfieldID>
        </Orgfield>
        <Orgfield>
          <OrgfieldName>lastname</OrgfieldName>
          <OrgfieldID>778</OrgfieldID>
        </Orgfield>
        <delimiter> </delimiter>
      </Orgfields>
    </field>
<field>
<fieldname>accounttype</fieldname>
      <Orgfields>
        <Orgfield>
          <OrgfieldName>Customer</OrgfieldName>
         <OrgfieldID>CONST</OrgfieldID>
        </Orgfield>
      </Orgfields>
</field>
<field>
<fieldname>phone</fieldname>
      <Orgfields>
        <Orgfield>
          <OrgfieldName>phone</OrgfieldName>
          <OrgfieldID>778</OrgfieldID>
        </Orgfield>
      </Orgfields>
</field>
<field>
<fieldname>fax</fieldname>
      <Orgfields>
        <Orgfield>
          <OrgfieldName>fax</OrgfieldName>
          <OrgfieldID>778</OrgfieldID>
        </Orgfield>
      </Orgfields>
</field>
<field>
<fieldname>otherphone</fieldname>
      <Orgfields>
        <Orgfield>
          <OrgfieldName>otherphone</OrgfieldName>
          <OrgfieldID>778</OrgfieldID>
        </Orgfield>
      </Orgfields>
</field>
<field>
<fieldname>email1</fieldname>
      <Orgfields>
        <Orgfield>
          <OrgfieldName>email</OrgfieldName>
          <OrgfieldID>778</OrgfieldID>
        </Orgfield>
      </Orgfields>
</field>
<field>
<fieldname>email2</fieldname>
      <Orgfields>
        <Orgfield>
          <OrgfieldName>secondaryemail</OrgfieldName>
          <OrgfieldID>778</OrgfieldID>
        </Orgfield>
      </Orgfields>
</field>
<field>
<fieldname>emailoptout</fieldname>
      <Orgfields>
        <Orgfield>
          <OrgfieldName>emailoptout</OrgfieldName>
          <OrgfieldID>778</OrgfieldID>
        </Orgfield>
      </Orgfields>
</field>
<field>
<fieldname>notify_owner</fieldname>
      <Orgfields>
        <Orgfield>
          <OrgfieldName>notify_owner</OrgfieldName>
          <OrgfieldID>778</OrgfieldID>
        </Orgfield>
      </Orgfields>
</field>
<field>
<fieldname>bill_street</fieldname>
      <Orgfields>
        <Orgfield>
          <OrgfieldName>mailingstreet</OrgfieldName>
          <OrgfieldID>778</OrgfieldID>
        </Orgfield>
      </Orgfields>
</field>
<field>
<fieldname>bill_city</fieldname>
      <Orgfields>
        <Orgfield>
          <OrgfieldName>mailingcity</OrgfieldName>
          <OrgfieldID>778</OrgfieldID>
        </Orgfield>
      </Orgfields>
</field>
<field>
<fieldname>bill_state</fieldname>
      <Orgfields>
        <Orgfield>
          <OrgfieldName>mailingstate</OrgfieldName>
          <OrgfieldID>778</OrgfieldID>
        </Orgfield>
      </Orgfields>
</field>
<field>
<fieldname>bill_code</fieldname>
      <Orgfields>
        <Orgfield>
          <OrgfieldName>mailingzip</OrgfieldName>
          <OrgfieldID>778</OrgfieldID>
        </Orgfield>
      </Orgfields>
</field>
<field>
<fieldname>bill_country</fieldname>
      <Orgfields>
        <Orgfield>
          <OrgfieldName>mailingcountry</OrgfieldName>
          <OrgfieldID>778</OrgfieldID>
        </Orgfield>
      </Orgfields>
</field>
<field>
<fieldname>bill_pobox</fieldname>
      <Orgfields>
        <Orgfield>
          <OrgfieldName>mailingpobox</OrgfieldName>
          <OrgfieldID>778</OrgfieldID>
        </Orgfield>
      </Orgfields>
</field>
<field>
<fieldname>ship_street</fieldname>
      <Orgfields>
        <Orgfield>
          <OrgfieldName>otherstreet</OrgfieldName>
          <OrgfieldID>778</OrgfieldID>
        </Orgfield>
      </Orgfields>
</field>
<field>
<fieldname>ship_city</fieldname>
      <Orgfields>
        <Orgfield>
          <OrgfieldName>othercity</OrgfieldName>
          <OrgfieldID>778</OrgfieldID>
        </Orgfield>
      </Orgfields>
</field>
<field>
<fieldname>ship_state</fieldname>
      <Orgfields>
        <Orgfield>
          <OrgfieldName>otherstate</OrgfieldName>
          <OrgfieldID>778</OrgfieldID>
        </Orgfield>
      </Orgfields>
</field>
<field>
<fieldname>ship_code</fieldname>
      <Orgfields>
        <Orgfield>
          <OrgfieldName>otherzip</OrgfieldName>
          <OrgfieldID>778</OrgfieldID>
        </Orgfield>
      </Orgfields>
</field>
<field>
<fieldname>ship_country</fieldname>
      <Orgfields>
        <Orgfield>
          <OrgfieldName>othercountry</OrgfieldName>
          <OrgfieldID>778</OrgfieldID>
        </Orgfield>
      </Orgfields>
</field>
<field>
<fieldname>ship_pobox</fieldname>
      <Orgfields>
        <Orgfield>
          <OrgfieldName>otherpobox</OrgfieldName>
          <OrgfieldID>778</OrgfieldID>
        </Orgfield>
      </Orgfields>
</field>
<field>
<fieldname>description</fieldname>
      <Orgfields>
        <Orgfield>
          <OrgfieldName>description</OrgfieldName>
          <OrgfieldID>778</OrgfieldID>
        </Orgfield>
      </Orgfields>
</field>
<field>
<fieldname>converted_from</fieldname>
      <Orgfields>
        <Orgfield>
          <OrgfieldName>record_id</OrgfieldName>
          <OrgfieldID>778</OrgfieldID>
        </Orgfield>
      </Orgfields>
</field>
  </fields>
<!--
	// Left out from Account
	website
	tickersymbol
	parentid
	employees
	ownership
	rating
	industry
	siccode
	annualrevenue
 
	// Left out from Contact
	salutation
	accountid
	homephone
	leadsource
	mobile
	title
	department
	birthday
	reportsto
	assistant
	assistantphone
	donotcall
	reference
	portal
	support_start_date
	support_end_date
	imagename
-->
</map>

This script will add the “converted from” field present in the mapping and the action link on Contacts.

<?php
// Turn on debugging level
$Vtiger_Utils_Log = true;
 
include_once('vtlib/Vtiger/Module.php');
 
$module = Vtiger_Module::getInstance('Accounts');
 
if($module) {
    $blockInstance = VTiger_Block::getInstance('LBL_ACCOUNT_INFORMATION',$module);
 
	if($blockInstance) {
 
		$field = new Vtiger_Field();
		$field->name = 'converted_from';
		$field->label= 'Converted From';
		$field->table = $module->basetable;
		$field->column = 'converted_from';
		$field->columntype = 'INT(11)';
		$field->uitype = 10;
		$field->displaytype = 1;
		$field->typeofdata = 'I~O';
		$field->presence = 0;
		$blockInstance->addField($field);
		$field->setRelatedModules(Array('Contacts'));
 
		echo "<br><b>Added Field to ".$module->name." module.</b><br>";
 
	} else {
		echo "<b>Failed to find ".$module->name." block</b><br>";
	}
 
} else {
	echo "<b>Failed to find ".$module->name." module.</b><br>";
}
 
$module = Vtiger_Module::getInstance('Contacts');
 
if($module) {
 
	$module->addLink('DETAILVIEWBASIC','Convert to Account','index.php?module=Accounts&action=EditView&cbfromid=$RECORD$');
 
} else {
	echo "<b>Failed to find ".$module->name." module.</b><br>";
}
?>

coreBOS Documentación