Skip to main content

Load Data Using the Data Import Wizard

Learning Objectives

After completing this project, you’ll be able to:

  • Use the drag-and-drop report builder to create new Travel Approval reports.
  • Create a new dashboard and add your reports as visual components.

Introduction

How great would it be to get a report in your inbox every morning that shows the number of open travel requests waiting on your approval? Or access a report that provides all the key information of your travel approvals across your departments and their status? And see that information displayed as a graphical chart via a dashboard from your desktop or a mobile device? Good news because that is all possible.

The Travel Approval app you created earlier includes Reports and Dashboard tabs, where you can begin to create, edit, run, and schedule reports or dashboards. 

Note

Before you can do this project, you must complete the Build a Data Model for a Travel Approval App, Customize the User Interface for a Travel Approval App, and Add Business Logic to a Travel Approval App  projects. The work you do here builds on the work you complete in those projects. 

Make sure to use the same Trailhead Playground for all the projects in this trail.

In this project, you'll need to use the previously downloaded Workshop Lab Files. If you need to download them again, they're available here: https://developer.salesforce.com/files/content/learn/projects/add-reports-and-dashboards-to-a-travel-approval-app/2022-12-22-TravelAppWorkshopFiles.zip. Unzip or expand the files after downloading so you can access the individual files during the project.

Launch Your Trailhead Playground

You complete this hands-on project in your own personal Salesforce environment, called a Trailhead Playground. Get your Trailhead Playground now by first logging in to Trailhead, and then clicking Launch at the bottom of this page. Your playground opens in a new browser tab or window. Keep the playground window open while you do this project. After you complete the project steps in your playground, come back to this window and click Verify step at the bottom of this page.

Load Data

Let’s first load sample Travel Approval records so our reports and dashboards have more data.

  1. Click Setupand select Setup.
    Gear icon with Setup selected
  2. In the Quick Find search box, enter Data Import
  3. Select Data Import WizardSetup with Data Import Wizard highlighted
  4. Select Launch Wizard!
  5. Select the Custom Objects tab and select the Travel Approval object. Data Import Wizard with Travel Approval object highlighted
  6. Select Add new records.
    Data Import Wizard with Add new records highlighted.
  7. On the Add new record screen, enter the following values.
    Parameter
    Value
    Match By
    None
    Which User field in your file designates record owners?
    None
    Which Department field in your file do you want to match against to set the Department lookup field?
    Department Name
    Trigger workflow rules and processes for new and updated records.
    Checked
  8. Drag the TravelApprovals.csv file (from the folder you downloaded in the Build a Data Model for a Travel Approval App project) to the Drag CSV file here to upload section..
  9. Select Next.
  10. Ensure the names in the CSV file are the same as your object (these are automatically mapped).
  11. Click Next.
  12. Click Start Import.
  13. Click OK.

You are taken to the bulk import summary window. This shows the process has completed (that is, Closed) and that 300 records have been successfully imported or processed. 

Bulk Data Load Jobs page

Great job! Your Travel Approval object is now populated with hundreds of records. In the next step, you display this data in a Salesforce report.

Keep learning for
free!
Sign up for an account to continue.
What’s in it for you?
  • Get personalized recommendations for your career goals
  • Practice your skills with hands-on challenges and quizzes
  • Track and share your progress with employers
  • Connect to mentorship and career opportunities