Skip to main content

Questions tagged [data-loader]

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.

Filter by
Sorted by
Tagged with
2 votes
0 answers
17 views

DataLoader CSV Bulk API not loading field values if first processed record does not have all fields populated

Has anyone else ran into issues using DataLoader where if the first row of the CSV file that is loaded successfully does not have values for every possible field in the file, it will fail to load? For ...
SCVandal's user avatar
  • 103
0 votes
1 answer
32 views

How to re-import IERs into Salesforce - getting duplicate errors on et4ae5__MergeId__c field

We purged IER records (IndividualEmailResults, which is data from Marketing Cloud about emails sent there to contacts from SF) from Salesforce about nine months ago due to the large amount of data ...
hgolov's user avatar
  • 773
1 vote
0 answers
33 views

how to delete null line in batch script from csv files

I had a problem with my csv files input, because some of csv type is not processed because process runner is NPE to automate insert with dataloader CLI. Can you have a solution with this problem? This ...
Ichwan Sholihin's user avatar
0 votes
0 answers
15 views

ProcessRunner unable to run process upsert java.lang.NullPointerException

I have some problems with automate process with dataloader CLI. When doing the upsert process there is an error after mapping fields, but I don't know which part contains NullPointerExecption, has ...
Ichwan Sholihin's user avatar
2 votes
1 answer
123 views

Data Loader - Unable to Proceed beyond Edit Your Query

I'm trying to export data using Data Loader but I keep running into the same issue. This seems to be happening regardless of which object I'm trying to export data for - no matter what I select, I'm ...
Charles Burns's user avatar
-1 votes
1 answer
50 views

Too many query rows: 50001 in Production

We are getting Too many query rows: 50001 error in production during a data load activity of an Sobject. we have an active trigger on this Sobject. But we have only 14K records for this object in ...
Raham's user avatar
  • 43
-1 votes
1 answer
67 views

Why is an object I can edit in the front end not available in data loader?

In this case the object in question is the service cloud standard object VoiceCall. As the title says, I can edit records individually in the front end, but am not able to update them programmatically ...
Sunlight's user avatar
0 votes
0 answers
60 views

Why can I create a ContentDocumentLink via Apex but not via DataLoader?

I am trying to copy data from one org to a sandbox via a backup tool and SF Data loader. Most things worked fine, but ContentDocumentLinks are missing. I tried loading them via Salesforce Data Loader, ...
Andreas Tschritter's user avatar
0 votes
0 answers
139 views

Data Loader v58.x

Using Upsert to load data with the bulk options enabled, I discover that data for mapped fields are not uploading into the Salesforce environment. I've discovered this in the 58.x versions. This wasn'...
Landau 's user avatar
-1 votes
3 answers
374 views

How to retrieve the object data from Custom metadata types

I am trying to retrieve the records from custom metadata types objects but in data loader it is not showing up
venkatesh A's user avatar
0 votes
1 answer
435 views

Why Data Loader is not recommended to be used for uploading Knowledge Base Articles in Salesforce?

While being working with Salesforce since 2013, I have never digged much into Service Cloud functionality. Now I have a task to migrate 4000 KB Articles into Salesforce KB and I wonder if I can ...
Patlatus's user avatar
  • 17.2k
0 votes
1 answer
52 views

Potential solutions for syncing an org with Person Accounts enabled with another with Person Accounts disabled

I am setting up a new org with the Requirement that Person Accounts are Disabled. Ideally, I would like when an Account gets created/edited in the new org, an Account gets created/edited accordingly ...
Someone's user avatar
0 votes
1 answer
112 views

Unable to upsert customer data via Data Loader [Failed to parse date: 29/02/YYYY]

new to SF here. I have done a data upsert to update customer profile. This profile upsert have been done for many times (weekly basis) without problem. But this time the problem occur with customer ...
Kevin Aaron's user avatar
-1 votes
1 answer
190 views

How to convert contacts under an organisation to person accounts

I am currently working for an organisation which has put a bunch of clients under an organisation called 'individual', I am currently trying to convert these contacts to person accounts but unsure as ...
yazii230's user avatar
1 vote
1 answer
892 views

What is the best way to preserve Account Team Members on Bulk Owner Changes on Account?

Users can preserve Account Team Members while changing records from the UI. However, during mass owner change via Dataloader on the Account Object, there is no option to keep the Account Team Members. ...
Mehedi's user avatar
  • 419
0 votes
1 answer
149 views

Does Salesforce Dataloader affect Daily Async Apex Executions Limits?

Just curious, does Salesforce dataloader affect the governor limit called Daily Async Apex Execution? Dataloader settings: Bulk API off
malacdon's user avatar
  • 321
0 votes
1 answer
89 views

Lead Import is creating blank records

