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.

179 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
1answer
571 views

Easiest way to delete a million records?

Been doing tests in sandbox in which I've created about a million accountshares that I need to get rid of for testing. I'm trying data loader in bulk api mode to export than delete but I keep ...
4
votes
0answers
428 views

Data Loader does not open on OS X El Captain

Does anyone have similar issue opening Data Laoder on MAC OS X El Capitan?
4
votes
0answers
1k views

Is there a simple way to generate a create table script from a salesforce class?

I am looking for a way to synchronize Salesforce data with a local database. At the moment I just want a pain free way of downloading the data. I've been playing around with importing CSVs from the ...
4
votes
0answers
331 views

Dataloader to MySQL with SSL

Have scripted a salesforce dataloader import job using cliq with a MySQL source. see http://code.google.com/p/dataloadercliq/wiki/CLIqWithMySQL Everything works correctly.. Yet I am required to use ...
3
votes
0answers
73 views

Data Loader export of ContactHistory records ignores timezone setting in version 36

I noticed today using v36 of data loader against a Winter '17 Salesforce org that export of data fields in the ContactHistory object (OldValue/NewValue) was ignoring the timezone setting - unless the ...
3
votes
0answers
566 views

Getting error when scheduling data load from command line

I'm running dataloader from command line. It is working fine when all my parameter like username, password are in "process-conf.xml" file. Like this: <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//...
3
votes
3answers
676 views

List of Items we cannot migrate with Data Loader

I have to migrate whole Full Copy Sandbox org to my new Production that includes the following majorly: All Standard/Custom object records. All Note & Attachments part. All Libraries & ...
3
votes
0answers
2k views

Error While Uploading Data Via Dataloader :Too many retries of batch save in the presence of Apex triggers with failures:

I am Getting this Error While Uploading Data by Dataloader. Too many retries of batch save in the presence of Apex triggers with failures: when triggers are present partial save requires that some ...
3
votes
0answers
629 views

Powershell Apex Data Loader v29 CLI error

I'm trying to run apex data loader CLI from windows powershell. I actually managed to start the CLI from powershell however I'm getting the following errors: 2014-02-05 22:48:59,380 INFO [main] ...
3
votes
1answer
952 views

Updating Content records with dataloader

I'm trying to update detail fields on Content records using the Salesforce data loader, as well as dataloader.io. Typically, the uploads have failed w the message "ERROR: You do not have the level of ...
3
votes
0answers
331 views

Workflow outboundmessage not working when updating data using data loader

I have a workflow outbound message on opportunity which works when I am updating a single record manually. But when I am updating bulk records via data loader the same OM is not working. I can see the ...
2
votes
0answers
53 views

DataLoader issue with Unicode special charactes handling

I have a Data Loader CLI script importing data (Lead records) automatically from csv based on some schedule. Last week I stumbled upon following issue: DataLoader (both CLI and GUI version) doesn't ...
2
votes
0answers
256 views

CreatedDate Not Available as Mapping Option in Salesforce Data Loader When Inserting New Records

There's a need for me to load records in our SF sandbox wherein CreatedDate standard field in Case object must be inputted manually in csv file, instead of the system automatically setting itself. I ...
2
votes
0answers
86 views

Can't Resume Flows

I have several Process Builders and a couple directly-written Flows in our Org. I'm currently data loading 275k records over the weekend. Estimates show it should be done (if I don't find it stopped ...
2
votes
0answers
459 views

Why doesn't Dataloader use specified 10k batch size when Bulk API is selected?

I have this sample CSV file containing 10,000 records (with 33 columns) I'd like to import it via Dataloader into Case object at my sandbox environment. I tried using these settings below with Bulk-...
2
votes
1answer
137 views

Workaround to import Campaign Members w/o enabling “Modify All Data”

We have a scenario where 18 users need the ability to add campaign members via an import file. This requires using Data Loader. However, these 18 users also have access to all Contact data across the ...
2
votes
1answer
227 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: ...
2
votes
1answer
305 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 ...
2
votes
0answers
204 views

Importing multi-picklist values using data loader salesforce

In my Salesforce Org. I have a custom field multi-picklist called Category. Then it has list values of (Y Connect, Board Member, Annual Report, Celebrity). I do an import recently and the imports are ...
2
votes
0answers
92 views

Dataloader - AES246 encryption during upload - Check java version for AES256 compatibility?

One of the key requirement from the business and as per the policy is to encrypt (using AES256) while the data is pushed from the Data Loader (deployed in the local machine) into SFDC (while in ...
2
votes
1answer
697 views

How to Import Account as Partners & Contacts as Customer User through Dataloader or any other applications

I need to import Accounts & Contacts to enable Community Users. First I need to know how to Import Accounts & Contacts as Customer Users. I tried to put Ispartner Field as True, but couldn't ...
2
votes
0answers
51 views

Sort after Converting Object Name to Autonumber

We are trying to insert all of our historical quote data to a custom object "Quote". In doing so, we want to conserve the existing quote number that was generated in our legacy Access database but ...
2
votes
0answers
54 views

In which object Article contents stores?

In salesforce, in which object, article content stores. when i am extracting KnowledgeArticleVersion, there is no content. only some fields are there. i have posted both snapshots. please help me, i ...
2
votes
0answers
1k views

Dataloader Export CSV Issues: how to remove quotes & add empty column

In a requirement , I have to extract the file in .csv and copy it over to a FTP location. I am doing it with command line dataloader and facing following issue related to it. 1) They are asking to ...
2
votes
0answers
373 views

How can I include SFDC object AND date-time stamp in process.outputSuccess for DataLoader?

