Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

0
votes
0answers
6 views

KeyFile Content is too short Salesforce Data Loader CLI while creating a secret key

I am trying to use CLI for Data Loader. While trying to implement the first step i.e, creating a encrypted key I am getting error as Keyfile content is too short. I am using the below command C:\...
0
votes
0answers
17 views

Product Item Data Loader [on hold]

When I'm loading data from my spreadsheet I get the error that products that have the same Unique and Location can't be duplicated. Is there a way I could disable this option? There is other data that ...
1
vote
3answers
17 views

Data Loader Error Date/Time fields Failed to parse date

All of my records are failing to insert for the same error. I do not see an issue with the format itself. I also tried using European format with no luck
0
votes
1answer
37 views

How to insert on salesforce custom object using dataloader

I have a custom salesforce object that I am trying to insert data into via the salesforce data loader tool. I can only see the object when I click export and click on "show all salesforce objects". ...
0
votes
1answer
19 views

Report to fetch Duplicate Contacts

I need to generate a report with list of duplicate contacts and their duplicate count. I’m trying to run below query through Data Loader and Workbench & Export the results. select count(id), ...
0
votes
0answers
14 views

Sharing behavior when uploading data with owner, created by

Uploaded some contacts where the Owner, Created By fields set to user abc(I enabled audit fields for my API only user) Then tried uploading custom object X__c where it has a lookup to contact, Owner ...
1
vote
2answers
37 views

Data Export using Data Loader

I am exporting data from Salesforce using Data Loader, now I am facing some issues with the exported CSV file. Let me give an example, In my custom object, I have some data stored as 23-02-07 which ...
0
votes
0answers
27 views

How to load data from csv using Salesforce Dataloader where data in one csv has two master objects?

I have a data model where a child has two masters. I am trying to upload child csv data using data loader (automation through CLI) that references two master objects. I understand that I can use the ...
0
votes
1answer
44 views

How to query ContentDocumentLink in SOQL and then upsert records in Data Loader

When querying ContentDocumentLink in SOQL using the following query, an error is thrown. Goal: We are attempting to get a spreadsheet of the data so we can update IsDeleted flag with TRUE on entries ...
1
vote
1answer
24 views

How can I load all routing address use dataloader?

I want to load all routing address one time.(like use csv file by dataloader) I imported csv data into object emailServicesAddress by dataloader successfully, but the field EMAILDOMAINNAME is xxxxxxx....
0
votes
1answer
29 views

Importing a date prior to January 1, 1700 in a date field

Is there a way to import a date that is prior to January 1, 1700 in a date field? The documentation says that this is not an option. Link below https://help.salesforce.com/articleView?id=000240801&...
1
vote
2answers
47 views

Content Notes from CSV not uploading via Data Loader

