Windows 7 Migration Plan Guide Using Lite Touch Deployment :Part 3 ( The Assessment Tools -Office Migration Planning Manager (OMPM) )
Office Migration Planning Manager
The Office Migration Planning Manager (OMPM) 2010 is a group of tools designed to help administrators during the planning and testing phases of a Microsoft Office 2010 deployment.
OMPM assists administrators in the discovery and compatibility assessment of existing Office documents for migration from the binary document formats (.doc, .xls, etc.) to OpenXML formats (.docx, .xlsx, etc.). Additionally, OMPM 2010 adds features to 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, and a Version Extraction Tool (VET) to extract saved file versions.
Download it from http://www.microsoft.com/downloads/en/details.aspx?FamilyID=81d208f0-7ace-499c-8975-728c648b8b43&displaylang=en
Prerequisites
· SQL (we will use the same SQL we used in ACT)
· Microsoft SQL Server 2005 Backward Compatibility Components
· Microsoft SQLXML 4.0 SP1 pack
Both can be downloaded from
Accept the defaults and next
Accept the defaults and next
Install OMPM
You have to know that OMPM do not have a GUI but Microsoft has provided us with commands that will help us create and perform the needed operations
· Creating the database
· Now for the setting all of it is controlled by single file called Offscan.ini
· we need to create a share that everyone can write to it
Offscan has tone of options you can find it all in
http://technet.microsoft.com/en-us/library/ff602186.aspx
What I am using is this
Note the machines will run this only once to make the machine run more than one scan change the runid parameter
============================================================================================
[Run] ;Run ID is a unique ID for this distribution of the scan. RunID=1001 ;Description can be used to describe any extra info about the Run. I.E. Month/Year Description="This is a test run of the OMPM Scanner." [Scan] ;DestinationPath: the path where the log files will be written to DestinationPath=\\JS-SERVER\OMPM Scan Data ;ScanMyDocuments: if set to 1, the users’ redirected My Documents folder will be scanned ; if set to 0, only local folders will be scanned ScanMyDocuments=1 ;ScanDesktop: if set to 1, the users’ redirected Desktop will be scanned ; if set to 0, only local folders will be scanned ScanDesktop=1 ;DeepScan: if set to 1, file properties and conversion issues will be logged ; if set to 0, file properties will be logged DeepScan=1 ;CABLogs: if set to 1, XML log files will be compressed into CAB files ; if set to 0, XML log files will be written separately CABLogs=1 ;Verbose: if set to 1, every file logged will be printed to the console Verbose=1 ;Recovery: if set to 1, the scanner will attempt to restart a failed scan when the scanner is run again Recovery=1 ;LogOutPut: if set to 1, the output to the console will also be written to a file. LogOutput=1 ;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 ;VerboseSkipping: if set to 1, every file skipped will be printed to the console ; if set to 0, skipped files will not print a message to the console VerboseSkipping=1 ;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 ;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 ;Include all folders you want to be scanned in the FoldersToScan section ;Any folders you want to be skipped should be added to the FoldersToExclude section ;You may include a folder that is a subfolder of one of the folders to exclude ;If there is no entry in this section all physical local drives are scanned. ;The scan stops if a specified folder to scan does not exist on the system. ;Folder=C:\ ;Folder=\\server\share ;The scan stops if a specified folder to exclude does not exist on the system. ;Folder=c:\private ;Folder=\\server\share\private ;If you are scanning over a network, use the Network section to retry on some limited errors. ;If a retry is not successful, an error is logged and the scan continues [Network] RetryCount=10 ;set this to the number of reties per file you would like before moving on RetryInterval=1000 ;set this to the number of milliseconds to wait between retries. RetryTimeout=10 ;set this to how many sequential files to retry before aborting the scan. Use 0 to represent infinity. ;The following are the file types that the scanner will do a deep scan on. The scanner finds the ;files by the extension. If there are additional file extensions to scan, they can be added to the ;appropriate list. [Access] Ext=mdb,mde,mdz,adp,ade,mdt,mda,accda,accdb,accdr,accdu,accde,accdt,accdc ScanDAO=1 AccessScan=1 DisableConvDialog=0 MaxCopyFileSize=0 TempPath= [Excel] Ext=xls,xlt,xla,XLC,XLM,xlsm,xltm [PowerPoint] Ext=ppt,pot,pps,ppa,pptm,ppam,potm [Project] Ext=mpp,mpt [Publisher] Ext=pub [Visio] Ext=vsd,vss,vst,vdx,vtx,vsx [Word] Ext=doc,dot,wiz,docm,dotm |
===========================================================================================
Now we copy the scan folder to a share and create the following patch file this patch file will copy the folder to the client computer and start the scan
We place the script in a GPO (we can use the same one as the ACT so that this one can apply only to windows XP)
Nice video about OMPM
http://technet.microsoft.com/en-us/office/ff683609.aspx
Note: if and when OMPM show you an error for a file this does not mean it will not work with office 2010 but this means you cannot save it using the new extensions or data will be lost .office 2010 have a compatibility mode to work with older files
So what about the plug-ins and if you custom code for office
There is two additional tools for testing that. Usually the IT know where there is a special plug in installed on a machine or if there is a custom code involved with a specific machine
Office 2010 Tool- Office Environment Assessment Tool
Office 2010 Tool-code Compatibility Inspector
Office 2010 Tool- Office Environment Assessment Tool
Now you will have two kinds of scan passive and normal
· The passive will require that the user running it to be administrator level
· The normal scan will scan only running application
This is the report being generated
Office 2010 Tool-code Compatibility Inspector
We should be seeing
For further details please visit http://technet.microsoft.com/en-us/library/ee833946.aspx
