A project by Ecodev Sarl

EREN

The Evangelical Reformed Church of the Canton of Neuchâtel (EREN) website was designed with the aim of providing:

  • an efficient and attractive communication tool of what the EREN is and does
  • a calendar of events that can be filtered according to multiple criteria and serves as the source of information for la Vie protestante (XML output)
  • a centralized address book of people involved
  • a common platform for all parishes of the canton

Specifications

Tesseract was used for different purposes such as the listing of:

  • people involved
  • buildings (temples and chapels)

Tesseract was also used to create a photo gallery automatically from a subset of pictures stored in a resource management module (based on the DAM).

Implementation

A resource management module has been developed for specific customer needs. The database contains a table with all related informations about the pictures. The selection of the subset of pictures is based on a tag. Tesseract is used to display this subset as a picture gallery enhanced by jQuery Facebox.

The major advantage of Tesseract in this case is to enable a rapid and simple implementation of a photo gallery by a TYPO3 integrator that can then be  easily replicated elsewhere in the website by the customer.

Screenshots

Example of a picture gallery powered by Tesseract and jQuery 

Example of a picture gallery powered by Tesseract and jQuery

All the Tesseract components

All the Tesseract components

The HTML template

The HTML template

 The SQL query

The SQL query

 The data filter

The data filter

View the site

Easy to replicate

This project shows how easy it can be to set up a photo gallery based on the DAM. The power of "dataquery" and "datafilter" make it possible to select specific DAM records, thus enabling targeted and dynamic photo galleries.

For the end user, the solution is also very easy to use, since it just depends on proper tagging of pictures in the DAM.