Category Archives: Technology

MPEG-2 Import to iMovie when MPEG2 Muxed

Traditionally, when working with a Mac, things just work. You plug things into it, and it talks to these things (see Apple ad video). Having purchased a Mac Mini a year ago, I have been slowly getting back into video editing and making movies. My first experience was digitizing my high school video yearbook to create a DVD. Recently I started a new project of putting together a video for a group of friends that took a trip together. We had used a brand new Sony DCR-SR60 camera and thought it would be very easy to later edit as this camera records the video directly to an internal hard drive. Unfortunately, it records the files as MPEG-2, which are heavily compressed, not importable by iMovie, not playable with sound by QuickTime and just all around difficult to work with.
After 15 hours of searching the web I came to the simple conclusion: Don’t get one of these types of cameras if you care about quality.
My goal in spending this time online trying to solve the riddle of getting my footage into iMovie was to find the best way with the least degradation to video and audio quality. What I found was that there really is not a good way. Here’s how I recommend doing it after my research. Please, if anyone credible has another idea, I’ll repost. 🙂
Solution
Step 1: Go buy the MPEG-2 player ($20 from Apple) so that QuickTime can even play this file. You’ll want it later to work with another application.
Step 2: Install MPEG Streamclip, a fantastic application with functionality that should be included in QuickTime Pro. This application allows you to demux the file, which strips the audio out of the MPEG-2 file and creates two separate files that you can import and convert to another format later.
Step 3: Open the MPEG-2 file (most likely saved as .MPG) in MPEG Streamclip and from the File menu choose “Demux to M2V and AIFF…”. It will then ask you where you want to save the two files. Make sure they go into the same folder as this will be important later when importing into iMovie. Note: My files used AC3 for audio, but unfortunately iMovie doesn’t support this either, so I had to convert the audio to AIFF
Step 4: Create a new project in iMovie with the default setting of having it be a DV based project (other options are MPEG and H.264, but neither of these turned out with high quality when I tested them)
Step 5: Drag or import the newly created MV2 file into iMovie. iMovie will convert the MV2 file to a DV file in the project and include the appropriate sound file. You’ll now have the clip in the project!
The above solution covers the following problems:

  • “File could not be imported because QuickTime could not parse it. -2048”
  • MPEG2 can’t be imported into iMovie
  • Codecs: MPEG2 Muxed
  • Type: MPEG program stream
    Bit Rate: 9.20 Mbps
    Video Tracks: 224 MPEG-2, 720 ◊ 480, 16:9, 29.97 fps, 9.10 Mbps, upper field first
    Audio Tracks: 128 AC3 2/0, 48 kHz, 256 kbps

Networking Two Routers

