Troubleshooting Spreadsheet Converter issues

Although the Spreadsheet Converter is very easy to use, this section describes the most common problems and how to fix them.

I cannot open the Spreadsheet Converter after I transfer it to my PC.

  1. Make sure that the file CX98SSCX.XLA was transferred as a binary file.
  2. Make sure that you are running Microsoft Excel 97 or later.

My CMF Analyzer or CMFMON reports do not convert.

  1. Getting report information; do one of the following:
    • Make sure that the SYSPRINT DD statement in your CMF Analyzer JCL points to the data set that is to contain the report
    • Make sure that the CMFPRINT DD statement in your CMF Analyzer JCL points to the data set that is to contain the report
    • Use the IBM Sysout Display and Search Facility (SDSF) to copy the data from the SYSOUT queue to a data set.
  2. Make sure that you renamed your CMF Analyzer report file with the .txt extension.
  3. Make sure that you saved your CMFMON report with comma separated values (CSV).
  4. Make sure that you renamed your CMFMON report file with the .csv extension.
  5. Make sure that you transferred the file to your PC in the ASCII format.
  6. Display the transferred report on your PC to verify the following items:
    • There is carriage control in column 1.
    • Data has been converted from EBCDIC to ASCII.
    • Reports were produced by the CMF Analyzer.
  7. Check column 1 of the Conversion Log to see if there are any exception messages. If there are, look in the Messages and Codes display for additional information.

I cannot format the reports in Excel the way I want to.

Refer to the Microsoft Excel documentation, or contact Microsoft customer support.



 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*