In a complex database, with many tables, you often end up with long queries combining those tables. Rather than repeatedly writing out those queries, you can use SQL Views–turn those complex queries into a virtual table, and use that table instead. Requires hardly any storage space, always up-to-date, wish I had found this earlier.
In this blog post, I explain how SQL Views can be applied in the database structure of eZ Publish.Go to the post on share.ez.no.
Of course, also in eZ Publish it has always been possible to create an RSS feed. These will include items based their location in the content hierarchy. I have developed this extension to create RSS feeds based on tags given to each page, which makes it possible to create RSS feeds with just those items that one is interested in. Similar to the categories feed in WordPress, e.g. https://www.harryonline.net/category/ez-publish/feed
You can read more about this new extension on the eZ Publish project site at http://projects.ez.no/eztagfeed
404 – Page not found is the all too common error message, when a web page that you were looking for, is not at the requested location any more. Some sites have really cool and creative 404 error pages, but that’s not what you wanted.
If the page still exists on the site, this handy tool will help you to quickly find it back. Continue reading
Most converters from PDF to Word/RTF don’t do a very good job. If the text in the PDF is flowing straight from top to bottom, no problem. But if the text is in tables, columns, most converters mess up, so the garbled result is useless for further editing. I found a converter now that does a decent job, both online and as a desktop application. Continue reading
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, one can create a collection of documents on an eZ Publish site and easily create a CD-ROM from it, with a user-friendly interface, including a menu. Of course, distribution on DVD or USB stick is another option.
See the post on the eZ Share site on Creating a CD-ROM for all the details.
Hello World!, the standard post on a new WordPress site. I have explored several ways to set up this blog both in English (harryonline.net) and in Dutch (harryonline.nl). Read how it has worked out. Continue reading