Uncategorized

Office 365 Home Premium (Office 2013)

I have been setting up various companies on Office 365 lately and have enjoyed the experience so much that I decided to look into Office 365 for my personal use.  Luckily, they offer plans catered to home use, so it’s much more affordable.  At $9.99/mo., I can definitely budget for a subscription.  I’m currently running the 30 day trial just to see how it runs.  Following is my personal review of Word 2013 and Excel 2013 as these are really the only two programs that I, or anyone that I do IT work for actually use.

With my $9.99/mo subscription to Office 365 Home Premium, I get 5 licenses of Office 2013 to install on 5 different PCs within my household.  In addition, I get the usual access to the WebApps in SkyDrive which are Web based versions of Word, Excel, etc.  In addition, you also have the ability to “stream” a copy of Office 2013 to PCs that do not already have Office installed without actually installing Office.  This does not use any of your licenses as the software will not actually be installed on the computer.

Last night, I decided to do a test.  I booted up a VM with Windows 7 installed.  No Office product is installed on this VM, so I logged into my Office 365 account and downloaded the Word App.  After a short installation, I was prompted that I could start using the software, but that it may be slow while more components were being downloaded.  At this point, I did not see any icons for the software (as I had expected since this was a streamed version of Office.)  However, Word launched and I was able to use it just like a normal copy of Word.  I typed up a line and saved the document, conveniently, to my Sky Drive documents folder.  I shut down my VM and opened up Chrome on my host PC running Windows 8.  From here, I logged into Sky Drive (online) and launched the same document using the Word Web App.  This launched a very familiar looking version of Word.  Honestly, when put into full screen mod, it almost didn’t look any different than the actual Word application on the PC.  At any rate, I typed a line and saved the document, automatically going to my Sky Drive documents folder.

I then opened Word 2013 which was already installed on my desktop PC.  I opened the document from Sky Drive and typed a few lines.  I then opeend the file back up in the Word Web App.  Every time the document and the application UI remained the same.  It was very familiar, very universal, simple, and Cloud based!

If you have used or have been using Office 2010, then the switch won’t be to terribly different.  There are definately some differences, but the overall UI is very similar.  Office 2013 incorporates the SkyDrive platform.  By signing into Office with your SkyDrive account, you are able to open, edit and save documents right from SkyDrive without the need to install SkyDrive separately.  Though you can still install SkyDrive if you are like me and prefer to have a local copy of your cloud documents.  I did a test last night beginng

All of the applications in Office 2013 include a neat feature that has been used before.  This is the little “Quick Tools” button that appears whenever an object is selected.  This gives you access to the most common tool for the object you have selected.  For example, in Word 2013 if you select an image, the button gives you immediate access to choosing how the image interacts with word wrap in the document.  2-Click access to the most common option.  Genius, I think.

Excel has some very cool new features.  One in particular I want to mention is the Quick Analysis button.  This is the icon that appears when you select an entire table of data (including headers and titles).  Using this button gives you quick access to automatically generated charts, graphs, diagrams, and advanced formatting using the table data that you have selected.  I have used this feature already on some CSV files exported from my financial program.  So far I have gotten excellent output with absolutely no configuration.  I guess that would be 2-Click graphs?  Genius!

Another cool feature, one which I haven’t found any other application for than the demonstrated purpose, is their Auto-fill (or Auto-guess) feature.  Say you have a spreadsheet with 2 Columns: 1st is for Email addresses, and the 2nd is for First names.  Let’s say that the email addresses are all in the format of [email protected].  Let’s also assume that you have quite a few email addresses, but no names associated with them.  By filling in the first box manually, upon filling in the second box you will be prompted to auto-fill all of the following first name boxes using the auto-guessed first names from the email address column.  Genius!

I thought about including some screen-shots, but honestly I was lazy.  If you didn’t quite understand my explanations of these features, check them out for yourself.  Everything I mentioned is included in the “Take a Tour” document of each Office application.  Microsoft was very generous and included a nice little starter document that shows you some of the new featuers and how to use them.  Each thing I described above is included in the respective Office application.  Get a copy of Office today free for 30 days.  After that, it can be as cheap as $9.99/mo. (possibly cheaper if paid by the year).

Windows Live Mail (App) to Google Apps for Business Migration

A few weeks ago I began discussing with one of my contract clients about moving their email hosting to Google Apps for various reasons.  I have done a few Google Apps setups and it has become fairly simple.  Google even offers some pretty handy and reliable tools to assist in migrating all of the user data from the old mail server to Google’s servers.  So far I have not had any issues with getting data over almost 100% in tact and with the same hierarchy.  That is, until the company that was using Windows Live Mail.

My first road block, which was very easy to overcome with a simple Google search, was what to do with Windows Live Mail messages.  It’s storage is proprietary.  Google’s migration software doesn’t allow for this.  If I was dealing with one user who had a couple hundred emails, I could have easily setup an IMAP connection to the Google account and manually moved the messages over through the IMAP connection.  But we’re talking about over 40GB of total emails between 9 users on 9 different computers.  IMAP is slow and unreliable.  The other option is to get emails from WLM to Outlook.  Google’s Migration tool for Outlook would work just fine.

