XML import into Access - Workaround for truncation

I recently had to import some XML files into Access. It worked well, save for text truncation. Here's the process, the workaround is below:

Import or link data and objects - Access - Microsoft Office Online

1. Open a database, or switch to the Database window
2. On the File menu, point to Get External Data, and then click Import.
3. In the Import dialog box, in the Files Of Type box, select XML Documents (*.xml;*.xsd)...
6. To start importing the file, click OK . This completes the import procedure.

Note For most records that cause an error, Microsoft Access creates and adds a row to a table called Import Errors. To view the list of errors that were encountered, open the Import Errors table from the Database window.

7. To set options for importing, select one of the following under Import Options:
* To import just the structure of the table, click Structure Only.
* To import the structure of the table and the data, click Structure and Data.
* To append the data to an existing table, click Append Data To Existing Table(s).

The trick is to first import just the structure, then change the datatype from text to Memo where truncation is occurring, then use the append feature.

VMware Converter: Move to VM in one swoop

I don't yet have a good use for VM technology, but one day ...

VMware Converter: Turn your computer into a virtual machine - Download Squad

VMware Converter ... a free beta app from VMware that makes it supremely easy to take your current system and turn it into a virtual machine.. [and also] virtual machines to a newer version of VMware and converting images from other software like Microsoft Virtual PC.

In related news, LiveCD aficionados should check out this LiveCD Player Virtual Machine from vmwarez.com, which lets you create a virtual machine for VMware from any LiveCD ISO with just one click.

NAS at home, Google backup remote?

Amazon.com $1700: Infrant ReadyNAS NV, 1.6TB (4x 400GB Seagate Disks), RAID 5, 256MB memory
isn't cheap, but it's the first network addressable storage device to make an impact on the high end home market. With RAID 5 you get 1TB of storage, and one of the four drives can die without disrupting your work. Video editors, photo geeks, and hardcore home media zealots need this now.

I'd like to see Google sell something like this with built-in automated off-site backup. Buy the device from Google and it comes preconfigured with software and encryption services designed for Google off-site backup. Google makes money on the hardware and on the services. Users get reliable local storage (one drive can die without data loss) and offsite robust integrated backup services

Yojimbo: the fatal flaw

Bare Bones Software's Yojimbo is one of many snippet/fragment/knowledge management tools for OS X. It's produced by a great software firm and has many keen fans. Alas, it fails the first acid test for a knowledge store -- it uses a proprietary back end data store. Yojimbo suffers from data lock. Here's the note I received when I asked about their data store (quick response btw):

...You can export all your Yojimbo info at any time by going to the Library, doing a "Select All" and then using File -> Export...

Yojimbo takes all reasonable measures to preserve info on export, e.g. PDFs and web archives export as the corresponding files, notes which contain images will be exported as .rtfd documents, etc., although exporting does not/cannot preserve Yojimbo-specific metadata such as collection
membership, tags, or labels...

Cringely's Thai-build Linux powered auto video server

Cringely is a true hacker. I've no idea how he learns This stuff. The Thai Linux box is driveless, which is why he chose it. Now every auto stereo installer will know how to put in a 50-tv show capacity auto video server (emphasis mine):

I, Cringely . The Pulpit . Keeping the Peace | PBS

...Cars are hostile environments for computers. I wrote an entire column once on why we don't have hard drives in cars (it's in this week's links), so I knew that for a server I'd need a hardened, yet cheap, box, which I found in the Norhtec MicroClient Jr. from Thailand. Because of enlightened government computing policy, Thailand has the cheapest non-Microsoft PCs in the world and the MicroClient Jr. is among the least expensive. [jf: Thailand also has a government at least as corrupt as ours, their attitude to open source has recently changed.] In volume it sells for $90, but I paid $120 plus an extra $70 for WiFi capability. I might have saved the $70 and used a USB WiFi adapter I had lying around, but the box has only one USB port and I wanted that for storage.

For $190 I had a diskless, fanless, completely silent PC with a Via processor and 128 megs of RAM. To this I added a copy of Puppy Linux, which is a very good lightweight distribution you can boot from a CD, though in the MicroClient Jr. I used a CompactFlash card from an old digital camera as the boot drive. For the data drive I used a huge four-gig USB flash drive that came from who knows where: I don't recall buying it, but it was sitting on the shelf.

This is not a very ambitious project, really. The MicroClient Jr. is a little smaller than a Mac Mini and can run on 12 volt DC, so I mounted it under the driver's seat, stealing power from the seat motors. The USB flash drive is about the size of a pack of cigarettes, if you remember what that looks like, and I used Velcro to stick it to the side of the MicroClient Jr. The little PC runs fine as a server, and there are many open source programs for transcoding almost any video into the H.264 or MPEG-4 formats preferred by the PSP. The PSP already has WiFi capability and the components are never more than four feet apart. Best of all, I was able to put 53 shows on the data drive.

I want one. Of course the PSP is not cheap ...

Click to call in Google Maps

Clever.

Official Google Blog: Click to call in Google Maps

...Search for a business, like a hardware store, on Google Maps, and click the 'call' link next to its phone number. Then, enter your phone number and click 'Connect For free.' Google calls your phone number and automatically connects you to the hardware store.

There are two things that I really like about this. The business's phone number is automatically stored in your caller ID so you can easily call back in the future. And by checking the box to remember your phone number, you can make future calls from Google Maps with just two mouse clicks (and picking up your phone, of course).

This is neat on so many levels. Great solution to the old phone/net connection problem. Expect more in this vein.

Google web toolkit: now with Safari

Google's AJAX development toolkit now supports Safari. Can Gmail support be far away?

Google Web Toolkit - Build AJAX apps in the Java language

... Your GWT applications automatically support IE, Firefox, Mozilla, Safari, and Opera with no browser detection or special-casing within your code in most cases.

A GWT app will run on multiple platforms and browsers. I'd love to know how many people are developing real products with this free tool.