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
votes
1answer
11 views

Illegal Service Endpoint error from Dataloader.io

I am wondering if anyone uses Dataloader.io which connects to SF instances. If so have you ever received an "Illegal service endpoint" error? This would also be a question directed to anyone who has ...
0
votes
0answers
8 views

How do I bulk add users to Account Teams such that they have Read/Write access to Cases

This would appear to be easy but I have spent hours searching for a process that actually works. I have a group of users that I have already added to the Account Team related list for hundreds of ...
2
votes
1answer
44 views

Problem with trigger when Inserting new records on custom object

I am trying to insert new records into a custom object (production) via apex data loader. When I do so I get an error like ​ ReservationTrigger: execution of AfterInsert caused by: ...
2
votes
1answer
26 views

How to upload attachments exported from salesforce back to salesforce?

I have to export around 25k attachments from salesforce, change parentId and upload back to salesforce. Can this be done using data loader?. I exported data and it gives attachment body as binary ...
0
votes
1answer
26 views

Apex Data Loader problem

I am trying to insert data into a custom object. My MD field with Contacts is Email__c. I want to use the email to identify the contact as is the unique identifier for my custom object. ( like when ...
0
votes
1answer
31 views

Change Parent Account

Have one question, i have more then 10000 Accounts and all of them have configure the parent account.now here i just want to change the Parent account for all of them. I have seen that parent account ...
0
votes
1answer
33 views

Data Loader Scheduling in salesforce

I am new to salesforce i want to know about how to use Data Loader Scheduling in salesforce with example . Please help to understand it Thanks in Advance your help is great appreciate .
1
vote
1answer
47 views

Import CSV into Salesforce (Group Edition) automatically

I'd like to import CSV file into Salesforce automatically, e.g. once a day. I can't use Data Loader (Bulk API), because I don't have the needed edition. Is there any other, simple way?
0
votes
1answer
20 views

Data Cleaning: Removing Opportunities from Contact Activities

A few months ago we were trying to follow best practices and associate some activities of contacts with opportunities. Each opportunity is associated with an account. We had an error when we were ...
0
votes
0answers
11 views

Bulk Data load processing time

When looking at bulk data load processing time at the job detail level there is a https://help.salesforce.com/HTViewHelpDoc?id=monitoring_async_api_jobs_details.htm&language=en_US Time to ...
0
votes
1answer
20 views

how to assign data categories to articles through apex data loader?

I have inserted articles but now i have to assign data category and sub category to it.Article records are upto 200.Manually assigning category is not the feasible way to do. Could anyone suggest me ...
2
votes
1answer
21 views

Can we delete activity history for email messages sent,without deleting the record?

We have a requirement where we want to delete the activity history of the email messages sent. Is there a way to accomplish this without deleting the record itself. Please give insight of the issue ...
0
votes
0answers
6 views

Scheduling sequential Demand Tools operations to import an excel file

I have a requirement which is giving me a bit of trouble. We have an online app which collects survey data, and this data needs to be transferred to Salesforce once a day. The application does not ...
1
vote
0answers
19 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
11 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
8 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
69 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
58 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
16 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
15 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
128 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
26 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
22 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
28 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
99 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
18 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
174 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
47 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
30 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
72 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
22 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
40 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
38 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
23 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
43 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
61 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
23 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
48 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
52 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
46 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
39 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
32 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
31 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
62 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
106 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
54 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
65 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
207 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 ...