Webpublisher XML Updates

by Peter Tyrrell Wednesday, February 13, 2008 9:53 AM

This truth just hit me with the force of a hammer blow to the forebrain:

The Update action in the Webpublisher XML API mimics the Inmagic import function. It is not an update by query.

O merciful god in heaven. Import matches on one or more fields which have to be unique (in combination), which generally means a record id. If you don't know in advance which records might be affected you have to do a query to examine the results then perform the update. Two HTTP requests.

What I really want is the equivalent of a WHERE clause: update field X for every record found by the query.

UPDATE: Wait a minute. There *is* a batch modify option showing in the Webpublisher schema documentation, but not in the online help. The investigation continues...

Virtual Machines, Differencing Disks, and Virtual Goodness

by Ted Jardine Tuesday, February 12, 2008 4:50 PM

The credit for this post goes to Peter, who close to a year ago sent out instructions on how to use differencing disks in a different way to save significant hard drive space when using virtual machines (Virtual PC 2007), while keeping your pristine baseline image...well...pristine (read-only no less). As I'm tired of looking up the old email every time I forget the steps (going senile in my old age), I'm putting the steps here:

  1. In the VPC console, highlight your VPC > Click Settings > Select Undo Disks > Click Enable > undo disks > Click OK
  2. Turn on, and then immediately turn off the VPC. Choose to save changes but not commit them. The whole point is to get an Undo disk (file with extension of .vud).
  3. Find the undo disk (.vud) and rename the VUD extension to VHD. Tricky!
  4. Return to VPC console, highlight your VPC and choose newly renamed VHD as Hard Disk 1.
  5. Answer "Continue" when warned about the undo disk.
  6. In Settings dialog > Select Undo Disks > Clear the check-box to disable undo disks > Click OK (and blissfully ignore the catastrophic warning).
  7. At file system, set parent disk to 'read-only'.
  8. Boot VPC and work as normal, but with the knowledge that your pristine baseline image is safe.
  9. I like to take it one step further for data and hook it up with a separate virtual data drive (easier for incremental backups).

This tip is originally from Invirtus VM Optimizer (now vOptimizer it seems). If you're interested in a further explanation, in their words:

Microsoft Differencing Disks

As you may have read in our differencing disk article on our website, differencing disks are wonderful tools for extending virtual machines, but are terribly inefficient in disk space concerns. If you intend to use a differencing disk  more than a few times and you intend your differencing disks to have a moderate shelf life, consider using undo disks instead. Not in the classic sense, however. To ensure the parent image is held pristine we recommend a new way of using undo disks.

Instead of having your writes chained to the back-end of a VHD by way of undo, or VUD, we recommend creating then renaming the VUD to VHD and using it on the front-end to reduce ambiguity. Doing this will save you tons of disk space, guaranteed and you will not lose any functionality. To get there, however, you have to follow a few "new" steps.

And of course, do all of the above at your own risk. I'm not responsible for any chaos that ensues: Peter is.

Tags:

Visual Studio and the non-sensical "Apply Cut Copy commands to blank lines where there is no selection" option.

by Ted Jardine Friday, February 01, 2008 11:26 PM

Quoting some comments in Jeff Atwood's "Revinventing the Clipboard" blog post:

What I dislike the most, about the clipboard, is the really bad behaviour in VS. Say you cut something, then you try to past it elsewhere but you hit the C instead of the V (without any text selected) and bravo, you've lost your clipboard content! You now have to undo 3 or 4 times to re-start the manipulation. This is anti-productive at the most.

Fabian on January 22, 2008 03:01 AM

Fabian: That one gets me too, but the good news is that you can turn off that behaviour in Visual Studio.

Go to Tools->Options...->Text Editor->All Languages->General and untick "Apply Cut Copy commands to blank lines when there is no selection"

(I guess this goes towards what Jeff was saying about software having reasonable defaults).

GrahamStw on January 22, 2008 03:10 AM

It's one of those things that I never remember how to reset so here it is. Glory Hallelujah.

And btw, using ClipX and loving it (and yes, the beta seems to work fine in Vista).

Month List