Soap not working in vTiger 4.2.4

Comments

• 4 Comments sorted by Votes Date Added
• pickle

  June 2006 Vote Up0Vote Down

  i've gotten it to work by doing a number of things including applying the patch for the outlook plugin (included in the .zip). i've only verifiied the functions get_contacts_columns and contact_by_email. i may find more little bugs as i go through each function but this should help get you off the ground. be sure to backup your stuff in case you did mods to contact.php or activities.php. the little test program using nusoap is included (mysoap.php) -- just change the calls to your server and user names.
  
  works with 4.2.3 and 4.2.4.
• pneves

  June 2006 Vote Up0Vote Down

  hi michael,
  
  thanks for your reply.
  i haven't look into your code yet.
  i got it working by doing:
  - instaling 4.2.4
  - applying the patch by terry (november 2005)
  <!-- m --><a class="postlink" href="http://forums.vtiger.com/viewtopic.php?t=3722">http://forums.vtiger.com/viewtopic.php?t=3722</a><!-- m -->
  i just installed this file:
  contactserialize.php
  i did not replace the nusoap files
  
  since i needed the function create_account i also use soap.php.
  i had to change the create_account function on soap.php, since it didn't work
  for example i had to change several line similar to this one, from:
  $account->website = $website;
  to
  $account->column_fields[website] = $website;
  my function:

  function create_account($user_name,$password, $name, $phone, $website)
  {
  	if(!validate_user($user_name, $password)){
  		return 0;
  	}
  	global $log;
  
  	//todo make the activity body not be html encoded
  //	$log->fatal("in create contact: username: $user_name first/last/email ($first_name, $last_name, $email_address)");
  
      $log->info("pneves: create account: $user_name,$password, $name, $phone, $website");
  
  
  	require_once('modules/users/user.php');
  	$seed_user = new user();
  	$user_id = $seed_user->retrieve_user_id($user_name);
  	$current_user = $seed_user;
      $account = new account();
  	//$account->name = $name;
  	//$account->phone_office = $phone;
  	$account->column_fields[accountname] = $name;
  	$account->column_fields[phone] = $phone;
  	$account->column_fields[website] = $website;
  	$account->assigned_user_id = $user_id;
  	$account->assigned_user_name = $user_name;
  	$accountid = $account->save("accounts");
  	$log->info("pneves: create account , accountid - $accountid");
      //return "$accountid";
      return 1;
  }
  

  my vba (visual basic) code example:
  
  - for a contactserialize.php function

       set objsclient = new soapclient30
       call objsclient.mssoapinit(par_wsdlfile:="http://10.2.0.7/contactserialize.php?wsdl")
       fresult = objsclient.get_contacts_count("admin", "admin")
       fresult = objsclient.get_version("admin", "admin")
       set objsclient = nothing
  

  - for a soap.php function

       set objsclient = new soapclient30
       call objsclient.mssoapinit(par_wsdlfile:="http://10.2.0.7/soap.php?wsdl")
       // i could not use the password "admin", i had to get the user_hash from the database
       // since authenticate_user function in user.php does this -> and user_hash='$password'"
       // to get the user_hash do -> select * from users ;
       fresult = objsclient.create_account("admin", "21232f297a57a5a743894a0e4a801fc3", "dnl-nome2", "00351217586856", "www.google.com")
       set objsclient = nothing
  

  questions:
  - why do we have this two files:
  - contactserialize.php
  - soap.php
  couldn't we have all functions in one file ?
  i needed to use soap.php to use this function: create_account
  is it ok to use soap.php ?
  
  - is there a function that returns current accounts ?
  
  - who mantains this files ?
  i am asking this since terry had the same problems more than
  6 motnhs ago and i still find the same problems.
  
  - why this code doesn't have comments ?
  it would help.
  
  - are the soap files updated when the related module code is changed ?
  
  please give me some guidelines on how to use this soap code, since although i
  got it working i have alot of questions and i am not really sure how this code
  should work and if i am using it correctly.
  
  thanks a lot,
  
  pedro
• pickle

  June 2006 Vote Up0Vote Down

  hi pedro,
  
  nice work on the create account.
  
  the soap.php looks like a carryover from sugarcrm. if you tried running it at all you would have gotten errors for the opportunities and cases includes which are sugar not vtiger.
  
  there doesn't appear to be a function that returns current accounts primarily i think because the soap stuff was created for the outlook plugin and there's no concept of an account in outlook. you should just be able to copy the getcontacts from the vtigerolservice.php (and contact.php) and change it for accounts.