IBM Support

Converting HTML/MHT to XLS when sending emails is not working

Troubleshooting


Problem

Adding the Advanced setting RSVP.FILE.EXTENSION.XLS TRUE still sends emails with the MHT extension rather then XLS.

Symptom

File extension still comes through as MHT and not XLS

Resolving The Problem

Add the Advanced Setting at BOTH Dispatcher and Report Service Level.

Steps:


In Server Administration, add "RSVP.FILE.EXTENSION.XLS" parameter to both Dispatcher and ReportService/BatchReportService.

For version 8.3:

Steps:
  1. Open Cognos Connection.
  2. Click Tools menu in the portal and select Cognos Server Administration
  3. Click on Configuration
  4. Click on 'Dispatchers and Services'
  5. Click on Properties 'Configuration' toolbar button
  6. Click on Settings
  7. Click on Environment Advanced Settings - Edit link
  8. In the first empty set of boxes, type in the parameter name RSVP.FILE.EXTENSION.XLS and set the value to TRUE
  9. Press OK.
  10. Drill down on 'Dispatchers and Services' to the Batch/Report Services
  11. Click on Properties - Settings - Environment Advanced Settings - Edit
  12. In the first empty set of boxes, type in the parameter name RSVP.FILE.EXTENSION.XLS and set the value to TRUE
  13. Press OK.

Restart the service.

For version 8.4:

1. Open Cognos Connection
2. Click Launch and select IBM Cognos Administration
3. Click on Configuration tab
4. Click on Dispatchers and Services
5. Click on 'Configuration' tool button
6. Click on 'Settings'
7. Click on 'Environment: Advanced Settings' - Edit
8. In the first empty set of boxes, type in the parameter name RSVP.FILE.EXTENSION.XLS and set the value to TRUE
9. Press OK
10. Drill down on 'Dispatchers and Services' to the Batch/Report Services
11. Click on Properties - Settings - Environment Advanced Settings - Edit
12. In the first empty set of boxes, type in the parameter name RSVP.FILE.EXTENSION.XLS and set the value to TRUE
13. Press OK

Restart the service

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Component":"Cognos Connection","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"8.4","Edition":"All Editions","Line of Business":{"code":"","label":""}},{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Cognos Connection","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"","label":"HP Itanium"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"8.4","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
28 November 2022

UID

swg21385491