Stack Overflow
Stack Overflow

Questions tagged [apex-data-loader]

The Data Loader is an easy to use graphical tool that helps you to get your data into Salesforce objects.

The Data Loader is an easy to use graphical tool that helps you to get your data into Salesforce objects. The Data Loader can also be used to extract data from database objects into any of the destinations mentioned above. You can even use the Data Loader to perform bulk deletions by exporting the ID fields for the data you wish to delete and using that source to specify deletions through the Data Loader.

Features of the Data Loader include:

  • An easy-to-use wizard interface
  • An alternate command line interface
  • A batch mode interface with database connectivity
  • Support for large files with up to millions of rows
  • Drag-and-drop field mapping
  • Support for all objects, including custom objects
  • Detailed success and error log files in CSV format
  • A built-in CSV file viewer
  • Supported on Windows 7 and Windows XP, though an unofficial OS X version is also available
21 questions
7
votes
6 answers

keytool error: java.io.FileNotFoundException: C:\cacerts (Access is denied)

I am on Windows 10 with JRE8 and the command I'm using is: C:\Program Files\Java\jre1.8.0_60\bin>keytool -keystore "C:\cacerts" -storepass changeit -importcert -file "C:\Users\MyUser\Desktop\sf.cer" -alias Symantec_Secure_Server_Class_3 Here's what…
Mossi
  • 997
  • 5
  • 15
  • 28
2
votes
1 answer

The program 'mvn' can be found in the following packages:

I am trying to install dataloader on my Linux machine. https://github.com/forcedotcom/dataloader There is a command line on third line: $ mvn clean package -DskipTests When I typed that in, I got this error: The program 'mvn' can be found in the…
Java
  • 1,208
  • 3
  • 15
  • 29
2
votes
1 answer

How to automate an Excel data sheet to be loaded in the SQL developer?

We get daily data in Excel files and I want to load that Excel sheet data into the database on a daily basis. I want that Excel sheet data to be loaded automatically into the database. How can I set auto-load for this? I am using SQL Developer.
Gayathri
  • 339
  • 2
  • 15
  • 26
1
vote
2 answers

Mass Upload Files To Specific Contacts Salesforce

I need to upload some 2000 documents to specific users in salesforce. I have a csv file that has the Salesforce-assigned ContactID, as well as a direct path to the files on my desktop. Each contact's specific file url has been included in the csv.…
Ethan
  • 1,905
  • 2
  • 21
  • 50
1
vote
1 answer

Syntax for SOQL Query - Dynamic Date

Very new to SOQL. Looking to write a query (to be used in Apex Data Loader) that pulls records with a CreatedDate <= 14 days ago. None of the predefined date options (LAST_N_DAYS, etc.) seem to cover what I'm looking for. I'm guessing/hoping there…
Jake
  • 893
  • 2
  • 9
  • 17
1
vote
1 answer

How to Detect Errors in Apex Data Loader Batch Execution

We have a DOS Batch job which runs a multi-step process to: Delete all records from salesforce for a specific object (download IDs and then delete them using Data Loader) Deletes all records from a database table which mirrors the Salesforce…
Ron Ventura
  • 21
  • 4
1
vote
1 answer

Change date format of a column in CSV file to yyyy-MM-dd using VBScript

I am trying to convert the date from 06-10-2009 00:00:00 to yyyy-MM-dd. I need this for automated data import through Salesforce Apex Data Loader through command line. Thus opening Excel manually and formatting the columns is out of question. I…
RVP
  • 71
  • 1
  • 7
1
vote
2 answers

Getting the same 200 only records in each trigger when using BULK API via Data Loader

We have written a de-duplication logic for contact records where we call a batch job from trigger (Yes, it sounds weird but the only thing that seems to work as we have variable criteria for each account). To overcome batch schedule limit of 5, we…
Shahid Ali
  • 63
  • 2
  • 9
1
vote
1 answer

salesforce : C# Api compare to ApexDataloader

I have performance issue on salesforce I am trying to load table from salesforce into excel cvs, for that used, I tested the ApexDataLoader and found out that to load whole lead table for my organization take around 4~5 min, and have around 60,000…
Shaiba7
  • 159
  • 6
1
vote
2 answers

Error: Unknown duplicates value on record with id

I'm trying to Upsert the data to Account object using an external tool, Everything works fine but Salesforce is throwing error for few records when upserting. I was doing the upsertion process using the external id field. Except external id field no…
Santhosh
  • 189
  • 2
  • 3
  • 7
1
vote
0 answers

Using a collection in the where clause in the salesforce command line data loader

I'm currently trying to backup the attachment files from old cases and emails in our Salesforce org through an automated process. I first tried to do this with the Bulk API but sadly this doesn't allow me to export the body column of attachments. I…
Twan
  • 155
  • 3
  • 7
1
vote
0 answers

.bat file wont save a .log file when triggered in VBA

Ok, so this is a somewhat complicated question, but hopefully somebody can help me out. I created a .bat file to help with batch process data uploads to SalesForce servers. I then tied excel macros to the .bat files by having the .bat files called…
Jay M.
  • 11
  • 2
0
votes
1 answer

How to add validation to not import existing record using ORACLE APEX data load wizard

I've added a data load page using the data load wizard in oracle apex. My problem is I just noticed that I can reupload the csv file that's been uploaded already (containing the same records), which causing for duplicate records. How can I add a…
Eyei
  • 1
  • 4
0
votes
1 answer

How can I export custom Salesforce Objects (fields and tables)

I am using Dataloader to export data out of a salesforce instance. I am having two problems. Custom tables do not appear in the list of objects to select. Plenty of other objects do appear - and I can export them to a CSV file. But no custom tables…
Matthew McNally
  • 21
  • 4
0
votes
2 answers

Exhausting DateTime error in Salesforce Data Loader

So I've spent a whole day trying to get this working but without success. I'm exhausted so I though to ask you guys if you have any solution. I'm trying to upload a date-time field from a file excel.csv (with dataloader) to salesforce…
Ionut Sultana
  • 23
  • 6
1
2