I demonstrated this during the Lotusphere 2006 Jumpstart session I did on Integration, and a gentleman by the name of John Coolidge was in the front row. He commented he worked with Tom Duff to make the database. The version I had (and Tom is linking to) only had Office 2000 and Office XP (2002) constants in the database. John read my blog comment and we emailed. I volunteered to host the current version (its really big now ... 5+ megs zipped). This version adds Office 2003 constants and another neat feature. Go to the LSS view and click the Export button. You will get a MS Excel listing of all of the constants in a manner you can use as an Include file in LotusScript. I have a couple ideas of how to improve this, but this is a great start. Thanks John! MS Office Constants Database - 1.31.2006

The week after Lotusphere is always one of the hardest weeks of the year for me. Not only do I have to come down from the high that is "Notes Mecca" ... and recovering from all the parties and drinking and late nights. I ALWAYS get sick after Lotusphere. Hopefully not this year ... I have a busy February. Lots of travel and fun stuff to do. Hope everyone is energized with the great Lotusphere messages and energy. Back to work we go.

Here is what's coming out today ... Movies A-Team: Season #3 Adventures Of Mark Twain, The All-American Girl: The Complete Series (1994-1995) Archie Bunker's Place: Season #1 Comedy Collection (3-Pack) Corpse Bride, The (Widescreen) (#3 in the DVDPS Top 40) Diff'rent Strokes: Season #2 Dune: Extended Edition (#5 in the DVDPS Top 40) Extreme Comedy Collection (3-Pack) Final Destination: Scared 2 Death Pack Four Weddings & A Funeral (Deluxe Edition) (#11 in the DVDPS Top 40) Gastineau Girls: Season #1 Gone With The Wind (2-Disc SE) Hill Street Blues: Season #1 In Her Shoes (Widescreen) Inked: Best Of Season 1 Knight Rider: Season #3 Lawnmower Man 1 & 2 Legend Of Zorro (Widescreen) (#38 in the DVDPS Top 40) Lust For Life (#14 in the DVDPS Top 40) MI-5: Volume #3 Magnum P.I.: Season #3 Muppets Movies Collection My Big Fat Greek Wedding: SE Pink Panther Classic Cartoon Giftset Rat Patrol: Season #1 Sex & The City Essentials: Breakups Sex &a

Everyone who blogs should check out this comic at the Pearls Before Swine site. Very funny.

You have to click to understand: AAAAAAAAaaa rrrrrrrrrrrrrnnnnnnnnnnhhhh, HHHurrRRRRRRRRnhhhh. UUUHHHGGG-rrrr! UUUHHHGGG-rrrrRRR! UUUHHHGGG-rrrrRRR! HHHurrRRRRRRRRnhhhh. AAAAAAAAaaa rrrrrrrrrrrrrnnnnnnnnnnhhhh!

I have been in Orlando for over a week now ... and I am just beat. Lotusphere always takes a lot out of me. Sessions, a booth, all the talking, drinking, and lack of sleep usually ends up being me sick for a while after sphere. So this year I am spending 4 days doing nothing. My father lives in Orlando, so I will be at his place hanging out. Friday was sun, dinner with the family, and movies. Today will be more of that, just add in some good sushi. I hope everyone travels home safely (if you were at sphere) and I will be back Tuesday.

So I came up with a great idea, even if I am hurting after trying to drink an Irishman under the table last night. Yeah, I lost. Anyways, I thought that what we should do is put together a page with a link to all of the Lotusphere session slides and demo files that all of us will be posting over the next couple of days. Everyone should go here and add a link to your presentation. I added the first couple that I know about. I will try to get Ed to blog about it to make everyone see it.

