Friday, November 8, 2013

Using OMPM or How to bulk convert Pre OpenXML formats to docX or xlsX

We recently performed a migration to O365 for a client with Office 2003. Their Office files were still in the old format, xls without the ending X. This is a Pre OpenXML format and you cannot view these files in Office WebApps. When the client uploaded them to SharePoint Online, they are forced to download them to view them.

We needed to either individually open each of the 1000 Office documents and 'Save As xslx, docx, pptx' or we would have to find a way to bulk convert these.

Fortunately for us, we did not have to convert their 1000's of files individually, and used a tool from MSFT for this purpose called the Office File Converter (OFC.exe) which is available from the OMPM suite.

Here are the steps that we needed to do.




Download Office Migration Planning Manager (OMPM) to the machine that hosts the files.
From <http://www.microsoft.com/en-us/download/details.aspx?id=11454>

The installer extracts all tools and resource files by default to C:\OMPM
If your machine does not have Office 2003 installed, which by now it probably does not, then you will also need to install the Office compatibility pack to convert the files.
http://support.microsoft.com/kb/923505


Once that is installed, open the C:\OMPM\Tools folder that contains tools the Office File Converter (OFC) and Version Extraction Tool (VET)


Following this guide for more information:


Using OMPM tools

Use the Office File Converter (OFC) to do bulk conversions of specific Office files that are in version 97 through 2003 file formats to the Office 2010 file formats.
http://technet.microsoft.com/en-us/library/cc179179(v=office.14).aspx

Using the tool is a bit tricky. You really need to look at the documentation in the ini file.


One of the tricks was to ALSO include the FOLDER location from that INI file

For the OFC.exe to work there must be a [FoldersToConvert] entry in the OFC.INI file.
Fldr=C:\OMPM\TOOLS\EXAMPLE FOLDER\ (in this case I put all the files I wanted to convert into the “EXAMPLE FOLDER”)

You can put multiple folders under this folder,
OFC.exe will follow this path a convert all DOC and XLS files into DOCX and XLSX files. 
It will leave the old DOC file in the folder and create the new DOCX file right alongside.
The date created field will NOT change for the new DOCX or XLSX files

All the new files will be created in the appropriate folder, even if there are multiple layers of folders under the original location

In this case, the SourcePathTemplate and the DestinationPathTemplate listings in the OFC.INI file are just:
SourcePathTemplate=*\*\*\*\


DestinationPathTemplate=*1\*2\*3\*4\

No comments:

Post a Comment