Composr Tutorial: Custom structured content (via catalogues)

Adding a catalogue

(Click to enlarge)

The catalogue system is a bit like a visual database system such as Microsoft Access: you create your own ‘record definitions’ that define what data you want for your records, and then you can add these records, and browse through them. All you need to do is to specify what goes in the records: the rest is all handled for you.

You can have as many catalogues as you like, and some premade ones provided by default.

(in American English catalogues are spelled "catalogs")

The pre-made catalogues are:

• Links (for sharing links with visitors)
• FAQs (frequently asked questions and answers)
• Projects (a simple projects listing)
• Contacts (a simple contacts directory / address book)

All the pre-made catalogues may be removed in the Setup Wizard, so depending on what you chose in that wizard, they may or may not currently be on your site. They are somewhere between mere examples and a 'leg up' to producing a website.

Catalogues can be used to model most things required by large websites that would otherwise have to be implemented either as new modules, or hard-coded pages. Note that catalogues are designed to store records of which there are likely more than one, not as a container for all unstructured custom information (that is what Comcode pages are for).

Catalogues are initially defined by the fields in them. 'Categories' are then made in the catalogue. Then categories are filled with 'entries'.

A warning

In some ways we give you enough rope to tie a knot with via catalogues. In most cases, catalogues are great, but if you're not creating a pretty simple set of records you'll probably want a programmer.

For a more detailed discussion, see the How to approach complex projects tutorial.
I also highly advise reading the what Composr is not page which tries to spell out the practical realities of how to work with Composr (or any CMS really).

There are loads of features within the catalogue system, and there are more we could add to give yet further power that could be sponsored. Just proceed with caution, considering the cases laid out below.

Database design

A single catalogue entry can easily have 20 database rows associated with it (to be exact it is the number of fields in the catalogue plus one) -- that's a lot in the database.

Considerations you may not have thought of:

• sophisticated data relationships
• efficient searching
• data reliability
• ease of manual editing

The above items need proper database design, with an understanding of normalisation and linker tables, and indexing, and efficient query patterns. Catalogues do not give you that.

Custom editing interfaces

You may find the auto-generated add/edit form isn't good enough for you. If this is the case, you'd be best off coding a new content type directly, so that you have full control.

Adding new features

If you later want to add some custom code features for interacting with catalogue data, it is a lot harder programming with the level of abstraction that catalogues have.

Limitations

To preserve performance limitations may be imposed, including:

• Sorting may not be done on translatable/Comcode fields if you have over 300 records in a result set (typically a result set is a category)
• … or sorting by distance from co-ordinates in the same condition (advanced feature)

Fields

A catalogue consists of a number of fields.

You may order the fields, make some invisible, make some optional, and choose which defines ordering.

The first field in a catalogue is used as the title field for entries in that catalogue.

You may also specify which fields may be used to search the catalogue (searching is performed with the regular Composr search module).

For details about the actual field types you can use, see the Custom fields tutorial.

Modes of display

Display type

Embedded ratings (advanced)

Ratings will only appear on category views if there are no separate entry views. There are no separate entry views if all these conditions are met:

• All fields are visible on categories
• Trackbacks are not enabled
• Commenting is not enabled

You may be surprised that rating doesn't show on views for the bundled links catalogue, even if you manually add in the {RATING} Tempcode parameter somewhere to the entry templates. This is because the URL field is not set to visible, due to how it is folded in with the title field in the template.

This can be remedied by manually adding a rating field to the templating. The changes (which would be done in proper template overrides) would be like this:

Adding a catalogue

To add a catalogue (among other functions) go to Admin Zone > Content > Catalogues > Add catalogue.

Once a catalogue is added it will get its own icon under Content Management.

Editing/deleting a catalogue

Editing a catalogue

(Click to enlarge)

You can edit a catalogue to change details, add, edit or remove fields. Access this at:
Admin Zone > Content > Catalogues > Edit catalogue, or from under Admin Zone > Content > <Catalogue name>.

You cannot change field data types after you have created them (except between field types that have the same "storage" type) as this would affect the integrity of any data that may have already been entered into them. A workaround is to export to a spreadsheet, delete the field, create a new field with the same name and the new type, and reimport the spreadsheet.

You can delete a catalogue from the bottom of its edit form.

Adding/editing/deleting categories.

Permissions

Like other Composr content types, catalogues support access permissions. However because catalogues essentially allow many different content types to be produced (each in their own catalogue), there is an extra layer of permissions available: you may set access permissions for both catalogues, and categories within them.

