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

Conga template with apex trigger

Hi I am new to apex code and I need to create a trigger that fires off a call to appextremes.com/apps/Conga/PM.aspx when I tick a check box on a custom object. I am looking to update the checkbox via ...
2
votes
0answers
35 views

how to correctly insert datetime field using dataloader

I am using dataloader to insert activities (tasks and events), which have date time fields. I've read the documentation and if I understand correctly, Salesforce stores the date/time in GMT(UTC) ...
0
votes
0answers
26 views

Error While Uploading Data Via Dataloader :Too many retries of batch save in the presence of Apex triggers with failures:

I am Getting this Error While Uploading Data by Dataloader. Too many retries of batch save in the presence of Apex triggers with failures: when triggers are present partial save requires that some ...
3
votes
1answer
27 views

Upsert externalIDField

I am trying to run an upsert from a batch script. I can't seem to track down any documentation on the actual mapping file when using an external id from a .csv file. How do I tell my upsert which ...
3
votes
1answer
19 views

Jitterbit time format issue

I am using Jitter bit to load the data into SFDC. I have the separate fields for date(Field1) and time(Field2) in my text file. I have the upsert query and I did the mapping for salesforce like this, ...
3
votes
2answers
135 views

Does Upsert alway change the last modified date of the record?

If I run an upsert on a theoretical 100 records, all of which already exist in Salesforce, but only 4 of which have changed field values, will the last modified date for every record be set to the ...
1
vote
2answers
51 views

How to send a mail to a person after inserting data from data loader command line interface suceeds

I am using data loader command line to insert data into salesforce and scheduled for everyday using windows svheduler. I want to send a mail to a specific mail id whether this job succeeds/fails. ...
4
votes
2answers
73 views

Order of records in data load

I have a use case where I need to insert data in salesforce which is being exported from an external system. This data is split over multiple rows, and I need to get those multiple rows into the ...
2
votes
0answers
43 views

How can I include SFDC object AND date-time stamp in process.outputSuccess for DataLoader?

When using the DataLoader, the default format for the process.outputSuccess file is success041214124151388.csv, ie the string 'success' plus a date-time stamp. How can I include the SFDC object (or ...
0
votes
2answers
38 views

Billing Country populated during Data Migration when source was blank

I have migrated a sample account with only 2 fields account name and billing street. However upon migration the country value is populated as united states. I have used data loader and the allow null ...
3
votes
1answer
117 views

UNABLE_TO_LOCK_ROW, unable to obtain exclusive access to this record failing on bulk insert

Following trigger creates a child records on insert of parent record.It checks for number of years field on parent and creates child records based on number of years.It also does check for grantor ...
3
votes
2answers
77 views

review code in managed package (NPSP) apex triggers?

I'm getting an error on inserting Opportunities using the Data Loader: an apex trigger on opportunity insert is trying to dereference a null pointer. In trying to find a solution to this problem, I'd ...
1
vote
1answer
40 views

Migrating SugarCRM to Salesforce

We have a hosted SugarCRM V 6.3.3 with a MS SQL server backend and wanted to migrate data from it to Salesforce. No one in the organization is really familiar with inner workings of Sugar. Is there ...
0
votes
1answer
60 views

Empty column error in Dataloader

I am trying to load Content with Dataloader. When I go to load the file, I get an error that says: I hit Yes and it says: I then click OK and nothing happens. It just sits on the screen it was ...
1
vote
1answer
53 views

Want to Populate all fields of a custom object which is having a lookup relation to another custom object [closed]

Currently, i am building a relationship between several objects so that from one object i can populate all relevant information. These relationships are populated through custom report type. So, ...
4
votes
2answers
112 views

Data Loader - Custom Settings Import

I am trying to import data into custom settings via data loader. I am getting an error during insert operation stating "Required fields are missing: [Name] " If it is a custom object I can set ...
0
votes
1answer
76 views

Import users to Salesforce

I am using the Data Loader to import a bunch of test users to Salesforce. I have signed up for a Free Salesforce account and also created a Developer Sandbox. When I try importing users, I get this ...
1
vote
1answer
94 views

Invalid record type error with Dataloader

I am getting an 'invalid record type' error when trying to update a record type for some contacts. Currently, the contacts are of a a contact record type created by an installed package. We are ...
1
vote
1answer
45 views

Transferring Data from Salesforce to other Tool

Is there any way I can transfer my data from Salesforce to other tool(like ALM). I know that Dataloader can be used, but My problem is mainly with the documents(word,ppt,images etc.) associated with ...
0
votes
1answer
77 views

Excel Connector, “An internal server error has occurred while processing your request”, and ID column

I consider myself an expert with Excel Connector. Therefore, I'm perplexed why I cannot figure this out. I think it's a known issue that I'm just not finding posted anywhere. I literally have over ...
1
vote
2answers
47 views

Deleting PriceBookEntry results in errors

I'm trying to use the Data Loader to delete PriceBookEntry records. However, I end up getting an error for all of them. The weird thing is that the Error message is the same as the contents of the ...
1
vote
0answers
30 views

How do I insert a customer purchase history when uploading data?

We are a small ecommerce business that works in the B2C model. I am in charge of setting up Salesforce for us and I need to upload all of our customers names, addresses, other information and most ...
1
vote
1answer
39 views

Migrate custom field in Activity object

I've added a custom field to the Activities object which I'm trying to migrate data into using the Data Loader on the Event sub-object. However, when I'm creating the map for loading, I do not see my ...
0
votes
0answers
29 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
70 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
37 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
45 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
62 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
131 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
65 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
82 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
73 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
104 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
189 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
97 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 ...
1
vote
1answer
158 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
135 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
352 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
253 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
1answer
52 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
142 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
90 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
184 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
41 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
117 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
203 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
66 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
87 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
122 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
36 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 ...