About a year ago I moved in with a friend of mine. Both he and I are serious geeks that pride ourselves on trying to be more aware of the latest technology trends and cool consumer electronics. It’s rare that we have a computer or technology problem that we cannot figure out how to resolve on our own. Of course, sometimes this involves countless hours on message boards and geek forums looking for the answer to some obscure problem we run into with our latest purchase. One that had stumped us (mostly due to laziness) was getting our home networking setup to support all the computers we have in the various rooms of a very old house with dense plaster walls. The challenge was getting the wi-fi to reach the back room where my computers were as we couldn’t easily run cat-5 all the way back. After literally purchasing every available wi-fi router at Best Buy, I settled with the Linksys WRT54GX2 as it seemed to have the best signal strength and speed. However, in order to get even this high power puppy to reach the back room, we had to move it into my roommate’s bedroom to be as close as possible to the back of the apartment. This created the challenge. In order to do this, we had to connect it to another Linksys router. In doing this we then created two separate networks, which made it so that we could play LAN games with each other nor share our iTunes libraries with each others computers that are connect to the two rooms entertainment system. As someone who long ago studied networking and was fairly skilled in this category, there were just too many settings for me to want to attack the problem. Then more recently I wanted to explore the gaming and torrent file sharing possibilities with my computer that was connected to the wi-fi router. After some initial monkeying with the setup, another friend of mine stumbled upon the “NAT Mode” feature in the wi-fi router. The small description on the routers administration site said, “NAT Mode: If the router is hosting your Internet connection, select Enable mode. If another router exists on your network, select Disable.” Awesome! This was it! Well, as you might imagine it wasn’t as simple as just selecting “Disable”. Initially we gave up, but I was now of the belief that I could setup this wi-fi router to just act as an access point allowing me to operate with one network. Today, I got back online and started doing some more research on it. I didn’t find the answer well documented, but found enough info and sequencing feedback to figure it out and now have my wi-fi router acting as an access point thus allowing all my computers to get an IP address from the original router and be able to talk to each other. Given the limited info I found, I figured I’d write up my story here in case there are others that need to setup the same. So, here’s the detailed step-by-step direction on how to configure your Linksys wi-fi router to act as an access point only.
Configuring Linksys Wi-fi Router to be an Access Point

  1. Go to the wi-fi routers administration site (http://192.168.1.1) (user is blank and password is admin)
  2. Under the “Setup” menu select “Advanced Routing” and choose “Disable” in the drop-down box to the right of “NAT MODE”. Then click “Save Settings”.
  3. Under the “Setup” menu select “Basic Setup” and enter a static IP address outside your source router’s IP range in the field “Local IP Address:”. (Note: Your source router is the one connected to your cable or DSL modem. To determine the IP Address range go to its admin site and look at the range under “Setup – Basic Setup”. Choose an address that is outside the range, but follows the first 3 sets of numbers e.g., 192.168.15.x – Write down the static IP you choose.)
  4. Select the “Disable” radio button for “DHCP Server:”, then click “Save Settings”. The router will now reboot and you will need to change the physical cables connection.
  5. Move the cable that comes from the source router to any of the Ethernet ports (It’s likely connected to the port labeled “Internet”.)
  6. Unplug the wi-fi router to reboot it so that it now passes through the other router
  7. Cycle your network connection on your computer that is connected to the wi-fi router. You should be given an IP address now within the range of the source router (e.g., my source router has the IP of 192.168.15.x). Test this new connection by going to any website.
  8. Change the SSID on your wi-fi router by going back into the routers administration site. To access this, you’ll have to enter the static IP you gave it in step 3 above. Go to the “Wireless” menu and under “Basic Wireless Settings” enter a new “Wireless Network Name (SSID):” that you will recognize when connecting (otherwise if someone else in your neighborhood has a Linksys router you won’t know which one to connect to). Click “Save Settings”
  9. Connect your computer to the new wi-fi SSID
  10. Go back into the wi-fi routers admin and navigate to “Wireless – Wireless Security” to turn on security so that only authorized users can access your network (optional)

Let me know if you get lost in my steps above.

Video On Demand

We’re no where near having video on demand! I’ve recently had two experiences that were really disappointing. The first experience was when I was in search of a movie. I had a friend coming over that wanted to watch Top Gun. I didn’t have it, but I figured how hard could it be to get. I have cable broadband, BitTorrent, Comcast OnDemand and there are a dozen other services on the web. So, here’s what I did. I needed the movie fast, so I went first to Comcast OnDemand thinking that would be the quickest download of the movie as the last time I used it the movie loaded almost instantaneously. However, when I went to the movie list, there was no Top Gun. In fact, there was a disappointing list in total. Next up, google… I did a quick search for “video on demand” to pull up some of the web options such as Movielink, Vongo, etc. I was on Mac Mini though, which is connected to a HD projection LCD (perfect for movies). None of these services either a.) worked with my Mac, b.) were easy to figure out what to do or c.) allowed me to just get one movie quickly and on demand. I think this is the key to these services being truly successful. I should be able to get a movie going without too much hassle. Let me start it with nothing more than entering my credit card. Don’t make me sign-up for a full account or require me to install a ton of new software. In the end, I went to the tried and true, BitTorrent. It’s slow as molasses, but I haven’t yet not found what I was looking for.
My second video on demand experience that was disappointing was purely due to a poor UI. A few friends of mine have told me that I have to watch this new HPO Series. Since I have Comcast HBO, I also have access to most of the HPO content on demand. This is a pretty good experience, but someone needs to sit on a couch and use it before it’s rolled out to the public. As I was watching the show, I had a phone call that I had to take. I put the show on pause and took the call. During the call, the pause kicked off and it went back to the main menu. At first I was really frustrated expecting that I would now have to fast forward through the show to get back to where I was. Luckily, it has saved where I was, but required me to clumsily go back through the menu to get back to the show (btw, have you noticed there’s no “back” button on these remotes!). The other issue I have with this experience is it leaves me at a screen that shows my “saved programs”. First of all I didn’t “save” them and don’t care to as I’ve already watched them. Secondly, make it easier for me to watch the next episode!
It’s slowly coming together though. We have the bandwidth, we have the technology and we have the content. The keys to getting it all to work are going to be a.) making it easy to access and b.) priced to sell.

Software Testing Resource

A software testing resource for IT Managers and Software Engineers.
Software testing has been my area of focus as an IT consultant. I have managed large software testing efforts and developed and implemented software testing strategies for large companies. Recently I have focused on outsourcing software test organizations leveraging resources globally. Having built a software testing center of excellence in India for a large software company, I have learned to adapt many software development and testing processes to meet the specific needs of my clients. This software testing related website will focus on helping IT managers understand how to improve their existing software testing processes and organization as well as what to consider when outsourcing software testing. I welcome comments on any of my entries and I will certainly adapt knowledge capital shared.

