Thursday, August 08, 2013

The best way to manage tasks


Other than sharing our calendars with each other, the best way that my wife and I stay in sync is with Wunderlist. The beautiful task manager offers well-designed iPhone, iPad, Android, Mac and Windows apps, as well as an amazingly powerful website. All stay in sync automatically, and sharing a list with a friend is a snap. We primarily use it for grocery lists, so we share a list for Costco, Target, Trader Joe's, etc. I've got a HoneyDo list ready every weekend. And when we are planning a special event like a birthday party, it's easy to share responsibilities. You can even add sub-tasks, so the Party City item can break down to balloons, hats, helium, etc. The price? Free. Download it and invite me to a list to try it out. My name is Joe, and this is my website, in case you don't know my e-mail address.

Thursday, August 01, 2013

Apple TV for only $75 today

One of my favorite pieces of tech is on sale for 25% off today at Apple.com. It's refurbished, but that shouldn't matter a bit, since it comes with a full Apple warranty. 

With Apple TV you can easily see your own photos and movies on your TV, listen to your iTunes collection on your stereo, or enjoy services such Netflix, Pandora, HBO GO, flickr, MLB.TV, and much more. 

But the newest cool thing is Airplay, which allows anyone with an iOS device on your network to stream content to your TV or stereo through the Apple TV. So instead of showing you the latest pictures on their iPhone, you can view it on the big screen.

Wednesday, July 31, 2013

Backup Power for your iPhone


It's a major bummer when I am caught out with a dead iPhone or iPad. That's why I carry the Mophie Powerstationin my backpack. It's smaller and lighter than my iPhone, yet can recharge it twice on one fill-up. It can also charge an iPad to about half a charge. I much prefer it to a case with a built in battery, because on most days the iPhone's battery is good enough for me all by itself. It takes about an hour to charge an iPhone to 80%, but you can use your phone while it charges. It's only $80 on Amazon.com, and it has lasted me through three iPhones and still looks and acts new. A great gift for a person on the go.

Monday, December 31, 2012

Addressing Christmas Cards

Every year we go through the ritual of revising our Christmas card list. It's always been a manual process in Excel because my wife must have each card addressed exactly right. A card could be addressed to Mr. John Smith, The Smiths or the Smith Family, depending on John's success with women.

After seeing a few other friends' address management methods using Microsoft Word, then hearing one couple talk about what an organizational mess their handwritten cards were, I decided to do what I should have done years ago: create a method to rely on the same address book we use on a daily basis to generate our list. We use Contacts (formerly Address Book) on our Macs. Contacts syncs via iCloud to our iPhones and iPads and, after years of syncing nightmares, I believe this technology is now nearly flawless.

So the issue at hand was to print address labels from a group in Contacts exactly the way my wife would like them to read. The solution is to set a custom field in Contacts for Christmas cards, and use that field to print the labels.

HINT: if you are not as persnickety as my wife about how the labels read, you can't print labels directly out of Contacts. Just set up a group that has all your card recipients, highlight it, then print and choose labels. It will print a label for all addresses by default, so change it on the Labels tab to Home only.

Here are the steps for the persnickety amongst us:

1) Add a custom field in Contacts
2) Create a holiday card group in contacts
3) Step through your list editing the new custom field to your liking
4) Export the list in CSV format (comma separated values)
5) Open the list in Excel
6) Set up a Word mail-merge document to print the labels

Step 1: Add a custom field in Contacts

  • In Contacts, select the Contacts drop menu, then Preferences (Contacts>Preferences).
  • Click the Template button in the header.
  • Scroll down to the "Related Name" fields. You'll probably see "friend" and "assistant". Click the green "+" button. It will add "mother", but click on "mother" and select "custom", like this:
  • Fill in your custom label then click OK. Now that label will be available when you add or edit a contact.

Step 2: Create a group in Contacts and populate it with your holiday card list
  • Choose File>New Group, then name your new group. 
  • Select "All Contacts" at the top of the group list so that you can see your contacts again.
  • Drag your holiday card list contacts and drop them on the name of your new group.
Step 3: Step through your list editing the new custom field to your liking
  • With your group set up, you must now undertake the painstaking step of editing your custom field for each contact. This is a big pain the first time you do it, but will pay off for years to come.
  • It's also beneficial to make sure the address that you want to use on your label is in the Home field, not Work. This will put all the addresses in the same column when you export them.
