Migrating Legacy Office File to 2007 File Format Using Office Migration Planning Manager (OMPM) Tools

 

The Office Migration Planning Manager (OMPM) is a collection of tools that enables preparation and conversion for migration to the Microsoft 2007 Office system. OMPM checks for, and reports on, file properties to help analyse an environment.

The OMPM File Scanner (offscan) a command-line tool was used, that scans files for conversion.

The OMPM File Scanner was used to perform two types of scans:

§ A light scan that quickly identifies the Office documents on a user’s computer or network file system.

§ A deep scan that you can perform on Office documents to gather document properties that provide indicators of potential conversion issues.

SQL Server 2005 database creation tool enables to create the OMPM database, import scanned logs, and import action logs of converted files for further analysis.

Note: While executing the command line utility (ImportActions.bat) for importing action logs on desktops which are a part of work stations a folder hierarchy needs to be created. Change Folder hierarchy from C:\OFCLogs\MACHINENAME to C:\OFCLogs\YOURDOMAIN\MACHINENAME

ACCESS 2007 reporting is used to analysis scanned & converted results and export the scanned records to a text file for conversion.

The OMPM Office File Converter (OFC) a command-line tool allows for conversion of Word, Excel and PowerPoint files to the 2007 Office file formats in bulk.

There are two approaches by which you can perform file conversions with OFC tool

1. FordersToConvert: This approach is not recommended as it only performs the conversion without creating action logs and thus prohibiting the scanned files to be analysed by the Access reporting tool after conversion.

2. FileList: This approach is the recommended one as it performs the conversion and also creates the action logs which can be imported into the SQL Server database for analysis of the converted files by the Access reporting tool.

OMPM Migration Flow of Office File Conversion

OMPM Migration Flow Of Office File Conversion

REFERENCES

Official online documentation:

http://technet2.microsoft.com/Office/en-us/library/d0373697-31f5-4fc5-8dd1-1b9d7f35842f1033.mspx

OMPM Wiki

http://channel9.msdn.com/wiki/default.aspx/OfficeDeployment.OMPMv1

Document Migration considerations:

http://technet2.microsoft.com/Office/en-us/library/1db55715-df10-428d-ad42-4ce3c58a8edf1033.mspx

http://technet2.microsoft.com/Office/en-us/library/8bbdb70b-ddbc-412b-a525-3a0ca3ec0b691033.mspx

Office File Converter (OFC)

http://technet2.microsoft.com/Office/en-us/library/42a75e09-a6e1-4c0f-b77a-dcfa5b6f11c51033.mspx

Open XML Overview

http://technet2.microsoft.com/Office/en-us/library/cce79538-711f-4686-9a31-2bdc7dd999d51033.mspx

Troubleshooting

http://channel9.msdn.com/wiki/default.aspx/OfficeDeployment.Troubleshooting

Migrating Legacy Office File to 2007 File Format Using Office Migration Planning Manager (OMPM) Tools

Advertisements
Explore posts in the same categories: Open Office Xml

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: