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

1
vote
0answers
15 views

data loader concatenate transform data from csv without changing csv

we have a scenario where we will be getting input data in csv files. we need to load these in custom objects in salesforce. we do not want to edit these csv files. there are scenarios where we need to ...
0
votes
2answers
26 views

how many records we can insert using Jitterbit data loader at a time? [on hold]

how many records we can insert using Jitterbit data loader at a time ?
0
votes
0answers
10 views

Best way to migrate binary attachments from one org to another

Currently I am using apex data loader with bulk api enabled and batch size =1 . But its giving me failed to create batch when i try to import 1000 files with each size around 100kb. I need to ...
2
votes
1answer
30 views

Best Practise: Data Migration

I want to run a data migration using dataloader. I have changed the structure of my database and now I need to migrate the data. I am just wondering what is generally done in terms of testing the ...
1
vote
1answer
23 views

Error while uploading records

I hope you all are doing well. i have one question regarding dataloader error. Whenever i was trying to upload records i was faced the below error. "Attempting to update (as part of an upsert) ...
0
votes
0answers
31 views

When is an insert checked for errors

In a dataloader I want to insert information into the database. This information has a lookup with a different ID than the Salesforce ID. What I want to do is run a before insert trigger that checks ...
0
votes
0answers
11 views

using CMD data loader to find accounts whos ID is IN List/Array

I have a list of accounts that need to be updated but this list is not available in SF, this is only available in a remote Desktop environment. The accounts in this list do not have a SF ID; they do ...
0
votes
0answers
28 views

Is it possible to know if an upsert was done by dataloader?

I have a dataloader that will upsert information into SalesForce. I get the fields that need to be upserted from a third-party. Some of the fields on those objects are set to mandatory by validation ...
1
vote
2answers
55 views

error “AccountTriggerBefore: System.LimitException: Too many query rows: 50001”

I get error "AccountTriggerBefore: System.LimitException: Too many query rows: 50001", when attempting to change owner on account object via Apex Dataloader. There are 131 records that I am ...
1
vote
3answers
38 views

How can I export object's field schema information to excel?

How can I export the fields of an object from Salesforce into an Excel sheet ? I dont want the data !! I want the fields, kindly help me
0
votes
0answers
16 views

Data Load into Accounts (Std Obj) with a Lookup to Custom Object

The issue is that I am not able to map the LookUp Field with a value from the CSV as the Lookup Field is not displayed for Mapping. Tried Import Wizard, Data Loader, Workbench, Jitterbit ... None of ...
0
votes
0answers
31 views

Multiple File Data Set Import Cleaning

It is pre-Salesforce import, I have designed the Named Account structure inside Salesforce, and I have 1500 Hoover's D&B Family Trees with the same columns and headers in .xls form. What do I use ...
1
vote
1answer
34 views

can I upload user's profile image via data loader

I have a several user photos, is there a way of uploading them to the user's profiles en mass?
0
votes
0answers
17 views

How to Import the Data For Updation operation Lookup Field using SalesForce.Com Id as a record Identifier

