Migrating Workflow Items

​When performing SharePoint migrations, you will inevitably come across lists with associated workflows needing migration.  These can be challenging to migrate – especially if you just looking to migrate the data, and not the associated workflow(s).  Metalogix has a nice write up of how to use their tool to copy workflows (http://www.metalogix.com/help/Migration-Manager-for-SharePoint/SharePoint-Edition/002_HowTo/003_MigrationActions/017_CopyWorkflows.htm), but this article doesn’t help if all you want is the data from a list.  The Migration Manager will not allow you to copy items from a list which are associated with a workflow, unless the workflow and associated content types are migrated as well.I recently ran into this situation during a migration.  We had a list of tasks that were being created by a workflow in our legacy system.  The target system was setup as a clean environment, and while it had the workflow in place, they weren’t setup identically as the source.  The Migration Manager software refused to migrate the tasks unless we migrated the workflow as well.  Our simplest solution was to break the workflow association on the source server, then use the Migration Manager to migrate the list items to the target server.Here’s how we did it: 

• We created a .NET console application (our “MigrationHelper”) to read the source list, grab each field we cared about (including all metadata) and write the data to a temporary list on the same server.  This temporary list could be created/re-created over and over with no ill effects.  It contained all of the data that we needed, but not the associated workflow.

• We used the Migration Manager to migrate the temporary items to the destination list.  Since the list definitions were different, we simply mapped fields from the source to the destination using the built-in mapping functionality of the Migration Manager tool.

• We created an incremental job to migrate changed data in the temporary source list to the destination list.  We had a large number of items in the list and wanted our “go-live” night to require the least amount of data transfer possible.  (I’ll write a future blog entry on how and why you should do this)

The end result was a process that required a small amount of code on our part (reading the source list, deleting/creating the temporary list, copying data to the temporary list) and left the bulk of the migration to the Migration Manager.  Focusing on the limitations of the tool allowed us to work quickly and efficiently.  Yes, we had to write some custom code, but we didn’t have to reinvent the wheel and write code that Metalogix had already written (see my previous blog entry on using the right tool for the job:http://www.timlinenterprises.com/consultingknowhow/Lists/Posts/Post.aspx?ID=5).Have you ever run into a similar problem?  What did you do to solve it?

The Right Tool For The Job

When planning a data migration effort in SharePoint, you will undoubtedly be confronted by the classic build vs. buy decision.  Ultimately, your decision will be based on the changes to the data as it is moved from system to system.  For simple migrations where you are just switching from one provider to another (running the exact same software on both the old and new servers), a simple DB backup of the SharePoint Configuration and Content DBs should suffice.  However, when some type of data transformation is necessary, the decision becomes less clear.

The last project I worked on seemed straightforward enough - a migration from SharePoint 2007 at hosting provider A to SharePoint 2007 at hosting provider B.  However, a few requirements surfaced that made this trickier than a simple DB backup and restore.

The main complexity surfaced when the schema at the new facility was different from the schema at the source facility.  Why?  Because the custom application was modified and many of the fields that used to be used were no longer necessary.  My first inclination was to copy the entire  Content DB, and simply pare down the data to the desired schema.  However, seeing how the new environment was being setup as a completely "clean" environment, this was determined to be an unsatisfactory solution.

The next simplest mechanism for moving the desired data was to export the required lists to Excel spreadsheets, remove the unnecessary columns, and import them at the destination site.  Easy, right?  Not so fast - unfortunately, SharePoint will set the modification and creation information based on the import date, not the dates in the source data.  Since we were dealing with very sensitive data with strict auditing requirements, this was deemed unsatisfactory.

This left us with fewer options.  We could have just written code to copy directly from the source to the destination - but that's never as easy as it first appears.  Many unforeseen problems often arise that can take up days of programming time.  Ultimately, we made the decision to purchase an off the shelf tool to assist in the data migration - "The Metalogix Migration Manager."

Using this tool greatly simplified our data migration - however, it was not without its share of limitations.  Like any tool, it requires enough understanding of the platform in order to work well.  For example, we still needed to understand how the Content Types were mapped; how Workflows were being used and what data was associated with those workflows; how users were assigned to tasks and how to deal with mapping non-existent users in the new environment.

In the end, we ended up writing a fair amount of code to make the migration run smoothly.  One of my colleagues felt that we should have just written the entire data migration by hand.  I disagree.  I feel the investment in the tool was well worth the money and saved us from dealing with the bulk of the data transfer. Instead, it allowed us to focus on some of the more tricky/more interesting aspects of the move.

Using our custom code and the off the shelf tool in conjunction ultimately led to a successful migration.  Could we have done it all on our own and not used the tool?  Sure, but at a significantly higher cost.  Plus, the client ended up with a license for a tool that could be used for future migrations.

Bottom line - if you are doing any type of data migration in SharePoint, make sure you have someone that understands the platform and consider getting that person the tools they need to be successful.  Trying to save a bit on the tool cost will almost certainly cost you more in the long run.

What do you think?  Have you had a trying experience with a data migration?

Migrating Your Systems - Are You Prepared?

Lately, I've been leading a number of data migration efforts centered around SharePoint 2007/2010 for a few companies with very sensitive data. These companies decided not to upgrade to new versions of software, but decided to change hosting providers. In so doing, they believed that their system migraiton would be a simple process. Not so fast - it's always more complicated than it appears on the surface.


Here's a list of questions to ask yourself when preparing for a system migration: 

• Are we bringing over all of our data, or just a subset?
• What kind of downtime can we accept? 
• Disaster recovery? 
• Which systems get moved first?  Next? 
• Who has access to the old systems? Are those people still around? Will they be part of the migration effort? Do they want to help us? 
• Who will have access to the new systems?
• How are we planning on moving the data? 
• Do we understand our systems and know which systems access which data? 
• Do we know what exact versions of software our current systems are running on? 
• Will our new hosting provider be able to match the versions or do we need to upgrade? 
• How do we ensure the integrity of the data? 
• How much data do we have - how many databases, How many Gigs? How many records? 
• How is the data physically going to be moved? 
• How can we protect the data?  Do we need to audit the entire process?
• Have we inventoried everything at our current provider? 
• Who will be managing the new systems? 
• How much time do we have for the move? 
• What kind of testing will be done to ensure the new systems are working properly? 
• Do we need to hire consultants to help with the move (hint: yes!)

If I could offer just one bit of advice to anyone planning a migration effort, it would be - do not underestimate the amount of effort required.   Hiring an expert who has experience leading migration efforts is well worth the investment.  The cost of hiring a consultant is more than offset by the cost of not having an expert on hand and ending up with major unforeseen problems.  


What do you think? 


Have you recently been part of a system migration? Was it successful?

Dual Booting an Asus Eee PC 1000h

I got my new Asus Eee PC 1000h and have to say - I love it!
It comes pre-installed with Windows XP on a 40 GB partition and has a free 34.5 GB partition just begging for OS X. Here's how to do it:


WARNING: I'm not responsible for any damage, loss of data, etc. that this could do to your new machine. Use these instructions AT YOUR OWN RISK. They worked for me, but I can't guarantee they will work for you. OK - you've been warned. Still want to continue? Good...

You should read & understand:
http://www.maceee.com/how-to-mac-os-x-1054-for-the-eee-pc-901-1000h-27.html
before continuing here. Make sure you have everything you need.

1. Boot into XP

2. Verify that your Eee PC is setup like mine - 3 partitions:
40 GB
34.5 GB
32 MB
The 34.5 GB partition should be the D: drive and should be completely empty. That's the partition we're going to use for OS X.

3. Next, we want to delete the 2nd partition and re-create it as an "af" partition and make it "active." Here's the deal - once you change the active partition to the 2nd partition, your machine will no longer boot.

Ready? Here's what you do

Make sure you're on the desktop of your Windows installation.
Press WIN+R to open the Run prompt, then type DISKPART and press Enter.
Now we're going to use DISKPART to create a HFS+ compatible Mac partition that we can boot off.

Follow these next set of commands:

DISKPART> select disk 0

DISKPART> select partition 2

DISKPART> delete partition

DISKPART> create partition primary id=af

DISKPART> select partition 2

DISKPART> active

DISKPART> Exit

4. Follow the excellent instructions here:
http://www.maceee.com/how-to-mac-os-x-1054-for-the-eee-pc-901-1000h-27.html
(I DID NOT DO STEP 6)
Be sure to "Erase" this newly created partition and format for Mac OS X.

5. So, you followed the instructions and can now boot into OS X, but NOT into XP. That's OK - we're going to fix that now. You just need to modify one file:
/Library/Preferences/SystemConfiguration/com.apple.Boot.plist. Here's my complete file (the bold faced lines are the lines I added):

<plist version="1.0">
<dict>
<key>Kernel</key>
<string>mach_kernel</string>
<key>Kernel Flags</key>
<string></string>

<key>Boot Graphics</key>
<string>Yes</string>
<key>Quiet Boot</key>
<string>No</string>

<key>Timeout</key>
<string>5</string>
<key>device-properties</key>
<string></string>
</dict>
</plist>



You can edit this file directly from a terminal window using:
sudo nano /Library/Preferences/SystemConfiguration/com.apple.Boot.plist

that should keep the file permissions and ownership intact and just allow you to add the 4 additional lines.

That's it!
The system will boot OS X by default, but if you press F8 when prompted, Darwin will show you a menu and you can select either Windows XP or OS X.

I'm writing these instructions using my eee pc now (OS X of course) - however, i'm doing this from memory, so, if I missed anything or there are any errors PLEASE let me know and I will fix it. Hopefully, everything will go smoothly for you, but just remember, it's only a computer and you can always fix it ;)

Andrew's New "Do"

Well, we gave in to Andrew's incessant begging... he's all set for his trip to Florida:

In the chair











The buzzer is out












Uh oh...












Yep... a Mohawk! Oy...

Almost there...

It's hard to believe it's been almost a year since I got into the accident. I had my 2nd to last appointment with the dentist - molds were made for the final crowns! Here's what it looks like underneath:



Notice the implant on the right side of the picture (left side of my mouth). Maybe I should just keep this look?

Catch-22

File this one under the most ridiculous insurance policy to date. I got a call from my insurance broker yesterday to discuss my dental claims. Turns out, the dentist used "dental codes" to file the claims with Blue Cross. Silly people - don't they know that you need to use "medical codes" in order for the medical insurance to pay?

The broker asked me to have the dentist resubmit all the claims with the medical codes, and then he would be able to work on getting Blue Cross to pay the claim. Easy enough, right? Here's the catch: my dentist doesn't have the medical codes. Sounds simple enough, right? I asked the broker for the medical codes. Here's about how the conversation went:

me: My dentist doesn't have medical codes.

broker: Can they ask around and get them?

me: Um, can't you just give them to the dentist?

broker: Oh, I don't have the codes and Blue Cross won't give them to me.

me: Huh? Why's that?

broker: If I had the codes, then I would give them out and dentists would file under medical policies. Then Blue Cross would have to pay.


Ah, yes. Another one of the insurance companies methods for avoiding payouts. "Yeah, it's covered if you file the claim properly, but we're not going to tell you or anyone how to do that, sohaveanicedaybye!"

Implant Complete

I went to the dentist yesterday - I figured I would start my long weekend with a bit of pain. The worst part, by far, was getting the Novocaine injection into the roof of my mouth. After getting completely numbed up, the actual placement of the implant was completely pain free. Definitely heard some weird sounds, but none of the pain you would normally associate with crunching bone.

So, now i have a screw in my mouth that needs to fuse with the bone over the next 6 months. Very uneventful, just the way I like it. No more dental appointments until March... woo hoo!

Blockbuster Vs. Netflix

I've been a long time user of Netflix - since I got my first DVD player back in 1999 - back when Netflix was a pure rental model, not a subscription service. When they switched to their subscription model, I hated the "End of Late Fees" advertising, because, after all, you were constantly paying - late fee, subscription fee, whatever.

Anyway, eventually they got the pricing model(s) right, and I've enjoyed the service they offer for many years. The one thing that was missing was the ability to walk in to a store and exchange a movie on a whim. That's where Blockbuster could have a killer advantage. Recently, I decided to give Blockbuster Total Access a try. I hunted around the net until I found a 4 week trial of the 3 at a time Total Access Program. Here was my experience:

1. Sign up (thumbs up)
VERY easy. Up and running very quickly, first movie on its way within 1 business day.

2. In-store game rental coupon (thumbs up)
Big selling point for me. They give you 1 free in-store game rental per month with the total access 3 at a time account. That's an $8 value. Nice.

3. Selection (thumbs up)
They have both HD-DVD and Blue Ray titles available, and I found everything I was looking for.

that's where the good stuff ends.

I took my new coupon down to my local blockbuster, picked out Metroid Prime 3 for the Wii and tried to get it for free. I was asked if I had a store account, I said I have Total Access and was told the store and the internet program are 2 completely different entities. Huh?

Why in the world would they do that? What does "Total Access" mean???

4. In store Account Sign-up (BIG thumbs down)

If you are not an existing blockbuster store member, they now charge $10/year to use the store...err, excuse me, to join their non-optional rewards program. Uh, I DON'T NEED the store rewards, i get plenty of rewards from Total Access. I had never paid a fee in the past to be a "store member," but they conveniently dropped my account because it hadn't been used for 90 days or more.

I ended up leaving the store, going home, finding my old blockbuster card, and re-enabling my store account for free. What a hassle.

5. Movie Returns Via the Mail (thumbs down)

My first rentals showed up within 2 business days. I quickly watched and returned 2 of them. Then waited. It took 4 days to show up as returned before the next 2 shipped (Netflix is usually a 1 day turnaround for me). Turns out, 4 days was FAST. The next round took 10 days to show up, and even then, I had to mnaully tell the website I had returned my movies. Then I waited.

After nearly 3 weeks of using the trial service, I have received a total of 5 DVDs. That's with a queue of 15 movies and returning within 24 hours of receiving. That's just plain SLOW.

6. Customer Service (neutral)

I wrote to customer service to let them know how bad their service was and how slow things were... here's the response to my e-mail:

"I sincerely apologize for the inconvenience this has caused. I've reviewed your account and see that you are waiting for three DVDs to be shipped. Here's an explanation of why this happened. If a movie at the top of your priority list is not available at a distribution center near you, the system automatically searches for the movie at other centers. If that movie falls outside of an acceptable shipping window, the system automatically searches for a movie lower in your queue that can get to you quicker. This process looks for "Available" titles 30-40 deep within your queue. We do this so your shipping times will be faster. On occasion, if your top selections are not available at a center near you and you have fewer than 30-40 "Available" movies in queue, a shipment may be skipped.

It appears this is exactly what's happening with your account. Based on the process I mentioned above, I would recommend keeping more than 30-40 "Available" titles in queue at all times. Once you take a few moments to do so, I'm certain you'll see something shipped by the end of the next business day after your queue meets our recommendations. Please let me know if there's anything else I can help with."

Huh???
So, they would rather not ship anything because it would take too long to ship? That's the dumbest thing I've ever heard. I don't want 30 - 40 items in my queue. I had about 10 movies I wanted to see. I don't want to fill my queue with CRAP just so I can get something quickly.

So, I've given up on Blockbuster and moved back to Netflix 2 at a time for $14 per month. Even the Netflix 1 at a time unlimited was better than my Blockbuster Total Access trial.

On paper, Blockbuster could have a killer service. Unfortunately, they are trying to figure out how to nickle and dime you. It feels like they're trying to figure out just how far they can push you with fees and restrictions instead of making it a friendly, all inclusive service.

Take it from me - stick to Netflix - no hidden fees, great selection of HD movies, fast, easy service to use and excellent customer service. Why was I even thinking of leaving in the first place?

Rejected - Round 2

Got a response back from BCBS yesterday from my second grievance letter. I'll summarize:

Dear Mr. Seifer,

We already wrote and told you that we aren't going to cover you.
I've enclosed that letter in case you forgot.
Stop bothering us.

BCBS

So, now I am trying to get the insurance broker involved.
And the saga continues.

Kitchen Remodel

We now find ourselves on the slippery slope of remodeling. You know how it starts - "Yeah, I'd really like to fix up the fireplace" which leads to "and the kitchen could use new appliances" followed by "we should gut the kitchen" and next thing you know "it would be great to do the kitchen AND the bathroom AND the family room."

I guess we should set a budget, eh?

Fireplace Remodel

Now that my summer is over, it's time to start thinking about the colder weather moving in. My favorite room in my house is my Family Room / Home Theater. Problem is, it has 3 exterior walls, a non-working fireplace and a large OLD sliding glass door with no insulating properties to speak of. It gets chilly in there. It would be great to replace the fireplace with a gas insert and use it as a zone of heat. I also HATE the way my fireplace looks.

It's very plain, just look:



After playing around in photoshop for an hour or so, and digging out some pictures of fireplaces, fireplace surrounds and bookshelves, i mocked up a picture of what I'm thinking of doing:



What do you think?

Speaker Grills Should Match!

How To Paint Your In-Wall Speaker Grills

One of the projects I had completed when we moved into our house, was installing a home theater that could be experienced, but not seen - you know, in wall speakers, all of the components in the basement, flat panel TV - the whole nine yards. Apart from a few problems with the plasma (which were handled nicely by NEC BTW), the home theater has been amazing. Great video and outstanding sound, easily controlled with a Logitech Harmony 880 Universal remote.

The speakers I chose for my in-walls are from the Triad line of speakers (InWall Silver line). While they don't sound quite as good as a non-in-wall speaker, they do sound pretty darn good. Unfortunately, at the time I bought the speakers, the grills and brackets came in white, and it cost extra to match the paint of the room. They have since changed their policy and now include the cost of custom grills in the cost of the speakers - smart move if you ask me. Unfortunately, my speakers still stood out with their white faces on my desert tan walls. Triad offered to send me new matching grills - at $100 each! $600 for grills... I did consider it, but figured I'd see if I could paint them myself before spending any real dough.

I started by pulling the grills off the speakers, leaving the brackets/frames in place. I taped up the outside edge of the frames to keep my walls clean and proceeded to put 2 coats of Benjamin Moore Desert Tan paint on all of the frames. I did this with a 1" paint brush and 2 pretty thin coats of paint. The results were excellent - the frames blended right into the wall - ok, easy part done.

Now for the hard part. Painting the grills with a brush would just look like complete crap! The little holes in the grills that let the sound pass through would clog with paint, making them look and sound MUCH worse. However, I did find that if i painted the grill with a thin coat of paint, then used a compressed air can to spray the grill, the holes all opened up nicely and they started to look good. However, I then thought of a better way to paint these - using an air-brush. Since I didn't own an air-brush, I needed to find an inexpensive model (less than $50 for sure) that could do the job, otherwise, the time & expense of the project would be more than just ordering the grills from Triad.

I called around to a few arts & crafts stores and found that Michaels Arts & Crafts had just what I was looking for. They carry a basic Badger air-brush for $24.99. Add in a can of "propel" (compressed air) for $12.99 and it was well within my budget. After a quick trip to Michaels, I was armed with my new tool.

After assembling the air-brush (2 minutes), I experimented with the paint flow a bit. I ended up mixing water into the latex based paint to thin it down to the consistency of milk. This proved to spray very nicely and evenly. I experimented on one of the grills and voila! perfect. The paint coated the grill without clogging any of the holes.

I then spent the next hour spraying a thin layer of paint on all of my grills, trying to be as even as possible in the coverage (did one pass horizontally and one pass vertically). I did use a bit too much paint in spots, which resulted in clogged pours. This was easily remedied by wiping the excess paint from the back of the grills, then using my compressed air can to blow out the clogged holes.

I let all of the grills dry for an hour or so, then sprayed a second coat on, repeating exactly as I did with the first pass. After letting them dry for about an hour, the results were outstanding!!!
I reinstalled the grills and they look like they came from the factory painted to match my walls. Of course due to the nature of a grill cover, they appear a bit darker than the wall, but now they are MUCH less visible and no longer attract any attention when you enter the room.

Here is a picture:

Smile!

Got some new (temporary) teeth yesterday... it went like this...

Step 1: Get the teeth filed down (YIKES!)



Step 2: Add metal post to tooth nub



Step 3: Add 4 piece bridge



While it obviously looks better than having missing teeth, it's still not as good as it once was :(
Fortunately, these are plastic teeth and we'll work to make them look more natural before making the final teeth.

Here's what they used to look like:


The two teeth next to the front teeth used to be smaller and my front teeth where more rounded. Hopefully, we'll get them looking like that again!

Grievances

How crazy is it when an insurance company has 4 levels of grievances? It works like this - file your grievance, watch it get rejected. File a 2nd grievance. Watch it get rejected. Rinse and repeat. I'm on my second grievance attempt now. i've got 3 doctors notes all saying that my condition is medical. I've written another detailed letter to BCBS. Now, the insurance broker who works for my company will also follow up with BCBS. Maybe this will have some impact?

I don't know.

What I do know is that the process is obviously setup to discourage people from taking action. Put up enough barriers and most people will just say "screw it" and give up. Is this how insurance is supposed to work?

Time to Research

I used the time I had to start researching my options. I sent an e-mail out to the USCF-NE list to see what folks would say there. I got lots of good advice, offers from dentists around the area to check me out, but ultimately, nobody had the silver bullet.

I started talking to the dentists to see what they recommended. I made evaluation appointments at a few places and went in to get checked out. As a low cost alternative, I went to Tufts Dental School to get an evaluation, but ultimately did not feel comfortable there. Penny wise & pound foolish.

A good friend of mine's wife (Kathi) used to work for the "denying" side of the insurance industry. She gave me lots of great advice, plus a good dental contact. I went to see the folks over at the Dentist's Collaborative (http://www.superdental.com) and boy was I impressed. I got an extremely thorough exam, no jumping to conclusions on treatment until a complete evaluation by 3 separate specialists was completed. I knew I had found the place to do my work.

Now it was just going to be a question of how to PAY for all the work. My initial grievance with Blue Cross Blue Shield was denied (sorry, you're not covered). I was pretty angry by this point with BCBS - but Kathi had warned me nothing would come easy. Here I was, with full medical and dental coverage, plus race insurance and I was looking at $14k out of pocket. HOW COULD THIS BE!

I got a phone call from BCBS around this time - a customer satisfaction type of call. I was so pissed. "How's everything going?" SCREW YOU. I let 'em have it, told them they should be ashamed of themselves, blah blah blah. The insurance industry is so bad. They are fine for small stuff, but boy, when you need 'em for something big, poof - they hide behind their contracts and fine print. Complete BS. Start jumping through hoops and be persistent...

Insurance Companies Are More Dangerous

I was healing quickly and back at the office within a week. All along I had assumed I only had to focus on getting better, not the money for my treatment. I called Blue Cross to confirm my assumption. My conversation went something like:

me: "Will my dental work be covered"

them: "Yes, under your dental plan"

me: "But my dental plan has a $1000 max"

them: "Yes, that's where it's covered"

me: "But it's $10,000 worth of dental work"

them: "It's covered under your dental plan"

me: "No it's not, you're only give me $1k on $10k worth of work"

them: "That's due to your plan"

Turns out, no dental plan in the country offers more than $2000 per year, so, there was no way my dental reconstruction was going to be covered under ANY dental plan. So, I call back.

me: "My accident should be covered under my medical insurance"

them: "No, it's dental"

lots of arguing back and forth.

me: "Do you think I need my teeth medically?"

them: "They are dental"

me: "What if I didn't have dental insurance at all? What if I only had medical?"

them: "But you do have dental"

me: "Do you think my teeth are medically necessary?"

them: "..."

me: "I need them for eating, breathing, talking, quality of life, right?"

them: "Yes"

me: "So they are medically necessary?"

them: "Yes, and they are covered under your dental plan"

Ahhhhhh! So, I wrote up a grievance and talked to my dentist about how to go about getting medical coverage. He said, "good luck." He was totally not interested in helping me fight the insurance company. Damn.

I realized then that I was in for a fight, and that I needed as much information as possible. The good thing was, I had plenty of time to start my research. With a broken jaw, i couldn't even start to get my teeth fixed.

So, my research started...

Before and After

Just a couple of pics to show the wires on my broken jaw. The "old" me was taken in Dec. 2006... the new me was taken 2 weeks after the accident - still a bit swolen, but most of cuts had healed. FYI - those wires on my teeth were a real PITA!

Before:

After:

Staying at Home is not Dangerous

I was released from the hospital the following day - feeling much better, but looking back on it now, far worse than I thought I felt. I was sent home with some pretty good painkillers, but I tried my best not to take them (I think I took a total of 2).

Fortunately, I had recently started a new job which afforded me some sick time (I was previously consulting for Syrinx Consulting which would have meant no $ for me while I was laying in bed). After 3 days of lying around watching TV, I was dying to get back to work.

I still looked pretty horrific (although, according to some friends, it was an improvement), so when I told my boss I would be coming in to pick up some stuff so I could work from home, he graciously offered to swing by and drop it off for me.

I spent the week at home, healing as fast as possible. By Monday of the following week, I was healthy enough to go into the office, at least part time. It was also around that time that I started thinking about the cost of the accident and how the insurance company would handle the bills. I had (and still have) Blue Cross Blue Shield of Massachusetts coverage for both medical and dental. In addition, I had race coverage provided by the USA Cycling. I was well covered, so surely I would only have to worry about getting better, not the cash for treatment.

Boy, was I wrong...

Bike Racing is Dangerous

One of the things I love doing is riding my bike. I ride a lot and up until Father's Day of this year, race a lot.

I was in a local race in Newton, MA on June 17, 2007 when some sketchy rider in front of me fell and I managed to endo over him and hit the pavement with my face. Hitting the pavement with your face while traveling 32 MPH leads to problems.

I was knocked out, broke my upper jaw, lost 2 teeth completely, cracked another 2, split my face open vertically and basically cut my lips off - oh, and wound up with tons of road rash.

Yuck.

All this to get a little speed work in a week before the Fitchburg Longsjo Stage Race, which I was training very hard for.

Yuck.

I wound up at Beth Israel Hospital in Boston where they performed just about every test on me to make sure nothing was seriously wrong. Fortunately, I did not have a head or neck injury. My wife showed up in the ER before any of the injuries were treated. I could tell I looked pretty bad based on a couple of things: 1. The lack of any reflective surfaces in my vicinity and 2. My wife turning completely pale when she realized the bloody lump on the stretcher was me (she only knew it was me by looking at my wedding ring).

Three hours of plastic surgery and countless stitches (and shots of Lidocaine) later, my face was back together. I had to keep asking for an Oral Surgeon to come in to look at my teeth. If I didn't insist, they wouldn't have done anything - oh my.

The Oral Surgeon came in and shot my mouth up with some more Lidocaine (including a VERY unpleasant shot into the roof of my mouth) and proceeded to wire my upper jaw with an Arch Bar. She managed to save a tooth that had come most of the way out, but unfortunately, one tooth was completely missing and nowhere to be found.

Once the work had been completed, I was wheeled to a room, so I could spend the night. I wasn't able to sleep much that night, but by the morning I was feeling much better. I even took a picture of myself using my cell phone:


Isn't that pretty? Take it from me... it wasn't fun.