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
Watching:

Deciding whether to store personal data as nodes or users


From:

Drupal 6: Online Presentation of Data

with Tom Geller

Video: Deciding whether to store personal data as nodes or users

There is one Drupal specific point I think we should address ahead of time, that is whether to store a personal data as nodes or as users. This issue comes up whenever you want to store information about people on your site, and you might want to let those people actually log into the site and change their own data. Their information could be stored as part of the user profile or it could be stored in a separate node completely unattached to their user login. This video will talk about the advantages of setting up your site both ways, and we'll even show a third hybrid way that I've sometimes found to be better than those other two.
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

Deciding whether to store personal data as nodes or users

There is one Drupal specific point I think we should address ahead of time, that is whether to store a personal data as nodes or as users. This issue comes up whenever you want to store information about people on your site, and you might want to let those people actually log into the site and change their own data. Their information could be stored as part of the user profile or it could be stored in a separate node completely unattached to their user login. This video will talk about the advantages of setting up your site both ways, and we'll even show a third hybrid way that I've sometimes found to be better than those other two.

There are four good reasons for talking about this issue. First of all, it's a common question that often comes up whenever you are building a site featuring data about real people and where those real people might actually become users of the site. Secondly, we are specifically going to build a site that has personal information, and we could decide to architect it in several different ways. I want to be clear about the advantages and disadvantages among them before you see how we actually decide to do it. The third reason for talking about this now is once you decide to store your data, either in nodes or users, it's very hard to change later.

The last reason to talk about this is that it's an area of Drupal that's probably going to change with the release of Drupal 7, and that's going to happen in late 2009 or early 2010. Understanding the issues of nodes versus user is an important area that could help you to make the transition to Drupal 7 and keep your site alive for years to come. Now I should mention once again, this video assumes that you want to store personal data and have to decide whether to give the people in your site access as authenticated users. If you are planning to do some other kind of site, for example, something showing health care trends or a catalog site, you can skip it.

First, we are going to talk about storing the information in the user section of Drupal. This assumes that you've turned on the Profile module, which is installed with Drupal, but not actually enabled. To do that you would go Administer > Site building > Modules, then scroll down until you find the Profile module. We are going to turn it on now, and Save. There. But let's get back to talking about the advantages of using the user system. If you store personal information in the user part of Drupal, there are several advantages. The first is that, it connects the person that you are talking about with that person's online activity.

So if, for example, they make comments on certain nodes in your Drupal site or they visit pages, Drupal will actually keep track of that and you can have some online data tied in with whatever other information you've put in about them. The second reason is that users could then control their own information when they log in and they take a look at their profile they can edit it and change their information. It's a lot less work for the administrator, if you trust them to do it. The third advantage is that all of the data is in one place. You don't have to keep track of both the user and the node. But going against these advantages are some notable disadvantages. Largest among them is that the Profile module doesn't let you have as many different data types as a node module, and there is some other parts of Drupal that don't really interact with the user system as well as it does with the node system.

Drupal sees nodes as the place where you put content and users as a place where you put information about authenticated users, that is, not really extensive information, just enough so that they can get around the system. That leads to the other disadvantage, which is that some features aren't available. For example, let's say that you store all the information in the user section, then decide that you want to feature one of your users on the front page. Well, you can only do that with a node; you can't do that with a user. There is no way to promote a user to the front page. So let's talk about storing the information in nodes. The first advantage is you have very flexible field options. The CCK module or Content Construction Kit is designed specifically to add features to nodes. It's not available for users.

The second advantage is if you change anything in a node, it doesn't change any of the information that they personally feel that they own. For example, if you wanted to say that somebody had changed their email address, then you could do that in a node, and yet someone could still log on with the old email address because they are not connected. Thirdly, and this is actually quite important, more contributed modules work with nodes than work with users, so you got a lot of features that wouldn't be available if you decide to store the information as users. The disadvantages, well, you'll have to take care of all of those nodes, whereas if you'd stored them as users, the users would take care of the information themselves, you as the administrator either have to deputize people to take care of the information or you have to do it yourself. So if someone changes their address, you have to go and type it in yourself and so forth.

The other disadvantage, there is no connection to that user's online activity. They add comments, they visit pages; it's not really tied to whatever node you set up to store their information. There is a third solution, which is to use a module called Content Profile. The content profile module is available at drupal.org/project/content_profile. The way that it works is it sets up a content type called Profile. You create a node in that content type and that becomes attached to the user's user information, so when they log in and they edit their user, what they are actually doing is editing that node. That gives them some control, but you have all of the advantages of working with nodes.

There is a pseudo-link between the two sort of. That is to say, the node is not actually a part of the user's profile, but it seems to be. And, as I mentioned the users can actually modify them themselves without any additional help from you. Finally, I'd like to talk about one big change that's coming in Drupal 7, which we expect to be released in late 2009 or early 2010, and that's called Fields in core. What that means is instead of having CCK, the Content Construction Kit as a contributed module that let's you create new content types, it will be built into Drupal itself. That's also going to carry with it some big changes in the way that Drupal handles such information internally.

This hasn't been completely decided, but I believe Fields in core will only affect nodes. That is, it won't be possible to add fields easily to users even after Drupal 7 is released. That's one reason that you might want to do your site with all of this information in nodes instead of users, but if you want to get the full discussion, and it's a 90 minute audio discussion, go to the URL that you see here. And I should mention that is a correct URL, where it says looking-forward. It was a typo on the site.

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.