These are consideration and recommendation to use PeopleSoft nVision with Office 2007/ 2010
1.
Process Scheduler Settings
In the
"psprcs.cfg", (%PS_Home%\appserv\prcs\db\ psprcs.cfg)
under [nVision]
UseExcelAutomation=1
under [nVision]
UseExcelAutomation=1
Note:
Use USEEXCELAUTOMATION=1 in prcs config file, by default is 0 . There are some
some issue between Microsoft and PeopleSoft about OPENXML that introduce in
PT851, it is recommended to use UseExcelAutomation=1 until it resolved.
Please Re-configure the process scheduler domain and then reboot the servers.
Please Re-configure the process scheduler domain and then reboot the servers.
All layouts
need to be converted to the Excel 2007/ 2010 format to be able to run.
Please use the Microsoft Conversion Utility to convert ALL your custom layouts including your drilldown layouts. PeopleSoft delivered nVision layout have been converted in
Please use the Microsoft Conversion Utility to convert ALL your custom layouts including your drilldown layouts. PeopleSoft delivered nVision layout have been converted in
·
MigrationPlanningManager.exe:
http://www.microsoft.com/downloads/details.aspx?FamilyID=13580cd7-a8bc-40ef-8281-dd2c325a5a81&DisplayLang=en#filelist
- Installs a set of tools, which includes ofc.exe which does the bulk conversion.
- Installs a set of tools, which includes ofc.exe which does the bulk conversion.
·
FileFormatConverters.exe:
http://www.microsoft.com/downloads/details.aspx?familyid=941B3470-3AE9-4AEE-8F43-C6BB74CD1466&displaylang=en
- This installs binaries which are required for format conversion.
- This installs binaries which are required for format conversion.
·
Simple conversion steps:
1.
Download MigrationPlanningManager.exe and extract it into a new folder - say:
C:\Office.
2. Download and install the FileFormatConverters.exe Office Pack. This step is required even if Microsoft Office 2007 already installed on the computer.
3. Go to C:\Office\tools, open ofc.ini file using Notepad and edit the following lines.
MacroControl=0 - Takes care of macros associated with the layouts.
fldr=<PS_HOME>/nVision/Layouts - This refers to the source folder location that contains the layouts to convert.
2. Download and install the FileFormatConverters.exe Office Pack. This step is required even if Microsoft Office 2007 already installed on the computer.
3. Go to C:\Office\tools, open ofc.ini file using Notepad and edit the following lines.
MacroControl=0 - Takes care of macros associated with the layouts.
fldr=<PS_HOME>/nVision/Layouts - This refers to the source folder location that contains the layouts to convert.
4. Make a backup of all the layouts need to be converted and move them to a separate folder.
5. Rename all nVision layouts from *.xnv to *.xls. This is required because the utility does not recognize any file types other than Excel's native file types.
6. Open a command prompt and go to C:\Office\Tools.
7. Run ofc.exe. This utility will convert all Excel files present in the source folder specified in ofc.ini file to Excel 2007 format.
8. Rename the layouts from *.xlsx or *.xlsm to *.xnv.
Note:The conversion may fail for password-protected documents while doing a bulk conversion. These layouts should be manually converted.
nVision now
uses Excel Automation, which is dependent on Excel. Therefore, either Excel
2007 or Excel 2010 must be installed on the batch server(s).
nVision, which is a 32 bit application can run on a 64 bit Windows system. However, since it interacts with Excel, the Excel installation must be the 32 bit version to avoid any issues
nVision, which is a 32 bit application can run on a 64 bit Windows system. However, since it interacts with Excel, the Excel installation must be the 32 bit version to avoid any issues
It is recommendanded
to use the 32 bit Office version instead of the 64 bit version.
For Windows
Server 2008 based batch servers, create an empty 'Desktop' folder in path:
C:\Windows\SysWOW64\config\systemprofile\Desktop
C:\Windows\SysWOW64\config\systemprofile\Desktop
If the
string Value, "AppID", exists under registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Wow6432Node\CLSID{00024500-0000-0000-C000-000000000046}
Remove it as the aforementioned Desktop folder supercedes this setting.
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Wow6432Node\CLSID{00024500-0000-0000-C000-000000000046}
Remove it as the aforementioned Desktop folder supercedes this setting.
Unlike
Windows 2003, the DCOM Configuration setting for Microsoft Excel can be viewed
using a different command in Windows 2008 server.
Navigate to: Windows Start menu - Run - MMC -32 - File - Add/Remove snap-ins - Choose Component Services.
Then, navigate to: Dcomcnfg - Component Services - Computers - My Computer - Dcomcnfg - Microsoft Excel Application
Select the Identity Tab
Confirm "The launching User" is selected.
Navigate to: Windows Start menu - Run - MMC -32 - File - Add/Remove snap-ins - Choose Component Services.
Then, navigate to: Dcomcnfg - Component Services - Computers - My Computer - Dcomcnfg - Microsoft Excel Application
Select the Identity Tab
Confirm "The launching User" is selected.
