The Salesforce Data Loader is a software application that can be used to insert, update, or delete Salesforce records from a CSV or export Salesforce records to a CSV.

learn more… | top users | synonyms

0
votes
1answer
29 views

Can I export 8000+ contacts reports at once or should I use data export.io?

Can I export 8000+ contacts from reports at once or should I use dataloader.io?
0
votes
3answers
31 views

Unable to login into Data Loader

When I try to login into data loader, I get a login error. I am sure that I am using the correct username and password, but I am still unable to login.
2
votes
2answers
18 views

Data Loader Custom Settings

I am trying to export Custom Settings through data Loader, but I can not see Custom Settings in the list of objects. Does data loader support exporting custom settings or not?
0
votes
1answer
14 views

Where is the Data Loader executable file after installation ?

I've installed the Windows Data Loader client through Salesforce (Data Management - Data Loader), but I don't see an exe file afterwards. I've been looking all over, searching the entire C drive. I've ...
1
vote
1answer
8 views

Insert Quote using Data Loader

I am trying to upload Quote in my Salesforce Org(Enterprise Edition).I am System Admin of my org.But when i am using Data Loader,there is no option of Quote for Insertion. Thanks in Advance!!
0
votes
1answer
12 views

Content Delivery: Remove expiry date of expired content via data loader

From Winter '15 release, Content can be modified from API. the mass updated expiry dates of content delivery is possible using the object CotentDistribution and field EXPIRYDATE keeping the field ...
1
vote
0answers
15 views

Dataloader CLI gets stuck on ignoring fields

I am getting a weird error when trying to upload a CSV to SalesForce. It looks like the CLI gets stuck in ignoring certain fields that are not mapped in my SDL file (see image). Did anyone ever ...
0
votes
0answers
14 views

Recover Old data from salesforce after mass update

My client accidentally updated some records using data loader which made workflow execute and change plenty of records which were not supposed to be updated. We dont have old copy, can salesforce help ...
2
votes
0answers
15 views

Sort after Converting Object Name to Autonumber

We are trying to insert all of our historical quote data to a custom object "Quote". In doing so, we want to conserve the existing quote number that was generated in our legacy Access database but ...
0
votes
1answer
22 views

Why can't I log in to Apex Data Loader?

I created a new Partner EE org through the Environment Hub. Once it was live and I could log in to it I reset my security token (because I didn't have one) and started up Apex Data Loader. I went to ...
3
votes
3answers
56 views

User Mass update

I want to mass update username and email address for 4000+ users, and want to make sure that their username gets updated. There's only two ways to update username: If User go to link prompted by ...
0
votes
1answer
87 views

How to avoid duplicate Records in Sobject list during Bulk Insert in After Insert Trigger

I have a after insert trigger on Account which inserts another object (Places) after checking Account Shipping fields with address fields of existing Places records. If nothing is found it inserts new ...
0
votes
0answers
14 views

Commcare to Sales Force - Null Values (Insert)

I'm new to sales force and commcare so apologies if this is basic-- but I couldn't seem to find an answer... I am using Data Loader to import forms from Commcare to Sales Force. Not everything on the ...
0
votes
1answer
29 views

Read CSV file from FTP and update records in salesforce

I want to read a csv file from SFTP server and using that i need to update records or mark checkbox field true in Salesforce. This needs to be scheduled to run everyday. Can you please suggest a ...
1
vote
1answer
15 views

Why CampaignId is not accessible on workbench while querying on lead?

I am trying to access campaignId field by querying on lead on workbench. But i am unable to do that. Can anyone tell me, why salesforce did'nt provide that access or should I make any settings to ...
0
votes
1answer
15 views

Salesforce Chatter import contentdata feed using dataloader

I am trying to insert contentdata (e.g. pdf present on my local computer) as feedcomment or post in a group. but i am not able to do it. con anyone suggest how to do it? I am new to salesforce.
0
votes
1answer
36 views

Migrating from existing legacy Knowledge base to Salesforce Knowledge base

Our organisation has decided to move from legacy knowledge base system to Salesforce Knowledge base. We have huge KB and bunch of files (doc, pdf). One of the solution is to move from existing KB ...
0
votes
1answer
24 views

Exact created date and time using dataloader with using where condition [closed]

how to extract exact created date and time using data loader with out using where condition?
1
vote
1answer
30 views

Need to Upsert Data Using Tool Batch Wise

I have order and contact object which have lookup from order to contact...I have Excel sheet which has order as well as contact information in it..I need to insert or upsert this excel sheet which ...
1
vote
0answers
23 views

Automating Import to Two Orgs Using Dataloader

We then have a batch file scheduled to run every night to extract data from an external system. We then would like to have the data loader push the data into two separate SalesForce orgs. Is it ...
1
vote
2answers
43 views

SOQL query with Dataloader using List Literal in WHERE Clause

Is it possible to construct a SOQL query with a list literal in the WHERE clause? My use case is that the data loader cannot handle child relationships/subqueries needed for my search, but I can get ...
4
votes
1answer
83 views

Bulk data API: How to Avoid Upserts

I'm working on an daily integration of about 5 million records (file delta's is not an option). Best practices for large data volumes recommends avoiding upserts. The only alternative solution I can ...
2
votes
1answer
46 views

