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.
828
questions
0
votes
0answers
35 views
120 Records inserted via data loader but only 15 records are in org
I inserted 120 records via Data loader and i got success message for every record that those are inserted. But when I extracted with created Id's I got only 15 records, remaining 105 aren't there. And ...
1
vote
0answers
23 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
0answers
14 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
1answer
37 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
0answers
27 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 ...
0
votes
0answers
17 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
0answers
17 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 ...
0
votes
2answers
88 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
1answer
29 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 ...
0
votes
1answer
31 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
0answers
21 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
1answer
35 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
1answer
93 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 -...
0
votes
1answer
25 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
1answer
18 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
2answers
17 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 ...
1
vote
1answer
268 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
1answer
29 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
0answers
32 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 ...
0
votes
1answer
68 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 ...
0
votes
2answers
372 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 ...
1
vote
1answer
81 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
0answers
97 views
Is there a Salesforce data-loading/ETL tool that uses Bulk API V2.0?
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
0answers
32 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 ...
0
votes
1answer
66 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
0answers
12 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
0answers
180 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 ...
0
votes
1answer
181 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 ...
0
votes
1answer
35 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 ...
0
votes
1answer
42 views
export actual documents from document tab not from files, attachments object
I have three documents(like image, pdf, word etc) in my documents tab(Please note: not on attachments, files object) and I need to export all the three to my local.
But when I tried to get that ...
0
votes
1answer
152 views
Uploading file with 45MB size using data loader keep failing
I'm trying to upload files to Salesforce using data loader and the file size is around 45MB every time I'm trying to upload the file I got error with maximum retries reached, any idea how to deploy ...
0
votes
1answer
23 views
Retrieving Record ID for each Opportunity in a list
I need to retrieve the record ID of all opportunities in a single csv list, and I am wondering if there is a way to do this either with python or Salesforce natively.
Essentially I would need to loop ...
0
votes
1answer
29 views
Inserting 13k PDF Attachments each 192kb in Attachments object
I want to insert 13k PDF attachments in Salesforce. Each of the PDF is 192 kb. I have created a csv file with the name of the pdf and it's relative path on the local drive.
I tested inserting 15 ...
0
votes
1answer
41 views
Update created date from Data Loader or DBAmp [duplicate]
I'm migrating data over from another CRM.
The person who did it didn't populate the correct Created Dates for our contacts, so another field was created that does have the correct created date.
Am I ...
0
votes
1answer
16 views
can we insert a date value when the Closing date on opportunity is Null using a before trigger?
we are using dataloader to upsert records into Opportunity object but there might a case where there is no Closing date for some records, in that case, can we insert a particular date value using ...
0
votes
0answers
24 views
Data Importing into SF using built in auto-processes
I am currently going through the process of importing data into Salesforce using XL-Connector (and hence the SF bulk API). This is a lengthly process given the amound of data we have and the number of ...
1
vote
1answer
331 views
Ability to set CompletedDateTime on Task object while loading tasks from data loader
We are trying to load tasks using data loader, where curtains tasks need to be loaded in 'Completed' status, we have observed if a tasks get's loaded with 'Completed' date the System is automatically ...
1
vote
1answer
46 views
Invalid Field Mapping in DataLoader
DataLoader is not loading the column correctly.
I'm trying to update Task...But I get the error "Id not specified in an update call"
What i have to do in this case?
0
votes
1answer
84 views
Which tool to use for updating 10,000 records in salesforce in single transaction
I have a set up where an external integration will bring 10,000 records at a time into my salesforce org (update transaction, not insert). I need to test if my triggers, S2S connection (which updates ...
0
votes
1answer
27 views
Create multiple custom permissions
I have a requirement to create multiple(around 100) custom permissions. Can this be done using data loader or workbench? In data loader when we select insert option I don't see custom permissions ...
0
votes
1answer
25 views
Changing NULL to empty
Migrating from a SQL based system and using dataloader.io. The NULL values appear to have come over as "NULL" and when I try to create a duplicate rule it is saying there are too many ...
0
votes
0answers
30 views
Transaction Security Policy - Stop connectors(Data loader, Excel connectors, workbench, etc.. ) to do DML in salesforce
I got a requirement where I need to stop my users to perform the update, insert, and upset from any connector(Excel connector, workbench, data loader, etc..) even if they have access in the profile.
I ...
0
votes
2answers
67 views
Migrating Notes Into Salesforce
I am trying to migrate notes from another CRM into Salesforce. Based on the salesforce documentation (link below) it seems to imply I need to have my notes in text file format to import them into the ...
0
votes
1answer
93 views
Data Migration - How to set Opportunity Closed Date in Past?
I am doing a data migration from another CRM to Salesforce. Some of the opportunities in the legacy system have a closed date in the past. When I try to migrate those into salesforce, I get an error ...
1
vote
1answer
80 views
System.SObjectException: ORA-20001 when deploying Changeset for users
I'm deploying an apex class and Test class which is running successfully and covering 84% test coverage in sandbox however when deploying it in Prod, I'm running in to below issue. I have included ...
0
votes
1answer
59 views
Pattern to integrate million record if BULK option not available
This is in reference to Integration with a System having millions of records.
However, due to certain limitation we do not want BULK API needs to be implemented . Although there are other options like ...
0
votes
1answer
517 views
Exporting attachments with Apex Data Loader
I am trying to export attachments from Salesforce using Apex Data Loader. I am using the below query in Apex Data Loader.
Select Id, Name, ParentId, ContentType, BodyLength, Description from ...
1
vote
2answers
537 views
Dataloader Update Error - Account ID: id value of incorrect type: 001XXXXXXXXXXXXXXX
TL;DR: Trying to bulk update one field in Account but being told Id is of incorrect type. Have checked and am positive it is of the correct type.
I am trying to perform an Account bulk update with ...
1
vote
1answer
22 views
Import new contacts and campaign members together
I have a CSV file that includes contact's first name, last name, and email address. The file also includes campaign names. These contacts do not exist in the Salesforce. Is it possible to add these ...
1
vote
1answer
60 views
Is it possible to edit the Audit fields on UPDATE?
I found a question that was asked 7 years ago but they are only mentioning that Audit fields can be change on Create/Insert...
What about when fields are already created and needs to update the ...
