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.
843
questions
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 ...
- 1
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 ...
- 101
-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 ...
- 341
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 ...
- 11
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 ...
- 111
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....
- 1
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 ...
- 137
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 ...
- 765
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 ...
- 137
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 ...
- 127
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 ...
- 35.2k
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 ...
- 336
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 ...
- 35
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 ...
- 3,074
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 ...
- 25
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 ...
- 740
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 ...
- 11
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&...
- 107
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