Converting nVision Reports (Tools Upgrade)

After upgrading tools version and moving from msoffice 2003 to 10 we have to convert the nvision reports used in PeopleSoft FSCM.

It is fairly simple and here are the 12 steps .. just follow


1.  Download MS Office conversion utility and install 
      Link to download
      or
      search for nvision MigrationPlanningManager.exe in Google
2.  Take a backup of nvision directory
3.  Navigate to %PS_HOME%\nvision\LAYOUT
4.  Rename all xnv files to xls 
      for /R %1 in (*.xnv) do ren "%1" "%~n1.xls"
5.  Navigate to the directory where you have downloaded the conversion utility
6.  Edit ofc.ini
7.  Change the location to pick xls files: change it to  %PS_HOME%\nvision\LAYOUT in ofc.ini file
8.  Run ofc.exe - this will convert all xls file to xlsx
9.  It will created "Converted" directory under %PS_HOME%
10. Rename %PS_HOME%\nvision\ %PS_HOME\nvision_b4_conversion
11. Copy -R %PS_HOME%\Converted\nvision %PS_HOME%\nvision
12. Rename all xlsx files to xnv
     for /R %1 in (*.xlsx) do ren "%1" "%~n1.xnv"