Step 4: Export the list to Excel
Now we need to get our addresses out of Contacts so that we can print labels using the custom field. This is most easily done by springing $2 for a little app called "AB2CSV" available on the Mac App Store here.
  • AB2CSV is one-button app, so we must first change our Preferences (AB2CSV drop menu, then Preferences)
  • On the "General" tab, choose your new holiday card group, and checkbox for "All contacts in a single file":
  • On the "CSV" tab, check "Related Names" near the bottom.
  • Now close out of Preferences and click the big AB2CSV button, then choose where to save your export file.
Step 5: Open the list in Excel
  • Use Finder to navigate to your new file, right-click on it, and open it in Excel.
  • Excel may put each record in one cell, showing you a bunch of commas. Click on the column header to highlight it (the "A" at the top), then select Data>Text to Columns...
    • Step 1: choose "Delimited", then click Next
    • Step 2: check the box for "Comma" then click Next
    • Step 3: leave these settings alone and click Finish
  • You can now delete all the unnecessary columns and make sure all your data looks good. You should have one column with your new custom Contacts field as the header (in Row 1). It will be a bit to the right, though.
  • When you are satisfied with your document, save it as an Excel file.
Step 6: Set up a Word mail-merge document to print the labels
Using Word's mail-merge function seems more daunting than it is. It's a great thing to know how to do. I'll walk you through the basic steps. 
  • With a new Word document open, choose Tools>Mail Merge Manager. This will open a floating menu that will walk you through a Mail Merge in steps. My numbers below match those in the Mail Merge Manager:
    1. Click Create New>Labels... and choose the type of labels you are printing.
    2. Click Get List>Open Data Source... and open the Excel document (use the default options).
    3. The "Edit Labels" window should pop up automatically. Use this to build your labels by inserting the fields laid out as you would address an envelope.   When you click OK, it will populate all the labels with your fields.
    4. You can filter recipients if you wish to print labels in groups. Perhaps you want to include a letter to everyone out of state, so you could filter once for the state field matching your state, then again for it not matching your state.
    5. Step five is the payoff. It lets you see your data populating your labels. Click the "ABC" button to see the magic.
    6. Complete your merge by clicking the Merge to New Document button rather than the Merge to Printer button. This allows you to see the merge in a document before printing. It will also allow you to easily print one page in case there is a printing mishap. 
And that's all there is to it! Hopefully this will help organize your Contacts and free up a little time for Holidays 2013! I am happy to answer questions, just post below!



Friday, December 14, 2012

My Top Tech Gifts for Christmas 2012

Here are a few gadgets that you might want to consider this holiday season. As always, check my past lists below for other ideas. And if you have a questions, just leave it in the comments. I'll get notified immediately and respond. Merry New Year!

1. iPad Mini ($329, Apple)
If your eyesight can stand the reduction in screen size, this is the better iPad, and it costs less. It has the same resolution as the original, just packs more pixels into a smaller space. But what you'll really appreciate is its weight. With my iPad 2, every night I worry the things going to break my nose when I fall asleep. This thing is beautiful. But it may be in short supply before Christmas.



2. Nest Learning Thermostat ($250, Amazon)
This is thing beats other thermostats by a factor of 10. Designed by the guy that designed the first iPod and iPhone, the Nest learns your habits over time and programs itself. Turn the heat up every weekday morning at 7A, but not until 9A on weekends, and it will eventually start doing it for you. It also lets you access it from anywhere (so you could turn your heat up from your iPhone on your way home). It has gotten rave reviews.



3. Canon Pancake Lens: 40mm EF f/2.8 STM ($149, Amazon)
This one is on my Christmas list. If you have a Canon DSLR, you'll love how light and compact this makes your camera. The pancake lens has long been missing from Canon's line-up, but they now offer this high quality option for a low price. Any Canon SLR user would be happy to receive this.



4. The new iMac ($1,299, Apple)
If you haven't been by an Apple Store lately, its worth the trip to hold the new iPad Mini and see the new iMac. It is crazy thin, fast and beautiful. If you have the cash, choose the $1,499 model and add the Fusion Drive, a combo hard drive and solid state drive. That will make the thing scream.  The 27-inch models will ship in January. And remember that when you buy a new Mac, it's always best to by right after they are released, because the price rarely goes down. Wait a while, and you could purchase a Mac just before a new one comes out–the worst time.



