Drupal 7: Reporting and Visualizing Data
Illustration by John Hersey

Using the exercise files


From:

Drupal 7: Reporting and Visualizing Data

with Tom Geller

Video: Using the exercise files

If you have access to the exercise files for this course, you have all the components you need to follow along with the videos on your own computer. Working through this course involves two kinds of files, the first are content files such as text and images, the second or site files; I will get to that second group in a minute. You will find as you go through the course that sometimes there will be text or image files inside a folder. For example; here we have an image file. If you don't have access to these exercise files, you can use your own stuff to follow along, and you'll be fine.
Expand all | Collapse all
  1. 13m 51s
    1. Welcome
      50s
    2. What you need to know
      4m 50s
    3. Using the exercise files
      8m 11s
  2. 12m 58s
    1. A yoga studio
      3m 18s
    2. A national organization
      2m 51s
    3. An entertainment company
      4m 3s
    4. An organization with hyperlocal branches
      2m 46s
  3. 40m 43s
    1. Planning your site's data structure
      3m 31s
    2. Creating record templates
      5m 40s
    3. Understanding Drupal 7's data-template model (entities)
      4m 27s
    4. Creating categories using two methods
      6m 14s
    5. Creating unusual field types
      6m 38s
    6. Reusing and grouping fields
      6m 25s
    7. Looking at Drupal's database
      3m 50s
    8. Migrating custom fields from Drupal 6
      3m 58s
  4. 20m 47s
    1. Connecting two fields using references
      5m 36s
    2. Importing data using Feeds
      8m 48s
    3. Changing the appearances of fields
      6m 23s
  5. 53m 11s
    1. Understanding why views are useful
      5m 1s
    2. Learning from built-in views
      5m 52s
    3. Creating and deleting a simple view
      5m 42s
    4. Diving into the Views interface
      8m 43s
    5. Surveying field types
      6m 16s
    6. Adjusting the settings of individual fields
      5m 31s
    7. Sorting and filtering data
      8m 11s
    8. Changing Views' administrative options
      7m 55s
  6. 33m 33s
    1. Varying how a view appears in different displays
      10m 10s
    2. Formatting views with grid, list, table, and jump menu appearances
      6m 43s
    3. Rewriting field output for interesting results
      4m 21s
    4. Creating multipart views using attachments
      6m 8s
    5. Styling the output of views
      6m 11s
  7. 33m 56s
    1. Importing and exporting views
      6m 21s
    2. Controlling access to data
      6m 44s
    3. Adding dynamic filters to views
      5m 41s
    4. Extending views with relationships
      6m 24s
    5. Improving data administration with Views Bulk Operations
      8m 46s
  8. 29m 43s
    1. Understanding locational data
      4m 43s
    2. Setting up the Location module
      9m 42s
    3. Displaying basic maps with the GMap module
      8m 37s
    4. Displaying custom maps
      6m 41s
  9. 23m 50s
    1. Exporting data in simple text form
      7m 4s
    2. Adding dates and calendars
      8m 32s
    3. Displaying content in a slideshow
      8m 14s
  10. 1m 20s
    1. Next steps
      1m 20s

Start your free trial now, and begin learning software, business and creative skills—anytime, anywhere—with video instruction from recognized industry experts.

Start Your Free Trial Now
please wait ...
Watch the Online Video Course Drupal 7: Reporting and Visualizing Data
4h 24m Intermediate Nov 17, 2011

Viewers: in countries Watching now:

In this course, author Tom Geller demonstrates how to use the Views module and other add-ons in Drupal to present dynamic, data-rich content. This course examines several real-world examples of effective data visualization and describes the Drupal data-storage model. The course also shows how to create, format, and style views; control access to data; improve data administration with Views Bulk Operations; and display content as custom maps and slide shows.

Topics include:
  • Planning the data structure of a site
  • Creating record templates with custom field types
  • Connecting fields using references
  • Sorting and filtering data
  • Varying how a view appears in different displays
  • Formatting views with grid, list, table, and jump
  • Creating multi-part views using attachments
  • Importing and exporting views
  • Extending views with relationships
  • Understanding and using location data
  • Exporting data
Subjects:
Developer Web
Software:
Drupal
Author:
Tom Geller

Using the exercise files

If you have access to the exercise files for this course, you have all the components you need to follow along with the videos on your own computer. Working through this course involves two kinds of files, the first are content files such as text and images, the second or site files; I will get to that second group in a minute. You will find as you go through the course that sometimes there will be text or image files inside a folder. For example; here we have an image file. If you don't have access to these exercise files, you can use your own stuff to follow along, and you'll be fine.

I recommend that you go through the course in sequence from beginning to end. If however, you want to jump ahead, you'll need to align your Drupal site and the associated database to the relevant movie. That means restoring it from the files that are included in the exercise files. There are two different procedures for this, the first procedure happens only the first time you set up your site. You don't have to follow this procedure, if you've already installed Drupal through some other method. The second procedure is once your site is up and running, I will show you both now.

