this uploads all contacts and accounts from vtiger to dotproject.
it makes their accountid start at 10000+. accounts will get overwritten in dotproject details change.
enjoy
--------------
<?
$vtiger_home = "localhost" ;
$vtiger_user="----";
$vtiger_pass="----";
$vtiger_base="----";
$dotproject_home = "----" ;
$dotproject_user="----";
$dotproject_pass="----";
$dotproject_base="----";
if (!($vtiger_link=mysql_connect($vtiger_home,$vtiger _user,$vtiger_pass))){
echo "Error when connecting itself to the data base";
exit();
}
if (!mysql_select_db( $vtiger_base , $vtiger_link )){
echo "Error the data base does not exist";
exit();
}
$vtiger_sql = "SELECT * from account ORDER BY accountid";
$vtiger_result=mysql_query( $vtiger_sql )or die( $FunctionName . ": SQL error " . mysql_error() . "| sql = " . htmlentities($vtiger_sql) );
while($vtiger_catRow=mysql_fetch_array($vtiger_res ult)){
/* $dotproject_sql .= "INSERT INTO companies (company_module, company_name, company_phone1, company_phone2, company_fax, company_address1, company_address2, company_city, company_state, company_zip, company_primary_url, company_owner, company_description, company_type, company_email, company_custom) VALUES ('0','".$vtiger_catRow[1]."','".$vtiger_catRow[10]."','".$vtiger_catRow[11]."','".$vtiger_catRow[15]."','','','','','','".$vtiger_catRow[14]."','1','','','".$vtiger_catRow[12]."','".$vtiger_catRow[4]."')\n";
*/
$dotproject_sql .= (10000+$vtiger_catRow[0]).",0,".$vtiger_catRow[1].",".$vtiger_catRow[10].",".$vtiger_catRow[11].",".$vtiger_catRow[15].",,,,,,".$vtiger_catRow[14].",1,,,".$vtiger_catRow[12].",".$vtiger_catRow[4]."\n";
}
$filename = 'vtiger_account_import.sql';
@unlink($filename);
touch($filename);
// Let's make sure the file exists and is writable first.
if (is_writable($filename)) {
// In our example we're opening $filename in append mode.
// The file pointer is at the bottom of the file hence
// that's where $somecontent will go when we fwrite() it.
if (!$handle = fopen($filename, 'a')) {
echo "Cannot open file ($filename)";
exit;
}
// Write $somecontent to our opened file.
if (fwrite($handle, $dotproject_sql) === FALSE) {
echo "Cannot write to file ($filename)";
exit;
}
// echo "Success, wrote ($somecontent) to file ($filename)";
fclose($handle);
} else {
echo "The file $filename is not writable";
}
if (!($dotproject_link=mysql_connect($dotproject_home ,$dotproject_user,$dotproject_pass))){
echo "Error when connecting itself to the data base";
exit();
}
if (!mysql_select_db( $dotproject_base , $dotproject_link )){
echo "Error the data base does not exist";
exit();
}
$dotproject_sql="LOAD DATA LOCAL INFILE 'vtiger_account_import.sql' REPLACE INTO TABLE companies FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'";
$dotproject_result=mysql_query( $dotproject_sql )or die( $FunctionName . ": SQL error " . mysql_error() . "| sql = " . htmlentities($dotproject_sql) );
if (!($vtiger_link=mysql_connect($vtiger_home,$vtiger _user,$vtiger_pass))){
echo "Error when connecting itself to the data base";
exit();
}
if (!mysql_select_db( $vtiger_base , $vtiger_link )){
echo "Error the data base does not exist";
exit();
}
$vtiger_sql = "SELECT * from contactdetails ORDER BY contactid";
$vtiger_result=mysql_query( $vtiger_sql )or die( $FunctionName . ": SQL error " . mysql_error() . "| sql = " . htmlentities($vtiger_sql) );
$dotproject_sql="";
while($vtiger_catRow=mysql_fetch_array($vtiger_res ult)){
/*
$dotproject_sql = "INSERT INTO companies (contact_first_name, contact_last_name, contact_order_by, contact_title, contact_birthday, contact_job, contact_company , contact_department, contact_type, contact_email , contact_email2, contact_url, contact_phone, contact_2, contact_fax, contact_mobile, contact_address1, contact_address2, contact_city, contact_state, contact_zip, contact_country, contact_jabber, contact_icq, contact_msn, contact_yahoo, contact_aol, contact_notes, contact_project, contact_icon, contact_owner, contact_private) VALUES ('".$vtiger_catRow[3]."','".$vtiger_catRow[4]."','','".$vtiger_catRow[2]."','','','".$vtiger_catRow[1]."','','','".$vtiger_catRow[5]."','".$vtiger_catRow[15]."','','".$vtiger_catRow[6]."','".$vtiger_catRow[7]."','".$vtiger_catRow[10]."','".$vtiger_catRow[7]."','','','','','','','','','','','','','','obj/contact','1','')";
*/
if ($vtiger_catRow[0]!='1'){//don't overwrite admin
$dotproject_sql .= (10000+$vtiger_catRow[0]).",".$vtiger_catRow[3].",".$vtiger_catRow[4].",".$vtiger_catRow[4].",,".$vtiger_catRow[2].",,,".$vtiger_catRow[1].",,,".$vtiger_catRow[5].",".$vtiger_catRow[15].",,".$vtiger_catRow[6].",".$vtiger_catRow[7].",".$vtiger_catRow[10].",".$vtiger_catRow[7].",,,,,,,,,,,,,,obj/contact,1,\n";
}
}
$filename = 'vtiger_contact_import.sql';
@unlink($filename);
touch($filename);
// Let's make sure the file exists and is writable first.
if (is_writable($filename)) {
// In our example we're opening $filename in append mode.
// The file pointer is at the bottom of the file hence
// that's where $somecontent will go when we fwrite() it.
if (!$handle = fopen($filename, 'a')) {
echo "Cannot open file ($filename)";
exit;
}
// Write $somecontent to our opened file.
if (fwrite($handle, $dotproject_sql) === FALSE) {
echo "Cannot write to file ($filename)";
exit;
}
// echo "Success, wrote ($somecontent) to file ($filename)";
fclose($handle);
} else {
echo "The file $filename is not writable";
}
if (!($dotproject_link=mysql_connect($dotproject_home ,$dotproject_user,$dotproject_pass))){
echo "Error when connecting itself to the data base";
exit();
}
if (!mysql_select_db( $dotproject_base , $dotproject_link )){
echo "Error the data base does not exist";
exit();
}
$dotproject_sql="LOAD DATA LOCAL INFILE 'vtiger_contact_import.sql' REPLACE INTO TABLE contacts FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'";
$dotproject_result=mysql_query( $dotproject_sql )or die( $FunctionName . ": SQL error " . mysql_error() . "| sql = " . htmlentities($dotproject_sql) );
if (!($vtiger_link=mysql_connect($vtiger_home,$vtiger _user,$vtiger_pass))){
echo "Error when connecting itself to the data base";
exit();
}
if (!mysql_select_db( $vtiger_base , $vtiger_link )){
echo "Error the data base does not exist";
exit();
}
echo "<a href=index.php>Contacts and Accounts imported</a>";
?>