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

Dataloader connection to external database(SQL Server, ect), Made Easy

Hi all:
I wanted to share my experience in connecting to an external database from command line prompt using Salesforce.com Dataloader...

So Lets Get started:
I always wonder why companies would pay outside companies to do data migration between Salesforce.com and external Database. Salesforce.com provides everything for you. All you need to do is a little bit of work. Once you get one thing running then everything else is real easy.

What you save?
Well, if you want to be ahead in your company and impress your boss then you can save them money and do the migration yourself.
Also, if they ask about could this process run nightly. Say "YES".
(If you get a raise out of this then Share it... LOL)

What you need?

1. Most Recent Apex Dataloader. <== its free
2. Command Prompt <== Free
3. an Outside Database (SQL Server, Oracle, Access, etc.) <== Not free but I am thinking since you on my blog you probably have this already
4. Notepad <== free
5. a salesforce username and password <== Free if you are developer edition
6. jtds. jar file <== Free as well

Wow, so the only thing you need to spend money on is the database part but everything else is free.
Thanks
Check out my Other Blogs:
VisualForce Made Easy 
Salesforce Made Easy