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
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 ...
user avatar
-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 (...
user avatar
  • 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
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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.
user avatar
  • 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 ...
user avatar
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-...
user avatar
  • 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\...
user avatar
  • 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....
user avatar
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 ...
user avatar
-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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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, ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 -...
user avatar
  • 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). ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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&...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar

1
2 3 4 5
17