I recently added a new field and need to bulk update it using the Excel connector, but it's not showing up when I get the object definition. As I understand it, it's because I need to be connecting to a newer API number, and the method to do so includes setting the server URL to a higher number... however, when I go into Options > Advanced, the server URL field is unclickable, and the checkbox to specify a default server is greyed out. Even when I try to log in, I can type in the username and password, but the "Server URL" line is greyed out, and I can't edit it.

What the heck??? :\

We are using the Office Toolkit (Version 4.0) to interface with the Salesforce data (API). We are successfully retrieving data from various tables but can not access the quote table and quote line items. We receive the following error:

~~~~~~~~~
SForceOfficeToolkit4.SQueryResults4.1 error '80004005'

INVALID_TYPE: sObject type 'quote' is not supported. If you are attempting to use a custom object, be sure to append the '__c' after the entity name. Please reference your WSDL or the describe call for the appropriate names.
~~~~~~~~~

When we append the '__c' to custom fields we still receive an error. The WSDL does not provide a solution and various posts to the forum refer to the same problem but so far we do not see an answer posted.

Can someone please tell us how we can access the quote object using Office Toolkit (Version 4.0)? We do have quotes enabled for the organization. If there is any question about API version can you please tell us where to find this in the Office Toolkit?

I've updated the connector for PE to allow use of the 16.0 API and office toolkit 4.0

All new downloads are located here : http://code.google.com/p/excel-connector/

The old site will redirect to the new site on code.google.com

Downloads:

http://code.google.com/p/excel-connector/downloads/list

enjoy.

:smileyvery-happy:

PS: connector downloads hit 100,000 earlier this year.