Some have pondered how Media Center could exist in Microsoft’s new Start Screen environment (which I will call the “Metro Layer”). Folks like Josh Pollard at the Entertainment 2.0 podcast envision a situation where Media Center’s core, unique DVR functionality could be split into three or four Metro Layer apps. The the remaining functionality (like Photos, Music, Netflix, etc) will exist in their own Metro Style apps that are already being built.

I love this idea, and have gotten the essentials of this concept to work. By using some shortcut coding that has been on the internet for a few years, we can create Metro Layer shortcuts that deep-link into Media Center’s modules.

The essential components needed on the Metro Layer are: Live TV, Recorded TV, and Guide. I went to the Windows 8 Desktop Layer and simply created three shortcuts that use these lines as their targets:

• %windir%\ehome\ehshell.exe /nostartupanimation "/mcesuperbar://guide"
• %windir%\ehome\ehshell.exe /nostartupanimation "/mcesuperbar://tv?live=true"
• %windir%\ehome\ehshell.exe /nostartupanimation /directmedia:TV

Then I right-clicked on each shortcut and selected “Add to Start Menu”. This creates a generic Metro Layer shortcut button for each. Finally, I moved the buttons to my Media group of icons in Metro.

The resulting shortcuts allow the user to access the Guide, Live TV, and Recorded TV (respectively) with a remote control on the Metro Layer. (I do not have a tuner set up on this machine, however, so I can only guess that the Live TV shortcut does indeed work).

There are a couple of caveats, however. One needs to place a Windows button on their remote control in order to return to the Metro Layer. This is easy for Logitech Harmony remote controls. The dedicated Media Center remotes, however, don’t have this button, and their green buttons take the user back to the Start screen in the Media Center environment. In order to return to the Start Screen one has to arrow down to Settings and Close the Media Center app.

Additionally, these shortcuts, and the Windows 8 Metro experience do not convey to extenders, and that is something that will never be developed, unfortunately. In the Windows 8 era, extenders will still remain fully in the Media Center environment.

The only other shortcoming in my in vitro test is the unsightly generic icon used for shortcuts in the Metro Layer. Presumably Microsoft will add the ability to customize Metro Layer icons which would enhance the user’s experience in this UI.

Certainly the code level deployment of a separated Media Center would be offer a reason for Media Center users to upgrade. In its current condition Windows 8 offers nothing to dedicated Home Theater PC users that isn’t available in Windows 7. However as Metro Style apps get developed by media outlets such as Netflix, YouTube, HBO, Hulu, and others, HTPC users will increasingly find themselves wanting to be in the Metro Layer. A graceful entrance to and exit from the Media Center environment would sustain Windows Media Center as the premier DVR experience in the market. Until then, though, a little bit of work with a PC can give us an workable experience in Windows 8.

So far there are products on the market like the Roku box, the Boxee box, and Apple TV. The other approach we’ve seen is services built into the TV, such as Yahoo Widgets. Apple fanboys are spilling over with giddiness about rumors of an Apple-branded TV with Apple TV built in, but this approach is hopelessly flawed. If your phone were as old as your TV, would you be happy? The television is a expensive monitor meant to last more than a decade, and in that time software advances will lap the abilities of the TV’s software multiple times over. 

Clearly the external component box is what will win over the masses, but the key is getting critical mass into living rooms before content providers will choose this alternative delivery route over traditional cable or network delivery. The problem with Roku, Boxee, and so many others is that streaming shows and movies is all they do. They will never be accepted by Americans until the content is there, and the content won’t be there until the hardware is in place. Chicken meets egg.

Microsoft certainly is in place with 66 million XBox360s sold (worldwide). However as we’ve seen with Windows Media Center’s Internet TV offerings, Microsoft is completely incapable of making content deals with providers. iTunes, on the other hand, has much to offer, and makes Apple the most likely player to win this game. However Apple TV has only sold around 2 million units, and has completely flopped at getting into people’s living rooms. With Apple TV, the only draw is to buy TV shows that we already purchased from our cable company; tough sell.

