OpenOffice.org Calc: Pivot tables by another name

Posted by suvi under OpenOffice.org

DataPilots are OpenOffice.org Calc’s equivalent of what MS Excel and
other spreadsheets call pivot tables. Under any name, they are a tool
for extracting and summarizing the information contained in spreadsheet
cells in a more convenient form. Using a DataPilot, you can immediately
see relationships between different pieces of data that would be
difficult — if not impossible — to find using formulas, and tedious
to extract manually. In effect, a DataPilot gives you something of the
power of using a database without actually switching out of a

No Comments

Turn your computer into a media center PC with GeeXBoX 1.1

Posted by suvi under Linux, Multimedia

GeeXBoX,
a small media center Linux live CD distribution, can run from any small
device, such as a USB disk or a wallet CD-R, and can play both
disk-based media like DVDs and online media like Icecast streams. The
project has been in development for several years and has just released version 1.1.
I fed it every kind of media file I could lay my hands on — Ogg, MP3,
MP4, AVI, DVDs, VCDs, and their ripped versions — and it played them

No Comments

Tips and Tricks: How do I find the inode size of an ext2/ext3 filesystem?

Posted by suvi under Tricks

Release Found: Red Hat Enterprise Linux 2.1, Red Hat Enterprise Linux 3 and Red Hat Enterprise Linux 4

Resolution:

No Comments

Bazaar Bundles

Posted by suvi under Programming, Software

This article follows on from the series of tutorials on using Bazaar
that I have neglected for a while. This article is about the bundle
feature of Bazaar. Bundles are to Bazaar branches what patches are to
tarballs or plain source trees.

Context/unified diffs and the patch utility are arguably one of most important inventions that enable distributed development:

No Comments

Monitoring Ubuntu Services Using Monit

Posted by suvi under Server, Ubuntu

monit is a utility for managing and monitoring, processes, files, directories and devices on a UNIX system. Monit conducts automatic maintenance and repair and can execute meaningful causal actions in error situations.

Monit Features

* Daemon mode - poll programs at a specified interval
* Monitoring modes - active, passive or manual
* Start, stop and restart of programs
* Group and manage groups of programs
* Process dependency definition
* Logging to syslog or own logfile

No Comments

A SUCCESSFULL installation guide to VHCS2 on Debian Etch (4.0)

Posted by suvi under Debian, Server, Webserver

I’ve read a lot of manuals, how-to’s etc. describing the process of setting a Debian webserver containing the great VHCS2 control panel system. I’ve tried them all, and all were failing for me on several critical points. So i tried to gathered all steps to this one-stop how-to.

No Comments

Tracking TCP Connections With tcptrack

Posted by suvi under Networking

Basically, tcptrack is a sniffer which will show the information about
TCP connections on a specific interface. tcptrack will watch all the
connections that occur and show the information in a nice interface.
Although it’s on a text user interface but it’s simple and easy to
understand. tcptrack has been packaged on several popular Linux
distributions. The latest version of tcptrack is 1.2.0 released on
December 20, 2006. You can download the source code from the tcptrack website.

No Comments

Diagnose and manage your network for free with Linux and open source tools

Posted by suvi under Linux, Networking

In this Internet-connected world it is an essential skill to know how to troubleshoot network problems. High-quality software suites exist to do the job but can easily cost in excess of tens of thousands of dollars. With a handful of absolutely free open source tools you can do it yourself – on any computer anywhere in the world.

No Comments

Back up and restore your Firefox environment with FEBE

Posted by suvi under Backup, Networking, Software

The Firefox browser stores not only a user’s bookmarks, history, saved
forms, and usernames and passwords, but frequently also several
extensions and themes. When you’re switching computers or
distro-hopping, replicating the browser environment can be tricky and
time-consuming. But with the Firefox Environment Backup Extension (FEBE), you can back up and restore everything Firefox can hold, and then some.

No Comments

How to copy a dual layer DVD in Linux

Posted by suvi under Multimedia

Now that we’ve looked at doing various things to multimedia files and burning
them to a DVD, let’s examine how to make a copy of a dual layer DVD. If
you have a dual layer burner, then there’s no reason to read further.

No Comments

Howto Turn the Memory Stick light off on Sony VAIO notebooks in Feisty

Posted by suvi under Tricks, Ubuntu

If you are using VAIO VGN-FS660/W with Feisty fwan and the Memory Stick light on the front panel would always stay on. If you don’t use it, here’s an easy way to turn off.

Warning: This may disable other memory card readers.

Open terminal and enter the following command

lsmod | grep tifm

Now You need to edit the blacklist file using the following command

sudo vi /etc/modprobe.d/blacklist

No Comments

How To Manage An iPod From A Linux Desktop With Rhythmbox

Posted by suvi under Desktop, Linux, Multimedia

This article shows how you can use an iPod on a Linux desktop with the Rhythmbox
audio player. It covers how you can upload MP3 files from your desktop
to your iPod and delete files on the iPod. Normally, Apple’s iTunes
software is needed to manage an iPod, but iTunes is not available for
Linux. Fortunately, there are Linux alternatives such as Rhythmbox that
can handle the task.

I do not issue any guarantee that this will work for you!

 

No Comments

Access (K)ubuntu console with a single key

Posted by suvi under Tricks, Ubuntu

Yakuake is a Quake-style terminal emulator based on KDE Konsole technology
which makes the console more user friendly. If you need the ability to
quickly pull down a console to run a few commands with a keystroke, and
then make the console disappear again with another quick keystroke.
YaKuake is exactly what you are looking for.

The interface is highly customizable, you can adjust the height, the
width, the horizontal position you can change the keyboard shortcuts
and make it retract automatically when it looses focus.

No Comments

Configuring and Scripting WEBDAV Subversion Repos Part 1

Posted by suvi under Programming, Server

Subversion is a great system for centralized repository usage and
administration. One of the good (pragmatic?) things about subversion is the
simple built in access method using the svn protocol. While the
svn protocol is nice; using the webdav capability
for managing repositories
is definitely a nice touch. Managing a lot of repositories
can be challenging to say the least. In this series a quick look at setting
up a single webdav based repository; a simplistic script

No Comments

Use gperf for efficient C/C++ command line processing

Posted by suvi under Programming

The GNU tool gperf is a "perfect" hash function that, for a given set of user-provided strings, generates C/C++ code for a hash table, a hash function, and a lookup function. Learn how to use gperf for effective command-line processing in your C/C++ code.

Command-line processing and the need for gperf

No Comments