Start learning with our library of video tutorials taught by experts. Get started
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.
We've assumed that we would run this site with only one substantial user. That is, the administrator. But we could have designed it so that all members of the family are registered users and then let them enter their own date of birth and headshot and so forth. One result of doing things this way is that we could then use Views to keep statistics about how they were using the site, as we'll see in this video. In preparation, I've added a few users to our example Drupal site here. If you want to follow along at home, you can add some users on your own site by going to Administer > User management and Users and then clicking on Add user.
As you could see, I've added a few here, or if you have the example files for this course, you can import them directly. The first thing that we should talk about is what other kinds of views can be set up besides those that are based on nodes. To see that, we'll go to Administer > Site building and Views and we'll add a view. As we scroll down, we see the different view types available. The one we know about is nodes and that's clear exactly how that works. With users, the advantage that you get is that it's tied to an email address, access controls and online activities and so forth. Comments are those things that are attached to nodes. They're not actually nodes themselves, although there is some talk of changing the Drupal architecture eventually to turn them into nodes.
I don't think that's going to happen in the next version of Drupal and I wouldn't be surprised if it doesn't happen in the version after that. So, I wouldn't worry about it. Just keep in mind that comments are always attached to nodes. Terms, as you know, is meta- information. It's something that's stored in the taxonomy structure. Files are things that people upload to this site and they can have what they call a many-to- many relationship to nodes. That is, one node can hold many files and one file can serve many nodes. Finally, node revisions are sort of like comments. For each of these different kinds of view, you have different options about what you can show. We're not going to go through all of these, but we will talk about users just to give an example about how they're different.
One way that will show this is by looking at some of the blocks that are built-in that are actually user views. To go there, we'll scroll back up and go to Administer > Site building and Blocks and scroll down to the bottom to see those blocks that have not yet been put into a block region. Two of these blocks are actually very much like user views, the Who's new and Who's online blocks. Let's put both of those in the right sidebar just so we can take a look at them and learn from them. We move it to the right sidebar and click Save blocks. As expected, we see a list of who'd joined the site recently. We would also see a list of who is online if there were other people online.
We only have one person online. That's of course us, the administrator. Let's go back to our Home page and you see that block stays there. We're going to create a view that's very similar to that Who's new view. It's not only going to tell us that they're new; it's going to tell us how long they've been on the system and it will sort so the newest one is at the top. First, let's turn off those blocks. Go to Administer > Site building and Blocks, scroll down to the right column, what in Drupal is called the right sidebar and take those blocks out of the right sidebar. Scroll to the bottom and click Save. Now, we're ready to go and build our own version of that Who's new block. We go to Administer > Site building and Views and we'll create a new view and call it recently_active.
For a View description, I'll just say Recently active. I'll leave the View tag alone and scroll down to make it a User view rather than a Node view, then click Next. As you see, the interface is pretty much exactly the same as you're used to when you set up a Node view. However, when you start to add fields and filters and so forth, that's when you'll start to see the differences. Let's add a field. Scroll down to the bottom and the first thing that you'll notice is that all of the groups that were there before, they aren't there.
There's only a few: User, File and Global. Let's filter it just so we see the user choices. There are actually quite a few. I'm going to keep this simple and show only the user name. Remember, we're adding fields here; we're not filtering it. I just want to see a list of user names. So, we click there, click Add, we take a look at the different options we have. As usual I'm going to get rid of that label and link the field to its user and click Update. Then when we go down, we see a list of users. There is one interesting thing about this list. It includes the user anonymous and you'll notice that it's not linked to itself.
That's because the anonymous user in Drupal is a special case. I don't want them showing up in that list. So I'm going to go up to the Filter area and add a filter. Scroll down, change the groups to users, so I filter out all of this other stuff and scroll down and filter it out by User: Roles. Now, this isn't going to work, but I want to show you why and how to fix it. Click on Add and we see the configuration page, but you'll notice we actually can't select any particular role. We have the anonymous and authenticated roles, but those are actually built- in to Drupal and really not considered roles in the same way as those that you create.
So, this won't work. I'll click on Remove and try something a little different. Scroll back up to the top and instead I'll add a filter only for those users who are active. Scroll down to see more and click Add. Yes, I want to see only those who are active and update it. That got rid of our anonymous user. My point here is not to teach you the nitty-gritty of how to work with users, but to point out that each one of those other types of views, Users, Files, Taxonomy, they all have their little quirks and they'll take a little bit of figuring out.
If you ever have any problems that you can't solve, your best place to ask them as always is on Drupal.org. So, we have a group of users here. Let's add a little bit more information. The first thing that we want to do is sort it so that the ones who access the site most recently float to the top. To do so, we scroll to the top and add a Sort criteria. Scroll down again and let's scroll through and we have this User: Last access option. That seems about right so we'll select it and add. Once again, when you're dealing with time, it's hard to remember which is ascending and descending. We've been through this once before already, so we know that it's descending that we want. That is, going from the present time backwards is descending.
Click on Update, and we believe we have it sorted, but we're not really sure because we don't know exactly when these people accessed the site. We can change it though. Let's go up and add the Field, User: Last access. Again, we sorted on that and now we're going to show the value in the Fields. Scroll down, Add. We have many options here of course. The only one I'm going to change, and this is personal preference, is I'm going to say how long ago they actually accessed the site. We could add a custom date format if we like, but I'm just going to leave it as it is and click Update.
There. Now we actually have useful information and in fact, we see that we set up the Sort correctly. The administrator accessed it about a minute ago. Gracias accessed it about a half hour ago and so on. Let's save that and add one more piece of information. That is, the Title. We're going to call this Most-recent visitors, click Update and Save. Finally, remember why we wanted to set this up in the first place. We wanted to put a block in the right-hand column that gives us a little bit more information about who was last on the site. We'll add the block display like this.
Add an administration tag to it, so we'll know how to use it when we get to the Blocks page. Scroll down and we'll call it Most-recent visitors, click Update, and there we go. We can now preview it by going to our Display, Block and Preview. Let's save it and make sure that it actually has that title. Drupal can be sort of strange about what information it shows where and the best way to check is actually to look at the block itself. The preview doesn't always give you all the information. So, we'll click Save and then turn on that block by going to Administer > Site building > Blocks. Scroll to the bottom, where we have the inactive blocks and there's the one we created. We'll put it in the right-hand sidebar for now and click Save. There it is. It does have our title. It shows our Users and it's sorted by how recently they accessed the site.
I actually think I'm going to make it a little bit cleaner by putting this all on one line. Click Edit, click on the gear for Row style fields and scroll down a little bit and put those inline with a slash between them. Scroll down again, Update default display. Now we can see it's looking a little better, but we really don't need the last access. You know how to do all of this. As you can see at this point, when you create views, you go ahead and you do the new thing and then there's always a little bit of clean-up left over. But you do it faster and faster each time you work with views.
I'll go up and I'll remove that last access tag, scroll down, remove it, scroll down further, Update and Save. Now, if I go to my Home page, I have a really good sense of exactly how the site is taking shape. I'm actually going to remove that block from the right-hand column, because we're going to continue working with views and it's best to have as wide a page as possible. So, I go to Administer > Site building > Blocks and scroll down until I find the block and then remove it back to the None area and finally save. I know we're not using all of these blocks that we're building, but we will. When it's time, we'll bring this altogether for a really strong impactful data-driven Drupal site.
So, now you've seen how to set up a user based view, but as you saw, there's also file based views and taxonomy based views. The fact is they all operate pretty much the same. To understand them better, your task is just to practice creating those views, trying out different fields, filters, sorts and other options.
Find answers to the most frequently asked questions about Drupal 6: Online Presentation of Data.
Here are the FAQs that matched your search "":
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.
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
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.