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
2answers
57 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 ...
0
votes
0answers
14 views
Inserted date in salesforce is -1 from the date in csv file using data loader cli [closed]
I am using data loader CLI to insert records and when the process is complete it inserts the date as -1 from what is given in the csv.
The date format is dd/mm/yyyy. My server is in Rome that GMT+1, ...
2
votes
1answer
15 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
0answers
18 views
Getting Error while importing with Data Loader CLI
I am able to login to salesforce org but getting below error while inserting:
2018-12-02 19:51:10,648 ERROR [accountInsert] util.DAORowUtil handleError
(DAORowUtil.java:148) - !DAORowUtil....
0
votes
1answer
23 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
22 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 ...
0
votes
0answers
23 views
Null Pointer exception in data loader cli
I am trying to upsert data in account object but it is giving me the following error "Null Pointer exception in data loader cli".
Below are my files :
<bean id="accountUpdateProcess"
...
2
votes
1answer
34 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 ...
0
votes
0answers
23 views
What is the closest thing to replicating DataLoader for Windows in Powershell?
I'm trying to mimic the behavior of DataLoader for Windows via commandline and I'd like to know if there is something that closely matches its output. I'm primarily interested in the query fields that ...
0
votes
0answers
27 views
Product Items Serial Number Error
I have an Excel with multiple Product Items. They all have different manufacturer codes , but since they are parts they don't carry a Serial Number. What's the problem? Some products are repeated ...
1
vote
1answer
30 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
0answers
42 views
UNKNOWN_EXCEPTION: An unexpected error occurred. Please include this ErrorId if you contact support: 466096175-12641 (-1981325917)
I am loading data from outside of the salesforce using upsert DML operation but not sure why it not worked and getting the following error,
UNKNOWN_EXCEPTION: An unexpected error occurred. Please ...
0
votes
1answer
31 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
33 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
35 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
31 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
31 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
33 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
50 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
27 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 ...
0
votes
0answers
32 views
KeyFile Content is too short Salesforce Data Loader CLI while creating a secret key
I am trying to use CLI for Data Loader. While trying to implement the first step i.e, creating a encrypted key I am getting error as Keyfile content is too short. I am using the below command
C:\...
1
vote
3answers
30 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
52 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
27 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
43 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
0answers
28 views
How to load data from csv using Salesforce Dataloader where data in one csv has two master objects?
I have a data model where a child has two masters. I am trying to upload child csv data using data loader (automation through CLI) that references two master objects. I understand that I can use the ...
0
votes
1answer
105 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
30 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
32 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
57 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 ...
0
votes
0answers
31 views
Process Builder? Data Loader? Formula? What broke?
The issue:
A custom formula field called "current grade" stopped working is only now working for some of my students. Using data loader, I exported all students and then updated them matching only ...
0
votes
0answers
29 views
Update field based on lookup returning an error in Data Loader and Import Wizard
We are using the Person-Account model. We have Accounts (households) with Primary Keys populated, and then we have contacts who have their own External IDs and had Accounts created for them through ...
1
vote
1answer
26 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 ...
0
votes
1answer
38 views
Data Loader not exporting notes despite records in system
While we are able to export other objects, and can see Notes in the system under Contact records, Data Loader exports only headers and no records under Export All. We are using the "Notes" and "Files" ...
-1
votes
1answer
38 views
Dataloader relationship issues
How can data will be inserted if the records have master or look up relationship? Also how external id is useful in dataloader
0
votes
1answer
19 views
How to resolve below Dataloader error
Too many retries of batch save in the presence of Apex triggers with failures: when triggers are present partial save requires that some subset of rows save without any errors in order to avoid ...
0
votes
1answer
45 views
Mass Update Record Error too many DML
I want to mass update the record of my custom object called Request_Delivery_Plan__c.. There`s 1 trigger called RDP_Create_Delivery_Plan on Request_Delivery_Plan__c..
I set my data loader batch size ...
0
votes
1answer
43 views
Email is not firing for feeditem records inserted through DataLoader
When I am Inserting feed item records through dataLoader, the standard salesforce chatter email is not firing.
But When I insert a record through UI, I am getting the mail. Also, the email is coming ...
0
votes
1answer
44 views
Retrieve data from “FeedTrackedChange” table between particular time period
I want to retrieve data from "FeedTrackedChange" table between particular time period.
For Example:
select * from FeedTrackedChange where CreatedTime >= jan 2000
But the problem here is there is ...
0
votes
1answer
44 views
Data Loader Command line: fields are not validated and then insert is not performed correctly
I am currently using a powershell script to run a data loader command line insert job. The process appears to run correctly, and shows all records successfully inserted. However, when referenced in ...
0
votes
1answer
17 views
Importing external CRM data with new households/accounts joins
Is there a best practice / simplified methodology for importing bulk records from an external CRM when there are new intricate household and account joins?
I have looked into dataloader.io, but what ...
0
votes
2answers
36 views
Assign a Role as a Queue Member by Apex or DataLaoder
In the hypothetical situation, I have 100 queues, if I needed to update half of my Queues to have a member of Role 1 and Subordinates and the other 50 queues to have a member of Role 2 and ...
0
votes
1answer
31 views
Data Loader CLI - disable debug messages
I'm trying to turn off the DEBUG messages from Data Loader CLI's output when running.
As per the documentation I have set sfdc.debugMessages to false, but it's still outputting them.
I have set sfdc....
0
votes
2answers
36 views
Trying to understand upsert - data loader
Im trying to understand how to use upsert.. for example there`s :
ID = 1600.
Type = Shipping To.
and
ID = 1600.
Type = Billing to.
Can I use upsert to update record where ID = 1600 and type = ...
0
votes
2answers
47 views
How can I migrate data and related data from one org to another org?
I have a requirement to migrate data and I have a lot of related data, records and relationships to maintain.
Is there a utility or tool to help me do this to minimize the amount of manual steps I ...
2
votes
2answers
28 views
Encountering a very strange Data loader error with number field values in a WHERE-IN clause
Our product backend has an ID field for each customer's instance of our software, so we have a custom Number field on our SFDC Account object to track each customer's Product_Org_Id__c. Often folks ...
0
votes
1answer
31 views
How to Import/Query the 'EntityHistory' Object Data Through Data Loader in salesforce
i have some records/data, i mention in Excel File is in below, and i need How to Query the Records from "EntityHistory" Object...
please Help me i will try my developer Edition.
0
votes
1answer
148 views
Can't get CLIq to go beyond first screen
If I click on Next
I get the error
Exception in thread "AWT-EventQueue-0" java.lang.NoSuchMethodError: com.salesforce.dataloader.security.EncryptionUtil.encryptString(Ljava/lang/String;)Ljava/lang/...
0
votes
1answer
51 views
How to Import and Export Notes and Attachments from one Object Using Data loader
I need to export Notes&Attachments for one object from production and Import to the sandbox. Attachments should be linked for each record how they are in production?
