Matrix content headers,,,

To set the content type for matrix assets via a Design file:

<MySource_PRINT id_name="__global__" var="content_type" content_type="text/xml" />
<MySource_AREA id_name="page_body" design_area="body" />

Git and SciTE

How to have SciTE expliclty open a new window when using the check.if.already.open feature.

To change default editor that Git uses for commit messages:

git config  --global core.editor "scite -check.if.already.open=0"

And also add this to your SciTEUser.properties:

quit.on.close.last=1

Auth with Nodejs, Matrix and SQLServer,...

Doing Basic Auth with Node.js builtin HTTP client:

• Manual way
• Using a module

My doc from a while back on how to get Squiz Matrix talking to SQL Server.

And heres a real dossie.

Presentation at LCA

When building a slide deck for a presentation, test to make sure it works at 1024x768, as thats all you can really rely on from a projector at a random venue. They will definitely not be 16:9 !

Actually maybe even 800x600 is an even safer resolution to test with.

Having a clicker would make it easier so that you don't have to stand next to the laptop hitting hte space bar to advance the slides.

Deleting a branch on Github

If you need to delete a branch you have created on github or any ohter remote git repository, heres how to do it.

Excel tricks

First guest tip, from my colleague Jonathan Luker:

If you nest a MATCH() function inside a ISNA() function, it can make a column of TRUE or FALSE on the new data.

e.g. if I look for matches in ItemID between data in separate tabs:

=ISNA(MATCH(A2, 'Test-jul data'!$A$2:$A$15633, FALSE))

This will scan the list for matching ItemsIDs and put TRUE or FALSE in the cell beside each one.

Copy & paste for full list (takes a while to process of course!).

If you sort on that TRUE or FALSE column, you'll have all the new ones listed together.

There are a bunch of IS functions in Excel:

# Excel ISBLANK Function

# Excel ISERR Function

# Excel ISERROR Function

# Excel ISLOGICAL Function

# Excel ISNA Function

# Excel ISNONTEXT Function

# Excel ISNUMBER Function

# Excel ISREF Function

# Excel ISTEXT Function

Quite handy, especially when used with IF(), MATCH(), VLOOKUP(), etc.

Ubuntu

So, after buying a new HDD, comes the re-install of Ubuntu 10.04.
So far:

How to get back the kill X server key combo (in case of emergencys with complete X lockup)

Disable 3D desktop effects to get rid of annoying background flashing when playing flash videos in browser in full-screen.

To move the Gnome panels around, you first have to untick "Expand" in their properties and then you can drag&drop them where ever you like using std mouse left-click&drag.