Bruce has been nagging me for quite a while to get with the OpenNTF program (I figured hosting it was enough), so here goes. At Lotusphere in my BP309 session, I showed off a Notes application that allows for the management of Microsoft Office and OpenOffice.org template files. The first version has a user initiated action to install the templates. My goal is to have it be that the database will detect what a user has, and update the templates via an agent. Basically a way to control all of these templates. It will also serve as a template repository for anyone doing development that requires files, such as my mail merge demos. The first version will go up next week. It will just support Microsoft Office and an Install button. More versions will follow over the next couple of weeks. You can access the project here. Anyone want to provide a good name and logo? I am not an artist by any means :) If you use the app, I would love to hear about it!

Alex and I demonstrated a Notes application that allowed for easy, end user driven, exporting of Notes data to Excel. The database is not ours, just one we found and love to use. I am trying to locate the author to make sure that posting it here is OK with him. Once I do, I will post a link in this space. As we talked about, there has been some discussion on making this work from Excel to Notes and using it with XML. Anyone interested in that?

During my presentations at Lotusphere, I showed off a database that has all of the Microsoft Constants and the raw values. As I demonstrated, you must translate the Constants to the raw values to be able to save the code in LotusScript. Here are the links to the databases that contain Office 2000 and Office XP/2002: R5 R6 anyone have one for Office 2003?

Another Lotusphere comes to a close. Another amazing year. This year was a big one for me personally. I co-presented the integration Jumpstart with Alex Kassabov from PSC. We did it twice, back to back. 4 hours of speaking in 4:30 is a lot. Packed rooms both times. I did my best practices session and delivered on my promise from last year ... OpenOffice Mail Merge with Notes. A big room that was packed ... and I went head to head with Ed and Libby. PSC had a booth showing off e-phone. e-phone, developed by iscoord ltd., happened to win the Lotus Award for Best in Show ... PSC is the North American distributor. The booth was crazy busy. And meeting with all of our clients, business partners we work with during the year, and the community. Talk about a week that just drains. Lots of people will write about how the week was ... it was KILLER. The energy is the highest I have seen it since the R5 Launch. Surjit Chana, the VP of Marketing and Partners is an amazing add

My session is over, and I think it was one of my best ever. I showed a Word solution, built once with COM and a second time with Web Services. Same result, completely different technologies. I showed how Excel can consume XML from a Domino agent. I displayed how a WinForm application, built in Visual Studio.NET can work with the same data via a web service. I then moved on to show how VSTO has issues (anyone from Microsoft want to help fix it?). I also showed mail merge with OpenOffice Writer and the Notes Personal Address Book. Last, I introduced my soon to be released OpenNTF.org project which will allow Office and OpenOffice templates to be pushed to users. When I do this session, I typically fill the room and the overflow rooms. This year, they gave me the biggest room at the Swan. It was filled and people were on the floor. But no one was in an overflow room. I hate overflows. You hear the speaker and see the slides, but you do not see the speaker. So I am very gl

Here is what's coming out today ... Movies Allo Allo: Season #4 Aristocrats (2005) Dallas: Season #4 Educating Rita Flightplan (Widescreen) (#1 in the DVDPS Top 40) Fog (2005 / Widescreen / Un-Rated) Ghost In The Shell: Season #2 v3 (Limited Edition) Ghost In The Shell: Season #2 v3 (Standard Edition) Hill Street Blues: Season #1 Missing: Season #2 My Big Fat Independent Movie Oliver Twist (2005) Repo Man: SE Soupy Sales Collection (3-Disc) Virgin Spring, The: Criterion Collection Wubbulous World Of Dr. Seuss: Cat's Home But Not Alone Music Ancora Il Divo Your Man Josh Turner The Color Purple (2005 Original Broadway Cast) [Cast Recording] Brenda Russell, et al Black Cadillac [Enhanced] Rosanne Cash Elvis #1 Singles [Box set] [Collector's Edition] [Limited Edition] Elvis Presley The Greatest Cat Power Rabbit Fur Coat Jenny Lewis with The Watson Twins Marty Casey & Lovehammers Marty Ca