At first glance, WLM does not appear to support exporting to Outlook.  At the same time, Outlook does not appear to have an import from Windows Live Mail option.  However, WLM does have an option for exporting to Microsoft Exchange.  And this works as long as you have Outlook setup with a default profile.  You don’t have to even have an email account setup.  Just open Outlook, say no when asked to create an email account, and allow Outlook to load with empty data.  Then go back to WLM and use the export option with Microsoft Exchange as the export destination.  Select the folders to be exported and then wait.

At this point you end up with a PST file containing the emails from WLM.  I was getting kind of excited thinking that this would be so simple.  I opened up the Google Migration tool for Outlook and went through the wizard.  Contacts migrated over just perfect.  Suddenly I was given a prompt that the migration was complete.  0 Emails transferred.  I looked into the log and saw that the PST file was indeed accessed.  I confirmed the contacts did get migrated, but no emails made it over.  The log file also showed 0 messages for each of the folders inside the PST file.

I logged onto another computer and did the export and migration with the same results.  Out of curiosity, I loaded Outlook on my personal computer and did a test run using WLM and Outlook and my personal account to a test account on their GA Domain with the same results.  After a few Google searches, I found that quite a few other people have found themselves in the exact same situation.  A working PST file with lots of emails  that won’t migrate with the migration utility.  I have noticed the emails have a different icon on them than a typical PST file containing POP/IMAP downloaded messages (versus WLM exported messages).  All messages seem to have the unread icon.  Unread messages have bold font as usual, but all messages have the unread message icon.  I’m guessing WLM exports the messages into the PST file and stores them differently than an actual message. There are contact types, calendar types, post types, events, reminders, etc.  I’m guessing the messages go over and store as a different type than typical email messages.

At any rate, I was at a loss as to how to get the thousands of emails migrated over.  And quickly.

After a week of pondering this, I finally remembered that Google has a Migration utility for  Exchange.

I spent a whole weekend getting a Windows Server configured with a free 120 day trial download of Microsoft Exchange Server 2013.  I have never setup an Exchange server before.  And it took me about 24 hours the first time around to get it working.  My first attempt at this was using a VM for the server.  After getting things setup and working, I ended up creating a partition on my HD and installing a native Windows Server 2008 OS for better performance for the migration.  My VM kept hanging up with the Exchange software running full force as it was.

First let me explain my theory (which worked in the end): Migrate emails from WLM to PST.  Migrate PST to Exchange.  Use Google Apps Migration for Exchange utility to go from my local Exchange server to Google Apps.  The GAMME utility, by the way, works with IMAP servers as well as Exchange.  I actually ended up using the IMAP option.

Once you get your server setup with Active Directory services and then install Microsoft Exchange with Mailbox and Client Access roles, you can then login to your MS Exchange admin center and create users for each account.  The email addresses do not have to match up.  Meaning, for example, my local server has a user account for [email protected] which will map to my Google Apps account: [email protected].  This is done in a CSV file when setting up the GAMME utility.

After you get Exchange up and running and your users added, you then need to import your PST files.  There are a couple of ways to do this.  My first way was to load up Outlook, create a profile for 1 user, import the PST file and then wait until Outlook said “All folders up to date”  which indicates that all the data imported from the PST file has been copied over to the Exchange server mailbox.  This took quite a while.  I will be doing another set of migrations this week and I am going to attempt to use a PowerShell script that will import a folder of PST files straight into the Exchange server mailbox.  This should eliminate the need to do individual user imports as well as the need to have to wait for the data to sync.  I’ll post my results on that process.

Overall, the process wasn’t too bad.  It was a fun hands-on learning experience.  If you happen to find yourself in a similar situation, feel free to post a comment.  I would love to assist in any way I can in helping someone else through this type of migration.

ICS for Sprint Epic 4G Touch

A few weeks ago I finally gave in and flashed my phone with a ICS leak.  Unfortunately, 30 minutes after flashing I quickly realized that I was suffering major LoS (Loss of Service) preventing me from having a reliable data connection or phone call.

Well, tonight I was getting anxious again and saw that many new leaks have arrived.  After some searching, I finally found a good looking, Odin flashable FC07 ICS Stock ROM pre-rooted.  If you’re interested in doing this with your Epic 4G Touch, head over to xda-developers, at this direct link: http://forum.xda-developers.com/showpost.php?p=23478866&postcount=869
sfhub offers a download link and instructions for how to do this.  It’s rather simple actually, especially if you’ve messed around with an Android phone before.
Well, I am writing this right before bed, and bed is starting to look really good, so I may post my thoughts on ICS later.  Good night!

Automatic Updating Wallpapers

I’ve had plenty of friends and customers over the years who have used third party programs in order to get their wallpapers to rotate through a “public” gallery periodically throughout the day.  I have always hated this since it requires using a 3rd party program (meaning that it is not a part of the O/S or even from Microsoft).  I have just discovered, a little late, I might add, that Windows 7 has the ability to use image RSS feeds for updating your wallpaper.  I knew Apple had added the RSS feed Wallpapers/Screensavers, but had not seen the wallpaper option.

OS X Lion on my PC

I’ve done it before, and I’m at it again.  Can’t resist the pretty-ish OS X Lion interface.  Can’t really afford to go out and spend $600+ on a system that is built to run it, so I’ve spent the last week working on this.  I am nearly finished.  I finally have my PC booting and nearly fully running with OS X 10.7.1.  For some reason, the 10.7.4 Combo Update is taking forever to download.  My graphics are halfway working at the moment, but according so some posts should work natively once I get update to at least 10.7.3.  Will post more once I get further.