Another Admin is mass importing Leads via Dataloader. The load is working correctly, and all the records are created as expected. But for some reason, it also seems to be creating "phantom" ...
Dan Watkoski's user avatar
-1 votes
2 answers
134 views

Allow mass import of Accounts and Contacts only using Data Loader

I have created a Permission Set and added the "API Enabled" permission, and 'Import Leads' permission. Is there a way to allow the user with this permission set to only do mass import of ...
GroundToCloud's user avatar
-1 votes
1 answer
258 views

How to Bulk Insert Related Records?

I have a request from a client to add Multiple Contact related records to an Account. I have a CSV with Account Records IDs and Contact Records IDs. But I'm unsure on how to bulk insert related ...
Toime L's user avatar
-1 votes
1 answer
520 views

How to load more than 255 chars data in Text Area as seperate line

How to load more than 255 chars data in Text Area as seperate line when pushing data from Mule soft is there any line break can we add
Somesh's user avatar
  • 1
3 votes
7 answers
17k views

Data loader CSV Error: Can't read from CSV file

I am attempting to load using Dataloader and I am running into a "CSV Error: Can't Read from CSV file" on every attempt. Originally I successfully loaded some data without any error but now ...
user132532's user avatar
1 vote
0 answers
187 views

SFDMU - Setting two lookups to same record - odd behavior

I am using SFDMU to upsert an object that has two lookups to the same object - Zip__c. I'm seeing really curious behavior. I run the process once - and it only populates one of the two Zip lookups. ...
chris markiewicz's user avatar
1 vote
1 answer
625 views

Issues with using Data Loader for rich text field

I am using Data Loader in command line format. I am updating a record of type Knowledge__kav, in which we have a custom rich text field called Body__c. As per documentation, I have fortmatted it as ...
hamayoun's user avatar
  • 2,777
1 vote
3 answers
1k views

Help with Data Load to Multiple object using the CSV

We currently have four custom objects in the system and there are linked. We need to do a data import and data is in the CSV like below From the csv, I need to create the Card first and then Section ...
user4912134's user avatar
1 vote
1 answer
2k views

install.bat file not working for dataloader version 57.0.0 spring'23 windows

I tried to install the data loader for my windows 10 (64 bit) system but the install.bat file not working. I have installed the zulu11.62.17-ca-jdk11.0.18-win_x64 and even i have setup the java home ...
ajmal khan's user avatar
0 votes
1 answer
191 views

Uploading multiple records to a related tab for a specific ID

everyone! I've recently started working on a project and there's an issue where I'm stuck and need help with. Scenario: I've an excel sheet where there hundreds of types of House Numbers. For every ...
The Burgeoning Developer's user avatar
0 votes
1 answer
2k views

SOQL Query for to fetch Content Version documents of Parent to do data update activity?

We have a requirement where when we close the work order, we have to set custom field value "Allow Archieving" to true on it's content versions documents. For this, I have already written a ...
SFDCDJ's user avatar
  • 1,904
1 vote
1 answer
2k views

Import Files and Attachments to the ContentVersion object using CSV file and Dataloader

I am working on migrating files from an old SF org to a new one. I have done a data export on the required files and documents using the native Data Export tool in the Setup. That gave me the ...
Wesley Klein's user avatar
0 votes
1 answer
77 views

Monitor Data Loader Exports [closed]

We have few users with Data loader access. I would like to track their activity especially how do I monitor their exports please ?
Preethi's user avatar
  • 17
0 votes
1 answer
81 views

Extracting Salesforce Data Using the Data Loader Command Line

i want to create encryption key and encrypted password to import data into salesforce using data loader CLI, But it is giving me error, you can see in the image that i've uploaded. Please help me with ...
Abhishek Tomar's user avatar
1 vote
0 answers
219 views

an email can't have more than 1 sender on EmailMessageRelation object

I am trying to import EmailMessage from one org to another. I am following instructions on this page here https://help.salesforce.com/s/articleView?id=000380515&type=1 I am on step C1 and where I ...
Hulk Buster's user avatar
0 votes
1 answer
756 views

Data loader opens and closes on mac

Installed data loader on Mac with Big Sur (older than 2021 so rosetta no supported) Installed the Azul as well. It opens and then quickly closes again. Have deleted and reinstalled again - no luck. ...
Lauren's user avatar
  • 11
0 votes
1 answer
1k views

Data Loader won't open (Windows 11 pro)

I have installed Zulu v18.0.2.1, even have set the JAVA HOME. and also installed Data Loader v55 I open Data Loader using the shortcut created during installation. After few seconds command prompt ...
Prince Sharma's user avatar
-1 votes
1 answer
674 views

Uploaded a PDF but not visible on Salesforce

I uploaded a PDF to the ContentVersion object using dataloader. It uploaded successfully but when I click on it within SF it doesnt show anything. However if I download it I can see it. Any reason why ...
Hulk Buster's user avatar
0 votes
0 answers
1k views