Mapping in Data Loader seems is case-sensitive

I noticed that in the Data Loader mapping file (.sdl) names of fields of target objects must have exact the same spelling as on target Org (mean case-sensitive). Data loader does not show any error or ...
1
vote
1answer
27 views

Salesforce Custom Object lookup to Contact (or another custom object) and Data Loader import on email rather than id

I am new to Salesforce and hope to begin developing ASAP. I am currently testing a theory...I want to use either Contacts or a Custom Object which will have another Custom Object (Special Activities) ...
0
votes
0answers
18 views

Data loader error

I have installed data loader. When I open the data loader getting error for configure file. How can I resolve this error. Please find attachment of image file. Thanks in advance!
1
vote
0answers
48 views

Data Loader does not open on OS X El Captain

Does anyone have similar issue opening Data Laoder on MAC OS X El Capitan?
0
votes
1answer
32 views

How to Data Loader delete records using external ids

I want to delete some records from a custom object using import id. Is it possible using data loader, because when I try to delete the record using data loader I am only able to see id. I want to ...
-1
votes
1answer
69 views

DataLoader update = System.NullPointerException, Manual update = no error

I'm trying to run a set of updates to change a picklist field for our Opportunities, using Salesforce's DataLoader. When I run the update, none of the records are updated and the results show the ...
0
votes
0answers
24 views

Can Jitterbit Data Loader read XML files?

If I am receiving XML source files to load into Salesforce, can I read them with the Jitterbit Data Loader, or do I need to convert them to CSV first? Which tool I should use to achieve this???
1
vote
2answers
32 views

Is the communication between dataloader & salesforce encrypted?

If I am uploading a CSV file via dataloader into Salesforce, is this data flowing into Salesforce encrypted? Would someone be able to sniff out the data sent by dataloader to Salesforce - and see it ...
2
votes
1answer
28 views

Create Record type in Contact tab and How to upload Contacts using Data Loder?

I crate a Record type Sales Contact in "Contact" and assign a Sales Contact Layout And create a Record Type Enterprise in "Account" and assign a Enterprise Account Layout. When I upload contact in ...
1
vote
1answer
53 views

Unexpected element. Parser was expecting element but found ':HEAD'

I am trying to do the operation from apex data loader and am getting the below error: You are seeing that this error had occurred after processing of 14,400 records. But if I re-run the process ...
0
votes
1answer
20 views

ExactTarget TriggeredSend Future Limit on Dataload

I am trying to bulk insert Contacts that should be picked up by ExactTarget through the TriggeredSend but I am getting Future limits thrown. Is there a different approach that would allow me to ...
0
votes
1answer
36 views

