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
0 votes
0 answers
52 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 ...
  • 1
0 votes
0 answers
23 views

Mapping Problem

Hello I am supporting Data Loader user and I can't figure out why mapping is not working. When I am trying to click "Next >", nothing happens. Could you please help me on this? Thank you ...
2 votes
2 answers
383 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) ...
  • 2,353
-1 votes
1 answer
34 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 ...
0 votes
0 answers
114 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 ...
0 votes
1 answer
64 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 ...
0 votes
0 answers
28 views

External ID not found Jitterbit upsert

I have a project in jitterbit which upserts data into three objects; Lead, Project_c, and ProjectLead_c The Lead and Project objects are working just fine but I cannot get the upsert to run for the ...
0 votes
1 answer
76 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 ...
  • 201
0 votes
0 answers
19 views

How to migrate data from one namespace managed package to another within same org?

We have one managed package app with namespace xx__ installed on different organizations, but for improvement, we are creating a new managed package app with a new namespace yy__. Now we want to ...
-1 votes
2 answers
58 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
0 votes
1 answer
177 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 ...
  • 23
1 vote
0 answers
157 views

Data Loader Upsert Error : MISSING_ARGUMENT:External_ID__c not specified

I tried to make upsert method in data loader, when External Id is null i expected it will running method insert, when external id is not null it will running method update. Everythings work fine in ...
0 votes
0 answers
354 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 ...
0 votes
0 answers
37 views

Is there a way to export the DataLoader ProcessConf.xml instead of running the job?

I'm trying to script my organization's migration to Salesforce. I've had no success using the APIs to upload attachments so I figured I would try the DataLoader command line. Setting up the ...
0 votes
0 answers
237 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 ...
0 votes
1 answer
330 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.
  • 1
0 votes
0 answers
159 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 ...
0 votes
1 answer
922 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-...
  • 265
0 votes
1 answer
434 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\...
  • 265
0 votes
0 answers
134 views

Salesforce Data Loader 53 Command line - issue loading data to SQL Server

I am trying to move from Data Loader 37 to 53 to address the log4j vulnerability. The process runs via the Command Line interface for DL and it extracts from sfdc and ultimately loads to SQL Server DB....
0 votes
1 answer
267 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 ...
-1 votes
1 answer
19 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 ...
0 votes
0 answers
38 views

Avoid Creating Topics during FeedItem Migration

I'm uploading FeedItems to Salesforce from external system, but I'm facing the "Maximum topic per record limit reached." error when FeedItem body has #hashtags in it. I believe it's because ...
  • 759
-2 votes
1 answer
70 views

Dataloader Insert Problem

I'm trying to insert an Excel data in my org via Dataloader. But, when i try to use INSERT with the .csv file, i can't find the 'State__r:State__c:Code__c' in the mapping field. Error> State: id ...
1 vote
0 answers
60 views

How do I edit Tags (Topics) for many contacts at once?

How do I edit Tags (Topics) for many contacts at once? We use Topics (which we renamed to "tags") to keep track of the events where we met our contacts and leads. Say I add 100 new leads to ...
1 vote
1 answer
598 views

Python Simple-Salesforce - Import related records with an external ID

Some time ago I've started to use Python with Pandas and Simple-Salesforce to make data migration to Salesforce orgs. I want to insert Account records and Contact records that have lookup to Account ...
  • 121
1 vote
1 answer
66 views

Data deletion with Attachments using Dataloader

what should be the best practice to delete records and it's related attachments using Dataloader. As I understand, attachments are not getting deleted when you delete the parent record. Any ...
0 votes
1 answer
46 views

Updating existing records in a Salesforce Object after creating a new validation rule or trigger or Workflow Rule

Do I need to delete and insert all the existing records again into the Salesforce object via a Dataloader, after creating a new Trigger or a new Validation Rule or a new Workflow Rule to clean the bad ...
  • 55
0 votes
2 answers
755 views

Escaping quotes in csv for Data Loader

I have a text field that can consist of a csv i.e. foo, bar, fizz, buzz. Using Data Loader, I had an issue where the csv would then think foo, bar, fizz, buzz was being split up into separate columns ...
1 vote
0 answers
45 views

Dataloader upload is changing the content

I am trying to insert data into custom object using dataloader tool. But string is getting modified post insert. Expected string: Paiement rejeté Converted string: Paiement rejeté On the other hand, ...
0 votes
0 answers
134 views

Correct way to insert new records to custom lookup field - dataloader

I am inserting new records into an object using the Salesforce dataloader. I have a field in my object that is a lookup field to another object and I am confused as to what is the correct way to ...
1 vote
1 answer
171 views

Is there a way to upload/insert a particular custom object record and its related file document from one single csv file using data loader?

