As long as I have been using Xcelsius, I have always wanted a method to export data from an Xcelsius dashboard to Excel or XML file. The good news is there is finally a utility available to help fill in the gap. Xport Wizard, allows for the fast generation of services that enable Xcelsius dashboards to export to XML and Excel. For someone like me who doesn’t spend their days buried in code, the nice graphical wizard interface was convenient for me to click through and generate my desired service.
Why is this relevant?
A SWF by design can not generate output files like Excel and XML. Since SWF files generated from Xcelsius can stream XML to server-side processes like web services, there always existed the gap between the SWF and the output files. Xport Wizard has filled in that gap, and made a cumbersome process of building web services simple.
How does it work?
Xport Wizard uses the XML structure generated with the Xcelsius XML Data component to generate web services. The first test I did was using a sample right off the Xcelsius website. The goal was to export the data to Excel. After purchasing Xport Wizard off the website, I installed it on an instance of Windows 2003 server. After installing, I was instructed to modify a few folder permissions. After that I was up and running…
Check it out here at Xport Wizard. I will do a writeup this week instructing how to use this tool and my experiences. If anyone has any cool ways to use this tool, let me know.