Wow. What a way to kick off Lotusphere. My co-worker in crime, Alex Kassabov, and myself had a great time doing out Jumpstarts. We gave JMP204 twice. 1:30 to 3:30 and then 4 to 6. A long afternoon. A great afternoon. We filled the first room to the brim (I am told there were people very angry they could not get in) and had a full room for the second version. I figure over 500 people checked out the integration jumpstarts. From both of us ... Thank you! Presentation: JMP204.PDF Demo Files: JMP204.ZIP Thanks again!

As you can feel the buzz of the coming beast known as Lotusphere (I can see signs going up at the Dolphin), I played 18 holes at Bay Hill today. My father, my boss, and a client of my father's (who is a member of Bay Hill) played. I enjoyed the weather immensely (that is my way for saying I played like crap) ... how can I complain with 70 degree weather and playing golf in shorts in January?

I think I am the first to arrive ... (I know, picture quality is bad ... was moving fast ... that is the hallway with the escalators down to the Product Showcase). Things look so calm ... before the storm called Lotusphere2006 :) Golf tomorrow :)

I try not to put any politics on my site ... there is no good way to express political (or religious or sexual) topics without angering someone. I try to keep this site about technical and fun stuff. Reading this quote today, I could not stop from commenting on it. "It's time for us to come together. It's time for us to rebuild New Orleans - the one that should be a chocolate New Orleans," the mayor said. "This city will be a majority African American city. It's the way God wants it to be. You can't have New Orleans no other way. It wouldn't be New Orleans." Ray Nagin, Mayor, New Orleans. Woah. I get that I am blessed in my life ... I never forget that. I know that growing up in Upper Middle Class Wheaton, IL was not the hotbed of racism tension or struggle. I have been lucky. I know there are many people out there that are not as privileged or lucky as I am. This is not about that. My thought after reading this is that racism is still present in the US, and it is

Here is what's coming out today ... Movies Adventures Of Superman: Season #2 Casino: SE Dead Poets Society: SE (#40 in the DVDPS Top 40) Doogie Howser, M.D.: Season #3 Funny Factory With Donald Funny Factory With Mickey Gantz: Season #1 Good Morning Vietnam: SE Lois & Clark: The New Adventures of Superman: Season #2 Lord Of War (Widescreen) (#33 in the DVDPS Top 40) Lord Of War: SE (#8 in the DVDPS Top 40) Mary Tyler Moore Show: Season #3 Mr. Show: Complete Collection Muppets Movies Collection Richard Pryor Collection, The Rurouni Kenshin: Season #2 Titus: Season #3 Two For The Money (Widescreen) Walking With Monsters: Before The Dinosaurs Wild Hearts Can't Be Broken Music The Great American Trailer Park Musical [Cast Recording] Paul Ranieri (Performer), et al A Piece Of My Passion Juanita Bynum Ecstasy on the Edge Hall & Oates Silk & Soul Nina Simone Original Cast Recording [Limited Edition] [Import]

Google keeps coming up with the coolest web solutions. Take Google Maps, mix in Google Local with searching for locations and keywords, mix in driving directions and put it on your mobile device. Introducing Google Local for Mobile. Such as my Blackberry 7200. What does this mean? You have maps and driving directions anywhere you have a phone with a GPRS connection. Once we have GPS feature on these devices, automatic positioning ... now that will be amazing. If you have a mobile device that supports Java, check it out. Phones and Blackberries supported today.

