New Feature: Playlist Center! Pick a topic and let our playlists guide the way.

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

Using the exercise files

From: Drupal 6: Online Presentation of Data

Video: Using the exercise files

If you are a premiere member of lynda.com Online Training Library or if you are watching this tutorial on a DVD-ROM you have access to the exercise files used throughout this title. There are two kinds of exercise files. The first is the database file. Each video has its own database file, which is installed using the program phpMyAdmin. On the Mac you open phpMyAdmin by going to MAMP and then clicking on the Open start page button. From there you click on phpMyAdmin. If you are using a PC with WAMP you can get there by clicking on the WAMP icon in the System Tray and then going to phpMyAdmin.

Using the exercise files

If you are a premiere member of lynda.com Online Training Library or if you are watching this tutorial on a DVD-ROM you have access to the exercise files used throughout this title. There are two kinds of exercise files. The first is the database file. Each video has its own database file, which is installed using the program phpMyAdmin. On the Mac you open phpMyAdmin by going to MAMP and then clicking on the Open start page button. From there you click on phpMyAdmin. If you are using a PC with WAMP you can get there by clicking on the WAMP icon in the System Tray and then going to phpMyAdmin.

Once there, you will have to delete your existing database if you already have one loaded. I should warn you though this will completely remove your Drupal site. It will destroy the database that you already have. So be sure that you back it up if you haven't done so already. You can learn how to do to that in the course Drupal Essential Training. To drop your database and prepare to import a new one, go to the Databases link on the main page of phpMyAdmin. From there check the box next to the database which we have named "lynda" and then go down to this little icon which drops the database. Click it and it will ask for a confirmation. You then click Yes to drop the database.

To then import the database that you want to use, you click on the Import tab at the top of the screen. You browse for the file, which will be inside a folder called exercise_files. Inside that folder, there is one folder for each chapter in the course. Inside those Chapter folders are the individual SQL files. For this course, due to the amount of modules that need to be installed and setup as well as the ever-changing nature of these modules, we have only provided the initial database file of content to setup this course.

Click on it once and then click on Open, then go the bottom right-hand corner and click Go. If the import worked properly, you'll see a success message at the top of the screen. You can confirm that by opening up a new window and going to local host. If it shows the site the way that you expect it to look, then you have succeeded. The Drupal Username and Password throughout this course is always the same. The Username is admin and the password is booth. You should then be able to login to your Drupal site as the administrator.

In addition to the database files there is also a file folder labeled "graphics". You could learn how to use these graphics with your Drupal site from the video Including Images As CCK Fields, which is part of this series. There is one final step you may need to take. I'm recording this series using Drupal 6.10. But Drupal gets frequent updates. So there is a good chance you are using Drupal 6.11 or 12 or whatever. If there was a change in Drupal's database structure between updates you may find your Drupal installation acting strangely. So, if you are using a Drupal version after 6.10, go to your address bar and type update.php after the domain name. I'll demonstrate that.

Our domain name is localhost. Just type update.php and hit Return. You will then be led through the procedure you need to follow in order to update your database. At the time that you watch this course, these modules will have been updated as well Drupal itself, so always make sure you install the most current version. If you don't access to the exercise files, you can follow along from scratch or use your own assets. Let's get started.

Show transcript

This video is part of

Image for Drupal 6: Online Presentation of Data
Drupal 6: Online Presentation of Data

50 video lessons · 11181 viewers

Tom Geller
Author

 
Expand all | Collapse all
  1. 12m 56s
    1. Welcome
      1m 12s
    2. Reviewing requirements
      3m 35s
    3. Using the exercise files
      3m 11s
    4. Touring examples of data visualization
      4m 58s
  2. 27m 56s
    1. Planning data structure
      8m 26s
    2. Importing and manipulating data
      6m 40s
    3. Looking at Drupal's database
      6m 13s
    4. Deciding whether to store personal data as nodes or users
      6m 37s
  3. 1h 13m
    1. Understanding the Content Construction Kit (CCK)
      4m 57s
    2. Creating new content types with CCK
      7m 26s
    3. Hiding the Body field
      2m 46s
    4. Reflecting CCK field data in the Title field
      7m 28s
    5. Managing CCK field placement
      7m 34s
    6. Exploring CCK's other features
      8m 22s
    7. Using other CCK field types
      3m 25s
    8. Adding date information as a CCK field
      8m 43s
    9. Including images as CCK fields
      10m 23s
    10. Connecting content to existing nodes
      5m 58s
    11. Using taxonomies to categorize and group data
      5m 59s
  4. 53m 54s
    1. Understanding why views are useful
      6m 12s
    2. Using SimpleViews to create basic content views
      5m 49s
    3. Diving into the Views interface
      11m 16s
    4. Adding fields to a view
      7m 12s
    5. Understanding iconic controls in the Views interface
      7m 15s
    6. Surveying the Sort, Filter, and Field options in Views
      5m 40s
    7. Adding view displays as pages, blocks, and RSS feeds
      10m 30s
  5. 43m 34s
    1. Overriding default settings on view displays
      8m 56s
    2. Attaching more information to views
      10m 57s
    3. Improving view appearances with grid, list, and table formatting
      9m 20s
    4. Surveying other basic display settings in Views
      11m 3s
    5. Altering a view's appearance through CSS
      3m 18s
  6. 55m 8s
    1. Importing, exporting, and cloning views
      6m 9s
    2. Controlling access to views
      7m 19s
    3. Learning from built-in views
      5m 52s
    4. Creating views that aren't based on nodes
      10m 6s
    5. Extending views with arguments
      10m 17s
    6. Extending views with relationships
      7m 2s
    7. Going further with relationships
      8m 23s
  7. 46m 40s
    1. Understanding geographic data
      4m 26s
    2. Setting up the Location module
      16m 20s
    3. Entering geographic data with the Location module
      10m 10s
    4. Displaying basic maps with the GMap module
      6m 43s
    5. Integrating the GMap module with Views
      9m 1s
  8. 54m 21s
    1. Exporting data in tabular form
      11m 25s
    2. Planning with the calendar modules
      11m 31s
    3. Using the Charts module and Google Charts
      7m 11s
    4. Graphing data with Open Flash Chart
      4m 50s
    5. Making important data pop out with tag clouds
      7m 46s
    6. Putting it all together in an attractive package
      11m 38s
  9. 36s
    1. Conclusion
      36s

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

Are you sure you want to delete this note?

No

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.