Questions about OMPM

---

Summary: Questions and Answers about the Office Migration Planning Manager

Please edit to add your own questions and answers

So when can I have it?

The Office Migration Planning Manager released 2/19 - go and get it from Microsoft.com!

I don't want to convert any files to new formats. Is OMPM helpful to me in anyway?

Absolutely! The conversion with the "Office File Converter":OMPMOFC is actually an optional step. The OMPM is very helpful in determining how your environment is: where all your documents are, which documents haven't been touched for a while, and who owns which files.

Do I have to convert my all documents across the whole organization?

No, you can use the Reporting tool to filter for whatever subset you want to convert - all Excel files starting from this path, all files on this domain, whatever.

Is the conversion to the new formats going to mess up all my Macros?

The OMPM scanner only detects if there is a VBA project or not; it does not report on whether there are any macro conversion issues. There are some great articles on MSDN (insert link here) that discuss VBA migration issues. The "converter":OMPMOFC will attempt to convert all the macros it is given (unless you specify it not to do so in ofc.ini) - you should double check that they still work for you afterwards

How can I customize the OMPM Reporting Tool?

Just rename the extension from accdr to accdb and it is now fully editable.
For example - In the Office 2007 Compatibility tab, is there a way to include the owner of the file instead of the user context that did the scanning?

1. Rename ompm.accdr to ompm.accdb so that it can be edited

2. Open “Datasheet- Scanned Files” (listed under Forms) in design view
3. Replace the text User Context (or whichever field you wish to replace) in both fields with Owner.
- If you wish to add a new column without removing an existing one then:
i. Copy and paste one of the existing fields
ii. Type Owner in the new boxes
iii. Place the new field in the appropriate location in the list
(NOTE: the order that the fields appear on this form is the order in which the columns will be displayed)
4. Change the FileId textbox to read a.FileId
5. Set the Record Source property of the Datasheet- Scanned Files form to be:
SELECT * FROM Up_FilterApplyFile As a LEFT JOIN (SELECT fileId, Owner FROM omFile) As b ON a.FileId = b.FileID
(this is because Owner is not a field that is usually selected in this context)
6. Save and Close
7. Rename ompm.accdb back to ompm.accdr

How long does it take to run the OMPM?

Scanning files: very quick, <1s per file
Importing scan results: 10k results/ <5 minutes
If you want to convert the files, then it is about: 100,000 files / 24 hrs. varies greatly with size of files.

Can I assume that all of the files that converted have absolutely no data loss or other issues?

Unfortunately not. Even though most files will convert to the new formats even if they have compatibility issues, there will be some that fail, some that have data loss, and some that may have layout changes. The point of the OMPM scanner is to find such issues so you will know beforehand which files may have problems.

What languages is OMPM available for?

The OMPM tools themselves are only available for English at this time. However, they will work of Office files of any language.

Add your questions here

---

OMPM Homepage