Recent Drops
The Power Of Drupal Views
Submitted by learnbythedrop on Sun, 05/31/2009 - 00:23When people ask me why I would ever use Drupal to build a website instead of other platforms like WordPress or Movable Type I typically have one answer, "CCK and Views." That could be interpreted as two answers but since the modules go hand in hand I'll call it one. I've written about the basics of CCK before so I recommend that you check out that post if you're interested in understanding CCK better. This post is about the Views module.
Views is a module that offers Drupal site developers (you I presume) great flexibility of choices for displaying content. Views provides this flexibility by offering up a graphical user interface (pictured below) that allows you to query the Drupal database for content and choose the format of the content display without having to write SQL queries. I've written plenty of SQL queries in the past for business purposes and if I never write another one I won't be disappointed. If you want a much closer look at the interface I'm speaking of feel free to check out one of my videos that shows you how to do something practical with views.

Views Interface (Drupal 6)
Three Basic Types of Views
There are three basic types of views available in the base module. You can display content as a page, block, or RSS feed. When I say "content" I mean entire Drupal nodes or individual fields. For example, the page at http://learnbythedrop.com/cckandviews is a "view" that lists x number of nodes. When you list the node you get the Title + Body, plus links to comments and any other fields that would display when you are viewing a node. If you choose to display fields instead of nodes, then you can pick and choose individual fields from your nodes to display. For example,. the page at http://learnbythedrop.com/archives displays the Title (linked to the node), (Number of) Views, (Number of) Comments and (Number of) Votes fields.
The one thing that the views mentioned in this paragraph have in common is the fact that they are "page" views. Page views differ from other views because you assign a path (like http://learnbythedrop.com/archives) that displays the view as a page on your site. You can also create your list in a "block" view. When you choose block the content that you add to the view will be available on the block page (at admin/build/block) for configuration and placement just like any other block on the site.
You should put a little bit of thought in to what types of content you display in a block vs. a page. Blocks work well with lists of titles linked to nodes (see the "Recent Drops" and "Comments" blocks in the right sidebar), whereas a page might work best with full nodes or a collection of fields. Lucky for you that the views module has a very handy "live preview" feature that allows you view the results of your query while building your view.
will appear on the page. See the bottom of the page at http://learnbythedrop.com/gallery for an example of how this looks.Style Options
Drupal views also have several standard "style" options which differ depending on the type of view you choose. RSS, for example, is really a style option for your view. But if you choose to set up a page or a block view you have different options as to how the final display will appear. Some examples of style options are unformatted, list, grid and table. If you're creating a page full of nodes then you'll likely choose "unformatted" as your style. But if you're choosing a page with individual fields (like http://learnbythedrop.com/archives) then a "table" style might work best. For blocks that have lists of titles linked to nodes I typically choose the "list" style. Once again, the live preview option is your friend when making these types of decisions.
The "grid" style is an interesting choice if you're displaying just a couple of fields and want to repeat the content across and down the page. I've implemented this style on my view at http://iheartmets.com/metstweets, which shows a grid of recent tweets about the New York Mets.
- learnbythedrop's blog
- 1 comment
- Read more
- 2246 reads
Adding Community Features To Your Site
Submitted by learnbythedrop on Mon, 05/18/2009 - 19:36Lesson Fifteen of my special Getting Started With Drupal series of instructional videos.
This lesson provides guidance on how to get a community started by configuring the core forum module , the core tracker module and allowing users to be able to set up their own account. Includes a look at the changes required to the Mollom (spam prevention) and Comment Notify (subscribe to comments) modules that were initially added in Lesson Eleven.
The premium version of this lesson is encoded at the full 1024x768 resolution as originally recorded.
- learnbythedrop's blog
- 6 comments
- 1423 reads
Changes To Project Pages On Drupal.org
Submitted by learnbythedrop on Sat, 05/16/2009 - 09:23You may or may not have noticed some subtle changes to the layout of project pages for modules over on Drupal.org. A few things have changed. Links for project issues and feedback have been moved from the bottom part of the page to a larger block on the left side of the page.There is also a search field that allows for a keyword search of the issue queue and a link to subscribe to the issue queue via email. I was a little confused when I first realized there were some changes so I thought it was worth posting to give those a heads up who might be confused too.
Click To View Full Image
- learnbythedrop's blog
- Add new comment
- 836 reads
Install FCKeditor Using WYSIWYG API
Submitted by learnbythedrop on Mon, 05/11/2009 - 20:26This video tutorial shows how to install FCKeditor using the WYSIWYG API module. WYSIWYG makes it easy to install the most popular content editors on a Drupal site.
Note: Click the 'full screen' icon (to the left of the volume control) in order to watch online at full 1024x768 resolution.
- learnbythedrop's blog
- 8 comments
- 1634 reads
Install Locally With Acquia Drupal Stack Installer
Submitted by learnbythedrop on Fri, 05/08/2009 - 23:14This video shows how to install Drupal locally by using the Acquia Drupal stack installer. This is different from my previous localhost install video which required separate installations of Drupal and Wampserver. Acquia's installer is an all-in-one package that installs Acquia Drupal, MySQL, PHP and PhpMyAdmin. Acquia Drupal is a Drupal distribution that comes packaged with many useful contributed modules including CCK, Views and PathAuto.
Note: Click the 'full screen' icon (to the left of the volume control) in order to watch online at full 1024x768 resolution.
- learnbythedrop's blog
- 6 comments
- 1221 reads
Multi User Blogging Setup
Submitted by learnbythedrop on Sat, 04/25/2009 - 12:48Lesson Fourteen of my special Getting Started With Drupal series of instructional videos.
This lesson provides instruction on setting up Drupal to support blogging by multiple users. The lesson covers the addition of new users to the site, configuring permissions to allow new users to blog, creating an author list block and a biography block for each author. The lesson also covers the creation of a special "editor" role that will allow designated users limited administration rights for the management of comments and blog posts.
The premium version is encoded at the full 1024x768 resolution as originally recorded.
- learnbythedrop's blog
- 5 comments
- 1398 reads
Twitter And Your Drupal Site
Submitted by learnbythedrop on Fri, 04/10/2009 - 08:45
Twitter Node Settings

Twitter Post Example

Imported Twitter Statuses
Tweet Module
The Tweet module adds a link that makes it very easy for site visitors to share your nodes on Twitter. The link to share with Twitter is displayed in the "links section" on nodes and teasers. The tweet link can be presented as an icon and the module project page points to some free "tweet this" buttons that you can use.

Feed API
Twitter offers a wide variety of feeds that you can then import to your Drupal site using the Feed API module. Once imported via the Feed API module you can customize the presentaton of the tweets using the views module. Each user has their own RSS feed (here's mine) that is linked in the right sidebar of their profile page. Twitter searches via http://search.twitter.com also generate RSS feeds as well. Here's a feed link generated by a search for "drupal" on Twitter. You can get even more granular feeds from Twitter if you use their advanced search feature. For example, here's a feed generated from a search for "drupal" and my username on Twitter. The feed only displays the tweets from me that mention Drupal.

Tweets Imported With FeedAPI
- learnbythedrop's blog
- 2 comments
- 3208 reads
Configuring User Profiles
Submitted by learnbythedrop on Tue, 03/31/2009 - 15:58Lesson Thirteen of my special Getting Started With Drupal series of instructional videos.
This lesson provides instruction on the configuration of user profiles, including enabling profiles for public viewing and adding custom fields by using the core profile module.
The premium version is a full resolution (1024x768) version that contains additional content as indicated below.
- Configure the Real Name module to replace usernames with a proper name.
- learnbythedrop's blog
- 4 comments
- 1960 reads
Using Views To Create A Block
Submitted by learnbythedrop on Sun, 03/22/2009 - 17:39This lesson shows how to use the Views module to create a block that contains a list of node titles that link to their respective nodes.
- learnbythedrop's blog
- 7 comments
- 2308 reads
Drupal And The Cloud
Submitted by learnbythedrop on Sun, 03/22/2009 - 09:59
I have been spending quite a bit of time lately pondering how Drupal site builders can use "the cloud" to their advantage. I've been using some cloud resources for a while without giving the larger implications much of a thought. As traffic to my sites grows I've considered how to handle the challenge of maintaining (or even improving) performance while continuing to add features to my site.
So what I wanted to do was share a few ideas and links that I have found (and maybe even implemented) while pondering cloud computing in the context of my Drupal sites. Buyers please beware. I don't consider myself and expert on any of this stuff. But like many Drupal developers I'm curious and learning as I go.
Amazon Web Services
Amazon offers a number of interesting services through their Amazon Web Services division. Amazon S3 provides pay as you go, expandable storage for all kinds of files at a very reasonable price. I have an account on S3 and use the great S3 Fox add-on for Firefox to manage my files. I've been using S3 to host a variety of navigation images and icons for my sites. This strategy helps to improve performance since it balances the load of the site between the web server where you host your Drupal site and Amazon's servers. It is possible to use S3 to automatically store and deliver primary content, like photos and videos, uploaded to your site using the Media Mover module. I haven't tried the module yet but I plan to do so soon.
If you're interested in getting started with S3 please have a look at the Getting Started With Amazon S3 screencast.
One of the issues people have had with S3 is the fact that it is not a content delivery network (CDN). The files you send to S3 sit on a server at a static location and are not optimized for the fastest delivery to different locations around the world. Amazon solved that problem recently by introducing Amazon CloudFront. So if you're distributing media to the masses you can have it delivered via CloudFront and optimized for the location of the request for the file. The CloudFront pricing is very reasonable but will be added to the cost of Amazon S3 usage as well because files delivered by CloudFront are uploaded to Amazon S3. In very basic terms, when you upload a file to Amazon S3 you get two urls. One url is for delivering the file via S3 and the other is for CloudFront.
I'm using CloudFront to deliver the videos that power my recently added Learn By The Drop site guide. If you want to explore the possibilities of using CloudFront I suggest that you check out Getting Started With Amazon CloudFront.
More recently I've considered the merits of Amazon's EC2 elastic computing service. EC2 allows you to create an expandable server where you can run all kinds of web applications. This is definitely an option for more advanced developers who know how to setup servers and rock the command line. But it is getting easier to use and understand as companies race to offer user friendly tools for the EC2 service. EC2 is attractive because you can get a powerful server that can expand as your Drupal site expands and you only pay for what you use. It's unattractive because of the technical complexity and the fact that it's really not economical for smaller sites. My simple calculations estimate that a basic EC2 instance for Drupal will cost you about $60 per month plus bandwidth charges. I've no doubt that $60 is a great price for a server but most sites won't need the kind of horsepower EC2 offers.
Here are some links related to EC2 and/or Drupal that you can take a look at to learn more.
How To: EC2 For Poets | WorkHabit Drupal EC2 AMI Screencast | Drupal In The Cloud | CloudKick
Google Docs
I've been using Google Docs to replace some functions that would otherwise be handled by Drupal. Last year and this year I wanted to include a baseball schedule on my Mets fan site. With a csv file in hand I considered importing it to the Drupal database but decided to use a spreadsheet on Google Docs and embed the file in a page on my site. You can see the results here. I've also found Google Docs helpful for creating surveys using their "forms" feature. You can create an embeddable form whose data is saved to a spreadsheet on Google Docs. I'm using this technique to collect data from my Drupal Use Survey. What you essentially get from the service is a simple database that is hosted by Google.
There are always lots of questions about using 3rd party services to outsource your Drupal site functions. Some people have privacy concerns. Others worry about the reliability of the 3rd party service affecting their site performance. These concerns are valid. So I think it's smart to consider the Drupal-only way vs. using Google Docs when adding functionality. Google Docs is worth considering for collecting and/or displaying data if the content involved is not the primary content for your site. It keeps the size of your database down and (assuming Google's performance is solid) removes a bit of load from your web server.
Stop Sharing Spreadsheets, Start Collecting Information
Mosso: The RackSpace Cloud
I found Mosso only recently and I could see that it was a step in the right direction in helping the average Drupal developer to deploy their site on a powerful server. The service is billed as, "The fastest, easiest way to put sites in the cloud." It sounds like Mosso offers you the power of a dedicated server with greatly simplified setup and management. It differs from Amazon EC2 because what you get with EC2 is basically an empty space whereas your space with Mosso is filled with the goodies you need (MySQL, PHP, etc.) to run a Drupal site. Mosso's pricing starts at $100 per month, which is at least $40 more than the Amazon service. But there's definitely value in the simplicity of a managed environment where less technical ability is required.
Services like Mosso will appeal to those who want a high performance Drupal site but don't have the technical ability (or the desire to hire someone) to deploy a high powered web server. Cost could become a downside if your sites get popular. Mosso estimates that a top 1000 Technorati blog could cost about $800 a month on their service. Then again if your sites suddenly get very popular other hosts might shut you down (for exceeding bandwidth limits) while Mosso will allow you the room to grow in an instant.
If you're curiousity has been piqued then take a look at Installing Drupal 6 On Mosso.
Drupal And The Cloud
There are a lot of great tools and services that can help developers achieve benefits that were previously only available to those who could afford to spend thousands of dollars per month. It's an exciting time as competition builds in the race to bring the cloud to the average web developer. I have no doubt that Drupal developers will be able to take advantage of many of the things that come along.
- learnbythedrop's blog
- 14 comments
- 3232 reads






Comments
2 hours 29 min ago
17 hours 42 min ago
17 hours 47 min ago
18 hours 27 min ago
19 hours 8 min ago
1 day 2 hours ago
1 day 2 hours ago
1 day 2 hours ago
1 day 2 hours ago
1 day 2 hours ago