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).

Categories
Applications CSV

CSV Utility Package V1.0.2 released

I made some fixes and enhancements to the CSV Utility Package:

  • Bug #9: Spaces before and after a value are treated correctly now
  • Enhancement #10: CSVReader forwards comment lines to callback objects
  • Enhancement #11: A test script was integrated to check major features
  • New Class: CSVUtils offers methods for copying JDBC results and JTable data to CSVWriters

You can download the latest release here.

Categories
Linux Miscellaneous

PDF Printer with Linux

I use a PDF Printer on my professional Windows notebook. It enables me to create PDF documents from whatever application. So, how about Linux then. Thanks God, there is cups-pdf. A German tutorial can be found here. If you find a English HowTo, just post the link here.

Categories
Applications CSV

CSV Utility Package V1.0.1 released

A new update of my CSV Utility Package was released. It contains some fixes and enhancements:

  • Build system creates tar archive
  • Fixed Bug #2: NullPointerException in CSVReader class
  • Fixed Bug #4: Multiline values fail when a line looks like a comment
  • Enhancement #7: Excel Fix: first column of first row must not start with “ID”
  • Enhancement #8: Add row and column count

You can download the latest release here.

Categories
Linux

Switch Off Caps-Lock

I was always annoyed by CAPS-LOCK key on my Linux notebook. Thanks god, there is a solution:

xmodmap -e "remove lock = Caps_Lock"

will switch this damn thing off. 🙂

Categories
Miscellaneous Perl

Regular Expression for Email Addresses

[-A-Z0-9._%+]+@[-A-Z0-9.]+\.[A-Z]{2,4}

Categories
Apache Perl

Installing Bugzilla

This was weird. I lately tried to install Bugzilla on one of my virtual hosts but it’s testserver.pl script failed with:

Use of uninitialized value in pattern match (m//) at ./testserver.pl line 110.
Use of uninitialized value in pattern match (m//) at ./testserver.pl line 110.
TEST-FAILED Webserver is not executing CGI files.

The Apache error log told nothing more than

Premature end of script headers: testagent.cgi

All Google lookups failed to solve my problem. Although I had the impression that my CGI setup was somehow wrong, I couldn’t find the reason. Then I intensively checked the VirtualHost directive. The server uses a Plesk 8.0 installation for setting up hosts. The default configuration for virtual hosts with CGI there is to include a “SuexecUserGroup” directive. After removing it, the Bugzilla installation succeeded.

So you might wanna give it a try 😉

Update May 6, 2012: You might also want to try these commands when experiencing “Access Denied” problems in a virtual host environment:

find . -type f -exec chmod o+r {} \;
find . -type d -exec chmod o+rx {} \;

Do not forget to revert this change for localconfig file!!!

Categories
Miscellaneous

Personal Fix for DIY Dynamic Templates

Dan White wrote a wonderful Qt4 application for creating a personal D*I*Y planner. I like it a lot and it saves my job every single day since I use it. However, there is one flaw in his templates. The week numbers are missing in calendars. Luckily, he published his source code so I could make some fixes. And of course, I publish it to you for personal use as well.

The files you can download below are based on version 2.04. Following adjustments were made:

  • Added week numbers to day, week, month and year templates
  • Adjusted default page setting to European ISO style A4
  • Adjusted default zoom to 9 (instead of 25)

Download

Windows Executable 2.04 plus Fixes

Source Code 2.04 inkl. Fixes

Screenshots

Please excuse the German wording. I hope this will vanish on English PCs 🙂

Old version at the left, new version at the right…

day

week

month

year2

month-box