Skip to main content
10 votes
Accepted

Data Loader Error no viable alternative at character

You are only allowed to use single quotes in your query. Replace all of your double quote characters (") with single quote characters (').
Adrian Larson's user avatar
  • 150k
9 votes
Accepted

Uploading 100,000 binary files as attachments to Case record - best approach

I would suggest you to go with data loader using SOAP API, which is by default (not Bulk API). Why? You do not need to write any code to use Data loader It is tested solution, so no bugs With ...
AtulRajguru9's user avatar
  • 9,120
9 votes
Accepted

how to update email field to NULL value using data loader

Since you have already changed the setting of data loader "Insert null values". so, in the .csv, email field will be blank. NO quotes, NO NULL word. If you open the .csv in notepad or ...
Santanu Boral's user avatar
9 votes
Accepted

How to query ContentDocumentLink in SOQL and then upsert records in Data Loader

This is a system restriction on ContentDocumentLink. The object reference has specifics of what you're required to do: You can't run a query without filters against ContentDocumentLink. You can't ...
David Reed's user avatar
  • 93.2k
8 votes
Accepted

Difference between data loader and workbench

As you mentioned in the Question, I guess workbench operated in the Bulk API but in Parallel Processing mode. Parallel Processing mode is known to throw these kind of errors. Refer to the section ...
javanoob's user avatar
  • 8,907
8 votes
Accepted

How do I export activities related to an account with a specific recordtype?

You're in luck: you don't have to wait until Summer '19 hits your org, bringing with it Polymorphic SOQL, or use a subquery on WhatId, because you can query through the non-polymorphic AccountId ...
David Reed's user avatar
  • 93.2k
8 votes
Accepted

Do SFDX commands count toward limits?

Yes, SFDX commands do consume and count towards the limits of the resources they utilize on your target orgs, including API calls, Bulk API jobs, streaming and platform event consumption, and others. ...
David Reed's user avatar
  • 93.2k
7 votes

How to authenticate Data Loader with Single Sign On?

The answer saying it does not work is now outdated. You can use single sign-on with Data Loader since version 36 if you have a custom domain (xyz.my.saleforce.com). On the log in screen, choose ...
georg w.'s user avatar
  • 1,224
7 votes
Accepted

Struggling at logging into dataloader

You have two options here. Either download Apex dataloader latest version which support TLS 1.2 and second not so good option is disable this update in your org. The following steps can be followed ...
Tushar Sharma's user avatar
7 votes

Data Loader updates Date Value incorrectly

From Salesforce help Why do date fields import incorrectly when I use the Data Loader? When importing date fields using the Data Loader, sometimes dates import incorrectly because the Data Loader ...
sfdc's user avatar
  • 13.7k
7 votes

Formating Date time field in excell to import via data loader

You want to format it as: yyyy-mm-ddThh:mm:ssZ Where you can just make hh:mm:ss be 00:00:00. e.g. 2016-01-18T00:00:00Z
Nick C's user avatar
  • 6,780
7 votes

Will extracting data from salesforce remove all data from salesforce

No, you would have to do a delete. Extract with Dataloader is just a dump to a csv. So if you just do an export and don't then do a delete you're fine.
user4978's user avatar
  • 349
7 votes

How to automate data import on full sandbox refresh

If you're willing to take the time, the SandboxPostCopy interface lets you write code that's called once upon refresh. You could write a bunch of code to populate records. If you're planning on moving ...
sfdcfox's user avatar
  • 495k
6 votes

Data Loader login fails for sandbox instance

guess you are NOT able to login somewhere go to dataloader settings and change https://test.salesforce.com for sandbox https://login.salesforce.com for production
Andrei.Z's user avatar
  • 965
6 votes
Accepted

Not able to connect to sandbox org through Force.com IDE and Data Loader - TLS protocol issue

This issue is because Salesforce has disabled TLS 1.0 encryption. After June 25, 2016, at 9:30 AM PDT (16:30 UTC), all sandbox orgs -- whether existing, refreshed, or new -- will have TLS 1.0 ...
Rohit Patil's user avatar
6 votes
Accepted

How to import accounts without contacts using Data Import Wizard?

Choose Accounts and Contacts on the first step, and proceed through the wizard. Simply unmap all of the contact fields. If no contact fields are mapped for import, the wizard will only import accounts....
sfdcfox's user avatar
  • 495k
6 votes

Tasks Updates--Locking issue

A few key tactics should alleviate this issue: Group your input data by WhatId to ensure that the Tasks for each Account are grouped into as few batches as possible. Note that this might not actually ...
David Reed's user avatar
  • 93.2k
6 votes
Accepted

Transactions and Batch Size

Yes, you will get each record it its own transaction, but you'll also use 1,000,000 API calls against your daily limit. In other words, if you have less than 1,000 Salesforce licenses, you're likely ...
sfdcfox's user avatar
  • 495k
5 votes

Is it possible to insert or update CaseFeed object?

While the above answers are technically correct, they don't do a good job of pointing you in the right direction in order to do what you want to do. As mentioned above, you can't directly insert an ...
KyleFarris's user avatar
5 votes
Accepted

Why do some data loading tools work with professional edition?

There is actually a piece of documentation that goes over this in the ISVForce guide. API Access in Group and Professional Editions The first lines of text on that page read API access is not ...
Derek F's user avatar
  • 62.3k
5 votes
Accepted

Data Loader v38 (Winter 17)

As commented by Charles, v38.0.1 is now available: DataLoader V38.0.1 fixed Oauth option missing issue caused by release script and a bug in field mapping UI after sorting by column names. Partial ...
Daniel Ballinger's user avatar
5 votes
Accepted

Upserting Data using Data Loader with External ID

I will put 2 scenarios over here. I have created following csv file to upload data into my org, where External Site Id is External Id (unique is not selected) External Site key is External Id and ...
Santanu Boral's user avatar
5 votes
Accepted

How many API calls does dataloader use

Your best option could be to check the Data Loader Log File. It apparently tracks: the operations and network connections made by Data Loader So it would give you a very direct indication of the ...
Daniel Ballinger's user avatar
5 votes
Accepted

Combining Multiple Rows From SOQL Query In DataLoader

Adding this as an answer, after noticing the expected result. Such a advanced query is not supported by a SOQL through dataloader and would not be even possible by a standard report, as you want to ...
Raul's user avatar
  • 18.8k
5 votes

how to insert records on account and contact

Following things to be noted. The term deploy is used when we deploy configuration and customization components, which is nothing but metadata. We use word migration when data to be loaded into ...
Santanu Boral's user avatar
5 votes
Accepted

Best option to export more than 15 millions records from Salesforce?

Any tool that supports the Bulk API, such as Data Loader, should work fine. If your exporting data from an object or objects that support PK Chunking, you will probably want to use it. To provide one ...
xn.'s user avatar
  • 2,468
5 votes
Accepted

Data Loader 48.0 Installation error - Could not find install.bat

OK, ended up having to copy the dataloader.bat and the dataloader-48.0.0-uber.jar files from the Salesforce download, into the installed directory. It now works ! Maybe a permissions issue with ...
Mark99's user avatar
  • 66
5 votes

Installing Data Loader on Windows

You have to install the Zulu JDK first by launching the msi. JDK is Java Development Kit, it contains the Java runtime. Zulu is just the name/flavor of the JDK release. You also have to make sure the ...
identigral's user avatar
  • 7,655
5 votes
Accepted

Increase Heap Size for Data Loader Started from dataloader.bat Windows Batch File

Note that the article you link says that: Newer Dataloader versions (45 and up) that use Zulu Java manage heap size differently and should not need to do this. Are you certain that this is what ...
Thomas Taylor's user avatar
5 votes

Unable to Install Salesforce Data Loader v52 in Mac BigSur 11.4

It may be because your JRE version is not correct. To check this and fix it, try this: [For MacOS]: Go into where the data loader is installed and execute it from the command line so you can see the ...
Kajal's user avatar
  • 51

Only top scored, non community-wiki answers of a minimum length are eligible