+ Start a Discussion
book_Sonbook_Son 

Difference between DataLoader and Import wizard?

Hi,

 

Can any one plz tell me the differences between DataLoader and Import wizard?

 

 

 

Best Answer chosen by Admin (Salesforce Developers) 
nbknbk

All Answers

nbknbk
This was selected as the best answer
Ankit AroraAnkit Arora

Import Wizard :

 

Is designed for less-technical users and smaller, simple imports of up to 50,000 records.

Can only import data of : Account , Contact ,Leads , Solution, and Custom Object.

For more information, go to Help & Training | Importing Data | Using the Import Wizards.

 

Data Loader :

 

For complex imports of any size.

Can upload more than 50000 records.

Can import and export data.

Can import data of any object except User.

 

 

 

Thanks

Ankit Arora

Blog | Facebook | Blog Page

dsiebolddsiebold

Another notable difference is that Data Loader has a command line interface. This means you can automate the processing of data in your org.

 

Dianne

Suresh RaghuramSuresh Raghuram

the information in this site presented very well.

fouzia.bettachefouzia.bettache

hi,

 

I have a question, please can you help me.

 

the question is : Which Import functionality of salesforce.com should be used if one needs to import the 30000 Cases in Salesforce.com?

 

A- import wisard

B- data loader 

 

think you.

Suresh RaghuramSuresh Raghuram

After doing initial analysis on your question. 

 

Data Laoder is the answer.

 

Reason.

 

Import wiziard may not support the case object support.

Akhil_7Akhil_7

Import Wizard Is better up to 30000 records

Ramana414249Ramana414249

fouzia.bettache wrote:

hi,

 

I have a question, please can you help me.

 

the question is : Which Import functionality of salesforce.com should be used if one needs to import the 30000 Cases in Salesforce.com?

 

A- import wisard

B- data loader 

 

think you.



Ans:B

geeta garggeeta garg
Data Loader:-
1.You can use more than 50,000 records.
2.You can insert, update,upsert,delete,export the data.
3.It can not be ignored the duplicate records.
4.You can not schedule the data.

Import wizard:-

1.You can use upto 50,000 records.
2.You can delete the records.
3.It can be ignored the duplicate records.
4. You can schedule the data.




 
Nupur Shefali 91Nupur Shefali 91
Answer is Data Loader.

Import Wizard allows only
a)Accounts and Contacts
b)Leads
c)Solutions
d)Campaign Member Status 
e) And All Custom objects

With a limit of 50,000 records to be imported.

Therefore for the case object data loader is the option whether the records are 30,000 or 3 million.

 
Anuj Joshi 16Anuj Joshi 16
Data loader
Sunil Shah 8Sunil Shah 8
Thanks Ankit Arora :)
chathura ranasinghe 10chathura ranasinghe 10
When you use Import wizard , you need to map fields each and every time you want. if you want to use the same fields again still you need to map. There is no option to save the mapping and reuse, but when you use Data loader you can save the mappings and reuse it.
Jose Hugo Victoria Martinez 6Jose Hugo Victoria Martinez 6
The link of the best answer doesn't work anymore.