Office Toolkit & Excel Connector

Question

The Steps Followed to Get the Excel Connector working are as below:

[1] Installed Office Toolkit from the below Site: http://www.salesforce.com/us/developer/docs/office​toolkit30/SForce_Office_Toolkit_MSI.zip

[2] Downloaded the Excel Connector XLA from the below URL http://excel-connector.googlecode.com/files/sforce​_connector_901.zip.

[3] Excel >> Excel Options >> Add - Ins >> Manage (Excel Add - Ins) >> Browse >> Located the sforce_connect file (XLA file)

I was able to establish the Connection with my Sandbox by following the Steps...

In the Salesforce.com Login dialog Keyed in the below: User Name: Sandbox User Name Password: Password+Security Token Server URL: https://test.salesforce.com/services/Soap/c/16.0

And was able to connect....

I still have one issues while querying Custom Objects ....

Whenever a Query is initiated on a Custom Object, the criterion [System Modstamp > 1/26/2013] gets automatically added and the below error is thrown ... I also get a popup stating No Records returned.

---

Microsoft Excel

Error Generated by request::An internal server error has occured while processing your request. Url:https://cs8-api.salesforce.com/services/Soap/c/16.​0/00DL00000002wGB ExceptionCode : 5103

---

OK

Is there a solution to address the Error? ....

Answer 1

[2] Downloaded the Excel Connector XLA from the below URL http://excel-connector.googlecode.com/files/sforce​_connector_901.zip

This link doesn't work for me, 404 error. Try going to Downloads page and pick "1603". The new one (4 days old) for 64 bit machines is a bit quirky, my colleague tried it yesterday and it complained about office toolkit missing... Actually author admits it's untested ;)

This version is designed to work on 64 Bit OS/Office versions, i've not tested this but it's from a long time friend and so i'll post it and gather feedback in the issues area.

About the modstamp - it's standard thing, the tool tries to protect you from downloading all records which might mean thousands. Default is to retrieve records changed in last 7 days. You can easily bypass it:

1. use the query wizard to build a WHERE clause, that way this standard one won't be appended. Or simply fill in the cells yourself in this format and then click "Query"

   object name | field name | operator | value | field name | operator | value
   

2. You can also break the script execution (Ctrl + Pause/Break if I recall correctly), set the systemmodstamp value in the ancient past (2000?) and let it run query again ;)

3. Try to examine the visual basic code and remove this default date-based constraint if it annoys you so much ;)

About the error message - it might be a broken/old library (seriously, what exactly have you downloaded?). Try enabling a debug log on the server side. Or maybe you got logged out? Does it appear after each action or only sometimes? Also - try bumping up the API version in the endpoint to 27, 16.0 is a bit old ;)

Answer 2

Sorry - posted in the wrong place. As @eyescream says, you seem to have your versions all wrong...so make sure you have version 4.0 of the toolkit, and 1603 of the addin. There is also a little one stop script that installs both for you here:

I have also seen the 'Internal Server Error' start appearing recently when my query returns no data (instead of just a "no data found" message) - but you can just go ahead and modify your query as described above or in the help files and re-run and you should be fine...to test it is all working, just build a query for a record you know is in your system...