PowerPoint Search

The power of desktop search programs such as those by Google, Apple and Microsoft are impressive. I am a very organized person with a folder structure that usually allows me to find what I am looking for quickly. Yet, I have found myself gradually moving away from the depth of my folder organization structure to using the desktop search to pull up the same files. However, the major gap is non-text content such as images and video files that remain challenging to find over time. Yes, you can spend your life adding enough meta data to your image and video files to allow for better searching later, but I think it would be easier if an application allowed me to quickly scan available images or videos. One specific application I have for this tool is to be able to scan all the PowerPoint slides I have on my machine. Often, when I am putting together a PowerPoint presentation, I have an old design in mind. It could be an old deck that had a similar message or maybe just one slide that had graphics or a layout similar to what I intend to make. I’d like to see this capability today as I need to find the slide that has a pyramid representing different layers of an organization. 🙂

Revolution of the Digital Home Entertainment System

After seeing Microsoft’s offering for the living room at the Consumer Electronics Show this year in Las Vegas, I was actually sad when Macworld (held the following week) did not announce a similar “living room experience”. It was anticipated that they would announce a new Mac Mini, but the conference came and went.
Yesterday, on the verge of Apple’s 30th birthday, they finally released the new Mac Mini at a private event. In typical Apple style, it was a secretive, invite only affair that everyone wanted to be at. At it’s core, the future was displayed in the upgrade to the Mac Mini product line, which is less then a year old. The new Mac Mini, not only leverages the new, faster chip set from Intel, but provides a truly digital, home entertainment system at a price point that seems unimaginable (when compared to the stereo components and computer it can replace). The new Mac Mini, smaller than a box of Kleenex, connects to your TV and stereo system allowing you to surf the web, edit home movies, watch DVDs, and email from your couch.
I have the first version, which didn’t include the remote control capabilities or what is known as “optical outputs” for the latest technology in sound output. It’s been the most pleasant computing experience of my life. It simply works. It maintains itself and provides more things for me to play with than I have time for.
For those of you that don’t yet have a computer hooked up to your TV, this is the one you want! While most of my blog entries are focused on my own ideas, I had to write about this event. We are finally to the point where computers are leaving the office desktop and showing up in our living rooms, pockets and cars. They will connect us to everyone and everything in a time frame that will seem faster then the advent of the Internet. I imagine that within a couple of years, most of my dreams of an integrated multi-media lifestyle will be available. Broadband in the homes, Wi-Fi in every coffee shop and soon to be city, third generation cellular networks, all provide the communications platform for these new devices to share all of our personal media with us anywhere we are. Watching your TiVo’d episode of your favorite show will be just as easy on the bus as it is in the home.

Share Original Photos with Friends

How many times have you received that email from a friend with a link to an online album of all the wonderful pictures taken on their camera from an event you attended? I am so frustrated by the difficulty that exists in online photo sharing. In the age of digital cameras, photo albums are larger then ever. Unfortunately, most of the pictures you want are from someone else’s camera. Yes, this is not a new problem and I do remember the day when one had to ask, “Can you make a copy for me?” I realize that was much more difficult then the process today where at least I can purchase a printed copy of the shared photo. But!, I want to have the original so that I can keep it forever and maybe modify it myself in Photoshop.
I have reviewed the major online photo services out there and have yet to find one that does not charge both users a large fee for this convenience. Now, you may be thinking, “where is the business justification for them providing that service?” Well, here are my thoughts on that:
1.) Unique differentiator
2.) Increased “eye balls” on your site as customers spend more time clicking through images and choosing, which ones to download. You could for example allow only one download at a time, after which you present a splash screen trying to up sell on other products.
3.) Bandwidth costs could be shared with the consumer by leveraging a peer-to-peer technology such as employed by Bit torrent.
Latest News – Service providers that DO allow downloads of the originals:
Google’s Picasa

