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
1answer
30 views

Dataloader converts text field with value of 0001 to 1 with Update operation

I have a requirement where I need to provide a company no. to all accounts i.e. unique. Currently I have 50 accounts and they don't have company no. and the format of the company no. be same as auto ...
1
vote
0answers
18 views

need help on how to Import phone number into salesforce using data loader

I'm trying to insert phone number using data loader as (XXX)-XXX-XXX format, but upon insert into sales force the number is displaying as XXXXXXXXX format.What i need to do to display phone number as ...
0
votes
0answers
14 views

Where can I find v1.9.0.2 of Enabler4Excel?

Where can I find v1.9.0.2 of Enabler4Excel? I have v1.8 but after 1.9.0.2 they changed from free to a paid model. I don't use the tool often but it's handy once in a while.
0
votes
2answers
18 views

INFORMATICA free version of data loader : Does it support bi-directional sync?

Using a Corporate Enterprise Licence, I don't have access to BULK or SOAP API but only to REST. It seems that the best way to do cost effective interfaces to external tables / files would be to use ...
0
votes
1answer
17 views

dataloader - how to assign recordtypes

In my SF db I have 3 different Account recordtypes, and I want to import the data for 1 specific record type now. I have mapped all my fields, but cannot find the record type field in the mappings? ...
1
vote
1answer
25 views

Duplicates inserting from csv to salesforce through jitterbit data loader! [closed]

I am using free Jitterbit to load files (.csv) from SFTP into Salesforce (custom object). In FTP, xls files are fed and is converted into .csv file (via php) and that csv file is inserted into ...
0
votes
0answers
28 views

UPSERT opportunitylineitem via apex dataloader commandline causing Error code is:DUPLICATE_VALUE

I have created a external id field and made it to unique and is having combined text by concatenating OpportunityId and PricebookId; I have .csv file with PriceBookID, Opportunity Id and other ...
0
votes
1answer
27 views

Apex Dataloader : batch size parameter

I have a a file of 5000 recrods in a batch,which fails due to Apex CPU time issue but works fine when execute with 40 records at at time.I dont want to fix Apex right now) but I want to know,how to ...
0
votes
1answer
23 views

Issue with Nested Queries Support in Jitterbit

I am using free jitterbit cloud data loader to extract data from my salesforce.com Org. But i am getting an error saying "Nested Queries are not Supported". So what do i need to have in order to make ...
0
votes
1answer
35 views

The MIME type of the selected file is not allowed

When I am trying insert data using .csv file from Data Import wizard in salesforce, I am getting this error "The MIME type of the selected file is not allowed". My csv file contains a single column ...
1
vote
2answers
37 views

Apex Dataloader -IN Operator issue

We need to run a job on 1000's of records by filtering over an ID. In the dataloader when the condition section doesnt show IN or contains or LIke option. However i tried to put a condition manually ...
2
votes
3answers
96 views

Slow Partnerconnection response

I am developing a custom app for my organisation based on Partner API. In my org, the case object has large number of fields (70+). The custom app takes almost a day to fetch 26000 case records ...
0
votes
1answer
41 views

how to update opportunity line Item to refer a new Pricebook

We want the existing orders on old PriceBooks to be update to New PriceBook via dataloader. Is it possible to do this without following the below steps:? Delete line items update order header with ...
1
vote
2answers
40 views

Automating moving data from Prod to Dev

I have roughly 7 objects - some with relationship to each other and some stand alone. I have to repeatedly copy the data from the production org to one of the dev orgs (there is roughly 10 so you can ...
1
vote
1answer
36 views

How do I make the checkbox checked when loading data from .csv file

I am trying to populate a check box in a custom object with "checked" (True/1) using Apex Data Loader v 32.0.0 in command line mode. I have tried all values documented => True, TRUE, YES, Y & 1 ...
0
votes
0answers
24 views

Update custom object from CSV [duplicate]

I'm receiving CSV file with some data which I'd like to update within a custom object in SFDC. Does anyone know a good way to do this automatically on a daily basis? I'm trying to use Talend but I"m ...
1
vote
0answers
21 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
41 views

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

how many records we can insert using Jitterbit data loader at a time ?
0
votes
1answer
22 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
44 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
39 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
34 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 ...
1
vote
0answers
15 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
30 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
150 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
96 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
27 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
34 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
50 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
23 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
138 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
118 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
18 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
261 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
94 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
65 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
39 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
60 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
77 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
103 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
95 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
80 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
144 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
106 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
39 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
68 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
296 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
231 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
86 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
111 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 ...