I have a form with about 11 fields that are linked to salesforce. If I leave any one of the non-required, visible fields blank when I fill out the form, I get the following error in the dlog and the lead is not created:

Could not export webform submission with: '' is not a valid value for the type xsd:int.

This errors implies that there is a datatype issue but I don't see where. I am using textfields and selects and the linked fields in SF are the same.

Comments

aaronbauman’s picture

aaronbauman
he/him
commented

This is an issue at the SOAP/SalesForce layer.
it's also an issue for (at least) xsd:double and xsd:boolean

Unfortunately I don't have a workable patch at the moment, but the problem lies in the export function.
Each field exporter should check either the SalesForce data type (preferable) or the drupal widget (less preferable) to see if the datatype is nullable. Ideally this info would be cached and easily accessible without pinging salesforce.com for it.

aaronbauman’s picture

aaronbauman
he/him
commented
Title: Blank fields break the lead import to salesforce » Mapped fields need defaults based on Salesforce validation rules
aaronbauman’s picture

aaronbauman
he/him
commented
Category: bug » feature

Latest dev version addresses this issue to some degree by preventing non-nillable fields from being set to null.
Please give it a whirl.

Leaving this open as a feature request, because there's still work that could be done on this front.

EvanDonovan’s picture

EvanDonovan commented

What other things could be done?

aaronbauman’s picture

aaronbauman
he/him
commented

re #4: there is a lot of data in a) the WSDL and b) the object data that the sf module simply ignores.
for example, each SF field definition contains properties like: nillable, updateable, creatable, deletable, data length, soap type, salesforce type, default...
each SF object definition has similarly many many fields that are ignored by the sf module.

you'll see a good example in array/object notation if you go to the "test" tab in admin/settings/salesforce and view any object, or in xml format if you look through the partner or enterprise wsdl.

kostajh’s picture

kostajh commented
Status: Active » Closed (won't fix)