The first time you are going to using what's in this folder base-site, simply open it up, copy this twotrees folder and put it wherever you'd like your Drupal installation to be, this may take a while. I should mention that this includes Drupal as was current when I made this video. By the time you see this video, chances are there will be a newer version of Drupal available. You'll be fine as long as you don't launch this onto an actual public web server. However, if you do, I very, very strongly recommend that you update your Drupal installation; otherwise you could be open to all kinds of security holes.

For information on how to do that, see Drupal 7 Essential Training. The next step is to import this folder into the Acquia Dev desktop. If you don't have it already, you can get it at acquia.com/downloads. It's available for both Windows and Mac and it doesn't matter which version you grab, for Drupal 7 or Drupal 6. Since you are going to be replacing the version of Drupal that it comes with, again, for more details see Drupal 7 Essential Training. I already have Acquia Dev Desktop running, so let's import the site.

We go down to this localhost pop-up and then go to More and then click Import. We click Browse at the top here and navigate to our folder, twotrees, then click OK. We're going to create a new database and it has to have the Name twotrees. Likewise, the Server name also has to be twotrees and then click Import.

If you are normally installing Drupal, this is where you would step through the installation. However, we're going to bring in a database that we've previously saved out. To do that go back to Acquia Dev Desktop, close out this window, so that you're back at the front of Acquia Dev Desktop and click Manage my database. Here you see the twotrees database that was installed by Acquia Dev Desktop. If we click it though, we see that the database is still empty, because it never finished its installation profile.

That's fine, we're going to import a database, by going up to Import and clicking this tab. We then click Browse and go to the files that we want. We are going to use this exercise folder; this contains a very basic database without much stuff in it. The file that you want ends in .sql.zip, twotrees.sql.zip, click it and then click Open. Finally, click Go, this may take a while.

I found that some browsers have a bug that doesn't let you do this import completely, most reliable is Firefox. By the time you see this video that bug may have been solved already. So you may be able to use any browser, try out different ones if you find that it hangs at this point. When finished, you will see a message similar to this one. We can then go back to Acquia Dev Desktop, select twotrees and say Go to my site. If everything worked right you will see the site just like this. Note that the Username and Password throughout the entire course in the exercise files is admin and the password is drupal, all lowercase, drupal, and then login.

Now you're ready to go. So that takes care of the first time you set up your Drupal site using the exercise files. If you want to move ahead in the course, there is a slightly different procedure. To show you that I will go back to my desktop and open up my Exercise files. Let's say that we want to go all the way ahead to 0501-displays, I will open up that folder and we see there are two folders inside it, the database, which we will be using in a minute and the sites folder. The way that you use the sites folder is you first go to your Drupal installation and throw away your old sites folder.

Keep in mind that this will destroy the site as it is when you leave it and before you do this update. If you want to save it, follow the procedures you saw in Drupal 7 Essential Training. But let's say we just want to go ahead, so we'll take the sites folder and throw it away. We will then open up the sites folder here; it's compressed so you may need an uncompression utility. The one that I like is called 7zip. If you're using Mac or a later version of Windows, you probably don't need this, anyway, let's go back for desktop.

And there is our folder, we open up that compressed file and we drag the sites folder into twotrees. So it's replacing the sites folder that was there. This may take a while. That's the first part of the equation. The second part is to replace the database, for that once again we go to our Aquia Dev Desktop Control panel and click Manage my database, then click twotrees, we will scroll to the bottom, select all of these tables here by clicking Check All and then say Drop.

Again, this will destroy your site as it is now, so make sure you backup if you want to save it, but we don't so we just say Drop and we have to confirm whether we really want to do that, yes we do. And if it works, you will see this message up here. Now we import the database from the exercise files. To do that, we click Import, then click Browse, we find the exercise file that's in the folder that we want to update to. For us that was 0501-displays, open it, select the .sql.zip file and then click Open, then Go.

This may take a while. If everything works correctly you will see a lot of tables listed over here under twotrees and you will see this message saying that the import has been successfully finished. We can tell if that's true by going back to our site, once again, Acquia Dev Desktop, select twotrees and go to my site. And there it is, once again the Username and Password is always admin and drupal, we login, and we are ready to go.

I want to reiterate that when you do this, you will have an old version of Drupal, as well as old versions of modules on your computer. If you want to update those, go to Reports and Available updates, complete instructions on how to update both Drupal CORE and the Modules, once again, are on Drupal 7 Essential Training. Now I know that seemed like a big long procedure, but believe me, you get used to it and I have to admit that it doesn't always go as smoothly as you saw here.

If you have any problems, first check my site tomgeller.com, I post help tips there as needed. If all else fails, go to the Support menu on lynda.com, then click Contact Us, and send an email through this form.

There are currently no FAQs about Drupal 7: Reporting and Visualizing Data.

 
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ .

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Join now Already a member? Log in

* Estimated file size

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed Drupal 7: Reporting and Visualizing Data.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member ?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferences from the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Learn more, save more. Upgrade today!

Get our Annual Premium Membership at our best savings yet.

Upgrade to our Annual Premium Membership today and get even more value from your lynda.com subscription:

“In a way, I feel like you are rooting for me. Like you are really invested in my experience, and want me to get as much out of these courses as possible this is the best place to start on your journey to learning new material.”— Nadine H.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.