To celebrate the release of the Office Migration Planning Manager (OMPM) for Office 2010, I will be creating a series of blog posts that describe OMPM installation, basic and advanced usage, Q&A, and any other topics that come up. Do you have OMPM (or Office Environment Assessment Tool [OEAT]) questions that you’d like to see answered in this blog? Please leave your ideas in the Comments of this blog post for future consideration.
For this first post, I’ll walk you through a basic installation of OMPM using SQL Express 2008 R2 as the database back end. I’ll also scan my laptop to assess my old Office files and go over some of the initial scan results.
Let’s get started!
1. For this walk-through, I will be using the Access reporting tool to view the OMPM scan data. Therefore, make sure that you have Access 2007 or later installed on the computer where you install OMPM.
2. Download and install OMPM from the Download Center. The download process extracts the OMPM files to a folder of your choice. I will be using C:\OMPM for this walk-through.
3. Install SQL 2008 R2 Express. You can choose either the 32-bit or 64-bit edition. Remember which edition you install so that you can choose the same edition for the components you install in Steps 5 and 6.
4. The setup process for SQL 2008 R2 Express takes a while to download and extract files. Accept the various prompts and wait for the opening page of SQL Express 2008 R2, called the SQL Server Installation Center, to appear after extraction is complete. Then, follow these steps:
a. In the SQL Server Installation Center, click New installation or add features to an existing installation.
b. In the SQL Server 2008 R2 Setup wizard, read the license terms and accept them, and then click Next.
c. On the Feature Selection page, accept the defaults (all checkboxes selected). Click Next.
d. On the Instance Configuration page, create a named instance called OMPM. Click Next.
e. On the Server Configuration page, accept default service accounts. Click Next.
f. On the Database Engine Configuration page, accept the default authentication mode (Windows authentication mode). Your user account will be shown as a SQL Server administrator. Click Next.
g. On the Error Reporting page, click the check box if you want to send error reports to Microsoft. Otherwise, just click Next.
h. Wait for the installation process to finish, and then close the wizard and the SQL Server Installation Center.
5. Install the Microsoft SQL Server 2005 Backward Compatibility Components in the Microsoft SQL Server 2008 Feature Pack. Accept the defaults for all options.
6. Install the Microsoft SQLXML 4.0 SP1 pack, in the Microsoft SQL Server 2008 Feature Pack. Accept the defaults for all options.
Now that you have the SQL components installed, you are ready to create a database for storing OMPM results. Take the following steps:
1. In an Administrator command prompt window, navigate to the folder where you installed OMPM, and then open the Database folder.
2. Type the following command to create a database called ompmdb for the ompm SQL instance: createdb.bat .\ompm ompmdbWhen you execute the command successfully, you will see the following results in the command prompt window: C:\OMPM\Database>createdb.bat .\ompm ompmdbMicrosoft Office Migration Planning Manager version 2.0Database Provisioning ToolCopyright (c) 2010 Microsoft Corporation. All Rights Reserved.Database 'ompmdb' was created successfully.If you are running the command prompt without administrator privileges, the command will fail.
You are now ready to configure OMPM settings in the Offscan.ini file, which is located in the Scan folder where you installed OMPM. Navigate to the Scan folder and double-click Offscan.ini to edit it. I’m only going to change a handful of settings for this walk-through, but I will also point out some new settings in case you want to experiment. You can find more information about each setting in Offscan.ini in the OMPM Technical Reference.
Note: If you have permissions issues when trying to save Offscan.ini, add yourself to the permissions list for the OMPM folder and let me know via this blog if you encounter this issue.
The table below shows various parameters in Offscan.ini that I will use in this walk-through. Any parameter in bold indicates that I’ve changed the default.
[Run]
;Run ID is a unique ID for this distribution of the scan.
RunID=1001
Each time you run a scan, you must increment this number, otherwise the scan won’t start. When you view your OMPM scan results by using the Access report viewer, you can view all runs or a selected run.
;Description can be used to describe any extra info about the Run. I.E. Month/Year
Description="ORK team blog OMPM scan."
The description also appears in the OMPM Access report viewer. I highly recommend that you use a unique description for each run.
[Scan]
;SkipOldAccessedFiles: if set to 1, offscan will skip files with a Last Accessed Date less than OldAccessedDate
;if set to 0, offscan will not skip old files based on Last Accessed Date
SkipOldAccessedFiles=0
;OldAccessedDate: files with a Last Accessed Date before OldAccessedDate will be skipped if SkipOldAccessedFiles=1.
; Date format should be “YYYY/MM/DD”
OldAccessedDate=2005/01/01
;SkipOldModifiedFiles: if set to 1, offscan will skip files with a Modified Date less than OldModifiedDate
;if set to 0, offscan will not skip old files based on Modified Date
SkipOldModifiedFiles =0
;OldModifiedDate: files with a Last Modified Date before OldModifiedDate will be skipped if SkipOldModifiedFiles=1.
;Date format should be “YYYY/MM/DD”
OldModifiedDate =2005/01/01
OMPM 2010 now offers a way to limit scanning to only files that have been modified or accessed within a specified date period. These settings are not enabled by default, but we recommend enabling them to keep the scan results manageable. Work with your business groups to determine if scanning every old file is necessary, or if you can limit the scan (and eventual conversion) to files that have been accessed or modified after a specified date.
For this walk-through, I’m not going to skip files by accessed or modified date because I want to ensure that I get a variety of scan results.
;ScanMacros: if set to 1, offscan will attempt to scan macros in scanned filetypes for API or Object Model compatibility issues.
;if set to 0, offscan will not attempt to scan macros for API or Object Model issues
ScanMacros=1
ScanMacros is another new setting for OMPM 2010. For this walk-through, I’m going to enable macro scanning (the default is 0-disabled).
;ScanMacrosX64: if set to 1, offscan will attempt to scan macros in scanned filetypes for x64 compatibility issues
; if set to 0, offscan will not attempt to scan macros for x64 compatibility issues
ScanMacrosX64=1
ScanMacrosX64 is another new setting for OMPM 2010. For this walk-through, I’m going to enable X64 macro scanning (the default is 0-disabled).
FoldersToScan]
;Folder=C:\
;Folder=\\server\share
Folder=\\jillT400\C$
I’m going to scan my remote laptop’s C drive. You can specify multiple clients to scan here.
After you’ve completed and saved your offscan.ini edits, it’s time to execute a scan.
1. In an Administrator command prompt window, navigate to the Scan folder and type the following command:offscan.exe
2. You can watch the progress as each file is scanned. Most files are scanned quickly, but some can take a few seconds to complete. When the scan is complete, you’ll see the final lines of output, which are similar to this:
Start: 2010-08-04 12:33:59End: 2010-08-04 13:01:18Seconds: 2068Total number of files scanned: 133770Total number xml logs created: 5253Scan Complete
After the scan completes, your next step is to import the scan into the SQL database.
1. At an Administrator command prompt window, navigate to the Database folder, and then type the following command:ImportScans.bat .\ompm ompmdb c:\ompm\scandata
2. Wait while the scan data is imported into the SQL database.
Now you are ready to use the OMPM Access Report Viewer. Follow these steps:
1. Navigate to the c:\ompm\report folder and double-click the ompm.accdr file. (Update: A new version of ompm.accdr is available here.)
2. In the Microsoft Access Security Notice dialog box, click Open.
3. On the Welcome to the Office Migration Planning Manager screen, enter the following information:Server: .\ompmDatabase: ompmdb
4. Click Connect. You’ll see new links appear at the bottom of the page, like this:
5. Click Office 2010 Compatibility, which takes you to the Overview tab of the report viewer:
6. Click the Issue Summary tab to view a summary of the scan results. Depending on your scan results, you’ll see issues that are classified as Green, Red, and Yellow.
7. Now let’s view the Scanned files tab to take a closer look at the red and yellow issues.
8. Click the DOWN ARROW next to the Max Level column to filter the list to show only red and yellow issues. (FYI, if you don’t have any Red issues, they won’t appear in this list.)
9. In the filtered list, click the file name link to view more details about the issues detected during the scan. Here is one example of a PowerPoint file that has both red and yellow issues:
I’ll wrap up this first blog post here to give you time to experiment on your own. For my next post, I’ll review the results from macro scanning.
You asked… We answered… PowerPoint Templates We heard it at TechEd this year, “Do you have a slide deck that we can use to show my company the cool features and benefits of Office 2010, specifically PowerPoint ?” We do have templates you can customize. But if you are getting ready to present the idea of deploying Office 2010, and you want to show the benefits that PowerPoint 2010 can provide by using a slide deck – we have an answer for you. Using a template in PowerPoint takes away one major hurtle of presenting a slide deck - the design aspect. Perhaps you really didn’t want to come up with one on your own, or perhaps you were stuck on just how to lay out the details, facts and figures of your proposal - while showing off all the new features of PowerPoint 2010 . Here is a little project called “Everything in this movie was made in PowerPoint” that shows some of the 167 free Office 2010 online templates available on Office.com: http://bit.ly/ppt165. To get started using templates in PowerPoint 2010, watch an introductory video.
You asked… We answered… PowerPoint Templates
We heard it at TechEd this year, “Do you have a slide deck that we can use to show my company the cool features and benefits of Office 2010, specifically PowerPoint ?”
We do have templates you can customize. But if you are getting ready to present the idea of deploying Office 2010, and you want to show the benefits that PowerPoint 2010 can provide by using a slide deck – we have an answer for you.
Using a template in PowerPoint takes away one major hurtle of presenting a slide deck - the design aspect. Perhaps you really didn’t want to come up with one on your own, or perhaps you were stuck on just how to lay out the details, facts and figures of your proposal - while showing off all the new features of PowerPoint 2010 .
Here is a little project called “Everything in this movie was made in PowerPoint” that shows some of the 167 free Office 2010 online templates available on Office.com: http://bit.ly/ppt165.
To get started using templates in PowerPoint 2010, watch an introductory video.
A customer recently asked us whether the Group Policy Overview for Office 2007 downloadable book was available for Office 2010. The answer is "Not Yet," but in the meantime I've assembled the following list of Office 2010 Resource Kit articles that cover Group Policy.
I'll be working on creating the Group Policy downloadable book for Office 2010 in the coming weeks. You can find a current list of our Office 2010 downloadable Resource Kit content on TechNet. Let us know if there is a collection of Resource Kit content that you like to see made available as downloadable books.
The much-anticipated 2010 version of Office Migration Planning Manager (OMPM) is now available for download on the Microsoft Download Center.
OMPM helps IT Pros discover and assess the compatibility of existing Office documents for conversion from the binary document formats (Office 97-2003: .doc, .xls, etc.) to OpenXML formats (Office 2007 and beyond: .docx, .xlsx, etc.). Additionally, OMPM 2010 adds features that assess macro compatibility with Office 2010 and 64-bit Office compatibility. The toolkit also contains the Office File Converter (OFC), which enables bulk document conversions from binary to OpenXML formats.
OMPM 2010 includes the following new features and improvements:
You can find the OMPM documentation in the Office 2010 Resource Kit.
SharePoint Workspace is part of the Office Professional Plus 2010 suite, and it’s designed specifically to support remote and offline SharePoint users who need to work offline or have minimal access to SharePoint servers.
With SharePoint Workspace, an end user can easily connect to a designated SharePoint site, get a local copy of selected SharePoint libraries and lists, and add or modify library or list content within a private “SharePoint workspace”. Content in a SharePoint workspace automatically synchronizes with the associated SharePoint site when users are on their network, or it can be manually synchronized on demand. No browser access needed and no need for VPNs or special IT setup.
To learn more about SharePoint Workspace 2010, read Mena Paton's Blog post on the "To the SharePoint" Blog: Introducing SharePoint Workspace 2010.