The key to the XBox’s market penetration was games. People’s primary purchase intent with this device was to play games. However when they got home and realized streaming content from Netflix and others was available, they started doing more.

The big opportunity for Apple TV is coming in 2012. As the Nintendo Wii recently turned five years old, that company is looking forward to releasing its newest generation of Wii, the Wii U, in 2012. What the Wii U offers is a bulky, smart controller that contains a video screen. The concept is brilliant, allowing certain players to be privy to information that other players aren’t. However rumors swirl about a $600 price for this system, which only comes with one smart controller, a worthless device once it leaves the living room.

There is also this to consider: while Nintendo sold 89 million Wii’s, there have been 108 million iPhones sold, 40 million iPads sold, and 60 million iPod Touches sold. That’s over 200 million potential smart controllers already in people’s hands.

Consider this, too: one of the most popular XBox360 games is the Madden series, which sells around 1.5 million per year. However Rovio’s Angry Birds, the most successful smartphone game to date, has had over 500 million downloads so far. Just on Christmas Day (2011) alone there were 6.5 million Angry Birds downloads.

With so many potential gaming controller components already sold, all Apple has to do is introduce a better Apple TV that integrates iOS devices as controllers, and they have Nintendo’s number. If the Apple TV also features HDMI pass-thru capability, customers could gracefully switch between cable TV, games, streams without having to use the TV’s remote control to change inputs.

Nintendo’s pricey system looms on the horizon, opening the door wide open for Apple to not only take over the simple gaming market, but further that market position to become a major force with studios.

The Windows XP instructions for these apps are correct in instructing users to add the device’s IP address as a favorite network location, however even after following the instructions exactly, one may still have errors copying or reading files from the devices.

The problem is easily solved by installing Microsoft’s Software Update for Web Folders (KB907306). The update is a direct download (no need to run Windows Update), and installs very quickly. I ran this update on my three XP computers and one of them required a reboot while the others were able to correctly access these iOS-based network locations immediately without rebooting.

We simply make sure that all gas purchases for my car end in a “1” (ie. $28.41) and all purchases for her car end in an “2”. Any time I buy gas for someone else or for yard equipment, I end it in a “3”. Then when we reconcile our credit card statements in Quicken, I know exactly how to categorize the purchase.

An added bonus with this system is that any gas purchase made with my credit card with a number other than 1, 2, or 3 signals a red flag and requires investigation.

Unfortunately during the process iOS usually strips the PDF’s actual filename and replaces it with “QL-xxxxxxxx.pdf” (where xxxxxxxx is a seemingly random string of characters).

Authors can save their readers much consternation if they will add a “Title” entry to the metadata. From Acrobat one can edit this metadata by selecting File | Properties , entering something in the “Title” field, and saving the file. Once the file goes to the server, gets downloaded to the reader’s iPad, and pushed to a PDF using “Send To…”, the iPad will replace the PDF’s original name with the Title metadata instead of QL-greekness. For those dynamically creating PDFs on the server side, it looks like Zend can edit the metadata on the fly (though I have not tested this yet).

I don’t know whether or not this is a bug or yet another example of Apple not perfecting the polish on iOS devices. However it is extremely annoying and I wish they would just leave the filename the way the author intended!

With a patient chart view, I want to maximize the space I have. Each operatory has a 24” widescreen monitor at the 12 o’clock position, and without having to click on a tiny icon, I want to be able to quickly see the patient’s existing treatment, treatment plan, and the Clinical Note from the last visit. (I want other modules to appear, too, but that is the subject of another article.) I really want to see more history than that, though, and the default setting for the Clinical Note wastes a lot of space inserting blank lines between each Progress Note item.

I have solved this on most of my computers. I removed unwanted columns from the Progress Notes screen (right-click on any of the column heads like Date, Tooth, Code, etc and select from the menu). Notice that Dentrix puts Notes on a second line in the column headers by default. Simply drag this item up to the first line to the right of Amount, and you’ll see tons of white space disappear. The result is that I can easily Clinical Notes for the most recent 5-7 appointments.

