Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member

Using the exercise files

From: Drupal 7: Reporting and Visualizing Data

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.

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.

Show transcript

This video is part of

Image for Drupal 7: Reporting and Visualizing Data
Drupal 7: Reporting and Visualizing Data

44 video lessons · 6757 viewers

Tom Geller
Author

 
Expand all | Collapse all
  1. 13m 50s
    1. Welcome
      50s
    2. What you need to know
      4m 49s
    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 49s
    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 56s
    8. Migrating custom fields from Drupal 6
      3m 58s
  4. 20m 46s
    1. Connecting two fields using references
      5m 35s
    2. Importing data using Feeds
      8m 48s
    3. Changing the appearances of fields
      6m 23s
  5. 53m 15s
    1. Understanding why views are useful
      5m 1s
    2. Learning from built-in views
      5m 52s
    3. Creating and deleting a simple view
      5m 41s
    4. Diving into the Views interface
      8m 48s
    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 learning today

Get unlimited access to all courses for just $25/month.

Become a member
Sometimes @lynda teaches me how to use a program and sometimes Lynda.com changes my life forever. @JosefShutter
@lynda lynda.com is an absolute life saver when it comes to learning todays software. Definitely recommend it! #higherlearning @Michael_Caraway
@lynda The best thing online! Your database of courses is great! To the mark and very helpful. Thanks! @ru22more
Got to create something yesterday I never thought I could do. #thanks @lynda @Ngventurella
I really do love @lynda as a learning platform. Never stop learning and developing, it’s probably our greatest gift as a species! @soundslikedavid
@lynda just subscribed to lynda.com all I can say its brilliant join now trust me @ButchSamurai
@lynda is an awesome resource. The membership is priceless if you take advantage of it. @diabetic_techie
One of the best decision I made this year. Buy a 1yr subscription to @lynda @cybercaptive
guys lynda.com (@lynda) is the best. So far I’ve learned Java, principles of OO programming, and now learning about MS project @lucasmitchell
Signed back up to @lynda dot com. I’ve missed it!! Proper geeking out right now! #timetolearn #geek @JayGodbold
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

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?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

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 preferencesfrom 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.

Are you sure you want to delete this note?

No

Your file was successfully uploaded.

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.