Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

0
votes
1answer
27 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
17 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
16 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
47 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 picklist ...
0
votes
2answers
122 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
30 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
38 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
23 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
49 views
1
vote
1answer
38 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
15 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
147 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
223 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 ...
0
votes
1answer
42 views

How to create a 100% Read-Only profile in Salesforce (including 'Salesforce objects' as shown in DataLoader)?

Please hear me out completely. I am trying to create a profile where user can read data (= export) from Data Loader, but NOT insert/edit/delete ANYTHING back through it. So I created a profile with ...
0
votes
1answer
22 views

How can I use the Data Loader to connect SSIS?

My team wants to take data from Salesforce and using Integration Services, integrate that data to another platform. First of all , I would like to know if this is possible, and if it is, is there any ...
0
votes
0answers
34 views

Unable to extract Attachments and Files from Org

I am trying to move all the attachments and files from one org to another org but my attachments of account and opportunity are above 10000, I download the data loader but it is showing "Java heap ...
0
votes
1answer
45 views

Disabling Triggers in Production

I have a trigger live in production on Contact Object and I am trying to load a set of 500 records through data loader and I don't want that trigger to fire upon the contact records I am loading into ...
0
votes
1answer
25 views

I have moved account data through data loader but Attachments files is not showing

I have moved account records through data loader, but all attachments, files, record type are not showing in my target org, only account name and some other fields are showing. Can you please help me ...
1
vote
1answer
30 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 ...
0
votes
1answer
29 views

how can I move account owner alias field from the data loader

I have moved all the account data in another org through data loader but in the account owner alias field it is showing admin, I have to show the user perspective shot name. Thanks in advance
0
votes
1answer
76 views

Error while data loading to salesforce

I am trying to do data loading to salesforce which has Date field but it is giving the following error. INVALID_FIELD:Failed to deserialize field at col 1. Due to, '02/01/2019' is not a valid ...
0
votes
1answer
48 views

Is there a way to insert data with specific IDs?

I'm not sure if I'm explaining this correctly but I'll give it a shot. I'm trying to use Data Loader to insert CSVs of data into a Partial Pro sandbox, but I want these inserted records to use the ...
0
votes
2answers
63 views

Bulk data loader operations:: System.LimitException: Too many SOQL queries: 101

I am getting an error while performing data loader operations on the Leads object as I get this error: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY:LeadTrigger: System.LimitException: Too many SOQL ...
0
votes
1answer
41 views

Transactions and Batch Size

If I set a batch size of 1 in dataloader and update around a million records, is there a guarantee that in a single transaction, only 1 record will be updated - that is every record will be updated ...
1
vote
1answer
38 views

Failure when inserting records via dataloader, however anonymous apex inserts fine

I'm getting the following error when running dataloader (inserting new quotelineitems), however an identifcal anonymous apex works fine - any thoughts? Error: The price book entry is in a different ...
1
vote
1answer
96 views

Upsert by External Id - Different recordTypes

I have an External Id on Account object. Is there a way to make an upsert when 2 records or more have the same external Id BUT they have different record type? When I make the upsert I get the ...
0
votes
1answer
108 views

Trigger Exception on data Loader

I have written a trigger to create/update a contact when account is created/updated. Every account will have one contact associated with it. When i try to load the data from data loader in to account ...
2
votes
1answer
29 views

Purge an archived Product

In my orgs, for some truly obscure reasons, a Product has been archived. I've bookmarked it, and I can now see it with the direct url ( MYORGSURL/objectId ), but I can't do anything with it: I can't "...
0
votes
1answer
34 views

Does Dataloader Command Line Run Triggers

I have a process to insert records into salesforce using dataloader command line. The process works fine. However, there's a before trigger on the object which does not seem to be firing for this ...
2
votes
0answers
32 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
1answer
72 views

Do not see Event object in Dataloader

I need to move events from one SF instance to another, but when I open Data Loader I don't see Even (and Event Relation) object in the list of available options. I login under user with System ...
1
vote
1answer
52 views

I need to upsert the data into salesforce using data loader cli

