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.
710
questions
0
votes
0answers
10 views
Protect secrets in database-conf.xml
How can I protect the secrets in my database-conf.xml file when running Data Loader from the command line?
Below is an example BasicDataSource bean that exposes the URL, username and password.
<...
0
votes
0answers
14 views
Exceeded max length for one record data loader
How can I spot which record exceeds the limit shown by data loader when I try to insert the CSV in my 'to' salesforce environement?
The same files export fine in my 'from' environment.
I have tried ...
0
votes
0answers
22 views
The system cannot find the path specified Data loader CLI
I'm getting The system cannot find the path specified. error when I'm trying to create an encryption key file by running below command in cmd:
encrypt.bat -k keyfile "C:\Users\sfdc\Desktop\CLI Data ...
0
votes
0answers
18 views
Salesforce Data Loader Error while uploading CampaignMember
I am uploading CampaignMembers into Salesforce using Salesforce Data Loader. I am getting one strange error which says that "Already a Campaign Member."
I verified that Contact is not a member of the ...
0
votes
1answer
34 views
Data Loader error- (ID: value not of required type: 425.0.)
I'm trying to import a file with Data Loader into a Standard object and I get the errors as follow:
ID: value not of required type: 425.0.
The Data Type is TEXT in salesforce.
In the CSV import ...
0
votes
0answers
24 views
Can I export attachments using Command Line Dataloader and use ANT to get it to FTP site/Google drive
Background:
I want to run an after update opportunity trigger that would fetch all the opportunity records as well as attachments and then transfer it to a third party-website. In order to do that, I ...
1
vote
1answer
43 views
How to add Salesforce Id field for records that I am trying to update?
I am trying to update and insert (upsert) a bunch of records into Salesforce. The records are in a json file on my hard-drive. The records are inserted but if they already exist, they need me to ...
2
votes
1answer
35 views
Created by field is not showing in Data loader
I am uploading case through dataloader . But while mapping the fields from CSV to salesforce fields "Created by" field is not showing on the time of mapping from data loader on the time of Insert the ...
0
votes
0answers
23 views
Field Mapping is invalid Salesforce Data Loader
I am trying to upload Events in Salesforce. I have mapped AssignedTo(OwnerID) field in mapping file but when i click next, it says "Field Mapping is invalid Owner>Owner.external_id__c". I have also ...
0
votes
1answer
39 views
Notes. Mass Upload. Hitting some limit and getting “Note can't be saved”
I'm doing data migration and need to upload ~500k Notes. 192k Notes were uploaded and now I'm getting Note can't be saved error via API and Note contains characters that can't be saved when trying to ...
0
votes
1answer
22 views
Transferring activities associate with accounts to lead
1) On changing the "whoId" of the activities for the conversion of activities associated with the account to lead should we also change the "whoId" field of open activity and activity history too?
2) ...
0
votes
0answers
15 views
Dataloader cli setup and java installation error
I am trying to replace dataloader default directory to program files. While running install.bat for dataloader it is being installed to "C:\Users\somename" by default. How can I change this directory ...
0
votes
0answers
7 views
Data Loader Command Line Not Processing Entire File
I have scheduled tasks that run data loader from the command line for a simple integration and it has been working fine for several large files. Recently I have noticed that occasionally some of the ...
0
votes
0answers
29 views
What is file type of Bulk Data Load Jobs results-file while importing data through Data import Wizard?
New to Salesforce.I imported a certain .csv file into Salesforce through Data Import Wizard, when I clicked on data batch reports, a file named 'reports' was downloaded. But not sure or clue what type ...
1
vote
1answer
25 views
Transactional Security for Data Loader - tracking exported records
I have a Transactional Policy Setup for Data Export via Data Loader whihc is triggering as expected. Is there a way to determine what entity (records) were downloaded.
-1
votes
1answer
29 views
Salesforce Data Loader OAuth not taking another email address
I am trying to log in to a production environment in Data Loader through OAuth and giving a custom domain, then it is taking my personal outlook account and directly giving an error without giving ...
0
votes
0answers
36 views
How to unsquish DataLoader UI
How to fix the squished UI for dataloader. See Image below.
Machine specs: 4k res display, Windows, x64
0
votes
0answers
9 views
Data Loader - Command Line - Extract - Create dummy columns
Does anyone know of a way in the SDL file to create dummy columns? I am trying to make the generated file match up to an existing template but the template has columns that aren't actually fields in ...
0
votes
1answer
32 views
Importing custom objects
I have a problem importing and creating more than one custom object at a time using the data wizard. I have created a csv-file with headers that map correctly and imports fine when there is only one ...
0
votes
0answers
18 views
Content Version limits
i would like to be able to see all the content publications that have run in the last 24 hours. as multiple users make multiple loads (using data loader) into the org, i need not only to check how ...
0
votes
0answers
13 views
import Product lines direct to opportunity
we are still in the implementation phase of sales force and my team role is pre-sales. so basically, we add the product line items to opportunities. the problem is as per our implementer feedback, we ...
1
vote
1answer
79 views
Using External ID field from User in Dataloader to set lookup field (User)
I have created below two fields -
Object: User, Field API: identifier__c, Type: Text(25) (External ID) (Unique Case Insensitive)
Object: Lead, Field API: Lead_Owner__c, Type: Lookup(User)
Sample ...
0
votes
1answer
29 views
How can I cross-check a large csv file of email addresses against Salesforce data?
We use Salesforce Marketing Cloud and have thousands of records that don't appear to be in Salesforce. Hence, I want to delete these records so the two systems are in sync and we can save some money ...
0
votes
1answer
25 views
Why does Data Loader force a record update (last modified) with only the record ID?
I have seen this and I cannot find documentation as to why just updating with the record ID would force a record update as seen in the "Last Modified Date" field. It seem odd that "updating" the ...
0
votes
0answers
12 views
Update the Last Modified data without changing data. Tickling the records thru data loader
I need to fire my WF rules that has criteria ischanged( LastModifiedDate ). I just want to tickle the records using data loader to fire the WF without changing any data.
0
votes
0answers
42 views
Upsert Data with dataLoader using multiple keys
Is there a way to import Data with DataLoader \ Wizard using 2 keys?
For example - I want to import Data (Upsert) when the unique key is actually built from 2 keys :
externalId field and a ...
0
votes
1answer
54 views
ContentDocumentLink Throws an error using ContentVersion Object “ContentDocument ID: id value of incorrect type”
today i'm trying to upload some files to SF using Content objects. I already uploaded the ContentVersion record and the image is in SF now. The problem is when i try to upload the ContentDocumentLink ...
3
votes
5answers
435 views
Best option to export more than 15 millions records from Salesforce?
We have a requirement to export around 15 millions records.
Which option will be better Salesforce DataLoader or Jitterbit Cloud DataLoader or any other better option available.
Can we export ...
8
votes
1answer
166 views
Do SFDX commands count toward limits?
I am looking into utilizing some SFDX commands to possibly use for some data integrations and/or one-time loads. Do these commands count toward the same API call limits as API calls and Bulk API ...
2
votes
1answer
87 views
How do I export activities related to an account with a specific recordtype?
I am looking to export events and tasks from one organisation to another for all account records with a specific recordtype.
Is there a way I can query tasks and events which are related to accounts ...
0
votes
1answer
36 views
Handle Special characters like ° (degree)
We are trying to import data with name "6400L -37° JIC SAE Flare Male x SAE O-Ring Boss ORB Male Adapter Long" but on inserting data we got value in sfdc as � (Special char).
We have enabled UTF-8 ...
0
votes
1answer
71 views
Multiple Data Loaders on one machine
Can I have multiple data loader instances running on the same machine ?
Scenario : I have data loader configured for production, now I want to configure another data loader for sandbox. Is that ...
0
votes
0answers
19 views
Record transfer email notification
I reassigned (transferred) the contact owner for 64,000+ contacts this morning via Data Loader. It appears that it's possible that we had a Marketo smart campaign that was also triggering contact ...
-2
votes
1answer
36 views
Need help on Dataloader [closed]
I'm trying to insert Account and related contacts records in one org to another org.
In Org1 I exported Account and contacts here I'm trying to insert those records into another Org2
here I need ...
0
votes
2answers
94 views
Data import from data loader: maintaining the hierarchy on Account records
I have some accounts where ParentId is null which I want to populate. Here is my csv sample data
So I want the record to be associated with Account1 which has ExternalId__c as "4ab1dc5e-24cc-1405". ...
0
votes
0answers
20 views
How to move Chatter Feed of type 'TrackedChange' from contact to person account
We have recently adopted person account and are trying to move chatter feed from contacts to person accounts.
According to this article: https://help.salesforce.com/articleView?id=000213215&type=...
1
vote
1answer
75 views
How to Mass Update Records Without Changing the Last Modified By Field
I have a custom object that I need to do a mass update on to set a field on each to the same value.
I had written a snippet of code to execute in the Developer Console that would get all the correct ...
0
votes
1answer
40 views
Trigger is only updating one record per batch
I have a trigger that creates an AccountTeamMember object every time there is an update to an Account_Ownership__c object (this is a custom object that we've created in house to act more in line with ...
0
votes
1answer
180 views
CSV header row error when using DataLoader
I am working using DataLoader 45.0.0 to migrate our current SF to FSC. When choosing the CSV file in the "Load Inserts" dialog in DataLoader, I am greeted with the full error "CSV Error: Invalid CSV ...
0
votes
2answers
33 views
How to clear the values in a number data type field while importing data?
I tried using apex data loader and Dataloader.io
So i knew i need to enable Insert Null values option in apex data loader settings but it isn't working for the fields with Number data type. I am ...
1
vote
2answers
628 views
bad value for restricted picklist field (from dataloader)
How to Solve this issue to Import record
SOURCE: 'fsCore__Customer_Name_Format__c' DESTINATION:
'fsCore__Customer_Name_Format__c' ERROR:bad value for restricted
picklist field: Account Only
...
0
votes
2answers
195 views
NullPointerException processing XML configuration for Salesforce Data Loader CLI
Unfortunately I am unable to get Data Loader CLI (v45.0.0 running on Windows) running properly.
This is the command I am using:
process "C:\Users\erik\dataloader\custom" Account
Even when I use a ...
0
votes
2answers
108 views
How to export the Data from the ContentNote Object in the Salesforce Professional Edition
I have exported all the data from the Professional edition Salesforce Org. However I have all the data from the available objects, but the data of the Salesforce Internal object 'ContentNote' is ...
0
votes
1answer
84 views
Body is not present on the Attachment csv file
I have a attachment file which is from a Salesforce Org. Now I need to upload those attachment in different salesforce org. In my attachment file, I can't see the body column, instead I can see ...
0
votes
0answers
57 views
Unexpected error using CLI DataLoader “extract_all: could not instantiate class”
wadCurrently I'm working with CLI Dataloader and the main purpose of the process is to export data from different objects into Oracle Database. Everything works more than fine. BUT we wanted to ...
0
votes
2answers
103 views
could anyone explain, why this error comes “DUPLICATE_VALUE:This price definition already exists in this price”
DUPLICATE_VALUE:This price definition already exists in this price
1
vote
1answer
184 views
Street Address as separate lines
I'm are preparing data to be imported from our current Excel database to Salesforce.
Our organisation stores address of each member/contact in Excel as separate lines rather than a block of address ...
0
votes
1answer
76 views
Updating RecordType Id - importing data
I have exported data from production in .csv file, now I'm trying to import data to sandbox and I'm running into issue where RecordType.Id is not same as in the sandbox.
How should you go after ...
2
votes
3answers
373 views
How to load recordTypes using dataLoader based on their names and Not their Ids?
I am trying to load some (FinServ__ReciprocalRole__c) data using dataLaoder.
This data should be imported to many environments (sandboxes and scratch orgs).
Given that the RecordType ID is not the ...
6
votes
2answers
273 views
Not all records returned in SOQL Query
I have a query that I'm using to export data:
SELECT c.Id, c.SystemModstamp, ...
FROM Contact c
WHERE c.SystemModstamp > start
AND c.SystemModstamp < end
AND c.Id > string
ORDER BY c.Id ASC
...
