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.
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.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
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.