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.
690
questions
1
vote
1answer
25 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
1answer
24 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
19 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
9 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
21 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
23 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 ...
2
votes
5answers
160 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 ...
7
votes
1answer
132 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
63 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
28 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
41 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
14 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
33 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
70 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
19 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
37 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
32 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
73 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
24 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
279 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
162 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
60 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
45 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
36 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
70 views
could anyone explain, why this error comes “DUPLICATE_VALUE:This price definition already exists in this price”
DUPLICATE_VALUE:This price definition already exists in this price
1
vote
1answer
78 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
35 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
235 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
233 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
46 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
35 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
49 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
74 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
26 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
41 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
32 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
131 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
56 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
89 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
51 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
47 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
156 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
143 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
47 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
65 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
47 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
100 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
75 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....
1
vote
1answer
273 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
43 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?