I had a one object called Media. In that Media Object There is one standard field name called as 'Media ID' is there and there is one more field called "Branch" is there (actually a Lookup From the ...
-2
votes
1answer
67 views

Cannot Specify Id in an insert call error [duplicate]

I have been trying to do a bulk load of accounts in salesforce and it keeps triggering the following error UpdateCSMTeam:execution of AfterInsertcaused by: System.DmlException: Insert failed. ...
2
votes
1answer
81 views

APEX Dataloader fail INVALID_FIELD_FOR_INSERT_UPDATE, cannot specify Id in an insert call

I have a trigger and a class that seem to be causing an insert fail in Dataloader. I am trying to insert 200 records to see if an error is generated before moving these to production. I'm just ...
0
votes
0answers
15 views

Data loader execution from Java Application

I'm trying to build a custom app using Java, where it will take input csv file and do some validation and data enrichment (Picklist, dependent picklist field ) and based on the outcome it will insert ...
5
votes
3answers
175 views

Reliable way to import thousands of attachments to Salesforce?

I need to migrate 5GB of attachments to Salesforce. I've created the mapping file and have been able to successfully upload some files using Data Loader (Lexi Loader). I'm currently running into the ...
2
votes
1answer
82 views

Extracting Formula field in Data Loader Command Line Interface (CLI)

Need help. Can formula field be used in Command Line Interface ? I have a requirment to automate the extraction process.And i have created few formula fields as per the requirment.but i keep getting ...
1
vote
2answers
56 views

Design Query for implementing high volume periodic imports

We plan to implement periodic bulk import of records into our Salesforce. If implemented, then we would be importing around 2-2.5 Million Records into a custom object per day. Since this is a ...
1
vote
1answer
35 views

Cannot find Accounts table when using jitterbit data loader

I am using Jitterbit cloud data loader to sync a local MySQL database with my salesforce Objects. While most of the objects can be found, I am facing following issue. I would be grateful if i can be ...
0
votes
0answers
38 views

Using Dataloader.jar in Unix environment ? Is it possible to run with command line and shell scripting

I know, it's has been asked already . Unfortunately , it's not clear to me and i don't know how updated it is. http://stackoverflow.com/questions/4303024/apex-data-loader-in-linux-environment Can I ...
1
vote
0answers
64 views

Dataloader Export CSV Issues: how to remove quotes & add empty column

In a requirement , I have to extract the file in .csv and copy it over to a FTP location. I am doing it with command line dataloader and facing following issue related to it. 1) They are asking to ...
1
vote
2answers
81 views

Data Loader - Automated way to import data with parameters from Command Line

Can we automate the process of a data import operation with the following conditions ? -> The .csv file containing the data to be imported is present in the particular folder. -> The custom object ...
0
votes
2answers
76 views

How to Import data into SQL Server using Data Loader

How to integrate SQL Server and import data into a SQL Server database table directly from Salesforce using the Data Loader. Can anyone provide me steps to solve this.. Thanks,
0
votes
3answers
66 views

Can we export TAB delimited file from Salesforce [duplicate]

I have a requirement to export the tab delimited file from SFDC. Can we do it apex dataloader. I believe, there is no way to do it ? let me know if there is a workaround. has anyone used some good ...
1
vote
2answers
98 views

How to do move Pricebook and Products from sandbox to production

As the title suggusts, I have created a pricebook with a list of products and their prices in my sandbox, I would like to know how I can export this data into my production instance.
2
votes
1answer
78 views

Are static variables reset per batch during bulk DML operation? (Executing triggers for field updates)

A while back I had a trigger issue where I needed a trigger operation to execute exclusively on the second update or an update after an insert. So I had some code like this: Trigger Handler Class ...
1
vote
2answers
34 views

How can I update the MobilePhone field with the Data Loader?

I'm trying to run a mass update of a group of leads to include data for mobile phone numbers, but the MobilePhone field seems to be missing as an option in the DataLoader mapping setup. (Someone ...
0
votes
0answers
58 views

Error using ExternalID to reference Opportunity when loading Quote via DataLoader commandline

I am getting an error that states "Required fields are missing: [OpportunityId]" when I try to upsert some Quote records via the DataLoader command line (part of a nightly data load process). The ...
5
votes
1answer
240 views

Is it possible to use SSO with Dataloader?

I'm trying to determine what SSO scenarios are supported with Dataloader via both the GUI and the CLI. GUI (Graphical User Interface) Does Dataloader GUI work with SAML? Does Dataloader GUI work ...
2
votes
5answers
193 views

Migrate history data from one org to another

