Categories
Miscellaneous

Calendars 2011

I know, 2011 has already started a few weeks ago. However, I still owe you the DIY Planner calendar. Of course, the calendar differs from Ygor’s template in having week numbers on all templates. This year, I translated it to German as well, so you can have the German or the English version for download.

Unfortunately, I haven’t been able yet to create a Windows executable that runs without any additional library. So you have to build the version from your own scratch. The source code is available at my Subversion repository.

Categories
CSV

CSV/Excel Utility Package V2.1 released

I finished this release some months ago but didn’t find time yet to finally release it. Version 2.1 introduces some new features and classes that ease handling of table-like data from different sources:

  • New TableReader implementations for JDBC, XML, JTable
  • New TableWriter implementations for HTML and XML
  • Introduction of type conversion to allow object-string conversion and vice versa while reading and writing tables
  • New Reader and Writer wrappers that read and write JavaBeans.
  • New Filter implementations for TableReader that remove rows and columns.
  • Some abstract classes were separated into general base classes and stream-handling classes. This allows easier development of non-stream based implementations.

You can download the new version here or visit the Homepage of the utility where you will find some examples on how to use it.

Categories
Typo3

Typo3 and RealURL

I use various sites with Typo3 and RealURL extension. Mysteriously, it sometimes happens that links at the frontend do not work after updating Typo3 itself or any extension. Problem detection is very complicated because RealURL has a very hidden and strange behaviour. Even worse: it seems that there is no rule on what links can be decoded and what not.

Main things you have to do if you get “segment X ist not a postVarSet variable” error:

  1. Make sure you are logged off from the backend
  2. Make sure you give RealURL a chance to fill the path cache by clicking in your frontend from top to bottom!

What internally happens is as follows: Once the path cache is emptied, it will be filled again only when you are logged off from backend. I have no idea why RealURL implemented this feature but it has a special condition check before updating the cache that makes sure the user is not logged into the backend.

Furthermore, cache update happens only when “Encoding” takes place (ID to path translation). That means that you will get the postVarSet error when you try to get a page from your frontend before RealURL did encode it. That’s why you have to click “down” your website from top to bottom, so all links are created before they are ever requested by your browser.

So next time just follow this two simple rules and your RealURL extension will behave as expected.

Categories
Miscellaneous

Subversion Web Browsing

The default solution to subversion browsing is WebDAV within Apache. However, it has some drawbacks. You cannot browse history, see comment histories or even check filestamps.

WebSVN provides all these features and comes along with a very modern style. The best of all: You don’t need to install any additional modules. All that WebSVN requires is a current PHP version.

I just switched from the WebDAV solution here on my server to WebSVN. So, check it out…

Categories
CSV Java

CSV/Excel Utility Package V2.0.2 released

The package has undergone some minor bugfixing andJUnit Test was introduced for CSV files. Thanks to eldn for his help making this release.

You can download it here or visit the Homepage of the utility where you will find some examples on how to use it.

Categories
CSV

CSV/Excel Utility Package V2.0.1 released

It took me quite some time to upgrade this package to the next level and support Excel. It propably still has some flaws. However, I use it now for some months in production and fixed the most critical bugs. In fact, it seems to run quite stable now.

Please note that upgrading from previous version will require you to update your package imports.

You can download it here or visit the Homepage of the utility where you will find some examples on how to use it.

Categories
Java

Log4j Configuration Problem

It seems that some documentation that is hanging around the net contains incorrect information about correct configuration of the log4j system.

Take care that you specify the properties filename as an URL rather than simple plain path location, e.g

java -Dlog4j.configuration=file:///my/path/to/log4j.properties ...

Log4j should find your configuration then. So make sure you include file:// there… 😉

Categories
CSV Java

CSV Utility Package 2.0 Beta

Some work has been spent over the last weeks to upgrade the stable CSV Utility Package. Of course, the new version contains all the useful existing functionality. The most beneficial improvement is the introduction of ExcelReader and ExcelWriter classes that behave like the CSV pendants. This means that you do not have to care about the underlying output format when you want to read or write table-structured data. The most important changes are:

  • Introduction of a TableReader and TableWriter interface
  • Introduction of Excel implementation
  • Aligning CSV and Excel implementations to these interfaces
  • Introduction of a Factory class in order to select correct implementation (CSV or Excel)

The Beta version still requires some work in terms of documentation and code beautifying. However, the CSV part is already frozen and you can use it to upgrade your existing projects to the new utility version. The Excel part still faces some changes while improving usability.

Please be aware also that Java package structure needed to be changed to integrate the new classes and interfaces. Additionally, new 3rd party libraries were integrated (Apache POI and JavaBeans Activation).

Download the Beta Version or browse the existing API Documentation. Bugs and/or enhancements can be requested via Bugzilla.

Categories
Miscellaneous

SMTP and POP servers

There is a great SMTP/POP server list in case you need to configure around some of them:

http://www.patshaping.de/hilfen_ta/pop3_smtp.htm

Categories
Miscellaneous

Calendar 2010

I finalized my DIY-Planner for 2010. You can download the new calendar here (created with my personal fix for DIY Dynamic Templates).