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.

learn more… | top users | synonyms

2
votes
1answer
29 views

Data Loader and after update triggers running twice

I have a scenario. I am updating some Opportunity records through Data loader which causes after update trigger to run twice and cause issues. It shows that some WF Field update runs again and then ...
1
vote
3answers
36 views

Apex trigger runs OK while editing Account, fails in DataLoader

The trigger in question reassigns cases from the updated account to another account given a criteria defined by a single custom field in those cases. Basically, if "Case.ReassignTo__c" has a value, i ...
4
votes
3answers
58 views
+50

Data Loader Command Line Tool slow

I am trying to automate a data load using the Command Line tools and have everything working smoothly but it is taking 10x longer than if I do it through the Data Loader GUI. Below is an exert from ...
0
votes
1answer
35 views

How to assign old leads to a new particular record type in Enterprise Edition(EE)

I am new to sfdc. i want to assign old leads means leads created before record type is created.so,I want to assign these old leads to a new particular record type.I had tried to assign using ...
2
votes
1answer
23 views

How to enable Hard Delete option in data loader?

Can anyone have any insights regarding the activation of Hard Delete option in salesforce data loader?
0
votes
1answer
26 views

How to import login ip ranges in salesforce using data loader?

Can someone let us know how to import login ip ranges in salesforce using data loader? Thanks, Pankaj
1
vote
0answers
20 views

How to move/migrate old notes to new Notes?

With the new Notes, my users complain that they want all of their old notes in the new format. Knowing dataloader, I am trying to export all of the old notes and insert as new Notes, but I can't find ...
0
votes
1answer
23 views

Dataloader update of Opportunity Products is not firing trigger

I have a very simple before insert, before update trigger on the OpportunityLineItem object that updates a couple of field values based on other fields. When I update an Opportunity Product record in ...
1
vote
4answers
34 views

Automating the dataload

We use some client application named Rally tool where we extract the csv file daily and we need to update those records into salesforce on a daily basis. Now I need to make this process automated. I ...
0
votes
1answer
29 views

Mass reassign / upsert account team member

Is there any possibility that we can mass "Upsert" account team member? We have sales reps changing from different accounts, so how do we change assignments for all sales reps as an account team ...
1
vote
1answer
23 views

Updating Fields with Data Loader

If I upload a field (from a CSV file) using the update record pathway through the data loader and the field value is empty, by default does SDFC not overwrite the cell? Does it only update if the ...
0
votes
1answer
34 views

ContentNote Insertion through DataLoader

I see ContentNote has been introduced as enhanced note feature, Can anyone let me know in what format I need to insert the contentnote in a particular object via dataloader.io I am getting the error ...
2
votes
2answers
43 views

Import Notes in an object

I would like to import Notes via INSERT in a particular object using Dataloader.io , have tried various times but not able to. Can anyone tell me the .csv file format which needs to be used while ...
1
vote
1answer
59 views

access denied error in command line data loader

I am getting below error.Please suggest me how to resolve below error.I am pasting error log below 2016-01-05 10:59:17,448 INFO [main] support.DefaultListableBeanFactory preInsta ntiateSingletons ...
1
vote
1answer
34 views

Command line data loader incremental/Delta backup

I have one requirement based on command line data loader but with incremental or delta backup.I need to write data on files which is located to other external system.Could you please help me in ...
-1
votes
1answer
16 views

modified date or create date modification on Task import using DataLoader

I am having an issue importing Task using Dataloader. When I import it creates a new CreateDate per task imported. Can the CreateDate be modified to its original create date?
3
votes
0answers
42 views

Importing multi-picklist values using data loader salesforce

In my Salesforce Org. I have a custom field multi-picklist called Category. Then it has list values of (Y Connect, Board Member, Annual Report, Celebrity). I do an import recently and the imports are ...
0
votes
1answer
50 views

How do I pass values from a BEFORE trigger to an AFTER trigger to do an update to another object?

I have a BEFORE insert/update trigger on InvoiceLineItems which filters out certain line items that are not product lines (they are text narrative lines). This works nicely using the .addError option ...
2
votes
2answers
72 views

Dataloader fails to insert data due to different date format

I am loading data from a CSV file to my salesforce org using Dataloader.io. One of the fields for the record is a date field. In my salesforce org I have changed the time zone to (GMT+05:30) India ...
0
votes
0answers
20 views

Scheduled data import in Salesforce from a folder/database

My current customer is working on a differen CRM and they upload data in the CRM on daily basis (though an automated scheduled job). To achieve this, there is a middleware in place that exports and ...
0
votes
1answer
33 views

Loading files to Documents : Standard object

Loaded some external files in to the sandbox using dataloader. Specified the path of the file in the Body column. The documents got loaded successfully. I have tried the same from one datastage job. ...
0
votes
0answers
16 views

Records missing in data loader export

I am exporting the data from an object with the credentials of an user who has read and edit access to that object. The object OWD is public read write. The user can see all the records of the object ...
0
votes
0answers
39 views

Not able to delete old record types Undo

We are in the process of upgrading new changes to our Salesforce org. For this we are mapping some old record types to the new ones and are using data loader for the same. When we run a report on ...
0
votes
2answers
41 views

How do I Mass update owner in Contact and Account?

In my ORG I have a 20K Accounts and 50K Contacts. I want to update Contact and Account owner where owner is "Jai" to "Mrugesh". How to update all Contact and Account owner?
0
votes
3answers
28 views

Data Loader upsert with external id and opportunity id

Some of our opportunities are created in Salesforce and others are created in another system. I'm trying to make sure they all end up in both systems. When using upsert, in the data loader (just ...
0
votes
0answers
13 views

Data Loader manual run error “ System.CalloutException: sun.security.validator.ValidatorException”

