Krishna Chaithanya`s Blog Headlines

Krishna Chaithanya`s Blog

Friday, June 17, 2011

Insights into an Xcelsius (XLF) File

Xcelsius is a powerful dashboarding tool, but sometimes We are facing the problems with Qaaws connections while moving the development to production environment.
I discover a very nice solution to this problem. I also found out about extra capabilities that are not available through the Xcelsius interface.

Getting straight to the point, there is an XLF file at the end of a standard archive file. All you need to do is rename it to .ZIP and extract it in any folder. You will find the following files inside:

Xldoc: This is the Excel Data model used in Xcelsius (you can open it using Excel)
Document.xml: This contains your Xcelsius definition (graphs, canvas, connections…)
Folder(long name): This contains the pictures embedded in your Xcelsius file
The most interesting file for the purposes of this article is the Document.xml. In this file you will find the entire definition of your Xcelsius model; which provides great capabilities and opportunities! Let me give you three examples:

Replace the server of your QAAWS connections: just search for your server name to find the entries of your QAAWS connections (with the credentials if they are hardcoded in the model) then replace them for the new server.
Change the color schema: To change the color schema, all you need to do is replace the old color with the new one in the XML file and you are done. If you have defined a customized color schema you will also find it in the file.
Change the logos/pictures: You just need to overwrite the logos that you get after unzipping the XLF.
You can play around as much as you want with these files. To get your new XLF file all you need to do is add the folder back to a zip file and rename it to XLF!

No comments: