output += "<input>{!Opportunity.Description}</input>";

output += "<input>this is line 1
this is line 2</input>";

Select Id, ContactId From User WHERE Id = '[LOGGED_IN_ID]'

SearchString="Select Id, ContactId From User WHERE Id = {!$User.Id}";
var queryResult = sforceClient.Query(SearchString);

http://wiki.apexdevnet.com/index.php/Members:Apex_Toolkit_for_Eclipse

9. In the following dialog, select the Apex Toolkit and then click “Select Required”

Apex Eclipse Toolkit (8.0.2002) requires plug-in "org.apache.axis"

bad field names on insert/update call: IsPersonAccount

http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_guidelines_personaccounts.htm#topic-title

"For more information about person accounts, see the Salesforce online help"

entity type cannot be inserted: Opportunity Partner

https://na4.salesforce.com/email/author/emailauthor.jsp?p2=FirstName+LastName

Message Edited by GrantM on 03-28-2006 01:55 AM

Message Edited by GrantM on 03-28-2006 02:05 AM

Hi

I am trying to update large amounts of data to salesforce.
Basicly, i pull down every account we have (26000 currently), reach some conclusion, and update all 26000 after.

Now, everything works fine untill i try update such a large quantity, then i get the Exception 'The operation has timed-out.'

To update this, i have created a method, where i pass an array of Salesforce objects.
I then break these down into sets of 200 and run the sforceservice.update on each batch.
Its this method which times out.
My Code looks something like this:

public static bool UpdateBatchLarge(sforce.sObject[] objecstosave)
{
 //Create a sforceservice
 sforce.SforceService sforceservice = new sforcecommon.security([MyUserName], [MyPassword]).SforceService;
   
 //break the array down into arrays of 200 (the limit)
 Utilities.ArraySplitter arrsplit = new utilities.ArraySplitter(objecstosave);
 sforce.sObject[] tempArray;
 bool SUCCESS = true;
 while((tempArray = arrsplit.GetsObjectRange(200)) != null && SUCCESS)
 {
  sforce.SaveResult[]  saveresult = sforceservice.update(tempArray);

  //Loop through the result set determining if all was successfull
  for(int i = 0; i < saveresult.Length; i++)
  {
   if(!saveresult[i].success)
    SUCCESS = false;
  }
 }

 //return the result
 return SUCCESS;
}

When i lower the amount of records i'm trying to update (say to half - 13000), this does work.
Its just when i try run this on all 26000 records that i have the time out.

Is there some way i can improve how i'm doing this, or a way to specify a longer time out.

I found an article on Microsoft.com that seemed to point me in the right direction:

http://support.microsoft.com/default.aspx?scid=kb;en-us;815209

Is this the problem, or can i change my code to fix this.

TIA

Grant Merwtz

Message Edited by GrantM on 09-30-2005 09:57 AM

Message Edited by GrantM on 09-30-2005 09:57 AM

Hi

I have a massive list of Account Id's for which i'm trying to retrieve there related Assets'

Now this list is too big to create a SOQL query string.

I thought of using the sforce.SforceService.retrieve feature, but this only takes a list of Id;s and cannot be passed a list of AccountId's (a different field from the Id field)

HOw would i do this type of query?

TIA

Grant Merwitz
Workshare Ltd.

Hi

I am trying to update 2000 Case objects in one batch.

Currently i am using the sforceservice.update(sObject[]) method to update these object.
As this is limited to 200 objects per update, i have to break down my array an update these 200 at a time.

This takes about 7 minutes to run.

Is there any better method i should be using, or is this the only way

TIA

GrantM

Hi

I am trying to retrieve a set of cases with about 5000 given Id;s

I posted last week (about 3 posts below this) and was advised to use the retrieve call.
But i seem to have reached the limit of Id's i can use.

A) What is this limit?
B) Is there a way to increase it? or will i have to do multiple calls?

Thanks in advance

Hi

I am trying to return a large set of Cases, for which i have an Array of over 5000 Id's

