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
30
votes
1answer
43k 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
266 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
97 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
960 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
4k 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
728 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
523 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
563 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
488 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
305 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
3answers
628 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
199 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
840 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
8k 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
88 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
482 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 ...
7
votes
5answers
4k views

How can I import data owned by people who are not Salesforce users?

I am migrating to Salesforce.com from an on premise CRM system. I have a large amount of historical data relating to users who have now left my company. I need to bring this data into Salesforce and ...
2
votes
1answer
1k views

Help with a report and/or Data Loader Export/Query

I am currently use the Salesforce for Wealth Management managed package (unfortunately), and I am struggling to export or report on some of the data. The model is set up like this: 'Relationship ...
-1
votes
1answer
5k views

Finding Record Type IDs

Export a report on the Contract Record Type ID's. I want the name and Record type ID's (18 digit long ID's) of the Contract record types who's name starts with "BUNDLE".
1
vote
1answer
724 views

Error during mass update using APEX Data Loader

I am running into an issue when running an update using the mass data loader. I run the same update twice per week, however, this week, a new validation rule that I created is throwing a validation ...
3
votes
0answers
331 views

Workflow outboundmessage not working when updating data using data loader

I have a workflow outbound message on opportunity which works when I am updating a single record manually. But when I am updating bulk records via data loader the same OM is not working. I can see the ...
3
votes
2answers
2k views

How to identify Bulk Data Load Jobs in the log files

I am trying to dig into our logs and see what is really happening behind the scenes when we bulk data load data into SFDC, but I can't seem to id the operation name in the logs connected with the data ...
6
votes
4answers
5k views

Move data from custom setting in dev to prodn

I have a custom setting and this has some records in it. How can we move these records? Would custom settings be also available in apex data loader? Thanks
1
vote
2answers
2k views

Can I upsert with the Data Loader using different fields for existing and new records?

I have an object, Financial Account, that exists in Salesforce. The object is updated twice every week from our accounting system so that Salesforce reflects up-to-date balances for the accounts. ...
3
votes
2answers
145 views

exporting “complete” data for former users

I have an interesting request: We sold a region to another company, and we'd like to give the departing salespeople their data. It's a simple query to get everything the 4 users from that region ...
4
votes
1answer
2k views

Delay from Salesforce.com in querying records, Informatica

We are trying to insert records into salesforce org through informatica Batch Size = 200 no of records of records inserted 4000 to 50,000 Informatica process shows that insertion is completed. ...
1
vote
2answers
2k views

Trigger is not validate via data loader

Good afternoon everyone, I have two custom objects in my org where I'll call him here and Object1 Object2, Object1 is master detail. I created a trigger in Object2 where caught all of the X values ​​...
3
votes
1answer
357 views

Use data.com to cleanse/update the data uploaded via csv

If I am uploading a bunch of contacts (lets say 500 contacts) using the data loader, is it possible to update (cleanse) this data automatically using Data.com? If it is possible, how would I go about ...
7
votes
1answer
5k views

Mass Lead Conversion - Programmatically or Using Data Loader

Is there a way to mass convert leads into accounts and contacts using data loader? I believe that Partner API exposes a method that we can call to mass convert leads. Is there a way in Apex (using a ...