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
2
votes
1answer
175 views

Test.loadData() is there a way to load sObects with lookups to itself?

We have some custom object that has lookups to itself. Those objects used for some configs and there are quite a lot of them. Would be nice to create and load them from static resource for tests as ...
1
vote
2answers
392 views

Effect of TLS update in Apex Data Loader?

Does TLS update have any impact in apex Data loader? If it so, in what way will it affect? What measures has to be taken in order to use Data loader after that update?
-2
votes
2answers
491 views

query deleted custom object records from recyle bin [closed]

Query to get records from recycle bin
0
votes
0answers
468 views

Pentaho Kettle update salesforce

I get the following error when trying to update salesforce from a CSV Errors were found on item 0 Error code is: INVALID_TYPE_ON_FIELD_IN_RECORD Error message: Office: value not of required type: ...
1
vote
3answers
2k views

Timezone issue Data Loader

I have to upload a csv file in which a DateTime field has values across the global timezone, however I want to load this data in my org keeping the timezone consistent with my org. e.g. In CSV values ...
3
votes
3answers
2k views

Can I export related fields using a data loader?

I want to be able to export the related account fields for each quotation in Salesforce using Data Loader. I suspect this is possible using relationships (Object__r.FieldName__c), but I'm not 100% ...
0
votes
1answer
1k views

I am getting “407 Proxy Authorization Required” error when I try to login to Data Loader

I get "407 Proxy Authorization Required" error when I try to login from Salesforce Data Loader.
0
votes
1answer
188 views

Multi select picklist to picklist

I am trying to move from Multi-select picklist to a single select picklist. What steps should I take? I am thinking(not clear yet) there is a data load involved. Should I leave the existing data with ...
0
votes
0answers
93 views

process.conf.xml bind xxxx_lastRun.properties parameter in SOQL in API Dataloader CLI

I'm building a process.conf file to extract delta view records from Salesforce. my SOQL is looking like this now : <entry key="sfdc.extractionSOQL" value="SELECT Id,FirstName, LastName FROM ...
1
vote
2answers
844 views

updating the child record and linking it to parent

I have scnerio where I am loading the child record from an external system and I want to connect it with the parent record. But I do not have the sfdc id of the parent record that I can put in the ...
1
vote
0answers
90 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 ...
0
votes
2answers
494 views

Problem with date when uploading a csv via DataLoader

I'm having an issue when uploading a date from a csv via DataLoader. The date on my csv is for example 2017-04-03, but when uploading it via DataLoader, it will be 2017-04-02 in SF (always one day ...
1
vote
0answers
52 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
539 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 ...
0
votes
0answers
60 views

Opportunity stage Report or Dataloader export in salesforce

I would like to generate a report on opportunity stage with dates. for example the reports with following columns. Opp Name Finalist (50%) (90%) Closed Won (100%) ...
2
votes
1answer
107 views

Leading Zero appeared once upserting data into salesforce

I'm using auto data loader, and for some weird reason, once I'm upserting a child record into account using external Id, there some record that fails because: "Foreign key external ID: 040525479 not ...
2
votes
0answers
467 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-...
1
vote
1answer
235 views

Create Data for multiple objects through trigger

I have a somewhat complex scenario where I have multiple objects in my Data Model associated to each other like Contacts, Users, Campaigns, Campaign Members and one custom object. The relationships ...
4
votes
1answer
588 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 ...
2
votes
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
3answers
1k views

dataloader csv file date format

I am using data loader to export salesforce data to csv format. In the csv file all the date and time fields are coming as like '2017-03-08T06:18:46.000Z'. Is there any way to change the format like '...
3
votes
2answers
155 views

Combining Multiple Rows From SOQL Query In DataLoader

I am trying to output information from one of my org's pricebooks into excel for another department to review. I'm capable of getting the information with a basic select statement, but they would like ...
0
votes
1answer
280 views

Data Loader cmd line

I am getting this error when trying to authenticate into the cmd line interface for Data loader. I have read some previous threads on making sure Java and data loader are up to date. I have updated ...
0
votes
1answer
564 views

Assignment rules is not working while records are inserting into lead from dataloader

While i am inserting manually, assignment rules are comes into action if i checked Assign using active assignment rule option. But while inserting records from data loader, assignment rules are not ...
4
votes
2answers
630 views

How many API calls does dataloader use

We are using dataloader to delete several hundred thousand records. As stated in Salesforce knowledge, it should be 1 API call per batch. However, our BA told me that she watched the API usage went up ...
1
vote
2answers
185 views

Bulk data load job not visible for bulk upload

An external system uses the bulk api to push bulk data into Salesforce. THis external system will only push the data if Salesforce sends a request to push the data. I beleive all the bulk data that is ...
1
vote
1answer
77 views

Asynchronous calls behaviours

I would like some help over below: I have an use case where due to Apex CPU timout limits i would like to make this trigger in asynchronous with other objects. I was wondering Since sales force has ...
0
votes
1answer
77 views

