We're super excited to release a new series this week, which has been a highly requested one on our suggestion list: PSD to Drupal Theme. This series walks you through the process of converting a static design into a Drupal theme. We'll be covering strategies for breaking down your design into Drupal pieces, extracting your design assets, and working with those components in your CSS. Along the way you're going to also be introduced to grid frameworks, Sass, and other very helpful general web development tools. At the end you will have a theme that you can install and enable on your Drupal site. Having a little bit of Drupal site building experience, and a little bit of Web experience (HTML and CSS) will be helpful but it's not required, so if you find the world of Drupal themes mysterious, this is a great series to clear the fog.

After a brief break from our video schedule, we are back on track this week, picking up the trail on the Using Drupal Chapter 4, Media Management series. In these three lessons we'll take a look at how to get media into the body of our content, instead of as a separate field in our nodes. We'll look at what general solutions are out there for web development, by taking a look at tools like BUEditor, Markdown, and CKEditor and explaining what WYSIWYG is all about. We'll also spend some time to explain the very important, but often overlooked, text format feature of Drupal. This is an important concept to understand to make your content editing experience better, and make sure you keep your site secure. Lastly, we get a nice, shiny WYSIWYG installed on our site, and integrate our Media Browser with it.

This week we are starting off two new series at the same time to cover a very important topic for web sites today: Media Management. Almost every site out there needs to work with media in some way, whether it is just uploading images in your blog posts, or having to work with audio and videos in a variety of ways. In Drupal 7 the Media module has become the go-to solution for handling the full range of media needs.

Very few migrations are simple and straight-forward enough that a simple field mapping gets all of the little bits you need. In this week's Importing Data With Migrate and Drupal 7 lessons, we take a look at some complicated field mappings. We are going to add some new data we need to import, with team information. The team data is related to our player data through a relationship, and a player can have multiple teams they've played for.

This week we're finally ready to dive in and write our first custom migration with the Migrate module. To get things set up, we need to get our source data, and create the content type in our Drupal site so that we have a destination. Joe walks through grabbing some baseball stats in SQL format for the source, and then building out the content types we'll need for teams and players.