What look have you settled on? Post a link to a screen shot so we can see! (the best way to grab a screen is to use Vista/7’s Snipping Tool. Hit the Windows key on your keyboard, and type in Snipping Tool, and select it from the start menu results. Get a Window snip, then edit it in something like paint to remove personal information. It should take about 5 minutes to complete this portion, but it will be a help for years to come for the rest of us.)

According to medical sources (#1, #2) sunglasses can protect the eyes from UV light and prevent cataract formations. Around water the eyes get bombarded from below as well as above, so polarized lenses can help to not only protect the eyes, but also enable one to monitor the water more closely.

This solution offers floating sunglasses, but beware; I would only wear them when dealing with light duty (playing with small children in shallow water, riding on boats, etc.). I would not rely on this setup for skiing, windsurfing, or surfing.

What you need:

• 1 shoestring or lanyard-style sunglasses strap. (foamy ones like Croakies will not work) (#1, #2)
• 6 yellow foam earplugs (available at Home Depot, Lowe’s, etc)
• 1 1/8” drill bit
• 1 1/4” drill bit
• 1 pair of pliers
• 1 drill

The object here is to thread the earplugs down the thin sunglasses strap. In order to create a hole, grab the earplug along it’s long, curved edges, and hold the plug on a workbench, vertically. With the smaller drill bit, create a hole through the long axis of the earplug. If that hole is not big enough to slide onto the strap, use a larger bit to open the hole a bit more. Sunglasses come in different weights, but usually 6 floats will do. Be sure to spread them evenly, and test in a sink, bathtub, or pool before hitting the surf!

In our office we want to use the email information for each patient more and more. The problem is that at least half of the patients have not supplied this information. We tried to simply look for this information as each patient was in our office, but it is too difficult to remember to check. Therefore we want to set up a patient alert for each of the patients with no email. To do this I set up a Dentrix alert in each chart with a blank email field. Now whenever a staff member opens an appointment card or chart for one of these people, they will know to ask the patient for their email address.

Dentrix requires that these alerts be set on a patient-by-patient basis. So we will have to perform a query, then use AutoHotkey to open each patient’s Family File and set the alert. For our run, it took the machine about 10 seconds per patient to set the alerts, so the entire process only took a couple of hours. This isn’t the most straightforward activity, but it eventually saves the time it would take to either manually enter each patient’s alert or to hunt for this information when they are in the office (if you even remember to look for it).

Perform A Query

First we need to set a query. The best way to search for any group of patients by criteria is to open the “Patient Report (by Filters")” document. Since Dentrix is not able to search for the absence of information, we’ll just perform a search for all active patients (with and without email addresses).

• Go to Office Manager | Letters | Misc… | Patient Report (by filters)" (double click on the document name)
• Set the search criteria to match all of your active patients. I selected “Patient” “non-patient”, both genders, all balance aging, then cleared all field in the lower half of the screen. One could also just search for all active patients whose Last Visit Date was between, 2007 (for example) and today.
• Then go to the Data Fields tab (in the upper left), and make sure that only Last Name, First Name, MI, and Email Address are selected.
• Select OK
• Select Create/Merge
• Deselect “Add to Journal” and hit “OK”

Dentrix will run its search for several seconds. When the search is complete, hit View List. Select All off the text, and Copy it.

Now let’s do a few things in Excel with our data:

• Open Excel
• Select cell A1 and Paste the data into the sheet.
• Select All, then go to Data | Sort…
• Select the Header Row radio button.
• In the Sort By window, select “EmailAddress”, Ascending
• In the first Then By box, select “LName”
• In the second Then By box, select “FName”.
• All three sections should have “Ascending” selected.
• Hit OK.

This now separates our list into those with and without emails. You can now delete the lines with emails, leaving only our list of targeted patients.

Let’s do a second operation in Excel, one that formats the data as we need it.

• Now that the EmailAddress column is empty, lets change cell D1 to read “Result”
• Select Edit | Replace
• In Find What, type a single quotation mark: “
• Leave Replace With empty, and hit Replace All.
• This should remove all of the quotation marks from your Excel page.
• Next, let’s combine these entries:
• In cell D2, type in this phrase: =CONCATENATE(A3,", ",B3," ",C3)
• Hit Enter
• Cell D2 should now display the patient’s name with last name first, a comma, and the first name and middle initial. This is the format Dentrix’s patient selection screen uses to display a patient.
• Copy the concatenate cell to every cell below it for as many rows as there are patient names.
• Select the D column (click on “D” at the top of the column)
• Copy the column of selected, correctly formatted patient names.
• Open Microsoft Word with a blank document active
• Select Edit | Paste Special…
• Select Unformatted Text and hit OK
• Save this document with the filename of “PatientsWithoutEmail.doc”

Running The Script

We will work from this list, running our script which will call up Dentrix modules, perform actions, and return to the Word document. The script’s last action is to bold the text of the current patient, so one can see which patients have had the alert.

You’ll want to run the script on only one or two patients so that you can detect any errors. Once you feel more comfortable that the script is running reliably, go ahead and do a bigger number. I got comfortable running 500 at a time before we finished.

To run the script (which follows at the end of this article), make sure that you are logged into your Dentrix user account and have opened the Dentrix Family File. Then put the cursor on the first line of the Word document, and hit Ctrl-e to run the script. The script prompts the user for how many names it should process. Once the script is completed, hit Ctrl-e again and enter a new number of processes to run.

The script will put the message “Needs Email” for “Always”, will Show Symbol on Appointment, and will be displayed in:

• Create New Appointment
• Edit Existing Appointment
• Family File
• Fast Checkout
• Move Appointment
• Office Journal

Once the patient’s blank email is addressed, the staff member can open the patient’s Family File, open the Patient Alerts module (by clicking on the yellow flag icon on the toolbar), select the Needs Email alert, and hit Delete.

Beware that this new alert may interfere with other scripts you run, such as the one previously posted here for texting patients using Google Voice. The new scripts need to look for the existence of the Patient Alert and Family Alert windows and dismiss them as needed.

The need for email addresses with our patients will continue to grow. While the task of getting these addresses can be daunting for a patient population of a couple of thousand, a good alert system can help a practice gather this information for most of the practice in just a six month period.

The Script

Following is the script needed to execute the flagging. Copy it, paste it into Notepad, and save the document with an .ahk extension (i.e. “msgemail.ahk”). After having installed the AutoHotkey software, simply double-click on the .ahk file and the computer is armed and ready for your Ctrl-e command!

;
; AutoHotkey Version: 1.x
; Language:       English
; Platform:       Win9x/NT
; Author:         A.N.Other <myemail@nowhere.com>
;
; Script Function:
;    Template script (you can customize this template by editing "ShellNew\Template.ahk" in your Windows folder)
;

#NoEnv  ; Recommended for performance and compatibility with future AutoHotkey releases.
SendMode Input  ; Recommended for new scripts due to its superior speed and reliability.
SetWorkingDir %A_ScriptDir%  ; Ensures a consistent starting directory.

; This script requires having the resulting Word document and Family File open before launching.
; It takes about 12s per patient to run

^e::

GUI, Destroy
gui, Add, text, x20 y+11, How many names should be processed?
gui, Add, Edit, x220 y+-18 w90 vmult,
GUI,Add,Button, w60 x150 y+26, OK
gui, Add, text, x10 y+11, Reminder: Have your Word document and the 
gui, Add, text, x62 y+1, Family File open before hitting "OK"!
Gui, Show, w370, iPad Names Setup
return

ButtonOK:
GUI,submit,

Loop, %mult%
{
;CREATE PATIENT ALERT
Send +{End}
sleep 200
Send ^c
sleep 200
ClipSaved_3 = %Clipboard%
sleep 200
send ^b
sleep 200
WinActivate, Dentrix Family File
sleep 200
WinWait, Dentrix Family File
sleep 200
Send {F2}
sleep 200
Send %Clipsaved_3%
sleep 200
Send {ENTER}
sleep 2000
IfWinExist, Family Alert
{
WinActivate, Family Alert
sleep 300
Send !d
sleep 300
Send {ENTER}
}
IfWinExist, Patient Alert
{
WinActivate, Patient Alert
sleep 300
Send !d
sleep 300
Send {ENTER}
}
;Family File
send !f
sleep 300
send t
sleep 300
send !n
sleep 300
WinWait, Create Patient Alert
sleep 300
send !a
sleep 300
send {TAB}
sleep 300
send {SPACE}
sleep 300
send {TAB 3}
sleep 300
send Needs Email
sleep 300
send {TAB}
sleep 300
send Needs Email Address, then delete this notice
sleep 300
send {TAB 5}
sleep 300
send {DOWN 4}
sleep 500
send {SPACE}
sleep 300
send {DOWN 3}
sleep 300
send {SPACE}
sleep 300
send {DOWN 3}
sleep 300
send {SPACE}
sleep 300
send {DOWN}
sleep 300
send {SPACE}
sleep 300
send {DOWN 5}
sleep 300
send {SPACE}
sleep 300
send {DOWN}
sleep 300
send {SPACE}
sleep 300
send {TAB}
sleep 300
send {ENTER}
sleep 300
send !c
sleep 300
WinActivate, ahk_class OpusApp
sleep 200
send {Home}
sleep 200
send {DOWN}
}
send ^s
return

The big problem with this camera is handling the videos once one has completed recording. Panasonic bundles the camera with some of the worst software known to man, however the best way to handle the videos is to ignore that bundled software and use other products.

In another post I’ll discuss handling the files (I just use Windows Explorer), but the focus here is getting Panasonic and Sony’s .mts files up to YouTube. One way to prepare these files is with Windows Live Movie Maker. However Microsoft has oversimplified that product to the point that it is difficult to use. The best product, easily, is VideoReDo because of its blazing fast speed as well as versatile, easy to use settings.

VideoReDo has two modes: Cuts and Scene. Essentially the user picks whether they want to throw away the selected scenes or keep the selected scenes. To me it makes more sense to keep selected scenes, so I use Scene Mode. (This is selected thru Tools | Options… | General Parameters | Editing Mode)

Once a video is edited one has to pick a codec that is compatible with YouTube. While there is a growing list of compatible formats with YouTube, I’ve only found one that works reliably for HD video. The way to select it is to do the following once editing is complete:

1. Select “Save As…”
2. Type a filename and location
3. In the “Save As Type…” box, select MPEG2 Program Stream (*.mpg)
4. Select the “Options” button
5. In the Video section of the dialogue box, select the “>” button to the right of the resolution numbers, and select “1280×720” in the list.
6. In the Header Bitrate section, select 10000 from the pulldown menu
7. In Max Bitrate, select “9500 (DVD)”
8. To save time in the future, click the “Save as New Profile” box at the bottom, then rename this setting in the top box to something like “YouTube Upload”
9. Select “OK”, then Save to save the file.

VideoRedo will spend a few minutes transcoding the video, but when it is complete, open your YouTube profile page and select “Upload” at the top. Navigate to your saved video, and begin the process of uploading the video. The result should be an “HD” video that is easily navigable.

There are three levels of VideoReDo

• VideoReDo Plus ($50)
• VideoReDo Suite Version 3 ($75)
• VideoReDo Suite with H.264 ($100)

I believe that the $50 product will do the task at hand, but honestly, I do not know. Being an avid Windows Media Center 7, Android, and iPad user, I got the $100 version and it is some of the best $100 I’ve ever spent in the computer world. With this level I can take HD Home Video, Time Warner Recorded TV (via Windows Media Center) or captured VCR tapes and create compilation DVDs or convert them for playback on the Android phone or iPad. There are other products for doing these actions, but they are all extremely slow and are difficult to work with.

Here is one of my videos from this camera, uploaded using the method described:

2011 Playoff Calendar (Gcal)