Why is Salesforce inspector faster than data loader or workbench?

I have a use case where I need to delete a few million duplicates from my org. I have explored the following 3 tools to achieve this. Salesforce Inspector, Data Loader and Workbench. The performance ...
Nikhil's user avatar
  • 1
2 votes
2 answers
4k views

Dataloader v55 quickly flashes open and closes

I downloaded the latest version of dataloader, version 55.0.1, and installed the latest version of the JDK: openjdk 18.0.1 2022-04-19 OpenJDK Runtime Environment Zulu18.30+11-CA (build 18.0.1+10) ...
Dman100's user avatar
  • 2,455
-1 votes
1 answer
915 views

Deleting old content documents in flow

I am trying to delete all work order photos that are older than 2 years. My only caveat is that I want to keep everything that has a work order type of installation so we have something to review when ...
Aaron Bagwell's user avatar
0 votes
0 answers
710 views

Running the Data Loader from the command line

I'm trying to setup a scheduled export with the data loader. I'm trying to follow the instructions provided by Salesforce here but can't get past Step 1. Has anyone had a similar issue trying to ...
MattcG91's user avatar
0 votes
1 answer
311 views

SOQL Query for updating related records

I have two Objects: Opportunity and Bid(custom Object). A bid is having a lookup field to opportunity i.e. an opp. can have multiple bids. I need to update the comment field of Bid records, but the ...
Nikhil Singhal's user avatar
0 votes
1 answer
690 views

How to extract Field History for a Custom Object

In dataloader, there's no CustomObject__History object when clicking "Show All Objects". Can FH for a custom object be extracted somehow? My object is on the detail side of an MD ...
Al Cher's user avatar
  • 259
-1 votes
2 answers
194 views

how I will get all the record from QA to a fresh sandbox? [closed]

I want to get all the records in a fresh sandbox from QA. please guide me thanks
Rashid Minhas's user avatar
0 votes
1 answer
1k views

External Id fields not visible in Data Loader UI (they have FLS, aren't read only, can be updated, etc.)

The user is in the System Administrator profile. The fields have FLS (as shown below), which was granted years ago--there is no issue with setting it after logging in. The fields are not read only and ...
SFD's user avatar
  • 35
0 votes
0 answers
1k views

Data Loader: csv file with records without ID, instead with External ID

I used the upsert function in Data Loader, but it created new records, not updated records. How can I update these records using an External ID instead of a Salesforce ID? On the Lead object I have a ...
Vasyl Opyruk's user avatar
0 votes
0 answers
1k views

How can one authenticate Dataloader CLI when instance has MFA enabled?

Since moving my data export script out of my company's sandbox and into prod, I've been having a hard time getting Dataloader to authenticate, and I suspect this may be due to the Salesforce ...
Lauren Oldja's user avatar
1 vote
1 answer
1k views

Export and Import Macro & MacroInstructions

Can anyone please share how to export Macro & It's instructions together and import them in another org? I'm using Salesforce dataloader tool.
Saz's user avatar
  • 11
0 votes
1 answer
409 views

SFDMU - Deleting 30 Millions records

I deleted 30M records with SFDMU. The only issue I faced was that I have to update the Json file for every 900,000 records and re-trigger the job using sfdx sfdmu:run --targetusername Production. By ...
Sandra Zuluaga's user avatar
1 vote
1 answer
2k views

Error using inline dataloader: WARNING: sun.reflect.Reflection.getCallerClass is not supported

I'm trying to use the line loader and I'm getting this error data: I really have no idea why I'm getting this, I'll be adding my mapping: I will also leave the csv for the upsert: And the process-...
Souza's user avatar
  • 305
0 votes
1 answer
12k views

'process.bat' is not recognized as an internal command

I'm following the following tutorial to try to use the inline dataloader, and now in the last step I'm getting this error: C:\Users\ThaisCarolyne>process.bat "C:\Users\ThaisCarolyne\dataloader\...
Souza's user avatar
  • 305
0 votes
1 answer
769 views

RecordTypeId not getting uploaded from csv file to Salesforce org using SFDMU tool. Error: Value does not exist or does not match filter criteria

I am using SFDMU tool (Salesforce Data Loader SFDX Plugin) to upload csv data files to a target salesforce org. I have 3 records A, B and C in an object in a hierarchy. Record B is in a self-lookup ...
Ritika_salesforce's user avatar
-1 votes
1 answer
121 views

Get records modified by SF Data Loader App (or get history of jobs on it)

I did some bulk upserts using csvs and SF Data Loader. However, my formatting was off for my external Id and "duplicate" records were created instead. Is there a simple option to revert jobs ...
user2402616's user avatar

1
2 3 4 5
18