Journey on Peoplesoft

One of the ways you can set up the environment so the SOAPTOCI log is generated in a specific location on the application server machine is as follows. 1. Create an environment variable named PS_FILEDIR that points to the location where you want the SOAPTOCI logs. On Windows it would be a System environment variable. For UNIX the syntax would be different, and you can define it in the script that executes when you enter the shell (such as psconfig.sh). PS_FILEDIR=c:\pt849\appserv\FSCM90\files NOTE: PS_FILEDIR environment variable is sometimes used as the location by other applications. So, make sure that the location suits the various applications being used. 2. After setting the environment variable restart the app server using psadmin. However, prior to executing psadmin verify that the PS_FILEDIR environment variable exists. 3. Test an upload from ExcelToCI, and confirm it works as expected.

The Exceltocixxx.log and SOAPTOCIxxx.log are generated if he selects the Generate Log checkbox in ExcelToCI. i. SOAPTOCIxxx.log – By default this log is created in the app server's "files" directory (below the app server domain), but it may be in another location on the application server machine. The xxx is the timestamp appended to the file name. This log shows the PeopleCode execution path in the SOAPTOCI application package . ii. ExcelToCIxxx.log – By default this log is created in user’s Temp directory. The xxx is the timestamp appended to the file name. To determine the location where your Temp directory is mapped to do the following. On the client machine’s desktop right-click on the “My Computer” icon and select Properties. Then select the “Advanced” tab and click on “Environment Variables”. Locate the Temp (or tmp) variable mappings (it may be C:\Temp or some other location). This is normally where the ExcelToCIxxx log is placed.

After we open the Journal Import Spreadsheet in Windows 7 or Windows Vista, it does not let us click on any buttons to create journals, etc... We get, "Compile error, Cannot find project or library". The spreadsheet journal import, JRNL1.XLS, can be used so long as the Microsoft delivered XML library file msxml.dll exists on the environment. It does not exist with Windows 7 nor Windows Vista. Please copy the msxml.dll file from the Windows XP computer to the workstation with Windows 7 or Windows Vista. Place the file under the windows directory where it is referenced, as follows. --Open JRNL1.xls and then go to the VB Editor (Tools > Macro > VB Editor) or ((Developer > Visual Basic for Office 7) --With JRNLMCRO highlighted, click Tools > Reference There should be a reference to the Microsoft XML DLL library file (msxml.dll). Microsoft has several versions of this library (msxml2.dll / msxml3.dll / etc.) and they coexist on some computers. NOTE: • For Windows 7, t...