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

unable to upload a csv file without converting into utf8 format

unable to upload a csv file without converting into utf8 format. I am unable to upload a csv file directly can any one help me out.
1
vote
0answers
18 views

Tool to migrate field dependencies

Currently we have several controlling picklist fields that have 300-400 dependent fields under them. We are doing the field dependency matrix manually in the UI. Is there any tool that can be used to ...
0
votes
1answer
23 views

Finding & Evaluating Salesforce Backup & Recovery Service Providers

Realize that anything a third-party Salesforce backup & recovery service is able to do in theory I am able to do, but short-term, I am more focused on deploying Salesforce, than recovering it. ...
1
vote
1answer
25 views

Data Loader is skipping records during migration

I uploaded a batch of 10,000+ Accounts. Out of the Load file, let's say I have a record by the name Acme. Acme has apparently been successfully uploaded according to the Success Log (which also has ...
1
vote
1answer
17 views

Can we use Case Comment(internal comments) field while uploading case using data loader

I'm trying to upload close cases using data loader.while mapping fields i can't see case comment(internal comment) field.i have checked field level security & field level visibility its fine.but ...
1
vote
2answers
49 views

Apex data loader installation

After install Apex data loader 29.0 in my notebook(windows 7), I can not find Data Loader icon on desktop, or Start -> All Programs -> salesforce.com. Could someone help on this issue? Thanks.
1
vote
1answer
20 views

In dataloader.io, how can I save my field mapping settings with different files (same column headers)?

I'm using dataloader.io to import a large number of records (60K+) into a custom object with a large set of fields. I'm testing using a small file first (10 rows), but I plan to do a large import ...
4
votes
2answers
51 views

where can I find the most recent version release notes of Salesforce Data Loader

I know I can download the Salesforce Data Loader directly from within Salesforce, however, how can I find out what version it is without downloading and installing it? Also, where can I find the ...
2
votes
0answers
40 views

Is there a simple way to generate a create table script from a salesforce class?

I am looking for a way to synchronize Salesforce data with a local database. At the moment I just want a pain free way of downloading the data. I've been playing around with importing CSVs from the ...
2
votes
1answer
39 views

Error while using Command line interface for Apex Dataloader 29.0

While running encrypt .bat -g test on the command prompt. I am getting following error : 2014-03-20 19:55:51,549 INFO [main] security.EncryptionUtil main (EncryptionUti l.java:289) - Invalid option ...
3
votes
1answer
91 views

Command line data loading on Mac OS X

I've been using Lexiloader on Mac OS X as a drop-in replacement for the windows-only Apex Data Loader, but it doesn't seem to include the process command that provides command line support in ADL. Is ...
5
votes
1answer
77 views

Polymorphic ID does not accept external ID, or does it?

Requirement: Via APEX dataloader upload attachments (standard object) and link it via ParentId to a custom object's record. This works easily when the SFDC ID is provided for the polymorphic ParentId ...
0
votes
1answer
47 views

How to export data with tab delimiters using Apex Data Loader?

The internet vaguely says that this is possible. I need this feature to export translation values from a custom object and then import this back into Salesforce using translation workbench. ...
0
votes
2answers
46 views

Data loader missing field, but data is present

I exported an Account from one sandbox with the intention of inserting it into another (i.e. I am copying data between orgs). This is a simple CSV file with two lines: the first has the field names ...
0
votes
1answer
99 views

State and Country Picklist Causing Issues with Import

I'm tried to import Accounts into an instance with Country Picklists enabled and running into issues. If the country of the record is not the country set as Default in SFDC State and Country Picklist ...
0
votes
1answer
67 views

Need to export attachments from Salesforce using a soql query and reload them to a different custom object

We would like to move attachments for some Accounts to a different custom object. However since parentid is a readonly field , i cannot change the parentid and reassociate the attachments. So I was ...
1
vote
0answers
28 views

externalIdField in Command Line data loader Salesforce