I need to upsert data into Account object using Data Loader CLI. And I am getting below error. 2018-11-15 10:53:38,196 ERROR [accountUpdateProcess] client.PartnerClient proces sResult (PartnerClient....
0
votes
1answer
169 views

Inserting Chatter FeedItems with type 'TrackedChange'

I am trying to insert a Chatter FeedItem through Data Loader. When the type is 'TrackedChange', I am getting the error 'Cannot directly insert FeedItem with type 'TrackedChange'. How can I solve ...
0
votes
1answer
38 views

Pushing data from Salesforce to FTP or any other end point using Data Loader CLI

Is it possible to push data in a CSV format from Salesforce to any other external endpoint or FTP server using Data Loader CLI?
0
votes
1answer
53 views

Tasks Updates--Locking issue

We are currently facing issue while updating tasks via dataloader or workbench. We are updating tasks of around 8 lakhs. Problem is tasks are linked to account which locks the accounts while updating ...
1
vote
2answers
56 views

Tasks created in Data Loader don't send emails or create notifications

I have a lot of tasks to create so I am using the Data Loader to speed up the process. However, when the tasks are imported, the user they're assigned to doesn't get a notification within Salesforce ...
0
votes
1answer
38 views

SOQL limit Error with task dataload

I am receiving System.LimitException: Too many SOQL queries: 101 error because of my Apex trigger. Issue is clear but I am thinking of best possible way to handle it during bulk data loads. We ...
0
votes
2answers
37 views

Data Loader, export process

i need to export 19,00,000 records from the production. i started the process but in the middle due to network issue the process failed. and export file having only some of the records from where was ...
0
votes
1answer
81 views

Restrict update existing record while upserting from Data loader

I am going to load data using WorkBench/Dataloader using UPSERT (ExternalId__c) DML operation. Once this ExternalId__c is matched then we have to check one more thing like Sr_number__c in that ...
1
vote
1answer
38 views

Is it possible to insert records based on record Types using DataLoader CLI Approach?

A. Can the DataLoader CLI load process create multiple records in SalesForce for the same object with different recordTypes? Able to add records using DataLoader CLI Approach but Not sure how to ...
1
vote
3answers
78 views

Data Loader Error Date/Time fields Failed to parse date

All of my records are failing to insert for the same error. I do not see an issue with the format itself. I also tried using European format with no luck
0
votes
1answer
88 views

How to insert on salesforce custom object using dataloader

I have a custom salesforce object that I am trying to insert data into via the salesforce data loader tool. I can only see the object when I click export and click on "show all salesforce objects". ...
0
votes
1answer
54 views

Report to fetch Duplicate Contacts

I need to generate a report with list of duplicate contacts and their duplicate count. I’m trying to run below query through Data Loader and Workbench & Export the results. select count(id), ...
0
votes
0answers
16 views

Sharing behavior when uploading data with owner, created by

Uploaded some contacts where the Owner, Created By fields set to user abc(I enabled audit fields for my API only user) Then tried uploading custom object X__c where it has a lookup to contact, Owner ...
1
vote
2answers
49 views

Data Export using Data Loader

I am exporting data from Salesforce using Data Loader, now I am facing some issues with the exported CSV file. Let me give an example, In my custom object, I have some data stored as 23-02-07 which ...
0
votes
1answer
420 views

How to query ContentDocumentLink in SOQL and then upsert records in Data Loader

When querying ContentDocumentLink in SOQL using the following query, an error is thrown. Goal: We are attempting to get a spreadsheet of the data so we can update IsDeleted flag with TRUE on entries ...
1
vote
1answer
37 views

How can I load all routing address use dataloader?

I want to load all routing address one time.(like use csv file by dataloader) I imported csv data into object emailServicesAddress by dataloader successfully, but the field EMAILDOMAINNAME is xxxxxxx....
0
votes
1answer
35 views

Importing a date prior to January 1, 1700 in a date field

Is there a way to import a date that is prior to January 1, 1700 in a date field? The documentation says that this is not an option. Link below https://help.salesforce.com/articleView?id=000240801&...
1
vote
2answers
130 views

Content Notes from CSV not uploading via Data Loader

We are attempting to upload a CSV containing local drive links to text files and html files. We want these to become "Content Notes". Data Loader keeps throwing errors when we attempt to upload (see ...
1
vote
1answer
31 views

Can a CSV used in Data Loader have unused fields?

We are using the Upsert command in Salesforce Data Loader. If we have a CSV with several columns we do not wish to update (it's a wide CSV), can we still use it and just not map it? Or do all columns ...