To extract data from Human Resource Writer reports in CSV format when processing the report.

  1. Access Human Resource Writer Title Creation (HR65.1) and enter a value in the Spreadsheet Name field for the report.
  2. Access Human Resource Writer Report Request (HR170), which is used to generate HR Writer reports after they have been defined. In the Parameters section, select the report's title and ensure the Spreadsheet field is set to Y.
  3. Submit the report.
  4. Access the Print Manager after the report is complete, and select the report's output file with the File Name of the Spreadsheet Name value you entered on HR65.1 in step 1 above.
  5. Drill around on that file to see the path name where the CSV output for the report has been placed. An example of a path created this way is /apps/print/john/hr170js/print1, where john is the user name and hr170js is the name of the job submitted on HR170. The CSV file will reside in that path on the server.