Salesforce Data Loader bulk api result files

I see that when I run the Salesforce Dataloader with the bulk api mode enabled it still produces result files containing the success and error records. I did not expect this since the Bulk API is ...
1
vote
2answers
230 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
1answer
1k views

Facing record lock issue on Parent when loading millions records

An external system is pushing data into my org using bulk API. There are about 2 million records. The target object is child__c. The child__c has a lookup to parent__c. When the external system loads ...
0
votes
1answer
555 views

How to extract notes and attachment for a custom object “X”

I have tried to download notes and attachment for a custom object under donot get the option to filter notes and attachment for a particular object. Login to http://dataloader.io with your login to ...
2
votes
1answer
171 views

Will extracting data from salesforce remove all data from salesforce

If I extract data from salesforce for an object using dataloader.io or dataloader, would it remove data too for that object from salesforce.
2
votes
1answer
1k views

How to import accounts without contacts using Data Import Wizard?

I want to import a spreadsheet that only contains account information. Using the Data Import Wizard, I am NOT able to import accounts without contacts, which makes no sense. Is there a way to import ...
0
votes
0answers
134 views

error while updating records of Lead

seeking help here. I have a sheet to update on Lead where i have State Code and Country Code fields to update. But while updating from Dataloader i am getting error as "invalid cross reference id". ...
11
votes
1answer
3k views

Difference between data loader and workbench

I uploaded a .csv file with 50000 rows to the Salesforce Workbench to update a custom field in Opportunities. For most records I got the error Too many lock failure 200 Trying again later. I ...
1
vote
1answer
1k views

Importing value through data loader for a lookup field

I have account lookup field on a custom object. I want to import records through CSV file using data loader, but this file only have Account name, not ID. How can I import this file in salesforce? As ...
0
votes
1answer
28 views

is that possible to get id populated automatically based on name in data import wizard?

I have excel sheet with the lookup name than id and value ID - value 1 xxx 2 yyy object 1 LookupId - 1 value = 2 My excel sheet data upload format is value - value xxx 2 will ...
0
votes
1answer
183 views

Process Builder only calling invocable methods for top 3 records when uploading via DataLoader.io

First time posting and I'm quite new to SF. I've ended up on this site a lot when Googling to help me with issues - so thanks! On my org, we're uploading some opportunities via DataLoader.io that ...
1
vote
0answers
608 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
2answers
419 views

Is Document Body Blob field value encoded in Base64 when extracted by Dataloader? Can this encoding be used for insert or update?

I want to use Salesforce DataLoader to extract and upload Documents. However, I don't understand in which format Blob Body values are stored, is it Base64 encoded? Looks like yes, but why it is not ...
2
votes
1answer
1k views

Upserting Data using Data Loader with External ID

I'm using Data Loader in order to Upsert some data within my Org. I know, that if I will Upsert a record within my CSV that has duplicate External Id value with another record in the file, It will ...
3
votes
1answer
410 views

CLI Data Loader Failure notification

I am tryin to figure out but unable to sure as what seems to be available in the available resource is that whenever the CLI Dataloader fails, User will not be able to get the notification. Just to ...
6
votes
1answer
695 views

how to update email field to NULL value using data loader

I have a field email TL1 which have values populated by a workflow. Also I want to make this field as blank using NULL value in data loader. I have changed the setting of data loader "Insert null ...
0
votes
1answer
137 views

Mass Record insert using Salesforce connection for two org

I have created a salesforce to salesforce connection using trigger for new record and for update using the basic functionality. But as during the deployment I may be need to put million of data and ...
1
vote
1answer
744 views

getting Cannot specify both an external ID reference Owner and a salesforce id, OwnerId while upserting account using dataloader [closed]

We are getting 'Cannot specify both an external ID reference Owner and a salesforce id, OwnerId' error while upserting account record. Any idea?
0
votes
1answer
58 views

Bulk Address verification

I have custom button "Verify Address" which calls trigger and Webservice API for address verification. Now my requirement is , when records are uploaded through data loader how can i call this ...
0
votes
1answer
157 views

dataloader showing cpu time limit exceeded

I am facing one issue while using dataloader. I was upserting single Account records which has 2811 contacts using dataloader. But while upserting its throwing CPU time limit exceeded error. Then i ...
3
votes
3answers
545 views

Auto Data Loader using CLI uploading dates one day back

I'm using ant to operate auto data loader with the CLI. The dates that I load are uploading with one day back. I set a variable that get the GMT value but still it isnt working Here is my process-...
0
votes
1answer
211 views

Cannot find Account Name Field in Dataloader.io while trying to Update Opportunity Account Name

I cannot locate the Account Name field within DataLoader.io in order to change the account of about 270 opportunities: Any advice much appreciated.
0
votes
1answer
1k views

Command line data loader error in latest version (During encrypting key)

I have downloaded the latest data loader 38.0 and trying to execute from command line. When I execute the command dataloader>bin> encrypt.bat –g “sometext” it is throwing an error message: ...