Category Archives: Uncategorized

Groovy: StreamException: Cannot create XmlPullParser

If you get this error message, you might want to remove “xmlpull-1.1.3.1.jar” and “xstream-1.4.7.jar” from GROOVY_HOME/lib as a workaround. These libraries provided with Groovy seem to conflict with the ones used by the application. I didn’t notice any side effect … Continue reading

Posted in Uncategorized | Leave a comment

Perl’s “quote word” in Groovy

When it comes to embedding a long list of simple text strings in the code, Perl’s “quote word” is very handy: This is the closest equivalent I could find in Groovy: You can also use a multiline string : The … Continue reading

Posted in Uncategorized | Leave a comment

How to identify the end of lines used in a text file

It’s pretty easy to find files that have Windows end of lines (CRLF) with the GNU grep: And if you need to find files with Unix end of lines: But you may need more, for instance to find out if … Continue reading

Posted in Uncategorized | 1 Comment

What you should know before choosing JIRA

At my current work place, 2 years ago, we needed an application to track the bugs, features and other todo items for several of our projects. We chose JIRA for various reasons: Large feature set Pretty good end user interface … Continue reading

Posted in Uncategorized | 12 Comments

Converting unsigned to signed integers (using Powershell or Excel)

Let’s assume you got unsigned 32 bit integers, that actually represent 32 bit signed integers (using 2’s complement). How to get back the original (negative) values? The formula is pretty easy: signed = (raw+2^31) % 2^32 – 2^31 In Excel: … Continue reading

Posted in Uncategorized | Leave a comment

MediaWiki: Search for page content directly in the database with SQL

To search text in the last revision of MediaWiki pages directly in the database with (My)SQL, use the following request: This may be useful for instance to find pages which are using a deprecated plugin.

Posted in Uncategorized | Leave a comment

Zimbra: How to delete read-only events from a calendar

Today I needed to delete all the events from a calendar in Zimbra. It seemed straight-forward: open the calendar switch to the list view set appropriate start date and end dates select all hit “Delete” Unfortunately, Zimbra refused to proceed, … Continue reading

Posted in Uncategorized | Leave a comment

Shell, wc : getting progress in real time

On Unix/Linux, “wc” is a very useful tool to count the number of lines in a file or a stream. However, sometimes, the file or stream is so big that it takes minutes or longer to get the final result. … Continue reading

Posted in Uncategorized | 2 Comments

Lightroom hanging at start, showing splash screen and spinning Beach Ball of Death

That just happened to me, I spent 1h trying several things, including starting Lightroom as different user (that worked), and deleting all Lightroom related files in my home dir (that didn’t work). Google wasn’t of any help this time. In … Continue reading

Posted in Uncategorized | Leave a comment

JIRA: how to delete global transitions

Recently, I needed to delete in JIRA a transition reachable from “all states”, known as “Global transitions” in the documentation. I didn’t find a way to do this in the “Text” view of the workflow editor, but it’s trivial in … Continue reading

Posted in Uncategorized | Leave a comment