eZ Community » Blogs » Harry Oosterveen

Member since: 10/07/2003

Blog entries
  • Currently 5 out of 5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Make life easier with SQL Views

Thursday 15 November 2012 12:39

by Harry Oosterveen  | 7 comments

Every now and then, I find myself exploring the database behind eZ Publish, trying to do some obscure queries, or just because it is quicker to do the queries in a database tool than to write a script to do it and use the regular fetch functions.

There are more than 100 tables, and you often have to combine a few of them. You may have to write complex and long queries. Good SQL tools have the option to store your favourite queries, it saves you the typing, but the queries are still long and complex.

Using SQL views, you can use the result set of such a query and  create a virtual table with always up-to-date data. Now you can treat a complex query as if it were a simple table. 

  • Currently 5 out of 5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

An alternative approach to RSS exports

Thursday 04 October 2012 01:03

by Harry Oosterveen  | 1 comment

The standard eZ Publish RSS export works, you can relatively easy set up an RSS export. But you have to set up each RSS export manually, which can become cumbersome if you have a large number of RSS feeds to export.

I recall from discussions on the forum (could not find them back, there are just to many hits with RSS), and perhaps there are extensions implementing this already, to use the template mechanism to create RSS feeds, just like you create any view in eZ Publish.

This alternative approach uses a lists of prefered attributes to create each field in an RSS item from the selected objects. This gives a flexible way of creating RSS exports, so you can easily create multiple RSS feeds. This is demonstrated in a project to create RSS feeds based on tags given using the eZ Tags extension.

  • Currently 4 out of 5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Create a CD-ROM from your eZ Publish site

Thursday 16 August 2012 11:59

by Harry Oosterveen  | 0 comments

Targeting an audience with often poor Internet connections, IRC wants to provide information not only on the web site, but also on CD-ROMs. Using this tool, we can create a copy of (part of) our web site on a CD-ROM.

  • Currently 5 out of 5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

The Additional Nodes Pitfall

Wednesday 14 March 2012 11:51

by Harry Oosterveen  | 2 comments

Since the early versions 3.x there have been issues with the concept of additional nodes. The Technical Manual keeps mentioning it as a 'Pitfall', but nothing has happened to address the problem: in one location, content is visible with the subitems, in another location, the content is without the subitems. This article describes how the problem can be addressed.

  • Currently 5 out of 5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Restore a sub tree from the trash in eZ Publish

Thursday 16 February 2012 07:42

by Harry Oosterveen  | 9 comments

The trash is great: it just happens that you will accidentally delete an item, and you can simply recover and place it in the original location. This works well if you deleted a single item, but If the item you deleted has many sub items, this becomes cumbersome. A long time ago  this issue had been raised, but so far no solution has been created.

As it recently happened that I had to restore a large number of items from a sub tree from the trash, I created this script. Given a node ID, it restores the node itself and all items from the trash that are sub items (to any depth) from this node.

You must be logged in to track the activity of this blog!

Proudly Developed with from