Feedback

# Convert Notes Dates and Times to UTC format

Look, I perfer to class myself as one of your .Net readers now, so I guess that's 1 :-p

But anyway.. Why do it in Notes world, wouldn't it be easier to convert it in C# ? or am I missing something blatantly obvious here ? I'm assuming your accessing the data from some sort of C# app to plug it into SQL, or are you pushing it in from Notes ?

7/2/2007 12:01 PM | Doug

# Convert Notes Dates and Times to UTC format

I'm throwing together a quick view containing a computed column which outputs a SQL insert script.

It seemed the quickest way to get a load of text only data out of Notes and into a SQL database. I'm actually thinking about creating some sort of 'generator' app to do this for a few databases, however really I think I'll just end up copying, pasting, and editing the view into all my source databases.

If I did end up writing a Notes app to do this then I can see a fair few people out there being vaugely interested. Even more so if I could work out a way to nicely deal with Rich Text

Have you got any other suggestions for data migration?

I've just ran a quick test export, and it runs pretty nicely. A bit of data tidying up here and there, but the final result is pretty good.

(Doesn't help when you're staring at an @Function for 15 minutes wondering what the hell is wrong with it, only to finally notice that you've automatically separated the parameters with commas instead of semi colons)

7/2/2007 10:55 PM | Ross Hawkins

Due to excessive comment spam, all comments are now being moderated. If you're a comment spammer then you're wasting your time here. Your comments will not be published - ever.

Subscribe

The .NET 2.0 framework changed the way clientside JavaScript is delivered to the browser. Previously, ASP.NET 1.1 used the aspnet_client directory whereas now 2.0 uses WebResource.axd.

Published on October 8, 2006

One of the breaking changes which was made with the 1.0 release of the Microsoft Ajax Extensions was the renaming of the 'Debug' class to 'Sys.Debug' for reasons of compatiability with other frameworks. Breaking changes like this can often be a source of frustration..

Published on May 22, 2007

A textbox character counter is a pretty simple piece of functionality, and there's a lot of different ways to apply one to your application. The following method is nice and simple, and can be done using only clientside JavaScript if required, or combined with server side code in order to create a more dynamic effect

Published on December 4, 2006

A quick update to my previous character counter article adding some changes for those using it with Master Pages.

Published on February 7th, 2009

As the title says, this is a very simple but dynamic way of achieving tooltip text on a header column. It's not overly flash, but it's lightweight and quick to implement.

Published on April 15, 2007

A fix for another AXD related issue, this time with the SQL Server Web Report Viewer Control which was being served up via IIS7 on a Windows 2008 server.

Published on June 2, 2007
Updated on April 10, 2008