Thursday, March 10, 2005

Monday, March 07, 2005

MetaFilter profiles infamous London Underground Map(s)

Stand clear of the closing doors | MetaFilter

I've given a lecture on computational visualization at the U of MN for the past two years. It's a fun talk. The London Underground map features in my lecture, thanks to this collection of links I'll have a better story next year.

NYPL Digital Gallery: 275,000 images and counting

NYPL Digital Gallery

Bookofjoe pointed out that the New York Public Library now provides public access to their digital image repository:
NYPL Digital Gallery provides access to over 275,000 images digitized from primary sources and printed rarities in the collections of The New York Public Library, including illuminated manuscripts, historical maps, vintage posters, rare prints and photographs, illustrated books, printed ephemera, and more.
Wow. It's been a while since such a large repository has been connected to the web. It reminds me again how far we've come since Paul Kleeberg first showed me the minutes of a city council meeting in Australia using a Gopher client back around 1994. Even so, we're only at the start of this journey.

Launchers for Mac OS X: LaunchBar, Butler, Quicksilver and more

MacDevCenter.com: Launchers for Mac OS X

This was published 4/04 but I just came across it. Quicksilver has since gone into general release. Great discussion.

Google Desktop Search lays down another card

Google Desktop Search Plug-ins

When I tested out various desktop search tools Google Desktop search looked pretty feeble. I use Yahoo's relabeled X1 product -- it's not perfect but it's pretty acceptable on reasonably modern hardware.

But now Google has laid down another card - GDS plugins that extend its functionality:
This plugin is a web spider ('Kongulo' is Icelandic for spider) that crawls websites you specify and makes them searchable via GDS.

Kongulo follows links in HTML frame, image and anchor tags. It obeys robots.txt and knows basic and digest HTTP authentication. It can be run continuously, checking for updates to previously crawled pages, and uses the If-Modified-Since HTTP header to minimize transfers when doing so.

You can provide a regexp to limit crawls to e.g. your intranet domain.

This version does not have a graphical user interface and can be run from the command-line only.
Note my emphasis. This is a personal version of a corporate indexing tool. I'd guess it wouldn't scale to a large corporation, but who knows? In the meantime I'd use it to index my blogs so I can find stuff in them.

The product itself is interesting, but it emphasizes two things:

1. GDS might have a future.
2. When you build a product around Plugins, you gain a lot of power.

Saturday, March 05, 2005

A strange bug with Microsoft Office Outlook and Access 2000 and Palm HotSync and PocketMirror and ...

Microsoft Office Online Home Page

I wanted to consolidate and manipulate about 1100 contacts stored in an Outlook file. The history of those contacts is probably valid here. They've been through a myriad of applications over the years: FileMaker Pro on a Mac. FileMaker Pro on Windows. Palm Desktop/Mac. Palm Desktop/Windows. PocketMirror. PocketMirror Pro. Exchange. Outlook.

And that's the short list.

I export them from Outlook into Access. So far so good. In Access I can parse, manipulate and clean-up the data.

Except my queries don't work. I query 'not null' and get records with empty fields. I know Access 2000 had problems (2003 is better), but this is ridiculous. It can't be that buggy. The fields, however are empty. I run all the database repair utilities -- no effect.

Or are they?

I export all the data to a delimited file. Then I use a text editor to set the character set to ANSI and save the text file as PC format. They I reimport. Now all the queries work.

My guess is that there were 'illegal' characters in those fields. I know Access 2003 can handle UTF-8 data, maybe there those characters would have rendered in some way. In this case, they didn't. They were there, but Access couldn't get at them and couldn't delete them.

The risks of moving data between a LOT of platforms ...

Friday, March 04, 2005

Utility for import into OS X Address book

turingart - AB Transfer - OS X address book import utility:
'AB Transfer' imports from any file source, while 'AB Transfer Pro' (*) imports from databases too. The following database systems are planned as data sources: FileMaker, Oracle, SyBase, MS SQL Server, generic ODBC, MySQL, Postgres, SQLite."