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

1
vote
1answer
18 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
16 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
28 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
56 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
30 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
20 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
17 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!
0
votes
0answers
34 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
29 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
64 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
16 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
30 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
21 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
33 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
17 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
29 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
29 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
10 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
29 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
40 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
39 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
34 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
18 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
44 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
46 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
271 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
24 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
45 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
93 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
49 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
0answers
53 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
51 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 ...
1
vote
0answers
63 views

Mass Delete Tens Of Millions Of Records

I have done my due diligence on this and simply cannot find an answer that does not involve Apex, which is what I'm trying to avoid for various reasons. Does anyone know how to adequately without a ...
1
vote
2answers
74 views

“field mapping is invalid”

The cmd for the Dataloader is telling me the "Field mapping is invalid", even though the sdl file was built in the Apex dataloader tool. I have triple checked the mappings and there's nothing woring ...
0
votes
3answers
84 views

How to import knowledge articles using article import tool?

I need to import knowledge articles using article import tool of salesforce. I am referring this link :- https://ap1.salesforce.com/help/pdfs/en/salesforce_knowledge_import_cheatsheet.pdf but I am ...
1
vote
1answer
19 views

Take a Data backup of an existing custom object with attatchments into a new custom object

I have a custom object which is part of a managed package and is likely to be discontinued. We want to move all the data in that custom object of the managed package to be transferred to a new custom ...
0
votes
0answers
18 views

Is there any way to add public group in a Library using data loader?

How to add Public Groups in a Library using Data loader rather than doing it manually?
1
vote
1answer
35 views

Upserting more than one object via Apex Data Loader

As the title suggests I would like to know whether it is possible to upsert more than one object. Example : Updating Account.Site and Contact.FirstName together in a single apex data loader process. ...
3
votes
2answers
43 views

Apex Data Loader : Strategy for migrating Child records

A fresher question on Salesforce migration via Apex Data Loader : Let us say I need to migrate a contact C whose Account is A. Then in order to build the relationship between C & A I need to set ...
2
votes
3answers
45 views

How to Update blank value in particular field with use of Data Loder?

I want to update field by Blank value where Nick Name = "abcdefg" in Products.
2
votes
1answer
75 views

How do I install Apex Dataloader?

I have downloaded the files from sourceforge and extracted the zip files, but what do I do to install it? I'm on Windows 8.1 Surface Pro 3.
1
vote
1answer
26 views

Migrating Attachments from customized object to Case

How could i migrate all related Attachments and Notes from a custom object to Cases? We had a customized case object which we're trying to migrate, so far we've succesfully migrated all the custom ...
2
votes
0answers
23 views

In which object Article contents stores?

In salesforce, in which object, article content stores. when i am extracting KnowledgeArticleVersion, there is no content. only some fields are there. i have posted both snapshots. please help me, i ...
2
votes
1answer
38 views

How to clear out the field value of picklist field using LexiLoader or Data Loader

I have a large number of records that I need to clear out the piccoloist values of a field for. I have the ID's of the records and I would like to use a Data Loader to clear out the fields based on ...
-1
votes
1answer
59 views

Illegal Service Endpoint error from Dataloader.io

I am wondering if anyone uses Dataloader.io which connects to SF instances. If so have you ever received an "Illegal service endpoint" error? This would also be a question directed to anyone who has ...
0
votes
0answers
18 views

How do I bulk add users to Account Teams such that they have Read/Write access to Cases

This would appear to be easy but I have spent hours searching for a process that actually works. I have a group of users that I have already added to the Account Team related list for hundreds of ...
2
votes
1answer
97 views

Problem with trigger when Inserting new records on custom object

I am trying to insert new records into a custom object (production) via apex data loader. When I do so I get an error like ​ ReservationTrigger: execution of AfterInsert caused by: ...
2
votes
1answer
91 views

How to upload attachments exported from salesforce back to salesforce?

I have to export around 25k attachments from salesforce, change parentId and upload back to salesforce. Can this be done using data loader?. I exported data and it gives attachment body as binary ...
0
votes
1answer
53 views

Apex Data Loader problem

I am trying to insert data into a custom object. My MD field with Contacts is Email__c. I want to use the email to identify the contact as is the unique identifier for my custom object. ( like when ...
0
votes
1answer
46 views

Change Parent Account

Have one question, i have more then 10000 Accounts and all of them have configure the parent account.now here i just want to change the Parent account for all of them. I have seen that parent account ...