5. Sonos ($299, Amazon)
Sonos was on my Father's Day gift list, but I had to add it again because I have gotten to use it so much since then. I replaced my Polk XM receiver with a Sonos Connect, so now I have access to all the Sonos goodness like Pandora and Rdio, my new favorite music service. But the multi-zone aspect of Sonos is it's best feature. My friend, Peter, just put six zones in his house and it is ridiculous how easy it is to control the system from an iPhone, iPad, iPod or Android device. The picture and link above is the Play:3, which is their smaller portable unit. Check out the whole family of devices.

Tuesday, June 12, 2012

My Father's Day Top Tech Gifts for 2012

As always, I encourage you to peruse my last few lists for additional ideas, but here are my latest favorite tech toys--any of which should make a semi-nerdy dad smile.

The Sonos Play:5 is an elegant all-in-one that packs a wallop.

1. Sonos
I included the Sonos Play 3 on my Christmas list. Since then, I have had more time to play with different configurations. I have come to the conclusion that this is currently the best system for music in the home. My brother recently replaced his multi-zone home audio system with six Sonos amps. The result is a system that you control with well-designed iPhone, iPad or Android apps. It's ridiculously easy to group zones together to play the same music, or you can have every zone play something different.

The Sonos family of products.

The Sonos system offers four primary components: 1) CONNECT hooks up to your home network and outputs audio to your stereo or home audio system; 2) CONNECT:AMP includes an amplifier and can power speakers directly; 3) PLAY:3 is an all in one system including speakers; and 4) PLAY:5 is the big brother to the PLAY:3. They have also recently announced SUB, a $699 subwoofer that connects wirelessly to the system, which is due to ship in late July 2012.


You need only connect one Sonos component to your home network (if there is not an ethernet connection where a Sonos component will go, you can employ the $49 SONOS BRIDGE). Once a unit is connected, it creates a proprietary wireless mesh network to which all other SONOS units can connect.

The Sonos system is easily controlled by computer, iPhone, iPad and Android.
Once you've connected your SONOS components, you can listen to all music in your iTunes library, or you can access myriad other popular sources like Pandora, SiriusXM, Spotify, Rhapsody, MOG, Last.fm, Rdio and much more.

The Sonos system is excellent for it's simplicity of set-up and use. If he's a music lover, start him off with the Play:3 and a Bridge. That will allow him to easily take his music the porch, the backyard or the garage. And right now, you can get the $49 Bridge for free at Amazon.com.


The Big Jambox improves on a good thing.

2. Jawbone Big Jambox
Jawbone's original Jambox topped my Christmas list by providing great quality sound streamed via bluetooth from my iPhone or iPad. But if he likes a bigger sound and doesn't mind a bit more weight, the new Big Jambox is for him. At $299 it's a little pricey, but the technology and components are great, and the ease of use is wonderful. (Buy it at Amazon.com)


Still one of my favorite pieces of technology, and only $95.

3. Apple TV 
I have used the Apple TV as my primary music source for over five years, and there is still no more beautiful way to view your pictures and home movies.  This little device is about the size of a few decks of cards, but once plugged into your TV or home entertainment system (via an HDMI cable) offers you access to all your iTunes content, movies and photos. It also allows you to purchase or rent content directly from the iTunes store. Or you can watch YouTube, Netflix, MLB.tv and much more. And now with AirPlay technology, you can easily stream audio and video from any iPhone, iPad or Mac. At $95, the only reason you should not have one is if you have an older TV without an HDMI port.  (Buy it at Amazon.com)



4. The New iPad 
While the New iPad is merely an iteration of the iPad 2 without a major overhaul, it is an amazing piece of technology. The new retina display shows pictures and HD movies in stunning quality. I use my iPad more than any other piece of technology these days--for e-mail, reading, games, controlling my DirecTV and Apple TV and much more. And when iOS 6.0 ships in the fall, you'll get Siri to do your evil bidding. There is a reason that the iPad product line has gone from nothing to 25% of Apple's $160 billion in annual revenues--it is worth it. ($499 at Apple.com)


16GB of storage and about as big as a dime.

