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

Start learning with our library of video tutorials taught by experts. Get started

Drupal 6: Online Presentation of Data
Illustration by

Understanding why views are useful


From:

Drupal 6: Online Presentation of Data

with Tom Geller

Video: Understanding why views are useful

Now we get to the meat of the matter, the Views module, which lets you deconstruct the content you created in Nodes and present it in new and interesting ways. To better understand what it does, let's revisit some points discussed in the earlier video, "Planning your Data Structure." By now we understand that records are broken up into fields, Name, Address, City and so on. We also know that we have to make decisions about how to breakup these fields, when we design a Drupal site. For example, we could have broken the Address field into three, one for the street number, one for the street name, and finally, one for street or avenue or road or whatever.
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

Watch this entire course now—plus get access to every course in the library. Each course includes high-quality videos taught by expert instructors.

Become a member
please wait ...
Drupal 6: Online Presentation of Data
6h 8m Intermediate Jul 01, 2009

Viewers: in countries Watching now:

Drupal's built-in data presentation tools offer several ways for web designers to clearly and attractively package their data. In Drupal 6: Online Presentation of Data, Tom Geller explains how Drupal handles data so users can set up intelligent structures and implement them with Drupal's Content Construction Kit. Tom also shows how a data-driven web site can improve its interactivity by using geographic data to connect real-world addresses to maps. Exercise files accompany the course.

Topics include:
  • Importing and manipulating data in Drupal
  • Presenting date-formatted information in calendars
  • Understanding Drupal's data-query interface, "Views"
  • Improving view appearances with grid, list, and table formatting
  • Importing, exporting, and cloning views
  • Extending views with arguments and relationships
Subjects:
Web CMS Web Development
Software:
Drupal
Author:
Tom Geller

Understanding why views are useful

Now we get to the meat of the matter, the Views module, which lets you deconstruct the content you created in Nodes and present it in new and interesting ways. To better understand what it does, let's revisit some points discussed in the earlier video, "Planning your Data Structure." By now we understand that records are broken up into fields, Name, Address, City and so on. We also know that we have to make decisions about how to breakup these fields, when we design a Drupal site. For example, we could have broken the Address field into three, one for the street number, one for the street name, and finally, one for street or avenue or road or whatever.

We saw in the video hiding and automating unnecessary fields that it's possible to use the Token module to combine fields in simple ways under very limited circumstances. But what if you want to combine those fields in more complex ways. For example, to create mailing labels of all of the nodes in your Drupal site. You can do that by creating a formula that mixes fields with text delimiter, such as commas and carriage returns, as it's shown here. By reaching directly into the SQL database. But doing that requires some advance knowledge of two things; SQL Syntax and the Drupal database structure itself. It's not easy stuff. That's why Views was created by a programmer named Earl Miles, known as Merlin of Chaos throughout the Drupal community.

Views is essentially an easier user interface to the SQL database that lives behind your Drupal site. While Views itself can be daunting at first, it's much easier, and safer, and ultimately more flexible than hand-coding SQL. I'll show you what I mean by creating a very simple view using the data we already have. First, of course, we have to get the Views module along with the Advanced help module, which provides lots of guidance. If you're using Acquia Drupal, you already have them. If not, you can download them from the URLs you see here.

Watch the video expanding your site's capabilities with modules in the Drupal Essential Training course, if you have any trouble with this. We've already installed the modules. Now we're just going to go turn them on. To turn on the modules, you go to Administer, Site building, and Modules. The Views module will have all of its parts in a group called Views, whereas the Advanced help module will have its parts in the Other section. So we scroll down, there is the Other section. I'll just add Advanced help. If you'd like, you could add the Advanced help example that will help you learn Advanced help. Scroll down further. I'm going to turn on all three of these, Views, Views exporter and Views UI.

Basically, Views is the most important part. It doesn't work without the Views module turned on. Views exporter gives you the ability to move Views from one Drupal installation to another. I'll show you how to do that later. The Views UI is also an essential module. If you don't have the Views UI module turned on, you can't actually get in and change your views or build new ones. We have all of those turned on, so now we'll click Save configuration. There is one other thing you might have to do, if you run into problems. That's to increase how much memory is available to your PHP installation. Views takes a lot of memory. Unfortunately, the default installations of WAMP for Windows and MAMP for Mac don't give PHP very much memory at all.

If you increase the memory size to at least 32 megabytes or better yet, 64 megabytes, your problems will probably go away. To learn how to increase that memory allocation, go to the video where we tell you what requirements you need for this course. Now we'll go to Views interface, which we can find at Administer > Site building > Views. The Views interface will be overwhelming, I promise you, and we're not going to take anytime to explain it now. Rather, I just want to show you a very basic example of what it does.

But don't worry, in the next dozen or so videos, we'll be going back and showing you how to do every last little thing that you see me doing here very quickly. So I'm going to create a View by adding it. It will be called people. The description will simply be People. It will be a view full of nodes. I'm going to Filter it, so it's only nodes that have been published and that are of a certain type. They are Published, Yes, and they are of the type Person, Update.

Very good; now I'll add some Fields. Scroll down a little bit so we can see what we're doing a little better. Add Date of birth, Headshot, Married to, and Node: Title. I'll have to go through a few windows to say exactly what I'm doing. Finally, I'm going to change the style of this view to a table with a few sortable columns. Again, don't worry if you don't know exactly what I'm doing. We'll be going through all of this in the upcoming videos.

I'm going to save that, just to be safe. Add a page display with a Path called people. Save it again. Preview it. Finally, I'm just going to reorder my Fields a little bit, so they make more sense. The name will go first, followed by a Headshot, followed by the Date of birth, and who they're Married to Save it. And now we can actually go and take a look at that page. There! We now see the data in our site in a much clearer way than we did before. This was a very, very simple example of what Views can do. As you saw, I was able to create this view in less than a minute. But I'm sure you can already see, how incredibly powerful it's going to be.

Now, programmers aren't known for their user interface design skills, and even a talented UI designer would have a hard time harnessing all of View's power. So a lot of the options require drilling down a bit to get to the part you want, or are in places you don't expect to find them. Fortunately, the current version of Views, that is Views 2, is much better than the first version. The next version promises to be even better. Furthermore, there is a simplified option for Views administration called Simple Views, and we'll show that elsewhere in this course.

Find answers to the most frequently asked questions about Drupal 6: Online Presentation of Data.


Expand all | Collapse all
please wait ...

Q: The exercise files for the course appear to be missing.

A: Full exercise files for this course were not provided because of the unusually large amount of images, modules, and other files that would have to be installed in specific places, in addition to the database. We hope to have a solution for future Drupal courses that installs all items in their correct places.

Q: During the course the author makes reference to being able to add data via the exercise files; however, the data is not in the exercise files.
A: During the recording of the title, some of the exercise files were removed, since the frequent updates to Drupal itself and to the modules that are needed to run the exercise files cause them to break.

The data referenced in the video consists mostly of names and addresses, which will need to be typed by hand.
 
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.
Upgrade now


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 Upgrade now

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 6: Online Presentation of 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

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.