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
10 views

How can I upload/change user's profile image programatically or via API?

I know, that there is no way to mass-upload these images via dataloader as described here can I upload user's profile image via data loader ...
0
votes
0answers
4 views

Moving Appexchange Data to a NEW enterprise Salesforce. Whats the best backup or export on DataLoader

I know there are multiple options in backing up SFDC data. I am currently using the internal SFDC scheduled export and using DATALOADER to export each records. In Dataloader, do I have have to ...
0
votes
0answers
6 views

Programatically detertime error/success when Importing .csv file from CLI

I am importing data using the Command Line Interpreter tool. I am also getgin the error and success .csv files. But i want a programattic way to determine if the transaction succeeded or failed ...
1
vote
0answers
6 views

What if any are people's experience of Reliability, security and/or overall interaction with Syncfrog?

I'm looking into Syncfrog as a possible app for taking data and migrating it from Google Docs to Salesforce as a measure of updating existing contacts rather than creation. I was going to test it out ...
4
votes
1answer
43 views

Deploy “Rename Tabs and Labels” Object

I have seen a few stories touching on this topic but all I have found so far are for creating packages, not deployment from org to org. My question is simple - is there a way (either through data or ...
0
votes
0answers
7 views

Custom Opportunity force.com platform

I have standard object opportunity and for each opportunity I have attachment.As I am using force.com platform I have created custom object opportunity and moved all opportunity from standard opp to ...
2
votes
2answers
53 views

Bulkd trigger skips some records

I have an object that I upsert using Dataloader, that has a unique external ID but the same ID must be used as a lookup to another object. Sadly, in Dataloader, you cannot assign a value to two ...
0
votes
0answers
12 views

Issues with jitterbit jdbc driver on trial version to support sql queries

Is that possible to use join query in sql for non commercial free trial version. I am trying to write sql query in jitterbit but its not allowing me. Also, I found out one solution that "If you are on ...
0
votes
0answers
13 views

Use comma sign to show precision instead of period sign in Dataloader

I am using Dataloader to upsert some records but my decimals will not load because the values are not valid. The decimal uses a comma sign to separate the whole from the precision (so for example 2,34 ...
2
votes
2answers
104 views

How to make triggers not fire when we use API tools like Data Loader?

I have written and deployed a Contact Trigger in our production environment, and whenever I would have to use Data Loader to mass update contact records, I would always have to go into the code and ...
0
votes
1answer
22 views

Automating Data Loading

I have seen so many posts regarding this topic but none seem to meet the requirements which I would think are fairly common... We have several developer orgs and of course one production org, and we ...
0
votes
1answer
14 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
24 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
96 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
17 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
165 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
41 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
29 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
62 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
20 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
33 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
26 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
22 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
40 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
47 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
19 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
36 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
43 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
38 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
37 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
28 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
29 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
51 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
87 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
49 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
51 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
151 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
52 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
102 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
90 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
50 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
73 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
39 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
62 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
31 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
52 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
64 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
36 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 ...