Prerequisites
This table lists the files that PeopleSoft provides for the spreadsheet journal import user interface. Copy all files to the same folder on your workstation.
| Microsoft Excel 2007 (and subsequent versions) | Description |
|---|---|
|
JRNL1_WS.xlsm |
This is the journal workbook that you use to create and import journals with Excel 2007 and versions above. You can rename this file using a meaningful name. |
|
JRNLMCRO_WS.xlam |
This is the Visual Basic code library and dialog control used with Excel 2007 and subsequent versions. Note: As of Update Image 54, this file is no longer required. |
|
GLLOG.xlt |
This is the Message log template. |
Note:
If using the JRNL1_WS.xlsm file (Excel 2007), you may have to enable the macros before you can begin using the file. If the macros are not yet enabled, you will see a Security Warning at the top of the page. If so, click the Options button that appears near the Security Warning. Select the Enable this Content radio button and click OK.
No additional .dll files need to be installed on your workstation when using the Excel 2007 files.
In addition to the previously mentioned three files, Spreadsheet Journal online import mode expects the Microsoft delivered XML library file MSXML6.dll to be installed on your workstation.
To import journals in online mode from the spreadsheet, your system administrator must associate you with all a role that contains the EPGL9000 permission list.
To import journals in batch mode, your system administrator must set up the correct environmental variable (PS_FILEDIR) on the process scheduler server.