Questions tagged [data-loader]

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.

Filter by
Sorted by
Tagged with
1
vote
1answer
339 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)
1
vote
1answer
200 views

Unable to fetch __r records in dataloader

I am using query in data loader but unable to fetch __r records from database i only gets __c records only SELECT Model__c.Name, Model__c.Widget__r.Name from Model__c
3
votes
2answers
632 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 ...
-3
votes
1answer
1k 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
5
votes
1answer
992 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 ...
3
votes
1answer
972 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 ...
4
votes
0answers
335 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
207 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 ...
2
votes
3answers
1k 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
107 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
713 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
2k 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, ...
2
votes
1answer
3k 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] controller....
7
votes
1answer
3k views

Issue extracting special character with Apex Data Loader 28.0.2

I am getting issue's with the extracted .csv files from Apex Data-Loader: While extracting data that contains special characters, the exported .csv file doesn't show the special character as they ...
32
votes
1answer
46k views

How do I build a SOQL query for records in a list of IDs?

Can some one correct my soql? I need to export records in data loader like: WHERE Id IN ('123123123','123123fsdf') But this following query does not work for me: SELECT Id, Syndication_Documents__c ...
2
votes
1answer
269 views

Avoiding multiple Salesforce logins while extracting Records out of Salesforce using CLI data loader

Current Scenario: We have currently 6 beans for different objects extracts. CLI Data loader calls each process-bean one by one there by logging into salesforce each time, and get extract out of SF. ...
5
votes
1answer
1k views

Disable Data Loader by Profile

Is it possible to disable the data loader based on profile (or role)? We have some non-tech users who like to use the data loader for bulk updates, unfortunately, they are also making mistakes when ...
4
votes
1answer
704 views

Error when using dataloader command line

I have to upload some contacts to the salesforce database using the salesforce command line interface (CLIq). I downloaded the 23.0 beta version that works with dataloader 24 or higher. I haven't ...
7
votes
1answer
4k views

Invalid Cross reference ID [closed]

I have a csv to update the 35 user profile id. Csv has just two column Id and new profile Id. I updated the user with ID. I worked for 14 users sucessfully and for other 20 it is throwing Invalid ...
2
votes
1answer
2k views

Batch converting leads from an excel sheet

I am new to Force.com and Salesforce in general and am looking for assistance with a client requirement. On a regular basis, they receive an excel sheet from a partner listing new customers that have ...
1
vote
0answers
99 views

Build Data Loader job

How to build a data loader job to run in background that will upsert account and contact and update a field on contact.
2
votes
2answers
1k views

Dummy Update to existing data

I have a deployed a trigger to production and i need to run the trigger to update the existing records.Is there any way to run the trigger for existing data other than pulling the existing records ...
1
vote
1answer
2k views

How to automate the loading and updating of reference data from command line/ant?

It seems there are tons of ways to load data into salesforce - https://help.salesforce.com/HTViewHelpDoc?id=import_which_data_import_tool.htm&language=en_US But I am specifically looking for the ...
1
vote
0answers
191 views

Mass look-up Organization ID when uploading CSVs into Data Loader?

I am trying to mass upload Donations to Data Loader. Among other values, in my CSV document, I need to have an Organization ID. Is there a way to quickly get the ID from the Organization Name, or ...
6
votes
2answers
5k views

Date time export data loader

I'm using the data loader to export accounts. I put the following condition in the form of the dataloader: Select NAME FROM Account WHERE LastModifiedDate = 2013-06-11T15:54:00Z But i'm not able to ...
8
votes
1answer
5k views

Parent Id Apex Data Loader

I'm using the data loader. I'm not sure about the use of the Parent id in the picture below. When have i use this? I'm upserting with the data loader contacts that are related of course to certain ...
2
votes
2answers
760 views

using ID in dataloader mapping file

I'm using the commandline dataloader to do an upsert. The datafile looks like this: ID,COLUMN2,COLUMN3 965832145,2013,04 The sfdc.externalIdField property is set to "Id". Mapping-file: ID=...
3
votes
2answers
551 views

know data source

I'm writing a trigger on account to set a custom field account.Data_Source__c = 'ERP'; for the accounts imported with the data loader from command line . The problem is that my trigger works also ...
4
votes
2answers
571 views

Any way to query CRM Content Subscriptions?

I was wondering if CRM Content subscription information is stored anywhere. I am trying to find which users are subscribed to a particular tag. This object is the only thing I have come up with as a ...
2
votes
1answer
2k views

UseStandardPrice field when import PricebookEntry

I’am going to insert the prices for my products, but i’m not sure about how setup (true or false) the field UseStandardPrice of the object PricebookEntry. I have found this : UseStandardPrice ...
1
vote
1answer
498 views

