Salesforce.com Dataloader for Sandbox

Scenario:

   You want to load data, update data through Salesforce.com Dataloader to the Sandbox Instance.

Solution:

1. Open up the Apex Dataloader tool.
2. Go to Settings==>Settings
3. Where it States Server Host (clear for Default) replace the https://login.salesforce.com with https://test.salesforce.com

See attach pic

Thanks
eTechCareers.com Coming soon ...
Check out my Other Blogs:
VisualForce Made Easy
Salesforce Made Easy

How to bypass SOQL Errors 21 through Salesforce.com Dataloader

Scenario:

   You wrote a bulk trigger and now want to update all the fields through dataloader. But there is a managed package which has a trigger and is hindering the fact that your trigger has a conflict with that trigger because it is updating the same object. Basically called Recursive Trigger. Which can be handled in that way. But a little trick through dataloader and this can be done.


NOTE:

    I suggest writing a recursive Trigger  if you have one or more triggers updating one object at the same time. Now Managed packages do not allow you to see the code in the trigger. So you might want to do this then.

Solution:

     In the settings of the dataloader please go to Batch size and change it from 200 to 20.

Now this will take time. But it will bypass the error. 

Thanks
Check out my Other Blogs:
VisualForce Made Easy 
Salesforce Made Easy

eTechCareers.com 

Coming soon... 

More info on Recursive Triggers please click here