User login

Complete

To be used with care. Pages are complete only when they meet the posting guidelines.

OpenOffice Spreadsheet fun

It's April 14, and that means it's time for Ben to start doing his taxes.

Working on a spreadsheet to put in major expenses for

This did not work for reasons unknown.

=SUMIF(D2:D6; 'Household'; C2:C6)

This says it should:
http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_SUMIF_function

Get the complete base URL for a Drupal site

Certain things in the world of Drupal, such as the the shockwave function, swf(), expect a full, absolute URL path and not the relative path (such as just a slash).

Multimedia in Drupal: Digital Asset Management

As of 2009 April, Asset module, with no release since 2008 November, seems to have lost momentum in favor of Media module, still in development.

Twitter commands... Get your Tweet on

Use the commands listed below from your phone, the web update box, or your favorite third party application.

Making Drupal nids into edit link from your command-line SQL

I wanted to call this post "automating manual changes" but it's hard to get across the meaning of automating parts of the process that keep it manual.

Stolen directly from Growing Ventures Solutions post on migrating a messy Drupal 5 site to D6. (Primarily this post provides you with copyable text where there's had an image.)

Creating a word paste plugin for TinyMCE

Ebony-II:tinymce ben$ grep -nHR 'mceCleanup' . | less -S

Debug a somethnig going weird in someone elses nodeapi presave

This could be prettier. Do not judge. Especially could be prettier using an IDE.

Stop phpMyAdmin from logging you out in your own local environment (Ubuntu)

vi /etc/phpmyadmin/config.inc.php

You may need to use sudo; vim will warn you if you try editing a read-only file.

Edit an existing LoginCookieValidity setting if any, or (as in our case) add the following to the bottom of the file.

(Note that in vim you can search with /LoginCookieValidity and, if finding nothing, go to the end of the file with :999 -- actually that's go to line 999 which is just as good in this case, there's a command to do it for real too). Then you can press i to insert text:

Bringing SVN to a particular revision; useful with DBScripts

Checkout into a new directory:

svn checkout -r 1310 http://svn.repositoryurl.example.com/path/to/repos newlocalfolder
# Checks out a new working copy at r1310

Or update a working copy to a given revision number:

cd local-folder-for-repo
svn update -r 1310
# Updates an existing working copy to r1310

(Note: You cannot make changes and commit from an old checkout like these.)

Enter the Unholy: Microsoft Word to the Web

Summary of the issue below, and then the beginnings of a search for a solution.

Currently TinyMCE with the WYSIWYG API is in use.

Problems with the wysywg editor, which is a life or death issue for the site.

Problem 1: gibberish code inserted after cut and paste from Word
Problem 2: arbitrary line breaks inserted into text – they are invisible in the editor, visible in preview and in publish, but are not at all fixable by using the editor.

Syndicate content