hi,
we are creating dashboards using Xcelsius 2008.Please let me know how to Export a SWF File available in BO Infoview to Excel File.while the file is in XLF format i can view it in Excel format in the Preview mode by taking the Snapshot of the file to Excel format.Is there anyother option in Infoview. Please let me know.
Thnaks,
naresh
naru (BOB member since 2005-09-27)
Hi,
We have a similar requirement in our project.
We have achieved this by writing an XML parser in java and deploying the same on the Tomcat server. Basically, this jsp code takes the input in the form of an xml, parses it and writes it to a csv, whcih could then be opened and saved.
Refer to the link below, which we took as the base and implemented it on the same lines. It has all steps mentioned in detail.
Instead of aspx code, we used java code.
Hope this helps.
Fathima.
Fathima (BOB member since 2009-04-06)
Hi,
Centigon Solution actually created a very easy to use add-on component to do just this. Its very easy to use and cost effective. We recommend it.
Below is the link - http://www.centigonsolutions.com/xportwizard/index.html
Below is the description of the component from Centigon’s website:
Xport Wizard is a lightweight utility that will enable you to export data from your dashboard applications. The result for your dashboard end users is a seamless method for extracting and saving critical information to one of 3 output formats: Excel/CSV, XML and HTML. Xport Wizard’s graphical interface and web services provide an easy to use solution for saving data without writing a single line of code.
Benefits
* Export dashboard data to Excel with a single click
* Save dashboard scenarios, targets and comments
* No code writing required leading to fast deployment
Features
* Intuitive browser-based graphical interface
* Point and click generation and integration of web services
* Lightweight, configurable .NET web services
EverythingXcelsius 
(BOB member since 2008-06-17)
Dear Fathima,
Have similar requirement in our project. We have Tomcat server and looking for java code to parse xml to csv… Not an expert in Java coding. Your help on this will be very much appreciated…
Thanks in advance for your help…
Regards
Dhaya
dhayanithij (BOB member since 2007-06-26)
Can someone help me with Java code to convert the xml to csv file…
Thanks very much in advance…
dhayanithij (BOB member since 2007-06-26)
Hi
Same requirement for my project also. In my project they are asking to export Excel and PDF also.
We are using the xcelsius Dashboards and the data is coming from sql and the intermediator between the dashboard and the database is .net web service.
Please help me in this.
Thanks
Rajani
rajani_jagan 
(BOB member since 2008-01-23)
Hi all,
We developed this solution for Xcelsius using Tomcat and we have just sent it to myXcelsius.com.
Our solution is easy to configure (it is just a war file) and allows you to export your dashboard to excel using tomcat server.
Stay tuned on myxcelsius.com and check out when the ClearPeaks Export2Excel solution will be published!
Hope this helps,
Luca Spinelli 
(BOB member since 2008-08-27)
Thats Great News… Looking forward to see the details in xcelsius.com.
Belive it or not I check the website every 5 mins.
By the way does this code is available for free.
Cheers
Dhaya
dhayanithij (BOB member since 2007-06-26)
Hi all,
I’m glad to announce you that our solution is live on myxcelsius.com!
I hope you will enjoy it!!!
Luca Spinelli (BOB member since 2008-08-27)
Export2Excel is wonderful, I’ve tested it and it’s very easy to use !
However, what’s the rights to use this war for a product which deliver Xcelsius dashboards ?
acaussin (BOB member since 2009-04-24)
Hi acaussin,
of course you can use it for free. Our objective is just having the people know that ClearPeaks delivered it. As you can see when you export your data range, in the exported excel will appear also an about ClearPeaks sheet with our “free” copyrights.
In general you can definitely use it for your production environments without any problem!
Let me know if you need more details!
Cheers,
Luca Spinelli (BOB member since 2008-08-27)
Hi Luca Spinelli,
Thanks for providing it for free. It is working fine.
you done a really good job 
dandamudi (BOB member since 2008-07-03)
Dear Luca,
Many thanks for sharing the code. Great Help…
When I click the URL button, the file opens in Explorer instead how do I force the “File Download” dialog box… Please help…
Thanks again for your service to Xcelsius community…
Thanks
Dhaya
dhayanithij (BOB member since 2007-06-26)
Hi, Luca, can you please use the image only one in your posts? You currently have it in both your signature and the body of the post. Thanks. 
Dave Rathbun (BOB member since 2002-06-06)
Hi dhayanithij,
you should change your browser’s settings. If you go to your Internet options you will find the command to allow thee popup for your downloads.
@Dave: apologies for that I was changing my signature and I didn’t think about my old posts! By the way, I have just changed it as it was before!!
Have a great day guys!
Cheers,
Luca Spinelli (BOB member since 2008-08-27)
Thanks Luca for your reply…
Unable to find the settings that will Force the popup of File Download dialog box. Am using IE 6.0 on Windows 2000 professional… Spent hours on friday but could not find the settings… Your help will be very usefull…
Thanks again for your support…
dhayanithij (BOB member since 2007-06-26)