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.
1
vote
0answers
13 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 field:
...
0
votes
1answer
18 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 ...
3
votes
3answers
47 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 ...
1
vote
0answers
44 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 the ...
1
vote
3answers
83 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?
...
2
votes
3answers
56 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 ...
0
votes
1answer
94 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
55 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 ...
3
votes
1answer
80 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
...
0
votes
1answer
46 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:
3
votes
1answer
92 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
29 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
132 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.
4
votes
2answers
90 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
310 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
377 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
179 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 ...
2
votes
2answers
52 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 ...
6
votes
1answer
95 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 ...
4
votes
3answers
183 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
156 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 ...
6
votes
4answers
168 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
195 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
360 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
212 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 ...
1
vote
0answers
78 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 ...
2
votes
2answers
120 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 ...
3
votes
3answers
165 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
232 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. ...
2
votes
2answers
68 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 ...
3
votes
1answer
222 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
312 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 ...
1
vote
1answer
87 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 ...
3
votes
1answer
546 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 ...
