SugarCRM Account Insert

[clbryan26]

Hello everyone,

 

I am a little new to the whole web design and web coding scene. I have been looking around to try and find a CRM for WHMCS (not to replace the support features or user login system) but mainly for customer contact information, document management, and contact records for when we communicate with a client via phone, etc...)

 

I chose to use SugarCRM after exhaustive feature research and comparison. After the integration is complete I will gladly release it back to the community. I just need a little help getting started.

 

I used the actionhooks.php file in WHMCS to perform an event when the create user is executed. There is however a synthax error with my code. I know it probably is something very small and easy but I am still learning so be kind please. I did try it myself first and think I got pretty far with it having limited coding experience in the past.

 

I plan to further develop it so that when a user is updated or a contact for a user is entered into the system for particular user it gets created and managed into SugarCRM. I will possibly have to extend use of the API for both systems at some point.

 

I have been reading the forums and noticed a lot of people want to organize contacts and clients by business name. Perhaps using a simple bridge/hack like this to an already existing and well implemented system might be a good solution? That is just my two cents worth though.

 

Thanks for any assistance provided!

 

Corey Martin

 

Thanks for your help.

 

	#sugarcrm insert when created

$con = mysql_connect("localhost","user","pass");
if (!$con)
 	{
 	die('Could not connect: ' . mysql_error());
 	}

mysql_select_db("mycommon_v2", $con);

mysql_query("INSERT INTO accounts ( id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, assigned_user_id, account_type, industry, annual_revenue, phone_fax, billing_address_street, billing_address_city, billing_address_state, billing_address_postalcode, billing_address_country, rating, phone_office, phone_alternate, website, ownership, employees, ticker_symbol, shipping_address_street, shipping_address_city, shipping_address_state, shipping_address_postalcode, shipping_address_country, parent_id, sic_code, campaign_id, mybillid) 
VALUES ('', '$vars["Email"]', NOW( ) , NOW( ) , NULL , NULL , NULL , '0', NULL , NULL , NULL , NULL , 'NULL', '$vars["Address1"]', '$vars["City"]', '$vars["State"]', '$vars["Postcode"]', '$vars["Country"]', NULL , '$vars["PhoneNumber"]', NULL, 'website', NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , '$vars["ClientID"]')");

[bear]

Moved to integration questions