Squeakland – computing for kids

Niall, who should know, says Squeakland is “incredible”. I haven’t tried it myself, but it’s described as “media authoring tool” and is available for Windows, Mac OS, Linux and Unix! Check the “What is Squek?” page for more.

30 years ago this was a fantasy about how children would learn science and math some day on their own notebook personal “Dynabooks”. After many years of building and testing these ideas, today this scenario is real.

Google Talk on Linux

Google Talk works fine with a Jabber compatible IM client such as GAIM but out of curiousity I tried to install the Windows client so I could use the voice function. Alas, my version of Wine isn’t up to the task. No matter what path I enter in the second dialog the INSTALL button is always greyed out! Others have had more luck installing, but the application doesn’t run yet. (Thanks Feedster!)

How to convert from WMA to MP3

Converting Windows Media Audio files into MP3 format is rather easy with mplayer and lame. My car stereo plays MP3s, so WMA is of no use to me!
This code is based on this script but I have to wonder why they overwrote the wma file?
Piping the output of mplayer into lame is left as an easy lesson for the reader!
for i in *.wma ; do mplayer -vo null -vc dummy -af resample=44100 -ao pcm -waveheader "$i" && lame -m j -h --vbr-new -b 160 audiodump.wav -o "`basename "$i" .wma`.mp3"; done; rm -f audiodump.wav

Linux: Auto-mounting USB camera memory

I have 2 cameras. One takes Flash cards, the other takes SD cards. If my Sony still worked, I’d also add memory sticks to that list.
I’ve got a routine, a workflow, for copying photos off camera media but it’s slightly more complicated with multiple memory types!
Kevin Lyda kindly mailed me a script he had for auto-mounting his camera and copying the files off. It uses the usb hotplug program to do that but I couldn’t get it to work with my card reader so I wrote the following script. Bits of it are from Kevin’s scipt, so thanks!
I insert my camera media, and run “copyfromcamera.sh” and it find the Flash card and copies all files off it into a directory with today’s date!

Make sure you have your media mount points setup in /etc/fstab. Here’s what mine looks like:

----------/etc/fstab----------
/dev/sdb1 /mnt/cfcard vfat users,noauto,rw,uid=1000 0 0
/dev/sdd1 /mnt/sdcard vfat users,noauto,rw,uid=1000 0 0
----------/etc/fstab----------

Copy and paste this into a file and save it to /usr/local/bin/copyfromcamera.sh and make it executable (chmod 755 /usr/local/bin/copyfromcamera.sh)

----------/usr/local/bin/copyfromcamera.sh----------
#!/bin/sh

export YEAR=`date +%Y`
export TODAY=`date +%Y-%m-%d`
export DIR=/home/donncha/Photos/$YEAR/$TODAY/
mount /mnt/cfcard/ 2> /dev/null
if [ -d /mnt/cfcard/dcim/ ]; then
    mkdir -p $DIR
    find /mnt/cfcard/dcim -type f -print0 | xargs -0i mv -vi '{}' $DIR
    umount /mnt/cfcard/
    df -h
fi
mount /mnt/sdcard/ 2> /dev/null
if [ -d /mnt/sdcard/dcim/ ]; then
    mkdir -p $DIR
    find /mnt/sdcard/dcim -type f -print0 | xargs -0i mv -vi '{}' $DIR
    umount /mnt/sdcard/
    df -h
fi
----------/usr/local/bin/copyfromcamera.sh----------

Spreadsheet Templates

Every now and again I need to dig into Open Office to create a document, be it a report, or a spreadsheet.
Thankfully Linux has been able to read Word and Excel files for some time as that’s what the world and it’s dog use!
Anyway, I needed an invoice template, and came across these Open Office extras listing lots of templates for Writer, Calc and Draw. Several very useful examples there too!
Here’s a few sample reports in PDF format. Obviously it’s harder to edit, but at least they’ll provide for inspiration when creating your own documents!