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

0
votes
0answers
8 views

Will Data Loader for Salesforce 5.x End of life with Cload Data Loader 6.x 4/15/2015?

It was announced Data Loader 6.x will reach End of Life on April 15, 2015 and will cease to communicate with the Harmony Cloud. Causing existing operations to stop running. We have still have jobs ...
0
votes
1answer
16 views

mass create orders in Salesforce with link to opportunities

I'm trying to mass create order objects with some opportunities data. I have no trouble to create those orders with the Dataloader or the developer workbench, but for some reason, the field ...
3
votes
1answer
92 views

Can we load 20 k PDFs in attachment object like we load data using dataloader

Our client has a requirement to load his agreement PDFs & word docs inside salesforce account -> agreement -> notes & attachment. I am looking for fastest solution like Dataloader insert but i ...
0
votes
0answers
10 views

Is it possible to move object in an org with data into a manage package

We have couple of custom objects and we are planning to migrate to manage package. Is it possible to move object to manage package or data migration is the only options. Do we have any tools which can ...
3
votes
4answers
135 views

Salesforce large query conditions: query 20000 contacts by emails and update fields

I have a csv file which has 20000 email addresses in it. I need to update some fields on these contacts. the dataloader is not suitable as I don't have the ID field of these email addresses. query in ...
1
vote
0answers
32 views

Data Loader : the operation has fully completed there were 0 successful inserts and 2 errors

I have problem when I insert file .csv via data loader after mapping I get : the operation has fully completed there were 0 successful inserts and 2 errors I don't know what's the problem exactly. ...
0
votes
2answers
23 views

Cleaning Activities Data

I'm trying to lower the storage usage. I know that the archived Tasks is taking a lot of my storage. I tried to do it several ways but still no success. 1. I used the Data Loader "Export All'. My ...
0
votes
2answers
54 views

Problem with adderror method

Below is the scenario, I have wrote a trigger which on updating the account program status, updates the Opportunity stage name which in turns fire another trigger which clones another another ...
0
votes
1answer
17 views

How to specify the order of columns generated in the excel sheet when exporting from Salesforce using DataLoader?

I want that the exported csv file has a particular format of columns. Eg I want the first Column in the sheet to be "Name' second as "address' and so on..
1
vote
1answer
27 views

How to dummy mass update via Apex Data Loader?

I built a trigger on Object 1 which has a field, field1 which when updated will calculate another field, field2 in same object (had to use trigger for it's complexity). Now my question is that field1 ...
0
votes
0answers
19 views

Unable to insert into a Feed object for a Custom Object

I created a custom object (funding__c). The associated posting object that got created is (funding__feed). I'm using Informatica Cloud to load existing posts into the (funding__feed) object. I get ...
0
votes
0answers
20 views

MS Access To Salesforce

I am trying to automate data load from MS Access to Salesforce, using the command line data loader but unable to. Anybody has done this / is this possible ?
0
votes
1answer
32 views

Trigger causing NullPointerException only through Data Loader

I've developed a trigger to run if an Account owner changes, and based on the profile of who it changes to, update upcoming events titled "Welcome Call" to match the account owner. This runs fine for ...
0
votes
0answers
26 views

Error in Dataloader - execution of AfterUpdate caused by: System.NullPointerException: Attempt to de-reference a null objectTrigger

This issue just started happening this week with no change to our code. We use dataloader regularly to update a field on a custom object. This custom object does have some Apex before and after ...
0
votes
0answers
14 views

Salesforce to salesforce data transfer using jitterbit

How dow I connect 2 salesforce orgs using jitterbit? I've installed the latest version of Jitterbit, but I couldn't find a way to connect 2 salesforce orgs. But the app exchange description says you ...
-2
votes
1answer
30 views

i want tool to exchange data between oracle db to salesforce?

i tried to import data from oracle db to salesforce , i want a tool is available in salesforce let me know it helps in my project. Thanks, prince
1
vote
1answer
36 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
30 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
28 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
24 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
26 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
42 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
63 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
39 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
39 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
80 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
48 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
99 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
71 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
46 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
51 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
1answer
28 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
50 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
24 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
50 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
52 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
35 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
17 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
32 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
303 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 ...
2
votes
3answers
231 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
32 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
36 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
62 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
34 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
225 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
160 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
21 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 ...
6
votes
3answers
343 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 ...