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.
796
questions
0
votes
1answer
35 views
SOQL Query with three objects fails
I am quite new to SOQL and ran into a problem with my query in SOQL Query on Workbench.
My goal: Identifying all contacts which are in campaign "Hello" but NOT in campaign "Ciao".
...
0
votes
0answers
15 views
Notes migration from Salesforce ORG showing html tags
Migration of Notes: we migrated .notes from DEV org to PROD org but when I open the notes in the PROD I'm getting html tag along with the notes something like this:
> <p> ...
0
votes
2answers
29 views
Salesforce Dataloader - Accept duplicate values during upsert
I'm trying to perform an upsert using the Dataloader. Basically, I have records with duplicate ID numbers. This is not a mistake (but probably a source of larger data integrity issues). They are two ...
0
votes
0answers
39 views
How should I login via community user login credentials in Dataloader?
I have given Enable API access to community user. But Still not sure about the settings on dataloader.
As community user cannot login via login.salesforce.com and test.salesforce.com how should I ...
0
votes
1answer
22 views
load contacts by first name, last name, email or phone
I have a spread sheet from the business to load contacts and a related child object to contact. The business wants to load the contacts by the below matching criteria.
First Name, Last Name, Phone
...
0
votes
1answer
20 views
Dataloader import field as current datetime now
Is it possible to run a data loader import and set one of the fields being updated to the current date time of Now()? What is the best way to accomplish this? I was thinking of creating a temp ...
0
votes
0answers
11 views
Process Builder - Scheduled Actions for 'some' records did not execute upon mass update
Issue: Process Builder Scheduled Action for some records was not triggered when Data Update was performed
Scenario: Process Builder (time based)
Criteria: Case Status = Pending,
Result: (6 Days from ...
1
vote
1answer
23 views
Getting an Error on a scheduled job, but can't find the error
We have a scheduled job on Contacts that runs once a week. We have a couple processes that are also on Contacts. We are in the process of transitioning Workflow Rules into our Processes. Some there ...
0
votes
1answer
13 views
Contact Record Limits
We are working on a new implementation and have 5 million contacts in our existing database. What do I need to consider before migrating those over? I do not plan to use much salesforce reporting.
...
1
vote
0answers
23 views
Data Loader functionality issue
I'm consistently having issues with Data Loader functionality.
When I try to run Data Loader 50.0 with Zulu 11 (for MacOS 10.13 or later)when I attempt to browse for CSV files, it always greys out and ...
0
votes
0answers
59 views
Installing Data Loader Issue On Windows
I am following the instructions to install Data Loader here: https://help.salesforce.com/articleView?id=loader_install_windows.htm&type=5
I have met all of the requirements.
I extract the zip and ...
0
votes
0answers
39 views
Mass update permission set using data loader
I am trying to update current permission sets with the new on, so how to do bulk updation on permission sets with data loader? so I just want to remove old permission set and assign new permission ...
0
votes
1answer
22 views
Custom metadata loader Mapping
I am using custom metadata loader to perform the insertion of custom metadata with 200 records. Although I have mapped the values correctly I am hitting the below mapping error.
Note: There is no ...
0
votes
1answer
24 views
Custom notification Limit on Data Loading
I have a process builder which fires custom notification to case owners when the case is updated.Its working fine in normal scenario.
But I needed to Data Load(Update) 200000+ records which inturn ...
0
votes
1answer
20 views
Pull data from sql to salesforce
I am looking to generate reports and dashboards on Salesforce and the data reside in my SQL server.
How do pull data from SQL to Salesforce in order to create reports & dashboards in salesforce
2
votes
1answer
108 views
Salesforce Dataloader on Mac doesn't work past the select object page
I have attempted to use the Dataloader download for Mac several times to no avail. I am able to get to this screen (First Picture):
Once I hit next, I get a message stating: Initialization succeeded.
...
1
vote
0answers
41 views
Get RecordID based on ExternalID
I always stumble upon this situation - I have csv file with 200 records and each record has an ExternalId. These records may or may not exist in Salesforce. In Salesforce I have an ExternalID field.
...
0
votes
1answer
35 views
What are the limitations of using data loader command line interface to back up data on a schedule?
I coulnd't find an easy documentation on what the limitations are.
Does Data Loader CLI support All objects custom and standard?
Does it support metadata and files?
Does it support static resources?
...
0
votes
1answer
34 views
Validation rule working when manually entering values but not working when import using dataloader
I have the following validation rule on contact:
OR(AND(MailingCountry = "Other Locations", ISPICKVAL(other_locations__c, "")), AND(NOT(MailingCountry = "Other Locations")...
1
vote
0answers
34 views
Does SSO login works with Data Loader CLI? [duplicate]
For security reasons we are establishing SSO login to the entire org but we are facing an issue coming to Data loader CLI users. In CLI the username and password are provided in the process-conf files,...
0
votes
0answers
22 views
How to move notes created in one org to another org?
I need to migrate content notes (enhanced notes created in Salesforce) from one production org to another. I have followed this excellent Stack Exchange post but I have a couple questions:
Do I ...
1
vote
1answer
32 views
Dataloader is extracting records that have been hard deleted
I ran an export all on event records that returned about 7 million records. The export timed out around the 6 million mark. I went ahead and ran a hard delete on the 6 million records which ran ...
1
vote
0answers
96 views
Launching Data Loader without a command (shell) window
I just downloaded and installed the most recent version of data loader and I also had to install the Java Zulu OpenJDK 11 pack. I've successfully installed data loader and every time I run it, the ...
0
votes
0answers
26 views
migrating accounts and keeping ids on import to relate to opportunities
I've been tasked with moving a small amount (under 5,000 records) of accounts, contacts, and opportunities.
I combined and cleaned everything in R/Excel.
I have imported all of the accounts and ...
0
votes
0answers
18 views
Export Salesforce record to SFTP [duplicate]
What are the possible ways to send salesforce records to SFTP if we want to send the data in a text file? What tools can we use to connect to SFTP. Any help would be much appreciated.
0
votes
0answers
38 views
Dataloader stopped working after installing Ant [duplicate]
I installed Ant and after this, Dataloader stopped working - when I run Dataloader then this window is popping out:
After this, about there is line "The system cannot find the path specified.&...
0
votes
1answer
30 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
36 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
102 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
99 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 ...
4
votes
1answer
399 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
43 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
25 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
67 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
32 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
16 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
20 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
19 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
150 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
90 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
25 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
57 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
29 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
101 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
41 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
22 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
38 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
77 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
39 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 ...
1
vote
2answers
282 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.....
