Apr 15, 2009 GMTSay you use a simple OpenOffice.org Base database to keep track of your invoices and you want to analyze the invoicing data. One way to do this is to create reports and SQL queries, but this requires skill and a lot of time. Another approach is to pull database records into a Calc spreadsheet and then use Calc's tools to analyze the data. To do this, you have to register the invoice database as a data source in OpenOffice.org. Choose Tools -> Options, select OpenOffice.org Base -> Databases and press the New button. Select then the database and give the new connection a name. Press OK -> OK to save the settings and close the window. ...
Apr 10, 2009 GMTWhile OpenOffice.org has always sported the ability to talk to MySQL databases, connecting the productivity suite to the popular database engine wasn't particularly straightforward. Establishing a connection to MySQL involved installing and configuring a connector software, which did require some skills and made the whole idea less attractive. But it seems that you don't have to put up with this situation for much longer. A recent post on the GullFOSS blog has announced the availability of a native MySQL driver for OpenOffice.org. You can download the alpha version of the driver which works with OpenOffice.org 3.1. The blog points out that you should use the stock version of...
Apr 08, 2009 GMTThe Writer's Tools extension for OpenOffice.org developed by yours truly comes with a simple Visual Word Counter tool written using OpenOffice.org Basic. While this tool does the job, it has one serious drawback: once evoked, it doesn't allow you to do anything until you close its window. There are two solutions to this problem: you can either rewrite the macro from the ground up to add a so-called non-modal dialog window (i.e., a window you can keep opened while working on your documents), or you can use an already available Python-based macro from Yawar's Journal. The latter approach, obviously, makes more sense than the former. To make it easier for you, here is the macro in its...
Apr 02, 2009 GMTTime tracking tools are a dime a dozen these days, so what makes timebook so special? Two things: tiny size and simplicity. This command-line time tracking utility requires hardly any resources at all and it's extremely easy to get to grips with. timebook is written in Python, and it's pretty easy to install. Download the archived version of the utility and unpack it. In the terminal, switch to the resulting directory, and run the python setup.py install command as root. Using timebook is also pretty straightforward. The utility uses timesheets for grouping timing sessions. For example, you can create a timesheet called "writing" for all your writing activities using the switch...
Mar 30, 2009 GMTAs a Firefox user, you are probably familiar with Greasemonkey, a nifty extension that allows you to tweak Web pages to add all kinds of interesting features using scripts. One such handy script is Google Search Sidebar which adds a sidebar to the Google search page containing search results from YouTube, Wikipedia, Dictionary.com, and Flickr. Obviously, the script requires the Greasemonkey extension, so you have to install it before you proceed. Once you've done that, navigate to the script's Web page and press the Install button. That's it. Do a search directly from the Google search page or using the search...
Mar 29, 2009 GMTThere are many ways to tweak Firefox's settings to improve the browser's performance, but probably the most effective trick is to replace your favorite browser altogether with Swiftfox. It may sound as a drastic step, but there is no need to worry: Swiftfox is essentially Firefox optimized for specific AMD and Intel processors. The project features Swiftfox builds for AMD Athlon 64, Intel Core solo and Duo as well as assorted Pentium and Celeron processors. The best part is that Swiftfox detects and uses Firefox profiles. In fact, you can even run two browsers side by side if you are inclined to do so. There are several ways to install Swiftfox on your machine. If you are running a...
Mar 27, 2009 GMTImagine how much time you could save if you had a tool that could help you to avoid typing static text like "Kind regards" or your address. Like the idea? Then you'll most certainly appreciate the Autokey text expanding utility. The current version of Autokey is distributed as a tarball archive, and it requires a few additional Python packages: python-gamin, python-xlib, and python-configobj. On Ubuntu-based distros, you can install them using the following apt-get install command: sudo apt-get install python-gamin python-xlib python-configobj Download and unpack then the Autokey archive, move the resulting directory into your home folder, and use the autohot.sh script to...
Carnegie Mellon researchers say 3 million pages could fall down the phishing hole in the next year.
The US government rolls new best-practice rules for protecting SSH.
Klaus Knopper announces the latest version of his iconic Live Linux system.
All websites that use these popular CMS tools could be vulnerable to denial of service attacks if users don't install the updates.
According to a report, many potential victims of the Heartbleed attack have patched their systems, but few have cleaned up the crime scene to protect themselves from the effects of a previous intrusion.
DARPA and NICTA release the code for the ultra-secure microkernel system used in aerial drones.
Should you trust an online service to store your online passwords?
New B+ board lets you build cool things without the complication of a powered USB hub.
Redmond rushes in to root out alleged malware haven.
New initiative will bring futuristic virtual reality effects to the web surfing experience.