Skip to main content
Topics#TrailheadQuinn Franco's Question
Quinn Franco (ThingTech) asked in #Trailhead
Feb 4, 2020, 2:25 PM

Data Loader Extraction Issue

Hey Everyone,

I'm trying to extract information via the Data Loader for a trailhead exercise. I've downloaded the application, and attempted to run the steps provided: 

The next step is to select the Account object, rename the file to be extracted and save it to your desktop. Note: All file names default to extract.csv. Renaming files prevents losing or overwriting them.

From the Select Salesforce Object list, select Account (Account).

In the Choose a target for extraction text box, enter Accounts Export.csv.

Click Browse…

Navigate to the desktop, click Save, then click Next.

Now create the necessary SOQL query.

Choose the query fields below:

Id

Name

Site

To complete the where clause to your query, type (or copy and paste) WHERE Type LIKE '%Customer%' in the text box so your query looks like this:

Select Id, Name, Site FROM Account WHERE Type LIKE '%Customer%'

Click Finish, then click Yes. The Operation Finished window appears, reporting the number of successful extractions. Note: The resulting export file should contain 11 records.

I get this message as a result: 

Data Loader Extraction Issue

Can anyone provide some insight into how to fix this issue or how to proceed? 

Thanks for any help you could provide!
2 answers
  1. Sid K (App tech)
    Feb 4, 2020, 3:52 PM

    did you try using " "

    Select Id, Name, Site FROM Account WHERE Type LIKE "%Customer%"

     

    also you can use workbanch that will work perfact 

Write an answer...
0/9000