Step 2: Customize the Batch Renaming Script

The reports generated by Cognos scheduler are given cryptic names.

For example, Approver Settings could potentially be generated as a file named 397_1163638261400.pdf. For each PDF file, the Cognos server also generates a descriptor file in .xml format. This file contains the mapping of the generated PDF file name to the report’s original name on the Cognos Server.

Note: When the Cognos scheduler generates a report, it saves this PDF file to a “Work” subfolder at the output location you specify in Step 3.

Make sure to create these folders before running your job.

Deltek provides a script which, when run, takes the mapping information from the xml file to rename the PDF files to their original report names. This script then also appends the date and time of the report generation to the end of the file name. There is then an option to delete these descriptor files upon completion of the renaming process.

To customize the batch renaming script for your firm, you must edit the renameFiles.bat file (located at C:\Program Files (x86)\Deltek\CostpointEnterpriseReporting\CER723\SOX\Scripts), as necessary. The areas to edit are in italics in the following sample.

When you are through, save the renameFiles.bat file. Ensure that the renameFiles.bat, renameFiles.java, and renameFiles.class files are saved to the desired output location.

Note: The renaming script will not run if special characters exist in the name. Therefore, exclude special characters from path and report names.

Examples of special characters are: > < “ ‘ & + / ? % # + , . : ; = [ ]

@echo off
REM
REM Please update the following information before executing the program:

REM COGNOS_HOME:		Your cognos install directory

Set COGNOS_HOME=C:\Program Files\ibm\cognos\analytics

REM JAVA_HOME:		Combining Cognos_Home with this location
REM				should result in a folder location where
REM				“bin” folder can be found. Make sure there
REM				is a java.exe inside the “bin” folder.

set JAVA_HOME=%COGNOS_HOME%\jre

set PATH=%JAVA_HOME%\bin;%PATH%

REM CMOUTPUT_LOCATION:		Location where your CRN Server will
REM				save files. This is the directory
REM				where the files “renameFiles.bat”,
REM				“renameFile.class” and
REM				“renameFiles.java” should exist.

Set CMOUTPUT_LOCATION=C:\Output

REM WORK_LOCATION:	Location where all files will be moved
REM				before renaming them. By default this
REM				is the ‘Work’ subfolder of the
REM				CM_OUTPUT_LOCATION. You can use the
REM				alternate code below for specifying another
REM				location altogether. Just remember to “REM”
REM				the line of code not in use.

Set WORK_LOCATION=%CMOUTPUT_LOCATION%\work
REM set WORK_LOCATION=C:\test

REM Call the java program to rename the output file
REM –cp option specifies the classpath information i.e. location of renameFiles.class
REM The files (%1 and %2) that the server will pass to the batch file will be renamed

REM Set the last parameter of the code below to “Y” or “y” for the program to put files
REM under a subfolder; “N” or “n” otherwise
Call “%JAVA_HOME%\bin\java” –cp “%CMOUTPUT_LOCATION%” renameFiles “%WORK_LOCATION%” “%1” “%2” n

REM Delete the XML descriptor files
REM Remove “REM” from the line below if you want descriptor files deleted
REM Deltek %WORK_LOCATION%\*.xml

Costpoint Online Help

Step 2: Customize the Batch Renaming Script