If you manually alter the templates so that upload/picture fields display the raw URL, rather than going through Composr's downloader script, then you will need to delete the uploads/catalogues/.htaccess file. By default permissions are denied to directly access these URLs, to prevent users without catalogue access from accessing individual files.

Note that assigning permissions to add/edit whole catalogues comes with a high risk -- as permission to post any Comcode/HTML effectively comes with permission to add the catalogue.

Customising the look & feel of catalogues (advanced)

If you have multiple catalogues on your website and you wish for them to have customised appearances, this is possible for advanced users via one of two ways:

Tempcode programming

It is possibly to achieve template customisation wholly within the default set of templates, by using template programming. The catalogue name is passed into every catalogue template meaning you can use template IF directives to differentiate against that name, producing different output accordingly.

While the main CATALOGUE_DEFAULT_FIELDMAP_ENTRY_WRAP.tpl template uses the FIELDS parameter by default (which consists of precomposited template field rows, built using the other templates), it is also given special parameters correlating to each individual field row and each individual field value. You may thus entirely customise the catalogue look using these low level values to make very customised arrangements that are more complex than the simple tabular arrangement used by default.

For example, take the CATALOGUE_DEFAULT_FIELDMAP_ENTRY_WRAP.tpl template:

Our simple change. This is obviously a very basic change, but I just wanted to give one real quick example.

(Click to enlarge)

Let's imagine we have made ourselves a catalogue called classifieds, and we want to add a very simple little snippet to the end with profile and e-mail links. In this case we could add something to the end of the template, like:

You can see how you can reference individual fields in the template like {FIELD_0}.
For a full table of fields you can use, put {+START,PARAM_INFO}{+END} temporarily into the template, and it will show you everything defined in a neat table.

Field values are available in three forms:

1. Standard (e.g. {FIELD_0}) --  Parsed for Comcode (if applicable), and rendered by the field code
2. Plain (e.g. {FIELD_0_PLAIN}) -- Parsed for Comcode (if applicable), and not rendered by the field code
3. Pure (e.g. {FIELD_0_PURE}) -- Not parsed for Comcode, and not rendered by the field code

They are also provided in sequence order (e.g. {FIELD_0}) and by field ID (e.g. {_FIELD_44}). Field ID is more robust, should you reorder fields later it won't affect the naming.

Custom template sets

With some file system manipulation, you may make use of the 'custom template sets' feature. You then need to go to the themes/default/templates directory in Composr and copy all the CATALOGUE_DEFAULT_*.tpl files to themes/default/templates_custom/CATALOGUE_<your-catalogue-codename>_*.tpl.
You would then customise these templates as appropriate.

When we talk about default catalogue template set, we are referring to the CATALOGUE_DEFAULT_*.tpl files rather than referring to the default theme or the default versions within that theme. It is possible for custom themes to have their own versions of the default catalogue template set, and also per-catalogue versions.
We're using the word default in different contexts, so to clarify:

• themes/default/templates/CATALOGUE_DEFAULT_*.tpl -- the default theme's default template set
• themes/default/templates_custom/CATALOGUE_DEFAULT_*.tpl -- the default theme's overridden default template set (i.e. a site's owner has decided to override it but not on a per-theme basis)
• themes/default/templates_custom/CATALOGUE_somecatalogue_*.tpl -- the default theme's custom template set for the somecatalogue catalogue
• themes/mytheme/templates_custom/CATALOGUE_DEFAULT_*.tpl -- the mytheme theme's overridden default template set
• themes/mytheme/templates_custom/CATALOGUE_somecatalogue_*.tpl -- the mytheme theme's custom template set for the somecatalogue catalogue

We intentionally did not provide a highly user-friendly interface for enabling custom template sets because the process of working with multiple sets of templates is inherently difficult, and by setting it up manually you will get a better feeling for what Composr does.

Seamless catalogues

As well as customising the catalogue templates, you may also customise the language strings used by catalogues in a similar way to how custom template sets are customised. This gives you further control on how things appear to visitors within a particular catalogue.

To do this, you need to manually edit the lang/EN/catalogues.ini file to add new equivalents to the DEFAULT__* strings (where 'DEFAULT' is replaced with the codename of the catalogue that you are customising for). In fact, you should actually save your changes into lang_custom/EN/catalogues.ini, so that they are not lost during upgrades.

You can see this has already been done for some of the default catalogues:

Here's what they do:

• <catalogue-name>__CATALOGUE_INDEX -- Used to make the screen title when viewing the catalogue index
• <catalogue-name>__CATALOGUE_CATEGORY -- Used to make the screen title when viewing a catalogue category
• <catalogue-name>__CATALOGUE_ENTRY -- Used to make the screen title when viewing a catalogue entry

If you have the language cache enabled then you will need to empty the language cache before these changes will show up.

You can also add descriptions to the add and edit screens for catalogues by creating new strings like:

Here's an example lang_custom/EN/catalogues.ini for having customised strings for a classifieds catalogue:

Searching catalogues

The Composr search module provides special support for searching catalogues by matching against field values. You can choose which fields are searchable when you add them to the catalogue (or when you go back to edit).

For more information see the Searching your website tutorial.

Spreadsheet import

You can import CSV spreadsheet files into catalogues. Be aware this adds entries only, it doesn't try and do any merging with what is already there.
You can also export spreadsheet files. Some general notes about using spreadsheet files with Composr may be found in the Advanced Composr member system tutorial, as importing/exporting members via spreadsheet files is the most common use of spreadsheet files within Composr.

Creating a tree catalogue, fast (advanced)

There is a special feature on the screen to add a catalogue with a category tree constructed automatically for it.
To define the tree you just need to type in the categories you want in a special format that is very quick to write.

This is best shown by example, so here is an example for a catalogue category tree with that has categories for each of the states/provinces in the USA and Canada:

Breadcrumbs (advanced)

The breadcrumb structure for catalogue is quite subtle as it depends on various factors:

• Configured breadcrumb XML code
• Tree catalogue vs Non-tree catalogue
• Virtual roots

By default catalogue breadcrumbs include the list of catalogues. However, Composr also provides some default breadcrumbs XML that takes this out, because most webmasters don't want users to think of catalogues as anything separate.

Tree catalogues don't include a link back to the index for the catalogue, while non-tree catalogues do. This is because a tree catalogue provides full category access via the root, while a non-tree catalogue relies on the index.

If a virtual root is set then it will cut off everything before the virtual root (including parent categories, the index, and the list of catalogues). Virtual roots for catalogues are opened up with the keep_catalogue_<catalogue-name>_root URL parameter.

The default breadcrumb XML looks like this…

Screenshots with default breadcrumb XML

Tree catalogue

Viewing a category

Viewing a subcategory

Viewing an entry

Non-tree catalogue

Viewing an index

Viewing a category

Viewing an entry

Screenshots without default breadcrumb XML

Tree catalogue

Viewing a category

Viewing a subcategory

Viewing an entry

Non-tree catalogue

Viewing an index

Viewing a category

Viewing an entry

Custom fields for other content types

Most content types in Composr allow you to choose custom fields for them. This is actually powered by catalogues -- catalogue entries are automatically associated with other content entries, in order to extend them.

Upload security

Note that upload security (for file, picture, and video fields) is not perfect for custom fields. The security is checked when accessing a file field if it is a catalogue entry, but there is no mechanism to check the permissions of the content for which custom fields are attached.
A similar caveat holds true for Custom Profile Fields, which share the same field types.

Special kinds of catalogues

eCommerce catalogues

Composr can have special eCommerce catalogues, which integrate with the Composr shopping cart. This is explained in the eCommerce tutorial.

Classified ads

Catalogues are ideal for setting up a classified ads system. In fact, there is special support for this as you can program a catalogue to move entries to an archival category after a specified period of time passes. There is also a permission ('Have a longer expiry-time for catalogue entries') that allows you to grant usergroups a longer period of advert display.

This feature works by logging the date/time for each entry added. This is stored in the ce_last_moved field in the database, under each entry. Any entry in a category that has a move target assigned will be scanned to see if the ce_last_moved date/time is more than the configured number of move days. If it is, the entry is moved. When an entry is moved, the ce_last_moved date/time is reset to the current time. Therefore you could, if you wished, set up chains of movements. There is no way in the Composr UI to change ce_last_moved manually (it is not affected by manual moves, validation, or editing), although you could manually make changes to it in the database or you could manually move it back after it has moved and therefore the timer reset. As the movement happens in the system scheduler, the system scheduler must be configured.

The non-bundled classified ads addon overrides the functionality of ce_last_moved and uses it to track listing times. Unlike the default functionality, this de-validates entries rather than moving them (to allow listing extensions).

See also

• Custom fields
• Catalogues in Composr
• Adding standalone pages of content (via Comcode)
• eCommerce
• Catalogue field references

Feedback

Have a suggestion? Report an issue on the tracker.