We have a migration project from one salesforce org to a new salesforce org. We have migrated all the configuration and data. Now the client wants to know whether the history data (accountHistory, ...
0
votes
1answer
61 views

Error while using Command line interface

While running encrypt.bat -e "C:\temp\key.txt" I am getting the error below : 014-09-10 15:31:06,811 INFO [main] security.EncryptionUtil main (EncryptionUti l.java:289) - Invalid option ...
2
votes
1answer
92 views

How to preserve relationships upon data import?

I've set up lookup and master-detail relationships between objects in Salesforce, and I have SQL-exported CSVs of legacy data which mirror these relationships. How do I preserve the existing ...
1
vote
2answers
132 views

Date time zone incorrect

I am configured as (GMT-05:00) Central Daylight Time (America/Chicago) Time zone in salesforce.. I am trying to export case history and all the date fields are exported in GMT. Where as when I create ...
2
votes
1answer
79 views

how do we load huge attachments to salesforce content

i am looking to load multiple huge video files (100MB x 10) in separate files into the content object in salesforce. I intend to load the files into a particular library which is already existing. ...
1
vote
1answer
79 views

Can Apex data loader be installed in Windows server 2012

Will data loader work in windows server 2012
1
vote
1answer
184 views

Copy Opportunities with LineItems with TalenD

One way to solve the datamigration challenge in Salesforce seems to be the usage of ETL-Tools. Looking around for a free and powerful approach, I found here at SFSE some recommendations of TalenD - It ...
4
votes
1answer
261 views

Datamigration Salesforce to Salesforce with TalenD - Best Practice for Self-Referreces

Assuming metadata is already identical, the data-transfer of complex models can still take hours or even days of manual work. Fortunately there are free tools like TalenD which can help to automate ...
1
vote
2answers
136 views

how to execute Territory Assignment Rules when update or insert Accounts from Data Loader

I need to assign Accounts in different Territories based on the criteria rule when inserting or updating Accounts from Data Loader. In Data Loader we have to provide the assignment rule Id to ...
1
vote
0answers
36 views

Field Mapping doesn't create all fields in CSV export

This is my SOQL query: SELECT Count(Id), Category__c FROM Case WHERE CreatedDate = THIS_MONTH GROUP BY ROLLUP (Category__c) ORDER BY Category__c DESC It works fine when using the DataLoader GUI, ...
2
votes
1answer
44 views

how to change the case creator

I want to be able to change the case creator (I have a workflow rule that fires an email when the case goes to "waiting on update" and sometimes the case creator needs to be updated to prevent the ...
2
votes
1answer
121 views

List of Items we cannot migrate with Data Loader

I have to migrate whole Full Copy Sandbox org to my new Production that includes the following majorly: All Standard/Custom object records. All Note & Attachments part. All Libraries & ...
0
votes
0answers
34 views

C# Api compare to ApexDataloader

I am trying to load table from salesforce into excel cvs, for that used, I tested the ApexDataLoader and found out that to load whole lead table for my organization take around 4~5 min, and have ...
0
votes
1answer
138 views

“FIELD_INTEGRITY_EXCEPTION:Week: invalid date: Fri Jun 29 00:00:00 GMT 14 Error fields: Week__c ” [duplicate]

I am getting below error when I am trying to insert records using data loader.I see file contains Week__c column with value as 6/29/14 and Week__c is Date field in the custom object.What may be the ...
1
vote
1answer
129 views

Conga template with apex trigger

Hi I am new to apex code and I need to create a trigger that fires off a call to appextremes.com/apps/Conga/PM.aspx when I tick a check box on a custom object. I am looking to update the checkbox via ...
0
votes
0answers
307 views

Error While Uploading Data Via Dataloader :Too many retries of batch save in the presence of Apex triggers with failures:

I am Getting this Error While Uploading Data by Dataloader. Too many retries of batch save in the presence of Apex triggers with failures: when triggers are present partial save requires that some ...
3
votes
1answer
65 views

Upsert externalIDField

I am trying to run an upsert from a batch script. I can't seem to track down any documentation on the actual mapping file when using an external id from a .csv file. How do I tell my upsert which ...
3
votes
1answer
91 views

Jitterbit time format issue

I am using Jitter bit to load the data into SFDC. I have the separate fields for date(Field1) and time(Field2) in my text file. I have the upsert query and I did the mapping for salesforce like this, ...
5
votes
2answers
284 views

Does Upsert alway change the last modified date of the record?

If I run an upsert on a theoretical 100 records, all of which already exist in Salesforce, but only 4 of which have changed field values, will the last modified date for every record be set to the ...