We have two objects here. One is Master and other is child of that master. we have an external field on the master Object. I am trying to perform the Upsert Operation on the Child object with the ...
1
vote
2answers
103 views

How to import russian user records in salesforce?

I am trying to load the csv files data through data loader to salesforce,When i try to load the Russian data i get ?????? in the place of text .How to resolve this issue??
2
votes
1answer
56 views

Schedule data integration jobs with a Salesforce.com tool

I need to integrate a custom force.com app with data feeds that should be scheduled to run nightly and upsert data into different custom objects. I need to create a nightly schedule with dependency ...
3
votes
1answer
74 views

Mass touch with dataloader to trigger an update from a workflow?

I have a workflow that's updating a field on an object, but I don't want to have to manually touch each record to have them update. I saw mentioned that you can actually touch records with dataloader ...
0
votes
1answer
25 views

inserting records from a pivot table?

Is there a way to upload records based on a pivot table? If I have three objects in Salesforce, Object A represent hardware item, Object B represent price plan and Object C. Object C stores the ...
1
vote
2answers
49 views

Schedule import to salesforce

HI, I am getting daily csv files from other system. it contains the information of account name, contact detials, opportunity details and quote details i want import the records for every 30mins into ...
3
votes
1answer
88 views

Mass Delete Custom Object Records Using External Id?

Is there any tool that allows you to mass-delete custom object records using only the External Id on that object record rather than the Salesforce record Id?
1
vote
1answer
39 views

Bypassing Vlookup in Excel for import operation on related Objects

I have 'Visit' object related to Account using Vlookup relation. I have 10 Accounts and 30 'Visit' records which are related 1-many. While inserting related 'Visit' I need to populate AccountID. I ...
0
votes
2answers
49 views

Data loader read data from CSV to Salesforce contact (using UPSERT)

Is it possible to use data loader command line to read data from a CSV file and UPSERT into Salesforce contact by a schedule time? Thanks.
2
votes
0answers
70 views

Powershell Apex Data Loader v29 CLI error

I'm trying to run apex data loader CLI from windows powershell. I actually managed to start the CLI from powershell however I'm getting the following errors: 2014-02-05 22:48:59,380 INFO [main] ...
1
vote
2answers
30 views

how to reinsert old records from excel file in salesforce production edition [duplicate]

I have old records and i want to reinsert it now. i having a contacts and their spendings e.g like by year 2006- abc 2007 -abc now i want to add 2005 records from excel ...
1
vote
1answer
27 views

Can we upload data on custom object owned by a managed package

We installed a managed package called object converter. It is using a custom object and we want to do a data load using data loader. If we try to edit a record or update any data on the custom object, ...
0
votes
0answers
62 views

Uploading “Media File” binary content via the Apex Data Loader

I have a SalesForce Entity that I'm trying to upload via the Data Loader. So far we've been able to successfully upload all the "meta data" on the object but have been unsuccessful in actually ...
0
votes
0answers
13 views

how to convert lead to account via data loader? [duplicate]

I want to convert a large amount of leads to accounts with an opportunity.Is it possible by data loader?Also for some leads, account does exist. Therefore how do I map fields if at all I user data ...
1
vote
1answer
95 views

Convert Lead to Opportunity via data loader

I'd like to convert leads to existing/new accounts with opportunities using data loader. How do I go about it? Also, which all fields do I need to map in data loader?
5
votes
3answers
189 views

Unable to use dataloader to load file with Asian characters

Last year, I used dataloader to upload new leads with Asian characters by following this process: 1) In Excel, save file as unicode text 2) Open file in notepad, set Save As to UTF-8, select All Files ...
3
votes
1answer
83 views

Salesforce Apex Data Loader GUI vs. Command Line login

