Drupal Magcat Module

Welcome to the home page of the Magcat Drupal 6 Module - an add-on to my Bookcat Drupal 6 Module. Magcat is aimed primarily at those with magazine collections; out of the box, FNProgramvare's Bookcat does not lend itself to magazine collections, but by using the available custom fields, and by creating some new template pages in my Magcat module, it is a perfect fit! Laughing out loud

Obviously to get the best out of Magcat, you will have to utilise the custom fields in an identical way to me. But more importantly you will also have to group your magazines using the Series facility. I am using a Series entry for each magazine title to group a magazine title together - this gives great scope for anomalies such as when a magazine changes name or publishes special editions such as annuals or summer specials or any other type of one-off.

The following custom fields are being used:

Custom01

I am using Custom01 to store the Volume number of a magazine which should be numeric. Many magazines don't use volume, so leave it blank in those instances.

Custom02

This is being used to hold the Issue Number of the magazine which should be numeric. Magazines frequently combine a volume number with an issue number 1-12, although some magazines have sequential issue numbers incrementing each month without being reset to 1 at the end of the year. Zero is also an acceptable value - some magazines publish 'Issue 0' on launch as a trial.

Custom05

This is being used to hold the Year of the magazine. Note that this is a look-up table where you pick from a selection list. For the sample demo database I have used the following:

mysql> select BookCustom05, SortBy FROM BookCustom05 ORDER BY SortBy;
+--------------+--------+
| BookCustom05 | SortBy |
+--------------+--------+
| 1962         | 1962   |
| 1966         | 1966   |
| 1969         | 1969   |
| 1970         | 1970   |
| 1971         | 1971   |
| 1972         | 1972   |
| 1973         | 1973   |
| 1975         | 1975   |
| 1976         | 1976   |
| 1977         | 1977   |
| 1978         | 1978   |
| 1979         | 1979   |
| 1981         | 1981   |
| 1984         | 1984   |
| 1985         | 1985   |
| 1986         | 1986   |
| 1987         | 1987   |
| 1997         | 1997   |
+--------------+--------+
18 rows in set (0.00 sec)

mysql>

Custom06

This is the place for the Month of the magazine, although of course it doesn't have to be limited to month - you can use it for season, or bimonthly editions, or whatever. The key here is to ensure that you set the SortBy value to be something useful so that Magcat sorts the months in the correct order. You may want to check out my entry below - this contains entries of months, seasons and bimonthly.

mysql> select BookCustom06, SortBy FROM BookCustom06 ORDER BY SortBy;
+-------------------+--------+
| BookCustom06      | SortBy |
+-------------------+--------+
| January           | 01     |
| January/February  | 01     |
| Spring            | 01     |
| February          | 02     |
| Summer            | 02     |
| March             | 03     |
| March/April       | 03     |
| Autumn            | 03     |
| April             | 04     |
| Winter            | 04     |
| May               | 05     |
| May/June          | 05     |
| June              | 06     |
| July              | 07     |
| July/August       | 07     |
| August            | 08     |
| September         | 09     |
| September/October | 09     |
| October           | 10     |
| November          | 11     |
| November/December | 11     |
| December          | 12     |
+-------------------+--------+
22 rows in set (0.00 sec)

mysql>

Prerequisites

The Magcat module has the same dependencies as my Bookcat module, plus it needs the Bookcat module installed also.

Instructions

Download the module and add to your Drupal build as you would any other. Enable the module; it inherits the permissions of Bookcat so you don't need to set new permissions. If you aren't running the latest version of Drupal Bookcat you should upgrade at this point. When you open a bookcat database you will see a new link in the footer that takes you to the Index page of Magcat. This is one of three new pages in the Magcat system. If you click through, you will see the screen below.

Index Page

Magcat1The main index page is very similar to the Bookcat main page, the main difference being the magazine titles that are list on the left of the screen (1). As mentioned previously, these titles are obtained by retrieving the series entries. If you have a database containing books with series, and magazines with series, you may need to consider separating magazines into their own database. By clicking one of the titles, you will navigate to the MagazineSeries page.

MagazineSeries Page

Magcat2This is the view that gives you the information you need regarding a particular magazine title. There are some interesting features here - for instance (1) shows a collation of all the cover prices of the magazine title in the collection. A great feature for UK users for magazine's predating the 1971 decimalization is the old pounds/shillings/pence (LSD) prices are show. In addition, many magazine move publishers over the years,and magcat is capable of displaying the different publishers (2). Point (3) shows a list of the years of the magazines in the collection. The potted history of the title is at (4) - this needs to be stored in the Series Notes field. To obtain a list of the magazines, click on link (5)

Magcat4In addition, if the editor information is captured when the magazines data is input, a list of the editors is displayed at (6). Issue numbers in ranges of 10 magazines are available (7), whereas at [8] lists all database entries that have no custom fields associated with them, i.e. no year, month, volume or issue number.

MagazineList_Series Page

Magcat5The list page shows a list of a particular title with sorting available by volume, issue number, year, month.

Magcat6Filters are also possible on this view (1) by clicking on one of the links on the previous page. Shown here is a list of all magazines with a cover price of 45p which isolates a particular period.

To give the demonstration a whirl, click here


AttachmentSize
magcat-6.x-1.0-alpha2.tar.gz10.57 KB
magcat-6.x-1.0-alpha1.tar.gz10.62 KB