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

Connecting content to existing nodes


From:

Drupal 6: Online Presentation of Data

with Tom Geller

Video: Connecting content to existing nodes

One interesting feature of the CCK module is that it provides ways for you to link from one node to another, which will lead to some very interesting uses of this data. Before we begin, I should warn you that we are starting to get into some advanced concepts. If you have trouble later, I recommend watching both this video and one earlier in the series called "Planning your Data Structure." We have added a few more records to the database, so we'll have records to link. If you are following along and would like to have the same records in your database as you see here, you have two options. You can either stop the video now and enter these records, or if you received this video on disk or have a premium subscription to lynda.com, you can import the Exercise Files for this video.
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

Connecting content to existing nodes

One interesting feature of the CCK module is that it provides ways for you to link from one node to another, which will lead to some very interesting uses of this data. Before we begin, I should warn you that we are starting to get into some advanced concepts. If you have trouble later, I recommend watching both this video and one earlier in the series called "Planning your Data Structure." We have added a few more records to the database, so we'll have records to link. If you are following along and would like to have the same records in your database as you see here, you have two options. You can either stop the video now and enter these records, or if you received this video on disk or have a premium subscription to lynda.com, you can import the Exercise Files for this video.

The first thing that we need to do is to turn on the node reference section of CCK. We do that as always by going to Administer, Site building, and Modules, and then scroll down into the CCK area. The one that we want is called Node Reference. There is also one called User Reference, which we are actually not going to use, but it works very similarly except with users instead of nodes. We scroll to the very bottom, and click Save. The next thing that we want to do is we want to connect the people who are in our database. We are going to say who is married to who else, and create links back and forth between the two people. To do that we have to go back to our Person Content type that we created elsewhere in the series. To do so, go to Administer, Content management, and Content types. And then manage fields within that Person Content type.

We are going to add another field, which is called Married to. And again, we have to give a machine name to that, something the machine can understand all lowercase, married_to. And then select the type of data we are going to store. We see a new addition to this pop-up menu, Node reference, select it. And then we'll have a choice of which kind of selection we want. In other words, will people be able to select from a list of nodes, or checking boxes, or auto completing a text field where they start to type in the name of the person that they want to say is married to another person? We are going to do select list. But I'll talk a little bit about some of the security issues of how you make this selection. We'll go to the bottom, and click Save.

As always when you add a CCK field, there are options that are specific to the type of CCK field you have added. In this case, the most important one is what type of content can be referenced. A person in this case, can only link to another person so that's pretty clear. Later on, we are going to have people linking to households. So you will see it gets more complicated as we go. We'll save the field settings, and as always we'll just move that up a bit, so it's easier to enter the information. And click on Save at the bottom.

The next thing that we'll do is we'll go back to our homepage and we'll actually start linking people up who are married. We'll start at the beginning with Dani, and when we edit her node, you will notice we now have this option Married to. In Dani's case, she is married to Eli. So we select this pop-up, and go down to Eli de Nada. And scroll to the bottom, and Save. You can see that it actually automatically creates a link to Eli de Nada. If we click there, we could then edit his record and say that he is married to Dani de Nada, and Save.

There are two things to notice about what we just did. The first is that we added a reference from one piece of data, in this case a person node, to another. This whole idea of looking from one node to another becomes important later on when we start to build relationships between them which allow us to see further into these nodes. You will learn how to do that in the videos, extending views with relationships and going further with relationships. Let's go back and link all of our other married couples. I am just going to go back to my homepage and scroll down. I know that Dave is married to Sonya; Sonya is married to Dave obviously, and so on. You can setup the relationships as you like, I'll do the other relationships off screen once we are done. For the record, I also have Francisco married to Gracias.

The second thing I wanted to mention was about the security issues that this exposes. Anybody who edits these nodes can see a list of all the users in this site, which might not be what you want. In this case we are not terribly worried about it but there are several ways to solve the problem. For example, you can limit access to creating these nodes to trusted parties and only let trusted parties edit them as well. Further discussions about security are beyond the scope of this course, but it should never be far from you mind. If you building a site where security is more important, I'd recommend discussing your particular issue on the forums in the drupal.org website.

Now we have linked everybody. There is just one more thing I'm going to do which is to clean up the screen a little bit. You see how we have Date of birth inline with the actual date. I'm going to do the same thing with Married to. You remember how to do that; we go to Administer, Content management, Content types, and manage fields. Once there, we go to Display fields, and we can make the Married to Inline, and save it. We go back to our front page and there it is. We see it inline. Going back to concepts discussed in the planning your data structure video, this is an example of how Drupal's database is relational and how you can replicate that relational structure in your Drupal site. We start off with Gracias de Nada married to Francisco de Nada, and then we have Francisco married to Gracias but instead of having to type all that out, we just say record three is married to record four, record four is married to record three.

This is actually a super-simplified example of how relational databases work, and in fact we glossed over several matters. But that's okay, because in practice, Drupal handles all that stuff behind the scenes. Instead, the purpose of this video is to show you how you can create relations of your own, a trick that will become handy later on when you start building Views.

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

Notes cannot be added for locked videos.

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.