(Crossposted from SO - http://stackoverflow.com/questions/21255608/salesforce-apex-data-loader-gui-vs-command-line-login) I'm trying to wrap up some Upsert functionality into a simple application ...
1
vote
0answers
17 views

Imoport Data Through Data Loader after converting relationship from lookup to master-detail

i have 1 cutom object with 10000 records, now i want to customize this object & i want to connect this object with 1 object with master detail relationship, so i have to 1st create lookup with ...
0
votes
0answers
135 views

Data loader error “input stream cannot be null”

I am trying to export accounts data and I am getting error "input stream cannot be null". I have enable bulk API
1
vote
2answers
81 views

How to do Data Migration in salesforce?

What are the ways to do Data Migration in Production Organization. I am trying to do something like Migrate data from Account lookup field in Lead to new lookup field in the same object (lookup for ...
2
votes
1answer
50 views

not able to insert multi-line special characters data correctly

My problem scenario is like this: I have to migrate chatter data from a Japan org to my PROD org. The Japan org has all chatter data (CollaborationGroup, FeedItem & FeedComment) in Japanese ...
1
vote
1answer
72 views

can i download excel files from jitter bit dataloader

unable to download excel files from jitterbit dataloader I am able to save files in .csv format but i want to save files in .xls(97-2003 format)
0
votes
0answers
36 views

Unable to fetch __r records in dataloader

SELECT Model_c.Name, Model_c.Widget_r.Name from Model_c I am using query in data loader but unable to fetch __r records from database i only gets __c records only
3
votes
1answer
72 views

Is it possible to setup Approval Process and Steps via Data Loader?

I have list of approval process and steps which are large in number(600). I have the data ready with all the details. I know that we can move data using DataLoader. But, is it possible to do the setup ...
-2
votes
1answer
79 views

Data loader .csv files

How to map the fields in data loader from .csv file? what does the .csv file contains? can anyone explain with an example
4
votes
1answer
56 views

not able to upload attachments to Accounts with External ID

I have a Salesforce implementation for a big company; every month the marketing department produces a report ( pdf ) for each client account; they ask me about batch process to automatically import ...
1
vote
0answers
88 views

Updating Content records with dataloader

I'm trying to update detail fields on Content records using the Salesforce data loader, as well as dataloader.io. Typically, the uploads have failed w the message "ERROR: You do not have the level of ...
3
votes
0answers
47 views

Dataloader to MySQL with SSL

Have scripted a salesforce dataloader import job using cliq with a MySQL source. see http://code.google.com/p/dataloadercliq/wiki/CLIqWithMySQL Everything works correctly.. Yet I am required to use ...
1
vote
1answer
57 views

How to manipulate Standard Industry field with Data Loader?

History: We created a new Industry__c field under Account, in order to be able to have multiselect option on the 35 picklists values. Now, it is requested that we will only have 6 options, and NO ...
1
vote
2answers
241 views

Apex Data loader - Error java.lang.UnsatisfiedLinkError: Cannot load 32-bit SW T libraries on 64-bit JVM

I am trying to run apex data loader downloaded and installed from my SalesForce account. But when I try to run the jar from command prompt with this command java -jar dataloader-29.0.0-uber.jar I ...
0
votes
2answers
47 views

SQL Dataloader - Developer Box

If I want to connect to my sandbox then the host name should be https://test.salesforce.com. What should the host name be if I want to connect SQL Dataloader to my developer box. Thanks
4
votes
2answers
93 views

DemandTools security related to SalesForce

To any DemandTools users out there - we are trying to automate our interfaces to and from SalesForce using DemandTools product. When the scheduled task tries to execute, it is failing because it says ...
4
votes
1answer
239 views

Salesforce:bug? Allows importing of more characters in long text area than it can handle

text area long has size of 32768 characters. When we import data(using data loader) more than 32768 characters in text area(long), SF does allow import. However when we try to edit that text area, ...
1
vote
1answer
339 views

Issue while using CLI dataloader

I am getting this error while running my process in CLI dataloader: c:\Program Files\salesforce.com\Data Loader\bin>process.bat accountExtract 2013-10-15 15:26:27,695 INFO [main] ...