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.

learn more… | top users | synonyms

1
vote
0answers
15 views

Error in data loader cliq

I am using data loader from command line but I'm getting one error when I'm trying to verify if my password generated is correct or not Command: encrypt.bat -v generatedPassword secretKey Error: ...
3
votes
1answer
21 views

Best way to automate updating contact emails in sandboxes post refresh?

I'm looking for a way to automate the process of updating emails of all active contacts in sandboxes (mask them with the .dev or .test). Number of records to update after filtering: 900,000 Things ...
0
votes
0answers
16 views

Data Loader, CLI “External_ID__C not specified”

I'm trying to import a CSV over the Data Loaders CLI. When I import manually using the same Account, CSV, and Mapping it works. Error: ERROR [ImportKF] client.PartnerClient processResult ...
0
votes
2answers
24 views

Pulling data from AWS instance in csv to Salesforce [on hold]

Scenario - Files will be kept in .csv format in AWS instance. Requirement - Need to invoke Dataloader from CLI . How do I access the data kept in the remote url and update objects in SFDC through ...
0
votes
0answers
15 views

Given final block not properly padded - Dataloader password verification Error

I am trying to set up Dataloader in CLI Mode . I generated the Encrypted key and Encrypted password. When I am trying to verify that using encrypt.bat -v generatedPassword secretKey [or encrypt.bat ...
3
votes
1answer
32 views

I need to delete 7 million records but Data Loader keeps getting stuck

We found that 7 million Task records were created in our org and we need to delete them. We were recommended to delete all tasks, but there are many we want to preserve. We were able to create a CSV ...
2
votes
2answers
47 views

Establishing Parent-Child Relationship via Process Builder

Here is my use case: A data load of applicant information must be inserted (no updates) into Salesforce. From this applicant information, a Contact record must be created with a specific record type ...
0
votes
1answer
42 views

Mapping Problem with data loader

I'm a beginner in salesforce and i hope this is the right place to ask. I'm currently trying to update using data loader, in the Mapping Step, the column header always become one, ...
1
vote
1answer
28 views

Error when inserting users using Data Loader

I'm trying to insert users pulled from one org to another org using Data Loader. The user CSV file has the Federation Id as column, pulled from the source org. Here is the error for the failed ...
2
votes
0answers
14 views

Scheduling mass delete of pdf Attachments from Account using Data Loader ClI

I was able to upload pdf attachments to account object using Data Loader CLI. I want to delete these attachments daily and upload newest pdf files. Can somebody please suggest how can I schedule mass ...
1
vote
1answer
44 views

Before Insert Trigger with a Data Loader Insert Operation of 9,000,000 Records

I have a simple reparenting before insert trigger that is going to update a single field on each record. About 9,000,000 records are going to be inserted every morning and then deleted later that ...
0
votes
1answer
43 views

Getting error when trying to run Data loader on Mac

I just downloaded the Data Loader from salesforce (mac version) on my machine. Now when I try to run it, it's giving me the error: Please make sure that the config file: /Volumes/DataLoader/Data ...
1
vote
1answer
30 views

How do I give access to View Bulk Data Load Job Details on a read only profile

I need to provide access to View Bulk Data Load Job Details on a read only profile is that possible and how? please advice and thanks!
0
votes
1answer
16 views

Data Loader File column header

When i want to map fields in data loader, i see fields like this Account name;Owner ID;Account ID. As a result i am unable to map the respective fields. Is there any issue with .csv file format? I ...
-1
votes
0answers
11 views

Cliq data loader utility fails to run process

Error is thrown when batch file is run. E:\Data Loader\cliq_process\ApprovalHistory>SET DLPATH="E:\Data Loader" E:\Data Loader\cliq_process\ApprovalHistory>SET DLCONF="E:\Data ...
0
votes
1answer
35 views

How to configure update operation in Command-line interface for Force.com

What should I give in configuration like: <entry key="sfdc.loadBatchSize" value="500"/> <entry key="sfdc.entity" value="Opportunity"/> <entry key="sfdc.Id" value="id"/> <entry ...
1
vote
1answer
30 views

Dataloader API limits exceeded

We were loading lots of data in org and suddenly errors like Cannot obtain exclusive rights on records and then API limits exceeded. I did some research and founded salesforce reset its limits every ...
1
vote
1answer
27 views

Data Loader Export Booleans as 1 or 0

Does any one know if it is possible for the data loader tool to export boolean values as a 1 or 0 instead of the "True" or "False"?
0
votes
1answer
17 views

Monitoring Records Updating from dataloader

I have to do false update on opportunity.I am doing through dataloader. How can i monitor the records behavior. How would i know if trigger got broke. Would in success error files records it will give ...
1
vote
1answer
56 views

How does a trigger behave

Assume I have written a after insert trigger on an object A. I do some manipulation inside my trigger and at the end I create 3 to 4 new objects , that is a related list in Object A(Master-detail ...
0
votes
0answers
19 views

Data storage is about to finish and want to remove Email Tracking Statistics

We are running short of data storage and I can see most od the data storage used by "Email Tracking Statistics" almost 44%. I tried to delete it but I haven't get any option to delete. We were using ...
1
vote
2answers
40 views

Migrating Chatter files attached to feed comments

I am ultimately trying to use data loader to migrate our chatter posts & comments that have files attached to them. They were originally added by uploading directly from computer to the comment. ...
-2
votes
1answer
44 views

How to make a field blank using dataloader [duplicate]

I have an email field having some values. I want to make this field blank. The problem is I have to make this field blank for 1000 records. When I try to update the email with blank in data loader it ...
0
votes
0answers
34 views

Cliq utility doesn't work with version 36 of apex data loader

Error message is shown after selecting option Export in GUI and clicking next button Exception occurred during event dispatching: java.lang.UnsupportedClassVersionError: ...
4
votes
0answers
44 views

Data Loader CLI

I am trying to export data using CLI data Loader. Can I dynamically assign the export file name with the system date and time stamp. Any suggestions would be appreciated! Thanks!
2
votes
0answers
34 views

CLI Data loader export with dynamic file name

I would like to export the account data periodically using CLI data loader and generate the export file names dynamically with export time stamps.Eg:- If i am running the export @28-Mar-2016 , file ...
2
votes
1answer
39 views

Is trigger update existing records?

I have one trigger that updates records. Now i just wanted to know if we update those records with data loader. The D M L Operation code would perform or not. Because i need to update few existing ...
-2
votes
3answers
29 views

data loader every time showing 0 successful

Hi I export a report from production, now I want to move exported report to sandbox object. In my report contain all fields same in that sandbox object. But every time it shows 0 successful and 103 ...
2
votes
1answer
22 views

Dataloader from the Command Line: Change Query Request Size in XML Bean

Is it possible to change the Query Request Size when running Data Loader from the command line. I tried adding "sfdc.queryrequestsize" to the XML bean with no luck. Example of my attempt to change ...
0
votes
1answer
53 views

Data Loader Stuck

when I am using the data loader I going to insert and browse the report file to object. It’s always showing this pop up box “initializing salesforce object and csv file”. I am unable to move forward. ...
5
votes
2answers
61 views

Define Campaign Member Status via Apex?

I have thousand of campaigns for which I have to define campaign member statuses. Manually I know it is done via the advanced configuration on the campaign itself. But I don't think it feasible to ...
1
vote
2answers
19 views

Data sweep in production environment? [closed]

Hi i am a newbie to salesforce. I am trying to learn a easy way to do data sweep on some text fields and replace them with another value in production environment. As far as i know data sweep can be ...
0
votes
0answers
47 views

How to handle CSV file with 'line breaks' - data loading

I have a CSV file of Tasks (activity) to upload. As it can be seen from the picture below that the line breaks are occurring, how can I format such a file in excel, because the data loader or any CSV ...
0
votes
1answer
185 views

Data loader fail to open [duplicate]

I am facing problem after installing Data loader. when i try to open, it shows: This application Require JRE(1.8.0) 32 bit I have done all possible solution.check below detail, where am i going ...
2
votes
0answers
12 views

Automate downloading of zipped files created on using export now functionality [duplicate]

How can i automate downloading of zipped files created on using export now functionality.I am using export now functionality and a zipped file is being created .I need to download that file to local ...
0
votes
1answer
134 views

Salesforce Command line Dataloader - Passing Parameters to Process-conf.xml ?

My currrent situation is I have process-conf.xml, with multiple environments and multiple orgs eg. dev and QA Then an entry for each Object(Account, Opportunity) that I may be inserting for ...
0
votes
1answer
28 views

How can I extract productcode and productname for orders using Data loader?

I need to extract the productcode and productname from the order object using DL. Any help is appreciated.
2
votes
1answer
102 views

How to update converted leads using DataLoader?

I need to populate one new custom field on Lead object in all the lead records for reporting purposes. What I tried: The first problem I encountered was with leads already converted. The error ...
3
votes
1answer
36 views

Can I bulk Upload invitees (users) in calender Events

I have multiple events and I want to add many users in those events. How can I bulk upload invitees(users) I already tried public calendar but it was not meeting up with my requirements. Every users ...
3
votes
1answer
499 views

Can Data Loader run with 64-bit Java?

I have uninstalled all old versions of the data loader and installed the newest one: 36.0.0 I cleaned up all Java stuff on my 64-bit Win 7 machine and there's only one version left, it's this version ...
2
votes
1answer
33 views

Loading data using data loader

I have a scenario where I want to just edit and save bunch of records without actually editing any fields or data in that record. I want to do this because the workflow rule associated with this ...
0
votes
0answers
14 views

External API for Salesforce data loader

Is there an API I can use for the data loader tool in salesforce to bulk upload into salesforce from another application?
0
votes
0answers
25 views

Data Loader or CLI to upload related records without VLOOKUP first [duplicate]

I'm working on writing batch scripts to export data from one sandbox and then insert into a new sandbox via CLI. I have two custom objects State__c and Country__c. Currently Country__c is inserted ...
0
votes
2answers
179 views

Command line data loader error in latest version during encrypting key

I am using latest version of command line data loader (V36).I am trying to encrypt key using below command in command line. D:\Salesforce.com\bin>encrypt.bat -g anystring But it throws me error ...
2
votes
3answers
35 views

Is it possible to insert or update CaseFeed object?

I'm trying to insert a CaseFeed item under a Salesforce Case through the API and I kept getting back the following error: message: 'entity type cannot be inserted: Case Feed', errorCode: ...
0
votes
1answer
24 views

which api does dataloader uses when bulk api is not checked? What is the default API?

Which api does dataloader uses when bulk api is not checked? What is the default API ? I could see explanation for using BULK API in dataloader, but what to know which api is used in default?
3
votes
1answer
64 views

Data Loader and after update triggers running twice

I have a scenario. I am updating some Opportunity records through Data loader which causes after update trigger to run twice and cause issues. It shows that some WF Field update runs again and then ...
3
votes
2answers
74 views

Apex trigger runs OK while editing Account, fails in DataLoader

The trigger in question reassigns cases from the updated account to another account given a criteria defined by a single custom field in those cases. Basically, if "Case.ReassignTo__c" has a value, i ...
7
votes
4answers
254 views

Data Loader Command Line Tool slow

I am trying to automate a data load using the Command Line tools and have everything working smoothly but it is taking 10x longer than if I do it through the Data Loader GUI. Below is an exert from ...
0
votes
1answer
38 views

How to assign old leads to a new particular record type in Enterprise Edition(EE)

I am new to sfdc. i want to assign old leads means leads created before record type is created.so,I want to assign these old leads to a new particular record type.I had tried to assign using ...