Smugmug
Service providers not allowing downloads of the originals:
Flickr
Fotki
Kodak Gallery (a.k.a., Ofoto)
Picturetrail
Pixagogo
PhotoBox
Photosite
PhotoWorks
Shutterfly
Simple Star
Slide
Webshots
Yahoo Photos
Now, there are a few ways to share the originals (e.g., uploading them onto your own web server). However, they’re too cumbersome. Another alternative is to use Hello, which is part of Google’s Picasso application suite. It allows you to share the originals, but your computer and your friends have to be online at the same time for the exchange. PiXPO does the same.
If anyone knows of a service that solves this problem, please let me know!
P.S., during the course of writing this entry, another friend of mine sent out pictures from a trip this summer. Argh! I want the originals!
————–
September 8, 2006 Update: Finally!!! It’s arrived. Thanks to Google we will soon all be able to share original photos for download with friends. It’s currently in “test” as it looks like they haven’t committed to this product, but I’m hoping they do. Imagine when we all won’t have to sit through camera after camer during group photos because everyone will be rest assured they can get the original file off of one of the cameras! And, it’s FREE!
– A free download of the Picasa software for uploading your photos to the web in one or two clicks.
– Your own shareable Picasa Web Albums homepage showing all your public albums.
– Enough free storage to post and share approximately 1000 photos (an option for upgrading to more space is also available).
– Big, high-resolution pictures that set a new standard for online viewing. You can even download friends’ photos off the web to print at home or view a full-screen slideshow.
– Fun easy-to-use online tools, like captions, comments, rotate, and zoom.
Learn more about what’s new in Picasa here:
http://picasa.google.com/web/help.html
————–
Update: Snapfish allows sharring an original photo for download. It costs $.49 a pic.
Dear Snapfish Customer,
Thank you for writing to us.
Please find below how to download FREE pictures from Snapfish to your computer:
Images available for free download are of lower quality than the high-resolution versions we have stored on our computers. The High Resolution scans are used for making reprints when you order them, for creating Photo CD ROM’s, and are available for purchase in direct download form as well.
You can use free images where you would view them with a computer, but they won’t print high quality photos.
For Free downloads, we recommend that you download a picture from the “slide” view, as opposed to the “entire album” or “thumbnail” view, as the slide show view has larger images. Instructions are below.
A little technical information for customers who need it: the resolution of the “Slide View” photos is 384×256 pixels and the resolution of the thumbnail view is 96 x 64 pixels. The high resolution scans provided in high resolution download or with a Photo CD are 1536×1024 pixels.
All photos are in “JPEG” or “.jpg” format.
The instructions below cover FREE downloads for both Windows and Macintosh Computers. Please check our site for information and instructions on High Resolution Downloads at www.snapfish.com/helphiresphotos.

Brainstorming software

I wish I had more energy to chase building a company right now, but this just doesn?t quite interest me enough. Maybe later, I?ll build this, but for now I?m just going to share the thoughts. Imagine brainstorming with a large group of people, but you don?t have to listen to anyone talking, especially not the ones that overpower groups anyway. But, imagine you get a high amount of collaboration and ideas generating off of other ideas. What if it was just a piece of software? Now, imagine you have people logged in to a piece of software that doesn?t look much more complicated then a chat, but instead of streams of peoples conversations linearly floating up the screen with their name, it?s anonymous bubbles floating upwards like under the sea. As you see an idea, written inside one of these bubbles it makes you think of one, and you write it. This could go on for 15-20 minutes. Now, connect a reference database to it so that images started floating up replacing some of the words users are typing. You could add sounds as well, ultimately providing a visual experience of brainstorming. At the end, all the ideas are captured in a report and could even tell you who came up with each.

Google?s indexing the universe

While Google is happily indexing everything they can crawl to, I?m left wondering why all those brilliant mathematicians and marketers can?t come up with a better return then a laundry list of miscellaneous web sites that have words on them that match what I asked for. How many times do you scan, click, scroll, return, and repeat until you finally find what you?re looking for? It?s painful. Here?s a thought. Why not take all the intelligence gathered and change the paradigm. I noticed the other day that when I was playing around with the keywords associated with an AdWords campaign I had built, Google was able to recommend other keywords. It seems to me that based on my key words it knows something about them, which leaded me to wonder if it knows enough to categorize my results so that I can more easily find what I am looking for. Here?s a simple example. When I search for ?Montana fly fishing,? I am returned results for sites that provide informative information about fly fishing, places to fly fish, etc. Additionally, I?ll find sites for fly shops in different parts of the world. Another key category is fly fishing guides and outfitters. So, why can?t Google take all the results, categorize them as best as possible and then show me a relationship representation so that I could drill down only on those pertaining to fly fishing guides, which was what I may have been looking for in the first place.

System Execution

In today?s society, we are constantly surrounded and dependent on systems. Some work well and protect our lives and others well, let?s just say someone didn?t do enough testing. The one that gets me every week is the Seattle train system that moves me from the N gate back to baggage claim. After the train has taken off, it suddenly accelerates. The funny part is that this startles everyone, every time because the message, ?Please hold on? is delayed by about one second, just long enough to not warn you until it?s too late. It?s all about execution of a good system, not just the idea.