SOAP, Accounts Module

[xlep]

I'm having some trouble with my PHP/SOAP form that's supposed to enter Data into sugarcrm.

We used it to create Leads until now and it worked flawless. Since we do not want to use the Lead module anymore I tried to edit the form so SOAP creates a new Contact and a new Account instead.

Creating a contact works fine with a few modifications but SugarCRM refuses to write into Accounts via my SOAP calls. I'm no expert but I can't find anything on the subject. Do you guys have any ideas?

It's hard to post code since I can't Pinpoint any crucial passages. In essence it comes down to this:

$sugar->set_entry("Contacts", $sugar->fromAssoc($data_contact));

this works

$sugar->set_entry("Accounts", $sugar->fromAssoc($data_account));

this doesn't

Switching the arrays has no effect and all other default-modules work as well (Leads, Opportunities, etc.)

here's what fromAssoc does

function fromAssoc($array)
{
    $multi = array();
  
    while(list($name, $value) = each($array))
    {
        $multi[] = array("name" => $name, "value" => $value);
    }
      
    return $multi;
}

Are there any known problems or bugs regarding this?
Also I was thinking about working around the problem by writing directly into the database is there any way to do this (I know the basics of writing into the DB, but I have no clue what I'd have to pick for the "id" column)?

[jmertic]

I'm having some trouble with my PHP/SOAP form that's supposed to enter Data into sugarcrm.

We used it to create Leads until now and it worked flawless. Since we do not want to use the Lead module anymore I tried to edit the form so SOAP creates a new Contact and a new Account instead.

Creating a contact works fine with a few modifications but SugarCRM refuses to write into Accounts via my SOAP calls. I'm no expert but I can't find anything on the subject. Do you guys have any ideas?

It's hard to post code since I can't Pinpoint any crucial passages. In essence it comes down to this:

$sugar->set_entry("Contacts", $sugar->fromAssoc($data_contact));

this works

$sugar->set_entry("Accounts", $sugar->fromAssoc($data_account));

this doesn't

Switching the arrays has no effect and all other default-modules work as well (Leads, Opportunities, etc.)

here's what fromAssoc does

function fromAssoc($array)
{
    $multi = array();
  
    while(list($name, $value) = each($array))
    {
        $multi[] = array("name" => $name, "value" => $value);
    }
      
    return $multi;
}

Are there any known problems or bugs regarding this?
Also I was thinking about working around the problem by writing directly into the database is there any way to do this (I know the basics of writing into the DB, but I have no clue what I'd have to pick for the "id" column)?

Any sorts of errors coming back from the web service?

[xlep]

forgot to mention that. No there's no errors in the sugarcrm.log, or in the apache log files. Also tried it with a clean install of 6.3.1 and 6.1.7 on my local machine (with xampp) in the mean time, no change though...

[gauts]

Hi,

it is possible to write directly into the database.

In order to get a valid record id, you'll need to use the create_guid() function located in include/utils.php

But I do think this is not the best solution and solving your soap problem would be better.

Did you make sure to have all required fields in your data ?

Did you add any custom fields in the accounts module ?

[xlep]

Hi,

it is possible to write directly into the database.

In order to get a valid record id, you'll need to use the create_guid() function located in include/utils.php

But I do think this is not the best solution and solving your soap problem would be better.

Did you make sure to have all required fields in your data ?

Did you add any custom fields in the accounts module ?

Thanks for the info. Yeah I'd prefer to use the SOAP methods, but at least I know thre's a workaround now

Yeah, we've added custom fields in our sugarcrm Accounts module, but I've also tried two clean installs (6.3.1 and 6.1.7 and it didn't work either. I also tried to create a new Entry in Accounts and Contacts with the same data (only the assigned user) and it only works for Contacts.

[Angel]

An additional comment to add on to what's already been asked/suggested, historically, I recall that the SOAP API doesn't like null values in the 'value' portion of the name/value array. Check the values that you are passing to verify that none of them are null.

[xlep]

I'm replying a little bit slow due to the spam-control for new users

An additional comment to add on to what's already been asked/suggested, historically, I recall that the SOAP API doesn't like null values in the 'value' portion of the name/value array. Check the values that you are passing to verify that none of them are null.

This shouldn't be a problem since I already tried creating one Accounts-entry with nothing but "required fields" and one with "assigned user id" as the only data passed on to the SOAP method (from a field-database point of view).

I'll try a workaround with direct SQL-Queries but it's not a nice, clean solution so I'm still hoping to find a better way in the long run

[Angel]

I am not sure that lines up with what I meant...

I meant, say you do something like this in your name/value array:

name =>'name', value =>'acme',
name => null, value => null

I think what you are saying is that you did something like this:

name =>'name', value =>'acme',
name => 'annual_revenue', value => null

[xlep]

I am not sure that lines up with what I meant...

I meant, say you do something like this in your name/value array:

name =>'name', value =>'acme',
name => null, value => null

I think what you are saying is that you did something like this:

name =>'name', value =>'acme',
name => 'annual_revenue', value => null

ah ok, what I meant to say was:
I tested it with only passing name => 'asssigned_user_id', value => '1' and it while it worked creating a Lead or Contact it did not work for Accounts, so I figure that the problem must lie somewhere else

[jmertic]

forgot to mention that. No there's no errors in the sugarcrm.log, or in the apache log files. Also tried it with a clean install of 6.3.1 and 6.1.7 on my local machine (with xampp) in the mean time, no change though...

How about in the response itself. Sometimes there are PHP errors that aren't caught by the normal logging that mess things up.