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.
777
questions
0
votes
1answer
11 views
Invalid Cross Reference ID when importing Tasks
I'm trying to import TASKS related to opportunities from one Salesforce org to another using Data Loader.
I have done Excel VLookkups on all Id Values, and all related objects/records are in place on ...
0
votes
1answer
20 views
Salesforce -Fire apex trigger only after complete data load
So here is the issue We are loading data into a CustomObject__c using DataLoader. Usually the no of records that are passed are 3. Also, if there is any issue with the data passed, they run the ...
0
votes
1answer
34 views
Query or extract attachment metadata in bulk
Is it possible to query or extract the metadata/document properties from attachments in bulk? Previously I have been able to get around this by using the object IDs to bulk download the files and then ...
0
votes
1answer
31 views
Bulk Api V2: How to correlate success/failed records with source records
Bulk Api v2 provides successful and failed records in two different files. This means if there are some records failed in between a batch, then we will not be able to correlate those failed records ...
1
vote
0answers
36 views
Data Loader on MacOS - java.lang.NullPointerException with Zulu/OpenJDK 11
Last login: Thu Aug 27 14:29:01 on ttys000
/Users/vamshikrishna/dataloader/v49.0.0/dataloader.command ; exit;
vamshikrishna@MacBook-Pro-6 ~ % /Users/vamshikrishna/dataloader/v49.0.0/dataloader.command ...
0
votes
2answers
30 views
Can you Mass Disable the Marketing User field (UserPermissionMarketingUser) for multiple User records using Data Loader?
I am attempting to mass disable the User record's Marketing User field (UserPermissionMarketingUser) for certain user records that exist within a test SF org. The steps I used were:
Create a report ...
0
votes
0answers
9 views
Sdl.log file for Data Loader CLI jobs scheduled through Windows Task Scheduler
Can someone help me with sdl.log file setup
I'm facing issue in monitoring the dataloader jobs that are scheduled to run on daily basis through windows Task Scheduler.
The sdl.log file doesn't ...
0
votes
1answer
21 views
Data Loader export script to a sharepoint site
I created a batch file to automatically export data from Salesforce using dataloader.
Right now the extraction path is in the local drive then I have to manually upload all to our sharepoint site.
<...
0
votes
1answer
29 views
One time data upload options in an Org
I have a use case where I need to do a one-time data update for around 1.8 Million records. I know that we can achieve this with a data loader or we can create an Apex Batch to achieve this.
Challenge ...
0
votes
1answer
15 views
Can you manually populate Address long/lat fields
I use Billing Address in my Salesforce org with Data integrations turned on so that Salesforce can populate the BillingLongitude and BillingLatitude.
Some of my addresses aren't being populated and ...
1
vote
0answers
16 views
Not able to Run dataloader on win10 32 bit? [duplicate]
I have installed ZULU openJDK 11. on my windows 10 32 bit machine.
Also installed dataloader.Not able to start the dataloader.
0
votes
0answers
17 views
How are api limits calculated for data export using data loader tool?
I want to export a million records into csvs using data loader, but as precautionary step I would like to know how the api limits would be calculated to export these million records?
0
votes
2answers
35 views
Cannot Delete Knowledge Articles
I am trying to delete knowledge articles via Workbench. I am receiving the following error:
InvalidJob: No delete access for object:Knowledge__kav
I am the system admin, so I definitely have access. ...
0
votes
0answers
19 views
How to automate data import from SFTP into salesforce org?
When a file is placed is SFTP folder , i need to pick the file & automatically import the records from file into salesforce object .
Currenlty i am able to load data into salesforce via ...
1
vote
1answer
19 views
Issue with renaming Attachments with Accents in File Name- Bulk upload
I am working on bulk loading of Attachments and as per SF documentation, after Data export, I renamed Attachment names using 'bat' file. Everything went fine except for the Attachments that has Accent ...
0
votes
1answer
26 views
Bypass Required Field Missing error when Bulk Updating Opportunity Stage Name to Closed Lost
When bulk updating old Opportunities to 'Closed Lost' via Data Loader, some records failed to update with following error -
Required fields are missing: [Custom_PickListField__c]
How can i bypass ...
0
votes
0answers
25 views
Not able to insert the lastmodifiedby by a userid in salesforce when importing through dataloader?
What can be the possible reason?
The logged in user name is populating in LastModifiedBy
Already Enabled permission "Set/Create Audit field".
2
votes
0answers
74 views
Dataloader CLI problems with mapping of CSV File
I try to DELETE some Data from my Org.
I have written a process-conf.xml with 4 Beans which work in BulkApi Mode and a Windows Batch File which calls the Jobs:
Job1) extract DATA from SF via SOQL &...
0
votes
1answer
36 views
Salesforce CLI Dataloader issue on ANT doesn't support < symbol
I have the soql extract through ANT which works fine. However when I used "<" symbol. It is throwing error
The value of attribute "soql" associated with an element type "...
0
votes
0answers
15 views
CLI Dataloader to Sharepoint - Url error
I am trying to extracting an object from salesforce to sharepoint through CLI. I could achieve it in local machine however for sharepoint. I am receiving following error.
DataloaderFiles\config\...
0
votes
0answers
27 views
Automatically export data from Salesforce
I created a script to automatically extract data from Data Loader.
I tried testing the SOQL in the dev console and it's showing the correct data, but when I used it in XML file the process is ...
0
votes
1answer
28 views
How to insert new records into the custom object using Data Loader which has “Master-Detail” relationship with Account?
I have an Account object and a custom object "B" where Account is Master and "B" is Child. I already have Account data and I am looking for inserting records in "B" using ...
0
votes
0answers
33 views
Bulk API v2 Failed because of wrong Data type
We are uploading vast amount of Data using the Bulk API v2 of Salesforce.
Some of our data do not match the valid data type of our fields in Salesforce resulting in a fail import of our data .
For ...
0
votes
2answers
54 views
Data Loader Won't Open
I have followed the instructions given for downloading Data Loader to a T. Every time I tried to open Data Loader after installation, it would just say I don't have zulu installed and then just close.....
1
vote
0answers
37 views
first error: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY, concertHTMLToLongText: execution of BeforeUpdate
I am trying to update the Knowledge article through data loader. We have a trigger on the Update (before update event) of the Knowledge articles. The trigger calls a apex class is like below
trigger ...
0
votes
1answer
28 views
Retrieve contacts based on a list of external IDs
I have a csv with 126,000 External Ids for contacts coming from another system.
I need to export all of the contacts from salesforce where the id is in the CSV.
I was thinking of doing an update with ...
0
votes
0answers
16 views
How to associate Assignment rule to territory via Data loader
I've uploaded territories, Assignment rules, Assignment rule items but I'm not sure how to associate an active assignment rule to a territory through data-loader?
0
votes
1answer
15 views
How can I stop using Data Loader to assign owners to Campaign Members?
Salesforce Enterprise Classic
I have an outbound team of 10 individuals. We are calling contacts and leads for various reasons.
Our Marketing Automation Platform populates Salesforce Campaigns with ...
0
votes
0answers
85 views
INACTIVE_OWNER_OR_USER, owner or user is inactive
I got an issue when I want to load (data through Talend) to Salesforce.
When I do the upsert, I have like 50% of upsert errors with this message :
CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY:UserTrigger: ...
0
votes
2answers
50 views
How can I insert records from one sandbox to another sandbox?
I have sandbox shared for my team and I have personal sandbox. How can I insert records sandbox shared for my team to my personal sandbox? I have required objects and fields.
I don't need to insert ...
0
votes
2answers
34 views
Force RecordTypeId to Null on Contact
I am working in a very old org where majority of the contacts do not have a recordtypeid, and contact visibility, page layout assignments revolve around this master no record type id contact record.
...
0
votes
0answers
10 views
How to upsert child records with invalid foreign external ID(parent external ID)?
I am trying to upsert contact related to account using CLI Data Loader. We have a requirement to insert contact successfully even if the account with the external ID doesn't exist. For Example, if ...
0
votes
0answers
24 views
Import Knowledge invalid encoding for import setting: CSVEncoding
I've formatted my Solutions articles to fit the Knowledge fields and rich-text fields, downloaded and enter the correct parameter for my .property file and I keep getting an error of:
The .properties ...
2
votes
1answer
71 views
EmailMessage Storage Issue [closed]
Currently we are facing storage issue in org production. It is reached to 90%. Most of the storage is consumed by emailmessage. We looking different solutions. We are planning to extract the ...
0
votes
1answer
20 views
Update using External Id
I understand UPDATE operation doesn't support ExternlID.
Is there any other way i can use Dataloader to update Salesforce records using external id ?
If i use UPSERT operation, i don't want to ...
0
votes
1answer
31 views
What is the difference between supported Salesforce, Apex, and Dataloader text encodings?
If I export a file of Custom_Object__c with a Custom_Field__c (developer console and salesforce page layout displayed) value of:
XX – XYZ
I receive an exported CSV with:
XX � XYZ
If I open that ...
0
votes
0answers
37 views
Dealing with failed records in an Upsert operation
With the help of responses to my previous posts I was finally successful in Upserting Contacts in Salesforce via Jitterbit using External Id. However two records failed. I am thinking these failed ...
0
votes
0answers
25 views
Dataloader - Upsert Contact and Relate to Account
How can I UPSERT Contact and relate it to the Account ?
Data Structure
Supplier_ID__c (External Id on Account )
Supplier_AdminID__c (External ID on Contact)
Supplier_ID__c (lookup field on ...
1
vote
1answer
27 views
What is ACT! in Salesforce
What is ACT! in Salesforce
https://help.salesforce.com/articleView?id=exporting_from_act.htm&type=5 article talks about this and I see ACT! file on data import wizard and in one trailhead link but ...
1
vote
2answers
49 views
Exporting data from partial sandbox to developer sandbox for related objects
I am trying to export Account and Opportunity data using data loader from partial sandbox to the developer sandbox. Currently, the hurdle is that in Opportunity Account is a lookup and required field.
...
0
votes
0answers
22 views
Command line Data Loader for scheduled import of parent and child records
I am struggling with an urgent issue related to periodically scheduling data import using Dataloder CLI.
We are planning to use command line DataLoader for scheduling the data load for multiple ...
0
votes
0answers
76 views
findDuplicates size() always 1 - how to prevent duplicates on accounts created from a trigger on a custom object
When a custom object record is created, I'd like to create a personAccount from that record's field values, but I also don't want to create duplicates. I'd like to use the standard duplicate / ...
0
votes
2answers
27 views
Data Loader - Connect Activity/Tasks to Quotes?
I'm Data Loading from Org to Org.
Accounts, Contacts, Opportunities, Leads, Activities, Products, Price Books, and Quotes are all complete.
I just finished Quotes.
Activities/Tasks are showing on ...
0
votes
0answers
36 views
Do customer community/customer community plus licenses have access to Data Loader/Data Import Wizard?
I want to know if customer community or customer community + user licenses have access to data transfer applications like Data loader or Data Import Wizard? If not, is APEX driving custom component ...
0
votes
1answer
222 views
Dataloader stuck while exporting object
I have installed dataloader version 48 in my mac, I too have installed Zulu Java Sdk. I am trying to export Account object data from the sandbox and so far I am able to login using Password ...
2
votes
1answer
367 views
OAuth+SSO login works with Data Loader GUI but not Data Loader CLI
GUI
On my Windows machine, I can login with GUI Data Loader 44.0.0 without providing a username and password, by choosing "OAuth" and "Production" environment and clicking "...
3
votes
1answer
108 views
Is it impossible to export more than 2000 records from an aggregate SOQL query?
It seems odd to me that this would be simply impossible to do, but the aggregate query below returns more than 2000 records, and it appears that there is no possible way to even run the query, let ...
0
votes
0answers
108 views
Salesforce removing line breaks when importing data from CSV
We're currently busy with a migration of data from our old system to our brand new Salesforce system.
As part of this migration, we're migrating data fields that contain flat text with line breaks, ...
1
vote
2answers
25 views
How many parallel connections can be made for a single generic users?
I have a downstream system which will take data from SFDC to Snowflake through Talend Job. But I am connecting to SFDC through one generic user. Is there any limit on haw many jobs I can parallely run ...
0
votes
1answer
24 views
Data Loader - Command Line - Field Aliases
I am trying to extract data using Data Loader command line but can't get aliases to work.
The following SOQL query will work perfectly fine in the Developer console:
Select Hub_Name__r.Name ...
