rsync

I expect to be adding to this...

When refreshinging the saver directory from bargabus.com to local, get only the new files with...

rsync -ahv --ignore-existing user@bargabus.com:~/saver/* .

Using the 'less' pager in the mysql client

In iTerm2 on OS X, the default less is rather wonky in the mysql client.  I use it as my pager.  Anyway, I added the -S flag to my less options and things got better.

export LESS='-S'

Changing a CVS log entry after commit

bargabus@devfrench$ cvs admin -m 1.12:"`cat /tmp/x`" bookpub/lib/BookPub/Import/Importer/Amazon/Version15.pm
RCS file: /var/cvs/tools/bookpub/lib/BookPub/Import/Importer/Amazon/Version15.pm,v
done

Or instead of catting that tmp file, you can just do the text.  The tmp file was multiple lines long.

Adding a directory recursively to CVS

First add the enclosing directory and cd into it.  Then add all the directories except CVS.

find . -type d \! -name CVS -exec cvs add '{}' \;

Then add all the files, except any in the CVS directories.

find . \( -type d -name CVS -prune \) -o \( -type f -exec cvs add '{}' \; \)

Unique column values in OO.org and Libre Office

1. Select the whole column
2. Data > Filter > Standard Filter
3. Change 'Field Name' to -none- , click on 'More options' and check on 'No duplication' box

Changing text cells to numbers in OpenOffice

The text cells all have a leading apostrophe.  The apostrophe isn't really part of the cell content, it just signifies that the cell is formatted as text. To reenter all the data as numbers:

1. Highlight all of the cells and use Format -> Cells to change the cell format to an appropriate number format.
2. With all of the cells still selected, go to the menu Edit -> Find & Replace
3. In the Search For box enter .* (period asterisk)
4. In the Replace with box enter &
5. Select More Options and check Current Selection Only and Regular Expressions
6. Click Replace All

Paging/Scrolling in GNU screen

I'm having some intermittent network problems at home today, so to get some work done I'm running all my terminal sessions to work servers in GNU screen.  I rely on the terminal scrollback a lot.  To look at that in screen, ctrl-a [ puts you in copy mode where arrows, page up and page down, and all vi movement commands work.  Esc exits this mode.