Does Exact Target support loading normalized data?

We want to load the parent-child data from an Oracle database into ExactTarget using the data layout below. I'm looking if is possible to load in the normalized data format without converting the file ...
1
vote
1answer
40 views

Command-Line Upsert: “Internal Comments” mapping

I'm upserting Cases by Command-Line. I need to insert the content of the field "Internal Comments" that actually is not exactly a field of Case (but instead of the object CaseComments). When I create ...
0
votes
0answers
12 views

Data connection not displayed on page elements

I am new to Salesforce community.I am trying to design a page using community for the customers and would like to display some custom object data on community pages. I am planning to use page data ...
2
votes
1answer
42 views

Modify Case Date/Time Opened Field on Upload

I'm trying to import some historical case data into our SalesForce account either through Bulk API or through Data Loader tool. I need to have the field "Date/Time Opened" under the new cases I am ...
3
votes
2answers
43 views

record Created By

I have migrated 50k records in Case object and nearly 500k records in custom objects in Production org. After going soft launch i realized I did't updated the Created By from the older system. I want ...
1
vote
2answers
44 views

Data export of contacts on Account

I need to export Data from Salesforce.The requirement is that I need to extract Accounts and only one contacT associated with the account. Let us say if i have to extract 1000 accounts I need to get 1 ...
1
vote
0answers
53 views

I am Using Command Line Data Loader using Cliq, having error

I am upserting a CSV in sandbox using command line data loader with the help of Cliq, I am trying to upsert Account object and using a custom external Id field but after executing batch file I am ...
0
votes
0answers
23 views

Dataloader CLI for Mac

Is there any command line tool to be used for data loader for Mac ? I am trying to automate data loader for Mac , I see cliq is a tool available for windows, is there any similar tool for Mac ? Has ...
-1
votes
1answer
56 views

Getting exception'System.LimitException: awduplicate2:Too many SOQL queries: 101'.' while updating records through data loader

I was trying to upload 1000 records through data loader. On updates a trigger will be fired to update few fields on lead . trigger TotalReachout on Task (after update) { List<String> ...
1
vote
1answer
54 views

Tricky Question on using Data Loader to perform 'update' on Accounts

So I have a csv file which needs to update Accounts on Salesforce. Here's my question I have 138 different phone/product types(in the csv file) and each Account in the csv has more than one ...
2
votes
3answers
377 views

Apex Data Loader Fails to Load Config File

I am having a rather unique problem getting Apex Data Loader to run from the console. It works great from the GUI, but as soon as I attempt to run process.bat, it blows up from what I can tell during ...
0
votes
1answer
30 views

Inserting Opportunities using dataloader

I am trying to insert opportunities using data loader. I have mapped all the fields correctly and all my accountid and ownerid are correct. Now when I am inserting, the job is failed and I am getting ...
1
vote
1answer
53 views

How To Recover Data That Has Been Overwritten

Sorry in advance for the low grade of technicality that I can provide with this question, but I do not know SalesForce at all and the person leading me through this question has not a technical ...
0
votes
1answer
288 views

Apex dataloader login error

I am trying to login Apex Dataloder, but it's throwing error like this: Failed to send request to https://cs24.salesforce.com/services/Soap/u/23.0/00D19000000ECyF Actually I am using the sandbox ...
1
vote
3answers
72 views

Changing Person Account RecordType to Business Account RecordType

I am investigating possibilities for changing the RecordType of an Account from Person to Business Account. The reasoning for this is that I have a third party system which syncs Accounts with ...
4
votes
1answer
77 views

Dataloader CLI export records modified since process last run date

What I am trying to use Dataloader CLI to export Contacts created or modified since the process ran the last time. The process runs properly, but it always retrieves the same records, and I want it ...
0
votes
2answers
77 views

Error while encrypting password

I am trying to encrypt the password using command encrypt -e mypassword "D:\SFDC_docs\Salesforce-connectivity\try\Key.txt" but getting error as " security.EncryptionUtil main ...