Hi,

A few years back I was contracted to help a company to migrate from their then CRM to Salesforce (named by then). I used Enterprise API from .NET C# to make the data migration. It was an interesting exercize but found the EAPI quite static. Then heard of the PartnerApi and started to draw the idea of using it.

The end idea was to build a class library to simplify the access to PartnerApi methods and here are my two-cents.

I've just released the code I've done so far so that other can have a look at it, use it and hopefully develop an useful library for anybody working with this API.

The source code can be found at http://code.google.com/p/appexchange-connector/. It is licensed under LGPL so that it can be used even on non-free projects.

Hope you find it useful.

Any comments, question, suggestion are all welcome.

Saludos,

Martín Trejo Chávez
http://chilli-coder.blogspot.com
http://partnerapi.blogspot.com

Hi,

A few years back I was contracted to help a company to migrate from their then CRM to Salesforce (named by then). I used Enterprise API from .NET C# to make the data migration. It was an interesting exercize but found the EAPI quite static. Then heard of the PartnerApi and started to draw the idea of using it.

The end idea was to build a class library to simplify the access to PartnerApi methods and here are my two-cents.

I've just released the code I've done so far so that other can have a look at it, use it and hopefully develop an useful library for anybody working with this API.

The source code can be found at http://code.google.com/p/appexchange-connector/. It is licensed under LGPL so that it can be used even on non-free projects.

Hope you find it useful.

Any comments, question, suggestion are all welcome.

Saludos,

Martín Trejo Chávez
http://chilli-coder.blogspot.com
http://partnerapi.blogspot.com

I'm thinking about upgrading Karl's old ADO.NET provider to work as a ADO.NET 2.0 provider with batch update capability and VS Desgin support.

Is there any interest in the .NET community for a new version of the provider ?

Thanks,

Bill

http://sforce.sourceforge.net/excel/downloads.htm

I got excited at the recent user group after talking with some of the folks using the connector to get day to day chores done quickly, so i went home and worked out a new feature.

One comment that came up was that inserting records one by one required you to watch over the process as one bad record would stop the bulk load.

After clarifying with Benji and Adam how the create() call works in the office toolkit i was able to refactor my create() code to easily pass a batch of rows to create(), then pick up the return values (id or fail msg) directly from the array which was constructed and passed in to create().

The user interface available within excel for delivering these messages required a bit of creativity, I used the "comment" object on the cells which contain the row which failed to insert. The msg is taken directly from the SObject returned by the toolkit.

The result is that one or several failed create calls will not stop the batch from proceeding. If there are failed create()'s then i message the user at the end of the operation, leaving "new" in the rows which failed, writing the object ID's where we got a successful record inserted.

fixed one other bug with nul group names, also fixed some references to custom objects which were passed into ref_id() and overwritten by a nul string.

The user groups are cool, check them out if you are able.