I tried creating an Ugly Query saying something like:

Select Id From Case WHERE Id = '1000000000xAAAAA' or Id = '1000000000xAAAAB' ... and so on for 5000 Id's

But i get the error:

Query cannot exceed 1000 characters.

Whats the best way of doing this?

TIA

Hi

I am currently trying to return a full table from SalesForce, and loop through this table to do some processing.
The table i pull down contains 5660 records.

I first pull the table down, the loop through it casting each record into its SForce Object do retrieve data.

However, after 1999 records, i get the error:

error: index '2000' out of bound for pointer/array

Why is this, and how can i get arround it?

TIA

Message Edited by GrantM on 08-04-2005 03:53 AM

output += "<input>{!Opportunity.Description}</input>";

output += "<input>this is line 1
this is line 2</input>";

Select Id, ContactId From User WHERE Id = '[LOGGED_IN_ID]'

SearchString="Select Id, ContactId From User WHERE Id = {!$User.Id}";
var queryResult = sforceClient.Query(SearchString);

bad field names on insert/update call: IsPersonAccount

http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_guidelines_personaccounts.htm#topic-title

"For more information about person accounts, see the Salesforce online help"

entity type cannot be inserted: Opportunity Partner

https://na4.salesforce.com/email/author/emailauthor.jsp?p2=FirstName+LastName

Hi

I am trying to update large amounts of data to salesforce.
Basicly, i pull down every account we have (26000 currently), reach some conclusion, and update all 26000 after.

Now, everything works fine untill i try update such a large quantity, then i get the Exception 'The operation has timed-out.'

To update this, i have created a method, where i pass an array of Salesforce objects.
I then break these down into sets of 200 and run the sforceservice.update on each batch.
Its this method which times out.
My Code looks something like this:

public static bool UpdateBatchLarge(sforce.sObject[] objecstosave)
{
 //Create a sforceservice
 sforce.SforceService sforceservice = new sforcecommon.security([MyUserName], [MyPassword]).SforceService;
   
 //break the array down into arrays of 200 (the limit)
 Utilities.ArraySplitter arrsplit = new utilities.ArraySplitter(objecstosave);
 sforce.sObject[] tempArray;
 bool SUCCESS = true;
 while((tempArray = arrsplit.GetsObjectRange(200)) != null && SUCCESS)
 {
  sforce.SaveResult[]  saveresult = sforceservice.update(tempArray);

  //Loop through the result set determining if all was successfull
  for(int i = 0; i < saveresult.Length; i++)
  {
   if(!saveresult[i].success)
    SUCCESS = false;
  }
 }

 //return the result
 return SUCCESS;
}

When i lower the amount of records i'm trying to update (say to half - 13000), this does work.
Its just when i try run this on all 26000 records that i have the time out.

Is there some way i can improve how i'm doing this, or a way to specify a longer time out.

I found an article on Microsoft.com that seemed to point me in the right direction:

http://support.microsoft.com/default.aspx?scid=kb;en-us;815209

Is this the problem, or can i change my code to fix this.

TIA

Grant Merwtz

Message Edited by GrantM on 09-30-2005 09:57 AM

Message Edited by GrantM on 09-30-2005 09:57 AM

Hi

I have a massive list of Account Id's for which i'm trying to retrieve there related Assets'

Now this list is too big to create a SOQL query string.

I thought of using the sforce.SforceService.retrieve feature, but this only takes a list of Id;s and cannot be passed a list of AccountId's (a different field from the Id field)

HOw would i do this type of query?

TIA

Grant Merwitz
Workshare Ltd.

We are looking into upgrading SFDC integration from our application. Basically looking for autopopulating some data into sforce a/c  from our d/b on the fly.

For example if some one try to create a new lead from UI and enter company name, than some link or button can check if that company is existing in our d/b and it pouplate other information automatically.

Is it possible to use scontrol object for this kind of feature or what is the easiest solution to integrate this feature.

Thanks,

nupur