myphpadmin date formating

for exporting with a date in the file name use

[export_file_name_whatever]%G%m_%d

results in…

file_name_2011_04_28

Linux command line cdrom access

sudo lshw -C disk
sudo mount /dev/cdrom -t iso9660 -r /media/cdrom

to install wkhtmltopdf on AWS micro linux

Use yum to install font-config and urw-fonts. This dealt with the “wkhtmltopdf: error while loading shared libraries: libfontconfig.so.1: cannot open shared object file: No such file or directory” error and the output pdf only having squares instead of readable characters.

Download the proper static binary from http://code.google.com/p/wkhtmltopdf/downloads/list. Make sure that you know if you are running on a 32 or 64 bit system.

Untar the downloaded file. Optionally, rename the binary to something without the extra information.

Copy or move the binary file to /usr/bin

help from

http://code.google.com/p/wkhtmltopdf/wiki/static

http://code.google.com/p/wkhtmltopdf/issues/detail?id=222

installing matplotlib on debian testing

what a pain…

more notes later, but I installed with pip.

Required the installing or updating following packages through apt-get before it would install and work in ipython (I think - and check versions to make sure in future)

numpy python-dateutil python-dev libfreetype6-dev gcc g++

<button> will submit unless there is a specific type=”button” attribute

type="button"

submitting form - Dynamic Drive Forums

Hide VirtualBox menu and status bars

To remove the menu and or status bar from the VirtualBox guest window use the following command in the windows command prompt

VBoxManage.exe setextradata global GUI/Customizations noMenuBar,noStatusBar

This did not work in Powershell, had to do it in normal cmd window.

Vlad.Grinchenko: How to hide VirtualBox menu and status bars

grep within subdirectories

from the parent directory

find .| xargs grep "something"

Excel VBA mid function cannot compile

If it looks like standard functions in a VBA macro are missing and the code won’t compile…

These are the four core references you should have in your VBA IDE.

Visual Basic For Applications Microsoft Excel xx.0 Object Library OLE Automation Microsoft Office xx.0 Object Library

If there is a (MISSING) DAO Reference Add C:\Program Files\Common Files\Microsoft Shared\OFFICE14\ACEDAO.dll

Remember to uncheck all references that are marked as “MISSING”. Restart Excel.

ddply for a data frame of summary stats

Useful format for later…

ddply(YRDATA, .(GRP1, GRP2), function(x) data.frame(mean = mean(x$COL), median = median(x$COL), sd = sd(x$COL), variance=var(x$COL)))

Making a better summary statistics table with plyr in R - Stack Overflow

Linux command line prep for installing VirtualBox Guest Additions

Ubuntu specific, could probably replace apt-get with other package management software (yum, pacman, etc).

Build essential is gcc and a bunch of other compliation/deployment tools it is a package specific to Ubuntu/Debian.

sudo apt-get install build-essential linux-headers-$(uname -r)

or

yum groupinstall "Development Tools"

or

pacman -S base-devel