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

Drupal 6: Online Presentation of Data

Adding date information as a CCK field


From:

Drupal 6: Online Presentation of Data

with Tom Geller
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

Video: Adding date information as a CCK field

So we have seen how to put a Number field and quite honestly, it's very easy. You can look at all the different options of decimal points, float versus decimal as you like. But for now we are going to delete that Temp Content type and go back to our Person Content type that we'll use throughout this course. To delete this Content type, we go back up to Administer > Content > Content types and just hit the delete link right there and click on Delete. But if you want to use a field type besides Text and Number, you are in luck because the drupal.org website has many to choose from. Right now in our project we have only one custom content type called Person, which is only two fields, a first and last name. And both of those are simple text fields. We are going to get a Module that will let us give our people one additional piece of information, a date of birth.

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

Adding date information as a CCK field

So we have seen how to put a Number field and quite honestly, it's very easy. You can look at all the different options of decimal points, float versus decimal as you like. But for now we are going to delete that Temp Content type and go back to our Person Content type that we'll use throughout this course. To delete this Content type, we go back up to Administer > Content > Content types and just hit the delete link right there and click on Delete. But if you want to use a field type besides Text and Number, you are in luck because the drupal.org website has many to choose from. Right now in our project we have only one custom content type called Person, which is only two fields, a first and last name. And both of those are simple text fields. We are going to get a Module that will let us give our people one additional piece of information, a date of birth.

The Module that does this is called, amusingly enough, Date. We are starting to get into some more complicated modules where one module depends on another and sometimes requires you to add information that wasn't in the system before. That's okay, if the module is well written as these two are, Drupal will warn you when it needs information. So without fear, we'll forge on and we'll add what's needed as we go. First we'll get that date module. Go to drupal.org/project/date, scroll down and download the version that we are going to use. We have already downloaded and installed the date module. Now we'll go to turn it on. As always go to Administer, Site building, and Modules. And scroll down. You will see a new section here called Date/Time. The very core of the Date module is this Date, one right here, the rest of these do a lot of interesting things and I'll explain what some of them do but for now we are only going to turn on one. You will note however, we'll be told to turn on others as needed. Scroll to the bottom and click Save configuration.

See, it tells us that we need to turn on two more Modules to install Date. That's something very useful that well written Modules will do. They will force you to turn on certain other Modules that need to be enabled. Of course we'll say Continue. And we are back here. I would like to show you one other part of the Date Module before I go on, so we'll scroll down to that field group. One of the Modules it installs is called Date Tools. When you are actually building a site, it's a lot easier to turn on that Module and use the Date wizard that's built into it. Not only does it setup the Content type properly with a date field, it also creates some really nice calendar based views using that Content type. But I have decided to specifically to not use that tool so that you can see how to setup such CCK fields manually. I'll show you the interface for the Date Tools Module in the video Planning with a Calendar Module.

Now we want to go back and edit that Person Content type, you are going to notice something as we go back there. We are going to get a warning message that tells us we need to add some information because the Date Module requires it. But let's go there. Go up to Administer, up, and there it is. One or more problems were detected Check the status report. Click on the link. The Date Module requires that you set the time zone that you are using. Drupal usually doesn't require that, so all of a sudden we have to do that. Well, that's easy enough. They give us a link to do so. Since I'm recording this in Ventura, California. I'm going to down to the America/Los_Angeles selection. Close enough. Look at some of the other options. Yeah, First day is Sunday. That's fine. Users can set their own time zones. I'm fine with that.

And say Save configuration. Good, now we can continue on to Administer, Content management and Content types. Once we are there, we are going to go into the Person Content type and manage its fields. Once we are here, we are going to date of birth for this person. We go down to our new field, add Date of birth as the label, date_of_birth. Select our Field type and here you will notice three new options, Date, Datestamp, and Datetime. These have some differences in the UNIX world and if you would like some documentation on that you can find it on drupal.org and also in some UNIX documentation.

But for us we'll just choose Date and we'll leave it as a Select List. The other option is Text Field but that introduces the possibility of more errors from the users, so Select List it is. Scroll down and as usual click Save. On this page there are many, many options and we won't have time to go into them all, I'll just mention a couple. The first is that Dates can actually have from dates and to dates and several of the options on this page reflect that, so you could, for example have a multi-day event. In our case, it's a date of birth, so we won't be using two dates. We'll just have the to date be the same as the from date as you can see in this setting.

Scrolling down a little further, I would like to make one more change, this Years back and forward. Since we are using the Select List option, we'll only see a certain number of options to prevent that list from being infinitely long. We are dealing with a date of birth however, so we know that nobody is going to be born in the future in the way that we are using this in the database. So I'll say 0 there, but they could be born as much as 100 years back, so I'll say 100 there. Scroll down further, I see another reference here to, to date. Once again, we'll never have a time when someone was born one day to another.

In Granularity, we are not going to record the Hour and Minute that someone was born. So we can undo that by simply clicking on the Year then to select Month or Day, we can hold down Shift, on the Mac Command or on the PC Ctrl to select multiple ones. Scroll down a little further, as it happens because we are not using Hour or Minute, the time zone handling doesn't matter, we could just save now and then we would get an error. I happen to know about the error, so I'll say No time zone conversion, and save. As usual to make it look good in the form, I'm going to drag this up underneath the Personal and Family name, scroll down and save. Now let's take a look at what that actually looks like when you are editing a person. We'll go back to our front page where we see the only person that we have in this database, Tom de Nada. I click on it and we see all that blah, blah text we added earlier.

First thing I'm going to do is Edit it and get rid of all of that. Just select it all and hit Delete and scroll back up. Back at the top of the page you see exactly what you would expect, our Year, Month, and Day. Let's say that he is born in 1968, now you could scroll down through all of this but here is a little trick. When the field is highlighted as it is, you can usually just type in 1968 and it will jump to the correct one. That's true in most browsers but maybe not all. We'll say that he is born on April 16th and scroll down and Save.

Now if we return to our front page, we see exactly what we would expect, the name, the date of birth, and the body. You might remember from another video about cleaning up our display and that's actually fairly easy to do. We just go back to the Content type. Administer, Content management, and Content types, and then next to the Person Content type, click on Edit and Display fields. Once again, we can hide that label if we like but I think we'll actually leave it. We'll keep it Inline however, and save it.

As a side note, I want to mention we are only recording a single date or at least a date for a single event with a from and a to. That's not the same as what people usually think of a birthday, which repeats every year. As it turns out recording a birthday is actually somewhat more difficult to implement in Drupal at the moment using CCK fields. Instead most people use a completely different Module called birthdays, at drupal.org/project/birthdays. Just a recap, here are the URLs for Modules mentioned in this video. You will find many, many more Modules that work with CCK in some way at drupal.org. To find them, go to drupal.org, click on Modules and then take a look down here.

You will see the Content Construction Kit category, click on it, and again there are dozens if not hundreds available. Even if you filter it to only be for Drupal 6, many of these let you add new and even unusual kinds of fields to Content types such as bar codes, media files, currency, validated postal addresses, and many more. Others extend CCK's functionality with such things as per field security and conditional fields that appear only if certain calculations check out. If you plan to do anything on your site beyond text and graphics, I definitely recommend spending some time perusing this category and a few hours learning the features of each Module of interest.

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

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
Welcome to the redesigned course page.

We’ve moved some things around, and now you can



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.

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