Approach to Load data from Master to Child objects from Legacy database

We have an oracle database with 100,000 records which has a master table called Application and it has a child called Application Individual and each Application individual has one level children like ...
4
votes
3answers
312 views

will the change set deployment affect the ongoing data loading

I came across a situation where one of my peer is uploading some records using the data loader and it may take a long time may be more than 10 hours. My query is, what will be impact of deploying a ...
2
votes
0answers
1k views

Data Loader using self relationship lookup and external id

I'm currently using Jitterbit Dataloader. I have an object called 'Project' and it has a self relationship (lookup) called 'Parent Projects'. During an initial import there are no parent projects so ...
1
vote
3answers
2k views

Which is the best data loader for Salesforce? [closed]

Over time, I have come across three data loaders for Salesforce... Apex Data Loader, Jitterbit Data Loader, and dataloader.io to name a few. Are there any more data loaders for Salesforce? Which is ...
2
votes
3answers
408 views

Loading existing users to force.com sites from External application

We are building a force.com sites with authenticated user license. We currently want to load from an existing application around 500,000 users in a csv format with username, password to force.com site ...
2
votes
1answer
3k views

Can free Jitterbit dataloader do an auto-relation like Dataloader.io?

Until now I was a happy Datloader.io user as it allowed me on a Mac to insert from CSV and have this wonderful auto mapping feature where a Lookup or Master Detail relation can be pointed to an ...
0
votes
2answers
642 views

APEX Data Loader 21 Consistently Crashing - Error Message Inside

Nearly every time that I try to use the Apex Data Loader it crashes after clicking on 'Browse' to select the file to load data from. This error message is generated. Any idea what might be causing ...
9
votes
1answer
7k views

How to handle NULL values when inserting with the Dataloader(.io)

I'm uploading records with the amazing dataloader.io and have a hard time to upload some records with NO value for optional fields. What do I have to put in those fields? #N/A 'null' NULL '' "" 0 Is ...
0
votes
1answer
296 views

External IDs unavailable in Apex Data Loader

I have a number of external Ids in my SFDC environment, but I can't see them in the Data Loader or in the Jitterbit Data Loader. Any ideas? Data Loader: Field settings:
6
votes
3answers
5k views

Apex Data Loader is loading previous date

Apex Data loader is loading previous date. Salesforce Organization Default Time Zone is GMT+05:30 Salesforce User Time Zone is GMT+05:30 Apex Data Loader time zone is GMT+05:30 CSV, for Apex Data ...
0
votes
1answer
201 views

Data Loader Synch Date

I am running Data Loader via command line every night to upsert records from a third party generated CSV (using a Windows Scheduled Task), and am trying to figure out the best way to keep track (in ...
1
vote
1answer
4k views

How to insert new Products and Price Book using Apex Dataloader

Do anybody know How to insert new Products and Price Book using Apex data loader. Every 1 product will have more that 1 price in price book. please guide me to possible ways to do.
5
votes
3answers
912 views

Is there a SFDC tool to quickly load - and reload - test data?

Is there already a SFDC tool that will take a set of test data - similar to what is part of every developer org - and load it into a new developer sandbox? Is there a tool to wipe out an entire org's ...
1
vote
1answer
9k views

How do you prepare the CSV file for a successful upsert?

I would like to import several contacts into Salesforce and avoid duplicates. I would like to do this via upsert (not the the import wizard). For the upsert I plan on using dataloader.io. I have ...
5
votes
2answers
3k views

SOQL Query Limit and Data Loading

I have a philosophical question about the SOQL Query limit. What I mean by that is I don’t want to talk about specific code – just the design requirements that are leading to code. I am new and while ...
0
votes
1answer
2k views

Command line Upsert error

I am new to SalesForce (a former Goldmine user), but have dealt with mapping before. I am trying to set up the data loader so that I can run it from a batch file each night and insert / update our ...
3
votes
2answers
89 views

Informatica wants me to re-install because of old version, but no newer version available

I opened today the Informatica Data Loader (Free) tab, and wanted to sync some data. But then I got this message: You have an older version of the Informatica Data Loader Service managed ...
10
votes
2answers
1k views

Backing up and Restoring a Salesforce Org

There is a bit of information around which discusses backing up Salesforce using the data export capabilities or one of the data loader tools to download SF data into text files or ar relational ...
5
votes
3answers
2k views

Data loader - each batch a discrete operation/transaction?

I am currently designing a solution which will likely include upload (insert/upsert) of 1000s of records per upload. I am doing some calculations to evaluate how far the solution might be from ...
2
votes
2answers
487 views

Trigger for cloning isn't required for data loading

I have a 'Before Insert' trigger that was developed only because of the 'clone' functionality in SF. In our Managed Package if someone clones our custom object there are a number of fields that we ...