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
12 views

Command Line DataLoader in Salesforce unsupported option -g [duplicate]

I am trying to set up Command line Data loader by following steps here (https://www.jitendrazaa.com/blog/salesforce/tutorial-of-command-line-dataloader-salesforce/) I am getting an error(see screen ...
0
votes
1answer
30 views

Importing 40k PDF as attchments

I have 40k PDF's in windows shared drive. Each pdf should be attached to parent account. The name of each pdf is an external ID in salesforce. e.g AA123.pdf corresponds to AccountRecordId '...
0
votes
0answers
13 views

Schedule weekly import of documents from external location

I want to schedule a weekly batch import of documents from an external drive into Salesforce. Say, in the external drive there is a folder called 'CompetitorScore' and in that folder there are 50 ...
1
vote
1answer
26 views

Exporting Contacts from a list of Accounts

We have a list of 10000 Accounts in CSV format that we are updating through Data Loader. We also want to update all the related Contacts. What would be the best way to do this? The last time i did ...
0
votes
0answers
35 views

Unable to run SalesForce DataLoader from CMD - Receiving errors - Incorrect directory

trying to run dataloader from CMD. Running CMD as Admin and it looks like process.bat is looking in the incorrect directory. C:\Users\<me>\Desktop\dataloader\process-conf.xml\process-conf.xml ...
0
votes
1answer
19 views

Dataloader Command line error

I need to be able to run Data Loader from the command line (we need a scheduled import/export of data once per day). I created the conf file but get the error message below when I run the proccess.bat ...
0
votes
1answer
16 views

Is there a way to default the Export CSV file origin of dataloader to UTF-8?

I export Salesforce data out to CSV on a frequent basis especially in a foreign language like Mandarin. Even if I check the UTF-8 options on Dataloader settings : The file that gets exported out ...
0
votes
0answers
21 views

Java type in database-conf.xml for Decimal values

What is the correct Java type (or correct implementation strategy) to map numeric (Decimal) fields from Salesforce to a PostgreSQL database, when running extract jobs via Data Loader command line? ...
1
vote
1answer
42 views

Queueable call not executing in case of partial success using Database.update

I have written logic that enqueues queueable class from trigger of one object. This works perfectly when I update records and all records gets updated successfully,but in case of partial success I can ...
0
votes
1answer
42 views

Get dynamic file name in CLI dataloader (import)

How to get dynamic file name with name example "NameFileFormatYYYYMMDD.csv"? My code looks like this <bean id="accountInsert" class="com.salesforce.dataloader.process.ProcessRunner" ...
1
vote
2answers
33 views

DataLoader - Download Link missing - Deprecated?

Background Today, I tried to download Dataloader from "Setup > Data Management > Data Loader". It seems like Dataloader is gone. This raises several questions: Question Is Dataloader deprecated? ...
0
votes
0answers
14 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
30 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
79 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
20 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
48 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
30 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
48 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
95 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
43 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
63 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
25 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
25 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
32 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
35 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
42 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
12 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
49 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
21 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
16 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
192 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
2answers
50 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
30 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
59 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
139 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
927 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
180 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
107 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
38 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
141 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
20 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
141 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
24 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
162 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
42 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
281 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 ...