When using the DataLoader, the default format for the process.outputSuccess file is success041214124151388.csv, ie the string 'success' plus a date-time stamp. How can I include the SFDC object (or ...
2
votes
1answer
89 views

Import Data Through Data Loader after converting relationship from lookup to master-detail

I have 1 custom object with 10000 records, now i want to customize this object & I want to connect this object with 1 object with master detail relationship, so I have to 1st create lookup with ...
2
votes
0answers
1k views

Data Loader using self relationship lookup and external id

I'm currently using Jitterbit Dataloader. I have an object called 'Project' and it has a self relationship (lookup) called 'Parent Projects'. During an initial import there are no parent projects so ...
1
vote
2answers
416 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 ...
1
vote
1answer
44 views

Setting up data post refresh of partial copy sandbox. How to satisfy master details relationships without manual effors

We have a plan to refresh one of our partial copy sandbox. we would like to set up all data as it is post refresh as there any many UAT data in sandbox. I searched and found Template based refresh but ...
1
vote
0answers
297 views

Bulk API v2.0 Failed records are confused

I'm developing code in java for upload data to Salesforce. All did fine but I've a problem with failed records with bulk API 2.0 with upsert action I have the next file csv for upload data for ...
1
vote
1answer
307 views

Insert base64 string as attachment using apex dataloader

I have a .csv file which has a column containing base64 string equivalent of a image. Anyway we can load the csv file into Attachments object or ContentVersion object using apex dataloader? I know if ...
1
vote
1answer
354 views

DataLoader CLI Could not find main class FindJavaRunner

Okay, so currently, I'm trying to create an AutoIt script that would RunWait a command to run a Data Loader upsert. However, I've been running into several issues with running the process.bat batch ...
1
vote
0answers
178 views

Unable to Authenticate Login with Salesforce Data Loader CLI Using Custom Domain

I have scoured the internet looking for a solution that seems is extremely common among users looking to connect to Salesforce via Data Loader CLI. On top of reading just about every forum out there ...
1
vote
0answers
1k views

How to solve “Error: Check your username and password. If you still can't log in…”

Today I am having problems logging into Data Loader. I am using version 40 of Data Loader and using my admin profile user, I keep getting error message: Error: Check your username and password. If ...
1
vote
1answer
304 views

Can we use '|' Pipe delimiter for command line data loader interface

I have a huge data file, but it is "|" (Pipe) separated, not comma. I have to schedule a dataload job with using data loader command line without any manual intervention, completely automated. I ...
1
vote
0answers
345 views

Challenge when inserting records that has lookup field(that uses external Id of parent record)

In my scenario , I am loading records of object xyz__c in my system. This xyz__c has a lookup field that refers to abc__c object. I am loading records using an external system. It maps the fields on ...
1
vote
1answer
139 views

What is is the purpose of database-conf.xml and process-conf.xml?

What is is the purpose of database-conf.xml and process-conf.xml and how does the two compare with each other for Salesforce Dataloader?
1
vote
0answers
361 views

Why does data loader fail a whole batch of records if just a single master-detail relationship is not filled correctly?

I'm trying to upload records using the data loader. The object I'm loading into has a master-detail relationship, but in the CSV, I don't set any external id or Salesforce id that identifies the ...
1
vote
0answers
87 views

Scheduled Jitterbit Upsert

I have a couple different upserts built out in Jitterbit that are all supposed to be running nightly. Some of them are working and some of them are not. As far as I can tell they are set up the exact ...
1
vote
0answers
50 views

Is that possible to use record name field as master-detail relationship definition in data loader

Our customer is previously using import wizard to load data into Salesforce and she is able to use name field as the master-detail relationship field during that time. Due to this known issue: https://...
1
vote
2answers
521 views

master detail data upload through data loader from command line

I am facing a bit problem while uploading csv data in salesforce org by data loader from command line. I have master detail objects OBJECT 1: Customer__c - Age__c - CustomerExternal_ID__c ...
1
vote
0answers
2k views

EXCEEDED_ID_LIMIT: Aggregate query does not support queryMore(), use LIMIT to restrict the results to a single batch

When I run following query in dataloader/workbench, I receive the below error. SELECT Count(Id) FROM Account where recordtype.name = 'Client' order by COUNT_DISTINCT(Id) EXCEEDED_ID_LIMIT: ...
1
vote
2answers
224 views

How can I define which delimiter the data loader should use when run by command line

Does someone know how define which delimiter the data loader should use when it is executed by command line? I am using version 38. The GUI has an option for defining allowed CSVs delimitters, but I ...
1
vote
0answers
601 views

Intermittent Error: Failed to send request to /services/Soap/u/37.0

I'm trying to data load tens of thousands of records and intermittently getting this error: Failed to send request to https://instance.salesforce.com/services/Soap/u/37.0 It sounds like this issue ...
1
vote
0answers
64 views

Which tools\techniques are you using to improve performance of mass deletion of custom object records?

We have a custom object with about 40 million records. We have identified about 18 million that we are going to delete forever. All of this data is permanently retained in an Oracle backup so we are ...
1
vote
0answers
277 views

Error uploading Enhanced Notes - Invalid ShareType

I have migrated Notes to Enhanced Notes (ContentNote) using SF data loader. Most of the records are migrated successfully, only in few of the records I am receiving this error Invalid sharing type "...
1
vote
1answer
372 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 ...
1
vote
1answer
698 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"?
1
vote
0answers
316 views

IMPORTING DATA - Is there a sequence when it comes to importing?

It there an actual way to import records? I know the sequence is this for standard objects 1. Accounts 2. Campaigns 3. Contacts 4. Opportunities 5. Cases 6. Solutions 7. Pricebooks 8. ...
1
vote
0answers
49 views

import data using data loader - How to use it secured?

We opt to use data loader to load the accounts, opportunites, leads etc in live. So the question is how to load it secured with some sort of encryption in live as these are critical data and we are ...