I get this error when I want to run Account.cmd manually. System.CalloutException: sun.security.validator.ValidatorException Can anyone help? it's urgent Thanks in advance!
1
vote
1answer
38 views

Date/Time Field Being Passed Via Integration

We are passing date/time values from another system to a custom date/time field in Salesforce, and having timezone issues. We're passing in the org's timezone, which is central time, but it seems ...
1
vote
0answers
27 views

IMPORTING DATA - Is there a sequence when it comes to importing?

It there an actual way to import records? I know the sequence is this for standard objects 1. Accounts 2. Campaigns 3. Contacts 4. Opportunities 5. Cases 6. Solutions 7. Pricebooks 8. ...
1
vote
1answer
39 views

Replace Data Loader with a Web Service

I was planning to build an automated Data Loader process that would read a CSV file and populated the Account and Opportunity entities. There would also be some Account matching on existing records. ...
1
vote
1answer
14 views

Dataloader: upsert a Lookupfield

How do I upsert data with dataloader to a custom object? I have one Lookup field ("Class id") in the record that course trubble: I get following error notifications: "Class id: id value of incorrect ...
0
votes
1answer
53 views

Duplicate Rule is preventing update on possible duplicate record(s) even with Allow setting

I have a duplicate rule (via Duplicate Management) on account. If an account looks like a duplicate, I have it set to Alert and Report but Allow the record to be inserted/updated. For some reason, ...
2
votes
0answers
12 views

Dataloader - AES246 encryption during upload - Check java version for AES256 compatibility?

One of the key requirement from the business and as per the policy is to encrypt (using AES256) while the data is pushed from the Data Loader (deployed in the local machine) into SFDC (while in ...
1
vote
1answer
24 views

Data Loader from Command Line - Upsert Opportunity - Indicate Acccount Relationship Field

I'm using the command line of the data loader to upsert opportunities from an outside system to keep them in synch. I have a column with the Salesforce Opportunity ID, as well as, the associated ...
0
votes
1answer
38 views

Historical Account or Opportunity Owner not an Active User

My question is similar to: How can I import data owned by people who are not Salesforce users?. I realize I can't import new records that are owned by an inactive user account, but will I be able to ...
0
votes
0answers
14 views

How to mass update tags with Dataloader?

Probably a rookie question, but I can't see a way to update tags using Dataloader. I have the ItemIDs and the tags in a spreadsheet. But I can only see a way to upload tags themselves, not update an ...
1
vote
1answer
34 views

What is the fastest way to update a field on thousands of records?

I need to create a new checkbox field on an SObject, and I would like the original value to be true. Setting the default value of the field to true only applies to new records. What is the fastest ...
0
votes
0answers
30 views

Remove Users from Territory using Data Loader

I need to remove multiple users from the territory they are assigned to and would like to use data loader. I am wary to use the delete function and wanted to ask if anyone else has done this ...
1
vote
0answers
25 views

import data using data loader - How to use it secured?

We opt to use data loader to load the accounts, opportunites, leads etc in live. So the question is how to load it secured with some sort of encryption in live as these are critical data and we are ...
0
votes
0answers
17 views

Is it possible to insert value for required field without value in dataloader?

I have small clarification I need to upload excel file. I need to upload required field column without any value upload via data loader. Is it possible? Please can any one help me out for this issue
0
votes
0answers
15 views

UpdateContactSAPCustomerID: System.LimitException: Apex CPU time limit exceeded

I need urgent help for my problem,i need to update the accounts on priority but not allowing me to update,When i am trying to update a custom field on organisation(Account) through dataloader then i ...
1
vote
1answer
20 views

Workbench & Data Loader access

How can you restrict users from letting them access Workbench & Data Loader?
0
votes
1answer
20 views

Getting data loader error while uploading data

We are uploading bulk data through Apex Data loader,but getting an error message like -' FATAL_ERROR|System.LimitException: Apex CPU time limit exceeded'.Can you please advise me to overcome this ...
1
vote
1answer
55 views

System.LimitException: Too many SOQL queries: 101 Account dataloader

Unable to use Dataloader to import on account due to this error below AccountSetToLiveTrigger: System.LimitException: Too many SOQL queries: 101 My Trigger code is below trigger ...
0
votes
0answers
14 views

change owner using external id not allowed

Actually i am doing a backup and restore procedur for my client, and i want to restore their data with the owner set to the original user and not the one doing the insert. I am doing a mapping on the ...
3
votes
4answers
175 views

Loading data in Winter '16

There is a known bug where the latest data loader for Mac is not working. The workaround states: In the meantime, users may use the older version of Data Loader for Mac or Workbench. I assume ...
0
votes
0answers
16 views

Delete lead trigger not work after import

I'm trying to delete a lead according to condition I have, I wrote my code and it works on manual add new lead. But I tried it using Data Loader tool the trigger not fired and record created. ...
1
vote
1answer
31 views

Dataloader Batch Mode Extract CLI Process.bat Error

I am trying to do an extract via the CLI of dataloader and getting an error when I run my process.bat. Here is error message when running process.bat on csvAccountExtractProcess in the process-conf ...
0
votes
3answers
36 views

Export data types from Salesforce

I am trying to create an excel sheet of all fields for all of my Salesforce custom objects. I need to include each field's API Name, field label, and data type. However, when I do a bulk export using ...
0
votes
2answers
42 views

Data loader Error while Connecting to Sandbox error

I am using Data Loader for Inserting Data . But when i am trying to login it is giving me error. Thanks in Advance
1
vote
1answer
50 views

Cannot login to Apex dataloader 18.0

Downloaded the Apex Dataloader 18.0. Cannot login to Dataloader and error message is "Failed to send request to https://login.salesforce.com/services/Soap/u/18.0". 1) gave proxy details (username, ...