BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Launch Works 
Launch Works (Opens a new window)  

General Notice: No events within the next 45 days.

[Solved] BI4 - Excel to File System problem


 
Search this topic... | Search XI Scheduler... | Search Box
Register or Login to Post    Forum Index -> Enterprise Scheduling and Distribution -> XI Scheduler  Previous TopicPrint TopicNext Topic
Author Message
Nick Daniels
Forum Aficionado
Forum Aficionado



Joined: 15 Aug 2002

Posts: 12531
Location: England


flag
PostPosted: Tue Dec 04, 2012 6:14 am 
Post subject: [Solved] BI4 - Excel to File System problem

BI4 SP04 on Redhat
We schedule a simple WebI report to a destination of File System, format Excel, leaving the default File Name option 'Use Automatically Generated File Name'. This produces myreport.xlsx. When I click on this in the file system, instead of opening the spreadsheet it opens a compressed zip file, which contains a bunch of folders and xml files. The file system is on our Linux server, we accesss the report via a browser url.

If I amend the file name to be myreport.xls it will open in Excel, but only after displaying a message the gist of which is that the file extension doesn't match the file type.

If I set the file name to be myreport.xlsx, rather than allowing the automatically generated name to achieve the same result it again opens a compressed zip file when we click on the link with the browser.

_________________
cheers, Nick
Back to top
Nick Daniels
Forum Aficionado
Forum Aficionado



Joined: 15 Aug 2002

Posts: 12531
Location: England


flag
PostPosted: Tue Dec 04, 2012 6:29 am 
Post subject: Re: [Solved] BI4 - Excel to File System problem

Our server guy added a MIME-TYPE to apache....

application/vnd.openxmlformats-officedocument.spreadsheetml.sheet xlsx


Hey presto....

_________________
cheers, Nick
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Enterprise Scheduling and Distribution -> XI Scheduler  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0450 seconds using 17 queries. (SQL 0.0029 Parse 0.0354 Other 0.0067)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo