+ Start a Discussion
MarkNZMarkNZ 

Can't update Numeric fields

Hi,
We use the Excel Connector to update Opportunity records with quote values from an estimation spreadsheet.  It has worked fine for about 4 months but now won't update numeric fields.  Dates, currency and text all still work fine.
 
Any ideas?
 
Thanks.
Best Answer chosen by Admin (Salesforce Developers) 
MarkNZMarkNZ
Yes, I did get it going again - I think it was due to a setting on sForce Connector Options - Filter Updates tab.  The
'Allow update...' option should not be selected.  I think this was it - even though the description of this option doesn't appear to relate to the problem!
 
Let me know how you get on.

All Answers

Ken_m3Ken_m3
Hi Mark,

did you work out the problem?  I'm now experiencing a similar issue.

I get an error message that says object required.

I'm using a custom object.
I've turned off validation and workflows
I can update the numeric fields via the SF UI
I can insert new records with values in the cell

I cannot then modify/update the field using the connector ... very perplexing!
MarkNZMarkNZ
Yes, I did get it going again - I think it was due to a setting on sForce Connector Options - Filter Updates tab.  The
'Allow update...' option should not be selected.  I think this was it - even though the description of this option doesn't appear to relate to the problem!
 
Let me know how you get on.
This was selected as the best answer
Ken_m3Ken_m3
I guess you Kiwi's are pretty good after all!

thanks for that - worked a treat.
Kirk F.ax361Kirk F.ax361
I confirm Mark's solution.
Riley BRiley B

Worked!!! Thank You.

 

i'd been looking for a fix on this for 2 weeks.

 

after i re-read, and re-re-read the description for that option, it makes sense now.

 

Thank You.