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.
839
questions
0
votes
0
answers
10
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
0
answers
34
views
Standard object is not visible while performing upsert operation operation through Data loader
I am trying to run a upsert operation using data loader for standard Object (Asset) with read and edit permission (specific profile) but its not available to select.
Other users with the same profile (...
- 1
-1
votes
2
answers
34
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
26
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 ...
- 1
1
vote
0
answers
29
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 ...
- 235
0
votes
0
answers
47
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
13
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
62
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
71
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
83
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
204
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-...
- 1
0
votes
1
answer
83
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\...
- 1
0
votes
0
answers
66
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
143
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
14
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
18
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 ...
- 749
-2
votes
1
answer
51
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
24
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
291
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
32
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 ...
- 785
0
votes
1
answer
39
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
329
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
29
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
32
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
61
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
30
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 ...
- 34.3k
0
votes
0
answers
24
views
How to properly rename Attachment names before or after export with Dataloader/Dataloader.io?
Hello everyone and thanks for reading!
I have a request to export all the Opportunity Attachments that meet certain conditions. These Attachments are .PDF files.
I could do that using Dataloader.io ...
0
votes
0
answers
20
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 ...
- 1
1
vote
2
answers
1k
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 ...
- 306
0
votes
1
answer
142
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 ...
- 79
0
votes
1
answer
112
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
45
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
83
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 ...
- 2,994
0
votes
1
answer
712
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 -...
- 235
0
votes
1
answer
46
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
42
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
109
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
2k
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 ...
- 741
0
votes
1
answer
235
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 ...
- 13
0
votes
0
answers
48
views
I am getting the wrong Id in a Lookup Field by the record page, but the correct value by SOQL. What could be happening?
I recently updated a field called "Account Name" by Dataloader. It is a lookup field to Account. For specifics records, If I enter in the page view (like in the Image), I will get the Old ...
- 123
0
votes
1
answer
233
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 ...
- 35
0
votes
2
answers
859
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
477
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
307
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
67
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 ...
- 143
0
votes
1
answer
210
views
data loader import - no value for mandatory fields
I need a little help with a data loader import. I have a .csv with account records and some of the fields need to have a value, they're required. I need to know how can I import the file because there ...
0
votes
0
answers
27
views
How to import Files from folders and subfolders with only External id?
I need to migrate Files from legacy system to Salesforce.
The data is structure in folders with foldername External id. Inside those folder theres different pictures in different folders.
The number ...
0
votes
0
answers
800
views
Data Loader Permission Sets
I need to create a permission set for a member of staff to use dataloader. I created the permission set with license set to none so that I can assign to users with different rights.
I then assigned ...
- 1
0
votes
1
answer
498
views
What is the dataloader limit in 24 hour.?
How many records I can data-load in a single attempt. ?
How many such data-load I can perform in 24 hours.?
I have gone through the documentation, but not sure ( 5 Million ) documentation is talking ...
- 15
0
votes
1
answer
36
views
Can I change the status files format?
I would like to ask if there is an option to change the format (delimiter) of the success/error log files of each Dataloader operation?
I could not find anything in the documentation, neither on the ...