Hi it would be great if anyone could help me out with this. I have encountered a requirement in salesforce where I have to upload/insert a custom object record and its related file attachment into ...
0 votes
0 answers
41 views

How to package Salesforce data (not metadata)

This question is NOT about Custom Metadata Types where records can be indeed be put into Packages. It's about packaging real data. Records of Custom or Standard objects. Just assume you want to have ...
2 votes
1 answer
159 views

Bulk Load Data Jobs hanging in Queue

I am working with the bulk load API v52. I have successfully created a job and uploaded a single record CSV to test via rest. I login to the console and I see the job in progress in the monitor bulk ...
  • 21
2 votes
2 answers
3k views

Data Loader - Bulk Update Failure

I'm trying to do a bulk update of 141 records on a custom object (A2D) using Data Loader. In this bulk update, I have mapped the id field and about 8 boolean fields. When the update is attempted, I ...
0 votes
1 answer
339 views

data upload error: id value of incorrect type

A member of our support team gave me a list of 100 Account ID's and their associated 'Customer Success Manager' in text form. I was asked to upload this data to salesforce, using Data Loader. I asked ...
  • 93
0 votes
1 answer
189 views

Assigning Tasks to a Queue with DataLoader

I am looking to upload several thousand tasks to my org with DataLoader assigned to a shared Queue. I am assigning the OwnerID as the 18 digit Queue ID in my csv file. However, upon attempting to ...
0 votes
0 answers
149 views

Facing issues in bulk update via data loader

I am trying to update the records in campaign member via data loader. It keeps throwing me this error INSUFFICIENT_ACCESS_OR_READONLY: insufficient access rights on object id Like this I have 1 lakh ...
0 votes
2 answers
139 views

Migrate Quote with Quote Number from one Salesforce Org to another

I'm migrating Quote record of one salesforce instance to another Salesforce instance. The Quote number in source org is in Q-{MM}{YY}-{0000} format. I have changed the quote format in my target ...
0 votes
1 answer
1k views

How to export import JSON data for objects with record types using sfdx command [duplicate]

I wanted to export the objects data with record types from one scratch org to another scratch org. I tried with this command: > sfdx force:data:tree:export -q c:/soql/cObject.soql -u SourceOrg -p -...
  • 263
0 votes
1 answer
77 views

How to import two values that are in the same excel field separated by a comma

I just got an .csv file that i need to import into my sandbox as a custom object, it looks like this: The value that is on the left side of the comma should be stored as a field (called Location). ...
0 votes
1 answer
137 views

How to query Salesforce using multiple emails from a csv file?

I'm trying to export data from Salesforce but only those that match the emails I have in a csv file. I'm thinking of using Dataloader but I don't know exactly how to do that. I checked the Developer ...
0 votes
2 answers
344 views

How to import Note(Note) for existing contacts

I have many contacts, need to connect existing notes from .csv file. To import the note will I need to use the Note(Note) object or Note(ContentNote)? I need help to import notes from CSV file for ...
  • 159
1 vote
3 answers
4k views

Unable to Install Salesforce Data Loader v52 in Mac BigSur 11.4

Getting Error while starting 'install.command' in my Mac BigSur 11.4: “install.command” cannot be opened because it is from an unidentified developer. macOS cannot verify that this app is free from ...
0 votes
1 answer
458 views

salesforce Dataloader : field 'Description' can not be filtered in a query call

I am using dataloader to look for and extract certain emails(tasks) that must have the word "igloo" in them, I tried to do 'description' contains "igloo" and got an error saying ...
0 votes
1 answer
358 views

Import Opportunities using Data Loader in NPSP [closed]

I need to import opportunity data to NPSP cloud. Contact lookup to Account. And Opportunities lookup to both Account and Contact. I first imported Contact data using data loader. And then imported ...
  • 37
0 votes
2 answers
1k views

issues installing and running Dataloader on my MacOS Big Sur

please I am having issues installing and running Dataloader on my MacOS Big Sur. I have downloaded and installed Zulu. I have also downloaded and installed Dataloader but when I run it, I get the ...
  • 3
1 vote
1 answer
691 views

Handling special character in apex

I have one import object which stores the record from data loader then I run my apex class which pick the record from import object and assign data to the respective fields in new object. When I try ...
1 vote
1 answer
482 views

Is there a Salesforce data-loading/ETL tool that uses Bulk API V2.0? [closed]

Is there a data-loading/ETL tool that uses Salesforce's Bulk API v2.0? I see that both Data Loader and dataloader.io, in Bulk mode, still only use Bulk API v1.0. And please do NOT say "Workbench&...
0 votes
0 answers
118 views

RecordType changes when importing via REST API

I have this strange problem where if I import a Lead via REST API, the recordtype is changed from the one I specified in my JSON payload to a different one (and oddly, not even the default recordtype ...
  • 154

1
2 3 4 5
17