5. Verbatim Thumbdrive
More and more, automobiles come with a USB port in the stereo. If your car will play music from a USB device, this little thumb drive is a great addition. It's little more than the size of the USB port itself, but it packs 16GB of storage for only $15--less than a buck a gigabyte! That's enough for about 4,000 songs. And you barely notice it. (Buy it at Amazon.com)



6. iPad Camera Connection Kit
I love taking a sharing photos. And now when I am on the road with my camera, I bring my iPad and camera connection kit along. It allows you to connect a USB cable from camera to iPad, or insert an SD memory card into the bottom of the iPad to transfer your photos. And with the new iPhoto app, its easy to create a great slideshow on the fly.  (Buy it at Amazon.com)




7. The new Macbook Pro with Retina Display
The new MacBook Pro is a major rework of Apple's professional notebook computer line. It thinner, lighter and stronger. And it's the first Mac with a high-resolution retina display. So if he's been very good, and you have $2,200 burning a whole in your pocket, go check it out at the Apple Store.


That's it for this year. If you have any questions, just post a comment below. 

Monday, November 28, 2011

My Top Tech Gifts for Christmas 2011

Much of my Top Ten Tech Gifts for Father's Day 2011 post remains true, though some have had nice price reductions (the Canon Rebel T3i with lens dropped from $916 to $720). I thought I'd add a few more thoughts for Christmas.


1. Jawbone Jambox
A friend brought this little gizmo on a recent camping trip and I was amazed. It connects to a multitude of devices via bluetooth and pumps out thumping sound for it's size (6"L x 2.2"W x 1.6"H; 12 oz.).  It is rechargeable and lasts about 10 hours. It also works well as a speakerphone. The Jambox retails for $199, but you can get the red model shown above for much less with no tax and free shipping using the following link. (Amazon.com, $163)



2. Sonos Play 3
Sonos has long been a provider of whole-home wireless music solutions, but the recent release of the Play 3 and Play 5 remote speakers have brought rave reviews. Easily control your music from an iPhone, iPad, computer or Android device--playing the same song everywhere or a different one from each speaker.  In addition to your iTunes library, Sonos has built-in support for Pandora, Last FM, Spotify, Napster, Sirius XM, and many other offerings from the Internet. The speakers are well built, crank out great sound, and adding another zone means simply buying another speaker. If you don't have a wired network connection where the speaker will be placed, you'll need the $49 Sonos Bridge--you only need one for all the Sonos speakers in your home. (Amazon.com: Play 3, $299; Wireless Bridge, $49)


3. Epson MegaPlex Projector 
Epson recently released these turnkey projectors, but Amazon has already lopped the price dramatically in time for the holidays. The 720p model is HD, though not full 1080P HD, but it should be fine for showing the kids the latest Pixar movie on the side of your house. And the built-in speakers are loud enough to handle that rehearsal dinner slideshow. The iPhone/iPad dock is just gravy. (Amazon.com: 720p, $680; 520p, $549)



4. iPhone 4S 
It's silly not to upgrade to the latest iPhone if your contract allows it. You can sell that old phone on eBay for about as much as the new one costs you. And the new iPhone 4S offers increased speed, Siri, and an amazing camera upgrade. Dealing with the phone companies makes this a difficult gift to give, so the link takes you to the iPhone gift card page. (Apple.com, $199 with contract)



5. MacBook Air
If you need an extra computer around the house, the entry level Apple laptop is a great choice. Shoehorning this much power in such a small and light package is amazing. And the recent upgrades make this laptop even more of a bargain. (Amazon.com: 11.6" Display, $940; 13.3" Display, $1,280)



6. Fujitsu SCANSNAP S1100 Portable Scanner
I have used this line of scanners for five years now. The combination of build quality, performance and ease of use are unparalleled. Turning that pile of bills on your text into digital copies (now acceptable to the IRS) is much better than filing them all. And it folds up so small, you'll barely notice it. (Amazon.com, $190)

Just a few ideas. I know they are a little expensive in these difficult times. Check my Father's Day post for some less expensive options. Or just get him some Thorlo socks. Those are quite nice.

Incidentally, while the iPad is still one of my favorite gadgets (I rarely use a computer at home anymore), the rumor is that they will update it sometime around next March. So I would leave that for a Fathers Day gift.