We are attempting to upload a CSV containing local drive links to text files and html files. We want these to become "Content Notes". Data Loader keeps throwing errors when we attempt to upload (see ...
0
votes
0answers
29 views

Process Builder? Data Loader? Formula? What broke?

The issue: A custom formula field called "current grade" stopped working is only now working for some of my students. Using data loader, I exported all students and then updated them matching only ...
0
votes
0answers
22 views

Update field based on lookup returning an error in Data Loader and Import Wizard

We are using the Person-Account model. We have Accounts (households) with Primary Keys populated, and then we have contacts who have their own External IDs and had Accounts created for them through ...
1
vote
1answer
23 views

Can a CSV used in Data Loader have unused fields?

We are using the Upsert command in Salesforce Data Loader. If we have a CSV with several columns we do not wish to update (it's a wide CSV), can we still use it and just not map it? Or do all columns ...
0
votes
1answer
20 views

Data Loader not exporting notes despite records in system

While we are able to export other objects, and can see Notes in the system under Contact records, Data Loader exports only headers and no records under Export All. We are using the "Notes" and "Files" ...
-1
votes
1answer
33 views

Dataloader relationship issues

How can data will be inserted if the records have master or look up relationship? Also how external id is useful in dataloader
0
votes
1answer
15 views

How to resolve below Dataloader error

Too many retries of batch save in the presence of Apex triggers with failures: when triggers are present partial save requires that some subset of rows save without any errors in order to avoid ...
0
votes
1answer
40 views

Mass Update Record Error too many DML

I want to mass update the record of my custom object called Request_Delivery_Plan__c.. There`s 1 trigger called RDP_Create_Delivery_Plan on Request_Delivery_Plan__c.. I set my data loader batch size ...
0
votes
1answer
33 views

Email is not firing for feeditem records inserted through DataLoader

When I am Inserting feed item records through dataLoader, the standard salesforce chatter email is not firing. But When I insert a record through UI, I am getting the mail. Also, the email is coming ...
0
votes
1answer
33 views

Retrieve data from “FeedTrackedChange” table between particular time period

I want to retrieve data from "FeedTrackedChange" table between particular time period. For Example: select * from FeedTrackedChange where CreatedTime >= jan 2000 But the problem here is there is ...
0
votes
1answer
34 views

Data Loader Command line: fields are not validated and then insert is not performed correctly

I am currently using a powershell script to run a data loader command line insert job. The process appears to run correctly, and shows all records successfully inserted. However, when referenced in ...
0
votes
1answer
15 views

Importing external CRM data with new households/accounts joins

Is there a best practice / simplified methodology for importing bulk records from an external CRM when there are new intricate household and account joins? I have looked into dataloader.io, but what ...
0
votes
2answers
27 views

Assign a Role as a Queue Member by Apex or DataLaoder

In the hypothetical situation, I have 100 queues, if I needed to update half of my Queues to have a member of Role 1 and Subordinates and the other 50 queues to have a member of Role 2 and ...
0
votes
1answer
23 views

Data Loader CLI - disable debug messages

I'm trying to turn off the DEBUG messages from Data Loader CLI's output when running. As per the documentation I have set sfdc.debugMessages to false, but it's still outputting them. I have set sfdc....
0
votes
2answers
34 views

Trying to understand upsert - data loader

Im trying to understand how to use upsert.. for example there`s : ID = 1600. Type = Shipping To. and ID = 1600. Type = Billing to. Can I use upsert to update record where ID = 1600 and type = ...
0
votes
2answers
45 views

How can I migrate data and related data from one org to another org?

I have a requirement to migrate data and I have a lot of related data, records and relationships to maintain. Is there a utility or tool to help me do this to minimize the amount of manual steps I ...
2
votes
2answers
28 views

Encountering a very strange Data loader error with number field values in a WHERE-IN clause

Our product backend has an ID field for each customer's instance of our software, so we have a custom Number field on our SFDC Account object to track each customer's Product_Org_Id__c. Often folks ...
1
vote
1answer
22 views

How to import data in AccountFeed object through dataloader? [closed]

I have CSV file for creating/inserting a record in AccountFeed object or any other related Feed Object. At this time it can't able to insert through data loader. Could anybody explain or give me any ...
0
votes
1answer
26 views

How to Import/Query the 'EntityHistory' Object Data Through Data Loader in salesforce

i have some records/data, i mention in Excel File is in below, and i need How to Query the Records from "EntityHistory" Object... please Help me i will try my developer Edition.
0
votes
1answer
101 views

Can't get CLIq to go beyond first screen

If I click on Next I get the error Exception in thread "AWT-EventQueue-0" java.lang.NoSuchMethodError: com.salesforce.dataloader.security.EncryptionUtil.encryptString(Ljava/lang/String;)Ljava/lang/...
0
votes
1answer
36 views

How to Import and Export Notes and Attachments from one Object Using Data loader

I need to export Notes&Attachments for one object from production and Import to the sandbox. Attachments should be linked for each record how they are in production?
0
votes
1answer
61 views

How to import contentversion records(csv file) using dataloader

i have three records in csv file and three pdf files. how can i import these content version records to sandbox. i tried, but when i am uploading csv file using dataloader, i got Required fields are ...
0
votes
2answers
74 views

Failed to send request to error with Data Loader Log In

I am getting the following error when I am trying to log into Data Loader: Failed to send request to I checked that I am providing the correct Username, and the correct Password (in the form of ...
-1
votes
1answer
87 views

Call data loader from a lightning component

I'm trying to build a lightning component that would replicate data loader/data wizard functionality. Is there a way we can integrate data loader into a lightning component? I want users to upload csv ...
2
votes
2answers
75 views

Using bulk API, do seperate serial batches still run parallel to eachother?

I have to load several million child records distributed over about 2000 parent records, so obviously I'm running into locking issues. I'm trying to find a way to avoid locks as much as possible, so I ...
2
votes
1answer
71 views

Data Loader converting & to & and throwing error

I am trying to load a csv file (encoded as UTF-8) into the salesforce Data Loader. One of the values in the csv file is a string reading "Biotechnology & Science". When I try loading the csv file, ...
-1
votes
1answer
31 views

Pulling a list of updated query fields that DataLoader uses

How can I pull a list of the same query fields the DataLoader WebUI uses when you go to export each Salesforce data object to a CSV file? This list of query fields will be used in the DataLoader CLI ...
0
votes
2answers
74 views

Data Loading into Master Detail relationship objects

I have a scnario which I am not able to get through. I have two objects, Obj A and Obj B, both related through Master-Detail relation with Obj A being Master. Now, I have some records to be inserted ...
1
vote
2answers
219 views

Why do we disable validation rules and triggers while Data loads via loader

I'm trying to understand why do we disable validation rules and triggers while loading data via data loader or other tool. If we not disable, what will happen in the system level?
0
votes
0answers
30 views

Data Loader keeps AUTOMATICALLY updating Opportunity name, even though I didn't want to

I'm using data loader to update a few hundred records (opportunities), I'm moving what account the opportunities are related to. In doing so, the opp names are being automatically updated/mirrored to ...
1
vote
3answers
158 views

Time Field on Data Load - “value not of required type: 5:33 PM”

I am attempting to insert some records on a custom object that requires a value in the Time Received field, of type Time. Within an existing record (created manually) the value inside the detail page, ...
0
votes
0answers
18 views

Wait for data loader to finish

I have a set of logic that needs to be ran after data is processed post being loaded into salesforce via data loader, and only will run once there are no more records waiting to be processed. The ...
0
votes
0answers
34 views

Best solution for daily schedule export data from Salesfore to Windowns local server(CSV files)?

My customers want to export special data from Salesforce to local windows server daily. They are using Dataloader in the manual way to export data every day. But they want to save human resource by ...
0
votes
2answers
147 views

How to Extract Notes and Attachments Associated with a Specific Object

I am trying to extract notes and attachments related to a custom Salesforce Object. I have tried to use the workbench and data loader. Data loader does not work because you cannot use nested SOQL ...
1
vote
1answer
66 views

Data Loader behavior with addError()

I have a before update trigger on User object which checks for certain User fields. If that field matches a condition I am supposed to skip the update of that user record, else make some field updates ...
0
votes
0answers
74 views

Failed to send request when using Dataloader command line

I try to create a tool to schedule export data from Salesforce to Windows server. I follow a Salesforce guide and do every step but still got failure. Here is my config file: process-conf.xml <!...
0
votes
1answer
28 views

javax.crypto.BadPaddingException using config.properties file

I am using data loader CLI for upserting users. I have a config.properties with following content: sfdc.endpoint=https://pqr.salesforce.com sfdc.username=yyy@xxx.com sfdc.password=xxxxx When I ...
0
votes
1answer
25 views

How to Export attachments with parentType.field = 'ABC'?

In my org i have a lot attachments available (55,000) and i need to export only those attachments which has Account.field__c = 'ABC' (10,000). I am not sure this is possible in SOQL or not as i tried ...
0
votes
0answers
26 views

Dataloader upsert stops working after Reparentable Master Detail checkbox is checked

I am using V 42 for both Dataloader UI and CLI. We have a child object to Account with Account__c as a Master Detail type to the Account object. Its basically the Id of Account with Reparentable ...