Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now

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
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 ...