Here is what's coming out today ... Movies 5 Heartbeats: SE (Widescreen) Andromeda Season 5 v3 Baby Brainworks: Four Seasons Bad Sleep Well, The: Criterion Collection Beggars & Choosers: Season #1 Black Books: 1st Series Boy Meets World: Season #4 Constant Gardener (Widescreen) (#23 in the DVDPS Top 40) Ferris Bueller's Day Off (Bueller Edition) (#26 in the DVDPS Top 40) Final Fantasy VII: Advent Children SE Flash, The: The Complete Series Hustle & Flow Island In The Sun Mad Max: Superbit Collection Magnificent Seven (Collector's Edition) Men Behaving Badly: Season #3 Men Behaving Badly: Season #4 Nighty Night: Series #1 Once & Again: Season #3 Peckinpah Westerns Collection (#28 in the DVDPS Top 40) Red Dwarf: Series 7 Red Eye (Widescreen) Return Of The Pink Panther, The Rollerball (2002): Superbit Collection Samuel L. Jackson Collection Strong Medicine: Season #1 Transporter 2 (Widescreen) (#14 in the DVDPS Top 40) Urban Gothic: Season

To follow his Led Zeppelin, Rush, and Beattle tribute bands, Dream Theater's Mike Portnoy (drummer) is putting together a tribute band for The Who. Here is an excerpt about it: Dream Theater drummer Mike Portnoy has put together a tribute band that will play three dates in late May, paying tribute to The Who. The lineup for Amazing Journey - A Tribute To The Who includes Portnoy, Gary Cherone (ex-Van Halen, Extreme), Paul Gilbert (Racer X, ex-Mr. Big) and Billy Sheehan (ex-Mr. Big, David Lee Roth). The three dates are: 5/27 - Whittier, CA at Center Theater Stage/Whittier Community Center 5/30 - Chicago, IL at Durty Nellie's 5/31 - New York, NY at BB King's Blues Club More info on the Dream Theater website and Mike's site. Very cool that I get to see this ... wonder what songs they will do?

I co-worker of mine sent this to me ... I guess this is one way for the geeks in the server rooms to interact with the women ;) Hot-Babe for Windows

That is the new Dell XPS Renegade gaming desktop computer. Let us look at the stats on that beast: 4 GeForce 7800 GPUs Intel Pentium processor Extreme Edition 955 were factory overclocked at 4.2GHz 30-inch LCD monitor, the Dell UltraSharp 3007WFP, supports resolutions up to 2560x1600, can display 4.1 million megapixels, and has a 700:1 contrast ratio and a 178-degree viewing angle. The price? Straight from Michael Dell - "A Lot" ... the monitor can be purchased now for $2,199. The computer will be available in 2Q2006.

A summary of all the info released about the upcoming Queensryche album (the sequel to the amazing Operation:Mindcrime from 1988) Album Release Date: April 4th, 2006 Track Listing: 1) Freiheit Ouvertüre 2) Convict. 3) I¹m American. 4) One foot in Hell. 5) Hostage. 6) The Hands. 7) Speed of Light. 8) Signs say Go. 9) Re-arrange You. 10) The Chase. 11) Murderer? 12) Circles. 13) If I could change it all. 14) An intentional confrontation. 15) A Junkie¹s Blues. 16) Fear City Slide. 17) All the Promises. The first single (and video) is "The Hands" Pamela Moore returns as "Sister Mary," which should be interesting since she died in the first release. Dr. X is being played by Ronnie James Dio. Now that is cool. A picture to leave us all in eager anticipation for the release ... I can hear in my head "Mary, my lady of pain, always alone ..."

Here is what's coming out today ... Movies Alien Nation: Complete Series All In The Family: Season #5 Aqua Teen Hunger Force #1 Attack Of The 60 Foot Centerfold Cave (Widescreen) Dumb And Dumber: Unrated Cut Gunsmoke #1 (50th Anniversary) Gunsmoke #2 (50th Anniversary) Gunsmoke Set (50th Anniversary) Have Gun Will Travel: Season #3 Hunter: Season #3 Silk Stalkings: Season #4 Snatch (Deluxe Edition) Walt Disney's Timeless Tales #3 Wedding Crashers (Un-Rated / Widescreen) (#3 in the DVDPS Top 40) Music First Impressions of Earth [Explicit Lyrics] The Strokes First Impressions of Earth [Deluxe Edition] [Explicit Lyrics] The Strokes Better Days [CD-single] [Import] Goo Goo Dolls Rosenrot [Limited Edition] [Import] Rammstein Shopgirl [Soundtrack] Nick Cooper (Performer), et al Mrs. Henderson Presents [Soundtrack] George Fenton (Composer), et al Come and Get It [Im