If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Burst excel output to file location as .xls instead .mht

Started by PRIT AMRIT, 10 Mar 2011 08:54:59 PM

Previous topic - Next topic

PRIT AMRIT

Hi all,

I need your suggestion to get this done.

Well, I have reports(excel) bursting to the file location. And by default all these reports are saving as .mht.

Instead I want this to save as .xls by default without any script?

However, now I have a script and which converts all .mht to .xls in file location.

Thanks


PRIT AMRIT

Hi Peter,

Thanks for you quick reply, but I have already tried it before and no success.

You can see the attached screenshot. The files are still appearing as .mht

Anything else?

Thanks
Prit

AussiePete2011

Hi there,

Actually I've seen this before.  Do you have a distributed install?

I found that you need to enter the variables at the top most level of the server in Cognos and then restart to make this setting stick.
Select the Status tab in Cognos Administration, then Select system
On System, select "Set properties"
Select the settings tab
Hit the edit hyperlink on "Advanced Settings"
Add the variables as per the document.
You will need to restart.


This is the IBM document that suggests it must be set at Batch and report service
http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/topic/com.ibm.swg.im.cognos.ug_cra.8.4.1.doc/ug_cra_i_BatchReportServiceandReportServicePropertiesan.html#BatchReportServiceandReportServicePropertiesandValues

Hope this helps
Cheers
Peter B

NimrodA

I encountered that not a while ago. The key thing here is that you're trying to save to file system, which probably means you're using the cm.outputlocation directive. This directive renders the rsvp.file.extension.xls directive useless. So, you need to set up yet ANOTHER directive (CM.OUTPUTSCRIPT), that will, in its turn, run a batch file that will change the file ending. Don't look at me, it's the official IBM response thingy:
https://www-304.ibm.com/support/docview.wss?uid=swg21340529
They are nice enough to outline the code for the batch file, though.

PRIT AMRIT

Peter: I have already tried so, but no help. As Nirmroda suggested it's useless when you already have set cm.outputlocation.

Nirmorda: Correct. As I mentioned in my first post, I already have a script in File location which essentially does the same. Converts all the .mht files to .xls. I just wanted to ensure if I have followed the correct approach, which I am :D


However, now I would like to ensure the excel file should be sent as .xls attachment to the e-mail recipient instead .mht.


Thanks for your valuable suggestions guys.

Prit

NimrodA

perform a little test, if my memory serves, the rsvp.file.extension.xls directive applies when not saving to file system.

AussiePete2011

hI there

This particular subject appears to have been widely discussed here before
http://www.cognoise.com/community/index.php?topic=8438.0

And yes I agree, you do need the use the details from the IBM technote
https://www-304.ibm.com/support/docview.wss?uid=swg21340529 which renders the rsvp setting irrelevant.

My apologies for the confusion.. should concentrate on what I'm reading.
Cheers
Peter B

PRIT AMRIT

Hi guys,

Now
QuoteHowever, now I would like to ensure the excel file should be sent as .xls attachment to the e-mail recipient instead .mht.

Now it's working fine. I am getting the .xls as an e-mail attachment instead .mht.

BTW, could you please go through the below thread if not yet and see if we can achieve it within Cognos?
http://www.cognoise.com/community/index.php/topic,13244.msg41880.html#msg41880

Thanks for your valuable suggestions guys.

Cheers,
Prit